upgrading database questions

[fusionsp]

my zencart is showing version 1.39d

but my database is showing version 1.39a

how to i update it correctly? i did the 2 prior upgrades with an automated one and now im seeing the errors of my ways.

someone please help

[RobWUK]

i think that, if you still have your installation files on the server then you can visit your domain with /zc_install on the end and if your site is already setup and working then it should give you an option to upgrade database

backup first tho

Rob

[fusionsp]

well, it does give me the option to do the database but it only says to go from 1.38 to 1.39?

it doesnt have all the mid options that they have done. And like i said, Im currently at version 1.39a.

Also too there is another upgrade option that im not sure what is for? I didnt click that since I had never seen that one before.

But Im hoping that someone knows how to do the database please

[RobWUK]

yes, that is correct for the database 138 to 139

you have the files for 1.3.9d uploaded so you are upto date with files

just need to do your database to 139

Rob

[frank18]

my zencart is showing version 1.39d

but my database is showing version 1.39a

how to i update it correctly? i did the 2 prior upgrades with an automated one and now im seeing the errors of my ways.

someone please help

It shows that you have updated your store files and database from an earlier version to 1.3.9a

Subsequent upgrades (of certain files) from 1.3.9a to b, c or d do not require/involve a DB update.

Therefore, what you are seeing (v1.3.9d with DB 1.3.9a) is correct, valid and nothing to worry about

[RobWUK]

Sorry i read your original post as your database was 138, i need to pay attention :)

Rob

[RodG]

It shows that you have updated your store files and database from an earlier version to 1.3.9a

Subsequent upgrades (of certain files) from 1.3.9a to b, c or d do not require/involve a DB update.

Therefore, what you are seeing (v1.3.9d with DB 1.3.9a) is correct, valid and nothing to worry about

........... however, if this is a concern re-running the 1.3.8-> 1.3.9 sql upgrade script again will produce lots of harmless errors as well as upgrading the db version to match/show the 'd' suffix.

Cheers
Rod

[frank18]

........... however, if this is a concern re-running the 1.3.8-> 1.3.9 sql upgrade script again will produce lots of harmless errors as well as upgrading the db version to match/show the 'd' suffix.

Cheers
Rod

spot on Rod

PS: when are you next at the Sunny Coast so we can have a few frothies ???

[fusionsp]

well, I kinda wanted to update it even though it may create a few errors. But it has 2 options...

Upgrade DB and update CFG files? what is the CFG files?

and I tried to do the database update anyways and it came back with an error

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE counter_history_clean as SELECT * FROM counter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]

what does this mean??

I know this is prob a dumb question, but Im using hostmonster and they have their scripting updates. Its still telling me that my site needs updates, I manually did the file update like they show here...but Im wondering if i had them do the update script, if it would fix my DB? Or would it potentially break something?

Like my counter...its reading the duplicates like i found here and i havent had time to fix that yet....

[Branden]

Same problem here, upgrading from 1.3.8 to 1.3.9d.