WordPress.org

1. Duf
   Member
   Posted 2 years ago #

   Running MYSQl vers 4.120, uploaded the 2.1 files, ran the upgrade page and got this

   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 '( cat_id bigint(20) NOT NULL auto_increment, cat_name tinyte]
   CREATE TABLE ( cat_id bigint(20) NOT NULL auto_increment, cat_name tinytext NOT NULL, auto_toggle enum('Y','N') NOT NULL default 'N', show_images enum('Y','N') NOT NULL default 'Y', show_description enum('Y','N') NOT NULL default 'N', show_rating enum('Y','N') NOT NULL default 'Y', show_updated enum('Y','N') NOT NULL default 'Y', sort_order varchar(64) NOT NULL default 'rand', sort_desc enum('Y','N') NOT NULL default 'N', text_before_link varchar(128) NOT NULL default '
   ', text_after_link varchar(128) NOT NULL default '', text_after_all varchar(128) NOT NULL default '
   ', list_limit int(11) NOT NULL default '-1', PRIMARY KEY (cat_id) )

   Fatal error: Call to undefined function: populate_roles_210() in /hsphere/local/home/sduffey/duf.net/wp/wp-admin/upgrade-functions.php on line 500

   Anyone else run into this?

   I recently ran the 2.06 upgrade and it went just fine.

2. Duf
   Member
   Posted 2 years ago #

   Damn noone else has seen this? Scary.....

3. emmons
   Member
   Posted 2 years ago #

   I got the same kind of thing:

   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

4. coders4hire
   Member
   Posted 2 years ago #

   I had problems with the upgrade as well, but it was simply because I didn't deactivate my plugins. Here's what I did:
   1. Backed up all of my plugins
   2. Deleted them and replaced with the default 2.1 plugins.
   3. Ran the upgrade and it worked.
   4. Added each plugin back one at a time, reactivating each.

   Doug

5. emmons
   Member
   Posted 2 years ago #

   I'll try that. Thanks.

6. emmons
   Member
   Posted 2 years ago #

   no dice :(

7. Otto42
   Moderator
   Posted 2 years ago #

   Fatal error: Call to undefined function: populate_roles_210() in /hsphere/local/home/sduffey/duf.net/wp/wp-admin/upgrade-functions.php on line 500

   Did you upload all the files? This suggests that you are missing file or that they are incomplete. This particular function is in upgrade-schema.php.

8. DianeV
   Member
   Posted 2 years ago #

   It's important to delete the WordPress files from the server (except for the few mentioned in the Codex) because simply uploading new files over them is not always successful.

   To be honest, I'd only seen this twice in ten years, but then it happened again on one of my WP upgrades. So, while it's a hassle, it's more of a drag to not have upgrades go smoothly.

9. proxi
   Member
   Posted 2 years ago #

   happened to me too... dammit.

10. markjaquith
    Moderator
    Posted 2 years ago #

    Fatal error: Call to undefined function: populate_roles_210()

    Otto42 called it (I'm only responding because this has since been bumped to the WP-Advanced forum)

    Re-upload /wp-admin/ directory and make sure all files are overwritten.

Topic Closed

This topic has been closed to new replies.