MySQL problem when writing into WP tables from a php script (2 posts)

  1. Accur
    Posted 7 years ago #

    Hi everyone,
    I have been using wordpress for more than a year now, but I am very new to PHP and MySQL.

    My problem:
    When running a PHP script that sends content from a table to the wp_posts table, everything works fine, but the post_content makes everything crash if it is more than a few words. (I send data from this table to WP_posts in order to write posts quickly from the initial table and avoid as much a possible to go the wp-admin section)

    It was working perfectly a few days ago and the only things I changed is that I installed more plugins in my blog including Global Translator. I noticed several of my 18 tables get small overhead every time I touch something... And it seems Global Translator creates cache problems. I thought it could be that, so I deactivated Global T. but nothing has change.

    Now, everything my usually working script send a post_content that is more than about 10 words, the query fails saying suprisingly: "querypost_content failed:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BLABLABLABLA

    I have spent already 8 hours non stop trying to fix this problem making test and reading forums without success.

    Please help !


  2. Accur
    Posted 7 years ago #

    Solved... just a little " ' " at the wrong place. One full day around it...

Topic Closed

This topic has been closed to new replies.

About this Topic