Upgrade: So close but so far away

  • buffyvs

    (@buffyvs)


    19 years, 3 months ago

    So.. I finally figured it out on how to get the upgrade to install.

    First I installed the 1.2.2 files, ran it made sure it worked.

    Then I made a copy of all the files onto my desktop and downloaded a nightly (2005-01-10) and merged those files together overwriting duplicates.

    Uploaded the new files to server and go to the wp-admin/upgrade.php page

    Yay!

    “This file upgrades you from any previous version of WordPress to the latest. It may take a while though, so be patient”

    Hit next step and then I get this:

    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 ‘( ID int(10) unsigned NOT NULL auto_increment, user_login v]
    CREATE TABLE ( ID int(10) unsigned NOT NULL auto_increment, user_login varchar(20) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_firstname varchar(50) NOT NULL default ”, user_lastname varchar(50) NOT NULL default ”, user_nickname varchar(50) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_icq int(10) unsigned NOT NULL default ‘0’, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_ip varchar(15) NOT NULL default ”, user_domain varchar(200) NOT NULL default ”, user_browser varchar(200) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_level int(2) unsigned NOT NULL default ‘0’, user_aim varchar(50) NOT NULL default ”, user_msn varchar(100) NOT NULL default ”, user_yim varchar(50) NOT NULL default ”, user_idmode varchar(20) NOT NULL default ”, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, user_description TEXT NOT NULL default ”, PRIMARY KEY (ID), UNIQUE KEY user_login (user_login) )

    Fatal error: Call to undefined function: get_option() in /homepages/5/d88122796/htdocs/wp-admin/upgrade-schema.php on line 172

    Did a search here but did not find a solution.

    I checked all the files to make sure none were missing.

    Any ideas on how to fix this? I was sooo close.. so I thought 🙁

    Thanks for any help

Viewing 4 replies - 1 through 4 (of 4 total)
  • Mark (podz)

    (@podz)

    19 years, 3 months ago

    “Then I made a copy of all the files onto my desktop and downloaded a nightly (2005-01-10) and merged those files together overwriting duplicates.”

    Merging files WILL cause huge problems.

    A nightly download is a complete standalone install.

    Thread Starter buffyvs

    (@buffyvs)

    19 years, 3 months ago

    but the install directions said to delete all files EXCEPT index.php, wp-content, cpnfig.php and something else if you had made changes to it
    To then upload new files, and then put back the config.php, index.php, and wp-content

    That is what I did really, I just did it on my desktop rather than on the server first.

    I have been trying this for 4 hours today, 5 hours yesterday. Just isnt working for me. I keep wanting to blame my webhost, but I know thats not the case..lol

    So, you are saying that I can just delete all my 1.2.2 files all together, just upload the 1.5 and thats it? Done? No need to have any prior files from the 1.2.2?

    Mark (podz)

    (@podz)

    19 years, 3 months ago

    My mistake maybe .. I took that to mean you mixed files in other ways.

    The upgrading process, as described here ( http://codex.wordpress.org/Upgrading_WordPress ) does work – really.

    Thread Starter buffyvs

    (@buffyvs)

    19 years, 3 months ago

    I am sorry for the confusion. I just meant that I followed those instructions to a T, but did so on my desktop then transfered them to my server

    I have no idea why this wont work for me. I know that it works, others have it going. For me though I keep having major issues.. I think I am going to go back to blaming it on my web host 😉 So, any of you out there using 1and1? Having problems?

    And thanks for the very fast replies podz 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Upgrade: So close but so far away’ is closed to new replies.