Problem with transfering

  • Resolved pavel21

    (@pavel21)


    7 years ago

    I`ve done the site with gwolle guest book in my local host. When I transfered the site on hosting there appeared such problem:
    [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 ‘update-plugins count-0′><span class=’theme-count’>0</span></span>” at line 1]
    SELECT slug FROM wp_terms WHERE name = ‘Гостевая книга<span class=’update-plugins count-0′><span class=’theme-count’>0</span></span>’.
    This problem broke the site. How can I fix it?

    • This topic was modified 7 years ago by pavel21.
    • This topic was modified 7 years ago by pavel21.
    • This topic was modified 7 years ago by Jan Dembowski.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Marcel Pol

    (@mpol)

    7 years ago

    That is quite a strange SQL error, and should not happen.
    I suspect there happened some file corruption during upload.
    If you upload again, is it right?
    Alternatively, there is just a new update. If you update, does it work right?

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    I rolled back plugin version, update it, reinstall WP version but problem doesn`t resolved.
    Problem has been resolved when I changed single quote to double quotes. I change sintax in file gwolle-gb-hooks.php in str 39 and 50: "<span class='update-plugins count-" . $count_unchecked . "'><span class='theme-count'>" . $count_unchecked . "</span></span>" to "<span class=\"update-plugins count-" . $count_unchecked . "\"><span class=\"theme-count\">" . $count_unchecked . "</span></span>"

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    By the way, on local host php version 5.5.37 , MySQL – 5.5.50-log . On the hosting: php – 5.6.30 , Mysql – 5.5.52-38.3 . May be it’s important

    Plugin Author Marcel Pol

    (@mpol)

    7 years ago

    I assume you are using a plugin that makes a SQL query based on some admin menu-counters.

    I did spot a bug and fixed that bug in 2.3.1.
    Does that help in your case?

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    I’ve trided to use site when only Gwolle is on and the other plugins are off. But problem still remained.
    I’ve updated Gwolle but nothing is changed.

    • This reply was modified 7 years ago by pavel21.
    Thread Starter pavel21

    (@pavel21)

    7 years ago

    I’ve changed quote in the same file in the same places from
    "<span class='awaiting-mod count-" . $count_unchecked . "'>
    to
    "<span class=\"awaiting-mod count-" . $count_unchecked . "\">
    And problem has resolved

    • This reply was modified 7 years ago by pavel21.
    • This reply was modified 7 years ago by pavel21.
    Plugin Author Marcel Pol

    (@mpol)

    7 years ago

    I am really confused about this. I still assume there is something happening in the local configuration where something goes wrong.

    Anyway, I made some changes in trunk. Would you want to try them out? You can download it on the Development tab.

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    Ok. I’ll try. Thank You for feedback!

    Plugin Author Marcel Pol

    (@mpol)

    7 years ago

    Ah, let me phrase a question (I didn’t before 🙂 )
    Can you confirm if it works for you now without errors?

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    Ok. When the problem will be resolved I give You to know 😉

    Thread Starter pavel21

    (@pavel21)

    7 years ago

    In vers 2.3.2 the problem has resolved! But I’d deleted file update.php from wp-admin. I don’t know is it associated)))
    So thank You Marcel for feedback and timely reaction! 😉

    • This reply was modified 7 years ago by pavel21.
    Plugin Author Marcel Pol

    (@mpol)

    7 years ago

    Okay, nice.
    I still don’t understand it, but at least it works now.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Problem with transfering’ is closed to new replies.