Magento

Hello.
I have tried on many occasions to upgrade my install to the new 1.1.2 but i keep getting this error:

PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_quote’ already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /home/manicure/domains/manicured.co.uk/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 150
[trace:private] => Array
(
[0] => Array
(
[file] => /home/manicure/domains/manicured.co.uk/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 150
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `sales_flat_quote` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default ‘0’,
`created_at` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`updated_at` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`converted_at` datetime NOT NULL default ‘0000-00-00 00:00:00’,

`is_active` tinyint(1) unsigned default ‘1’,
`is_virtual` tinyint(1) unsigned default ‘0’,
`is_multi_shipping` tinyint(1) unsigned default ‘0’,

Any ideas, very confused.

warm regards

rob

Hi,

What method are you using to upgrade your Magento store? You should be following one of the methods listed here - http://magentocommerce.com/wiki/upgrading_magento

That’s due to couple of things.

1) Your tables are MyISAM and need to be converted to InnoDB
2) You may want to disable foreign key checks

What I do in this case is just edit the mysql-upgrade-x.php script and directly edit their mysql queries. Reason is because if you’ve performed an upgrade but you got an error, there are times your script went half way finished and you have some already in place while others you don’t. Such things happen when the upgrades creates a temporary table but then failed during the data import. Then you already have that table, so now it’s going to give you out an error that it exists, as you’ve pointed out here.

So you may need to start hacking your magento at this point, unless Varien can come up with more seamless upgrading options.

oh dear, this sounds very complicated. My back ups also have the same trouble,

even when i clear the cache the error comes up.

is it possible to copy my orders, products, customers, info to a clean install

cheers

Well that does sound to me like you going to have to dig up the code one by one to clear up the mess.
Or do you have the backup of the database as well? Because if you backed them up, you should be able to revert to it without a problem.

Ok, does simple helix have a backup of my backups, i was told by your team that this error was casued becasue i had gone over my memory limit so deleted a couple of old back up leaving only 2 which i never knew also had this problem. Maybe Simple Helix had the ones i deleted then i can just revert back to them......

my domain is manicured.co.uk thanks.

RH,
I’ll have the support team give you a heads up on your account.

Has anyone come up with a solution to this? I keep getting this error when upgrading and have already burned several days worth of working time trying to get a simple upgrade to work and am unable to do so because of this error.