MySQL error after upgrade to 2.1

  • benbt-japan

    (@benbt-japan)


    17 years, 3 months ago

    My host has WordPress available for automatic install/upgrade. I used their upgrade service (after backing some things up myself just in case) and everything seems to have gone smoothly, apart from this error which displays in the sidebar, under the archives list, where all my links should be (they don’t display):

    WordPress database error: [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 'ASC' at line 1]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_id- ASC

    I am using the veryplaintxt theme.
    The error occurred before I had activated any plugins so it can’t be due to that, I think.

    My post categories display properly in the sidebar, but none of the links, nor their categories, show up.

    http://www.language-global.com/blog

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • sofsoldier

    (@sofsoldier)

    17 years, 3 months ago

    I have a similar problem – received link errors when I upgraded from 2.07 to 2.1. My Link category is no longer available and I cannot add any links to the blog (that is, its in the blog roll but not on the site), when I do I get an error:

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_link2cat WHERE link_id = 1 ORDER BY category_id

    When I edit the bookmark I just added, there is an error listed in the Category box:

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    WordPress database error: [Got error 1 from storage engine]
    SELECT category_id FROM wp_categories, wp_link2cat WHERE wp_link2cat.category_id = cat_ID AND wp_link2cat.link_id = ‘1’

    Would deleting my link categories fix this problem? And if so, how do I do that exactly? I am running WP version 2.1, PHP 5.2 and MySQL 4.1.22. I have no idea how to use a phpMyAdmin type program but this is on my own server so I have access to the MySQL command prompt.

    Thread Starter benbt-japan

    (@benbt-japan)

    17 years, 3 months ago

    Yes, it would be useful to know if deleting all the links and link categories and re-entering them in 2.1 would solve the problem.

    It seems like link categories and post categories are no longer differentiated from each other.

    Also, I have a page which seems to have been added to a post category as a post, not a page.

    As above : http://www.language-global.com/blog

    sofsoldier

    (@sofsoldier)

    17 years, 3 months ago

    Please see: http://wordpress.org/support/topic/102313?replies=1#post-504945

    Thread Starter benbt-japan

    (@benbt-japan)

    17 years, 3 months ago

    That solution is not practical for me as I do not run my own server.

    Is there any way to get the link categories and the links to display in the sidebar as before, without having to roll-back (my provider will do the rollback for me, but I have to pay for the service)?

    Thread Starter benbt-japan

    (@benbt-japan)

    17 years, 3 months ago

    re: rollback : I have seen posts on this board about people even having errors after rolling back. So I feel like I’m stuck with a buggy wordpress and can’t do anything about it.

    🙁

    Thread Starter benbt-japan

    (@benbt-japan)

    17 years, 3 months ago

    Looking at the error message again, I think I may have hit on something:::

    WordPress database error: [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 'ASC' at line 1]
    SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_id- ASC

    Surely the ORDER BY cat_id- ASC should be ORDER BY cat_id ASC ??

    raywitw

    (@raywitw)

    17 years, 3 months ago

    My error is similar. I also have no access to the database, as I am hosted on Lunarpages. Here it is:

    [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 ” at line 1]
    SELECT cat_id, cat_name FROM

    ccf

    (@ccf)

    17 years, 3 months ago

    All the links in my blogroll are gone and I get this message in the sidebar

    WordPress database error: [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 ” at line 1]
    SELECT cat_id,cat_name FROM

    Why did I have to fix something that worked fine? I can’t even go back to 2.07, I have tried, and it doesn’t work
    Please help!!!!

    http://blogginginparis.com

    Samuel B

    (@samboll)

    17 years, 3 months ago

    Most of these type errors are from themes not updated for 2.1. Check your theme author’s website to see if he/she has an update.

    ccf

    (@ccf)

    17 years, 3 months ago

    I can’t change the theme. What I would like to do is go back to 2.07 which was OK for me. Could you tell me how to do that?
    Someone helped me with this theme a long time ago. I wouldn’t know how to change it and haven’t got a clue how to change it so that it adapts to 2.1
    What you are telling me is I can’t ever recover my links unless I change the theme.
    I like my theme and don’t really want to change it.
    Why, oh why did I upgrade?

    ccf

    (@ccf)

    17 years, 3 months ago

    eija, here suggested a fix that worked.

    Thread Starter benbt-japan

    (@benbt-japan)

    17 years, 3 months ago

    After the panic, I managed to fix the problem on my site with the link categories and links not displaying.

    I edited category.php in wp_includes to correct the query. The error message was enough to track down the right place and then it was a question of just adding an
    if ($xxx='id-') { $xxx='ID'; }
    to correct the variable containing the typo.

    After that everything works as it probably should.

    pgmccullough

    (@pgmccullough)

    17 years, 2 months ago

    I am having the exact same problem. Benbt-japan – could you elaborate on exactly where to stick:

    if ($xxx=’id-‘) { $xxx=’ID’; }

    Thanks so much.

    driveafastercar

    (@driveafastercar)

    17 years, 2 months ago

    Ditto – where in category.php did you put that code? I’m getting the exact same error you did in the exact same theme.

    moshu

    (@moshu)

    17 years, 2 months ago

    I think instead of editing core files (always a bad omen) you should update your theme files!
    Most likely the template file displaying your links (sidebar.php?) is using a deprecated template tag; see:
    http://codex.wordpress.org/Template_Tags#Links_Manager_tags

    or, due to the changes in the database, the template tags are pointing to the wrong link category ID#.

Viewing 15 replies - 1 through 15 (of 17 total)
1 2
  • The topic ‘MySQL error after upgrade to 2.1’ is closed to new replies.