Upgrade Problem (Table 'databasename.ps_timezone' doesn't exist

[sparior12]

Hey, i just upgraded my shop and when i go to the front or back office, it says

Table 'databasename.ps_timezone' doesn't exist
SELECT * FROM ps_timezone

What did i do wrong?

[EA4FVB]

I have just the same error, I think new database and old database are not =

any solution ?

[m-tias]

I've got the same problem as well.
I tried to update from 1.1.0.5 to 1.2.1 but the updater didn't finnish. I fixed all the permissions and pressed Next, then it got stuck. The progress bar was rolling but nothing happened, no network traffic at all either. When I tried to access the shop, I got the same message as above.

I tried to manually add the requested tables doing some copy/paste from the installer sql-file, but it didn't work that well. The products doesn't show and the <base href="" /> is wrong (it says <base href="domain.comhttp://domain.com/shop/" />).

I was wondering wether the fact that I installed Prestashop using mysql 4, and then moved to mysql 5, got anything to do with it?

Anyway, the problem seems to be that the updater doesn't upgrade the database correctly, if at all.

[m-tias]

The <base href="" /> problem was just a 1.1 theme issue. But still, the database isn't healthy.

[Kasperle]

Hello.

I have the same problem, any idea how to solve it?

Thanks!

[sibony88]

hi
i have the same prob is there a solution ???

[MPavliscak]

I have the same problem. PLEASE HELP!

thanks

[sibony88]

pls anyone can't upgrade my site do to a Table 'databasename.ps_timezone' doesn't exist
any idea

[jowa]

Hi, I've got the same problem upgrading on my local Mac OsX computer.
On step 2 "Système et permissions" everything is green = ok. Clicking next ->Gives the errors:

Extract from Firefox error console:

Erreur : erreur de syntaxe
Fichier Source : http://mysite/install/model.php?_=1251316222070&method=doUpgrade
Ligne : 1, Colonne : 1
Code Source :
Duplicate key name 'category_name'

ALTER TABLE ps_category_lang
-------------------------------------------------------------------------------------------------------

Erreur : uncaught exception: [Exception... "Could not convert JavaScript argument arg 0 [nsIDOMHTMLParagraphElement.appendChild]"  nsresult: "0x80570009 (NS_ERROR_XPC_BAD_CONVERT_JS)"  location: "JS frame :: http://mysite/js/jquery/jquery-1.2.6.pack.js :: anonymous :: line 11"  data: no]
-------------------------------------------------------------------------------------------------------

Prefix DB is: "ps_"

THE SOLUTION I CAN SEE:
Doing a complete new fresh installation with new db, then changing the backup.sql source code (from your backup http://www.prestashop.com/wiki/back_up_your_database/) to match with your new db schema + tables names and finaly restore your database.

[jowa]

Missing Info:

I upgraded from version 1.0.8 to 1.2.1 !
Should I first upgrade with 1.1 then the last one?
If yes, where can I download the 1.1 version?

Thanks ;-)

[jowa]

Congratulation Presta team ! You'are quick ! Bravo.

Should work now with the latest version 1.2.2 final from today !
I'will try sooner ;-)

PS: Merci à tous pour votre travail chevronné !

[sibony88]

ok the solution is like this ...after moving all the files into the new installation and installing prastashop 1.2
there is some new tables in the prastashop 1.2 that are not in the presta 1.1
so you need to delete from the new db all the tables that are the same with the old site
after you delete the tables you will remain with only about 18 tables that are new and aren't in the old DB
only then import the the old db

worked for me perfectly