error in SQL syntax

  • Resolved EvgenBest

    (@evgen81)


    5 years, 10 months ago

    Hi!
    The plugin displays errors. When you turn off the plugin, the errors disappear

    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 ') )) AND ((post_type = 'post')) LIMIT 0, 999' at line 1 в ответ на запрос SELECT pea_posts.ID, pea_posts.post_title, pea_posts.post_excerpt, pea_posts.post_content, pea_posts.post_author, pea_posts.post_date,

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    @evgen81
    Thanks I’ll look in to it. Can you resubmit the error in English please.

    Thread Starter EvgenBest

    (@evgen81)

    5 years, 10 months ago

    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 ') )) AND ((post_type = 'post')) LIMIT 0, 999' at line 1 in response to a request SELECT pea_posts.ID, pea_posts.post_title, pea_posts.post_excerpt, pea_posts.post_content, pea_posts.post_author, pea_posts.post_date,

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    Please send me the shortcode you are using that is causing the above error. Thanks.

    Thread Starter EvgenBest

    (@evgen81)

    5 years, 10 months ago

    [netsposts taxonomy=’zametki-trejdera’ thumbnail=’true’ size=’imgsidebar’ image_class=’alignleft’ auto_excerpt=’true’ excerpt_length=’15’ meta_info=’false’ include_link_title=’true’ wrap_title_start='<div class=”title-class-sidebar”>’ wrap_title_end='</div>’ wrap_text_start='<div class=”text-class-sidebar”>’ wrap_text_end='</div>’ list=’5′]

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    I have an updated version here on github for you to try. Download the files under the folder Branch2 and upload them via ftp over riding the other files: https://github.com/johnzenaida/networkpostsextended

    If that doesn’t fix the syntax error please upload the dbug version under Branch3.

    I need you to do this because I can’t re-create the error on my server. Thanks.

    Branch3 is the dbug version and I’ll need you to do the following please:

    install debug version and copy and send printed sql query to help recognize problem.

    Just paste it here and please put them between backticks so the code can be copied directly.

    • This reply was modified 5 years, 10 months ago by johnzenausa.
    Thread Starter EvgenBest

    (@evgen81)

    5 years, 10 months ago

    Hello! Thank you for helping me figure it out.

    I installed the version of the Branch2 plugin. Over the post, the following code is displayed:
    SELECT pea_posts.ID, pea_posts.post_title, pea_posts.post_excerpt, pea_posts.post_content, pea_posts.post_author, pea_posts.post_date, pea_posts.post_type FROM pea_posts WHERE pea_posts.post_status = 'publish' AND (pea_posts.ID = '') AND (pea_posts.post_type = 'post') LIMIT 0, 999SELECT pea_2_posts.ID, pea_2_posts.post_title, pea_2_posts.post_excerpt, pea_2_posts.post_content, pea_2_posts.post_author, pea_2_posts.post_date, pea_2_posts.post_type FROM pea_2_posts WHERE pea_2_posts.post_status = 'publish' AND ((pea_2_posts.ID = '334') OR (pea_2_posts.ID = '340') OR (pea_2_posts.ID = '341')) AND (pea_2_posts.post_type = 'post') LIMIT 0, 999SELECT pea_18_posts.ID, pea_18_posts.post_title, pea_18_posts.post_excerpt, pea_18_posts.post_content, pea_18_posts.post_author, pea_18_posts.post_date, pea_18_posts.post_type FROM pea_18_posts WHERE pea_18_posts.post_status = 'publish' AND (pea_18_posts.ID = '') AND (pea_18_posts.post_type = 'post') LIMIT 0, 999

    Then I installed Branch3. Data on top of the post displayed similar

    With these versions php_errors was not displayed in the logs

    • This reply was modified 5 years, 10 months ago by EvgenBest.
    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    Thank You

    Thread Starter EvgenBest

    (@evgen81)

    5 years, 10 months ago

    Will you update the plugin so that I do not see sql queries?

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    Is there a page where the errors are occurring?

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 10 months ago

    You still get errors but not in the logs?
    You see them on the actual page or in the admin panel? Or in an error_log file in the root directory.

    • This reply was modified 5 years, 10 months ago by johnzenausa.
    Thread Starter EvgenBest

    (@evgen81)

    5 years, 9 months ago

    Yes, the logs have disappeared, but now they are displayed on the site above the posts

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 9 months ago

    Can you send me a link to the site where this is happening?

    Thread Starter EvgenBest

    (@evgen81)

    5 years, 9 months ago

    http://mirtraderov.ru/analitika-rynkov/

    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 9 months ago

    Hi EvgenBest

    Please go to https://support.johncardell.com/ and grant me temporary superadmin privileges so I can check it out further.

    Thanks

    • This reply was modified 5 years, 9 months ago by johnzenausa.
    Plugin Author johnzenausa

    (@johnzenausa)

    5 years, 9 months ago

    I see you still haven’t updated. Please do so.

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • The topic ‘error in SQL syntax’ is closed to new replies.