Thread

Simply trying to upgrade from 1.6.9 to 2.1 with no success.  This is the first error I come across.

{"error":"
Error Number: 1050

\n\n
Table 'exp_snippets' already exists

\n\n
CREATE TABLE `exp_snippets` (\n `snippet_id` int(10) unsigned NOT NULL auto_increment,\n `site_id` int(4) NOT NULL,\n `snippet_name` varchar(75) NOT NULL,\n `snippet_contents` text NULL,\n PRIMARY KEY (`snippet_id`),\n KEY `site_id` (`site_id`)\n )

"}

Any ideas?  My server passes all the tests with flying colors.

jbriggs,

Have you downloaded the very latest build?
What is app_version in system/config.php?

I assumed it’s the latest build, i downloaded it yesterday, Aug 3. 

App version on my current install is $conf[‘app_version’] = “169”;

Did you attempt to upgrade earlier, and got part of the way through the install?

The very first time I tried to upgrade I got a MySQL 2006 error, it seemed to stop on one of my extensions.  I’ve since tried the update a dozen times, each time needing to restore the database, and ending up with the 1050 error.

jbriggs,

Please roll back your files and database to their 1.6.9 state. Then try the upgrade making sure the third_party folder is empty per this thread.

If you still encounter an error let us know before continuing further.

Not sure what you mean with the third_party folder.  1.6.9 has no third_party folder and I think the thread you referenced, they were upgrading from 2.0.

I set config.php to disable extensions, but that makes no difference.  Also, I’m trying to upgrade using ‘system’ as the name for the system folder.  My current install has a different name.

jbriggs,

When your files and database are back to their 1.6.9 state, what’s the first error you encounter when upgrading? exp_snippets was added in EE2; it should not be present in your database if it was properly rolled back to the 1.6.9 version.

Ok, I just restore to a database that I’m sure doesn’t have exp_snippets, yet, when I check out the tables - exp_snippets, exp_accessories, etc are all still there.  Could this be an issue with Plesk just not getting rid of the extra tables?

jbriggs,

I see you replied to similar thread. Can we keep your troubleshooting just for this thread please as it will be easier to focus on rather than multiple responses.

Take a look in your EE database at the exp_password_lockout table. Does it have a field called ‘username’?

Hi John, yes that field is part of exp_password_lockout.

Regarding the other thread, I’m not sure why the EE 2.0 tables are still part of the restored database?

Ok, I just restore to a database that I’m sure doesn’t have exp_snippets, yet, when I check out the tables - exp_snippets, exp_accessories, etc are all still there.  Could this be an issue with Plesk just not getting rid of the extra tables?

When you restore a database, be sure you are importing the SQL into an otherwise empty database without any existing tables. I have not used Plesk, but with phpMyAdmin what I do is 1) drop the entire database I want to replace, 2) create a new database of the same name 3) import the SQL.

I’ll give that a shot.  I’m not sure what admin panel I was actually using, maybe it was cPanel, but i’ll try what you said and see how it goes.  Thanks!

Hi jbriggs,

Good stuff. Let us know how it goes.

Cheers

Greg