upgrading database questions

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:frusty:

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

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 :wacko:

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

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:frusty:

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 :smile:

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

Rob

frank18:

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 :smile:

........... 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

RodG:

........... 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 ???

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....

Same problem here, upgrading from 1.3.8 to 1.3.9d.

Does anyone know what would cause this error when trying to update to 1.3.9d from 1.3.8a

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'

I was not able to solve the problem but I was able to get arround the issue by installing easy populate and outputting the csv then I just installed a new copy of zen and then inserted the csv.

fusionsp:

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;]

I got the same error and my site says " NOTICE: The website is currently Down For Maintenance to the public
Warning Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels."
at the top. And I can't get to my admin page.

When upgrading the database it will put the store in a down for MAINTENANCE status. After you get back into admin you can that by going to config -> WEBSITE MAINTENANCE

Admin should sill work even if the update faild. Are you having troubble loggin in or can you not get to your admin login page?

I just figured the admin page out. Missing one backslash in the configure file. Thanks! Now if I could just upgrade the database properly.

I don't know if anyone else has noticed, but when I go to Upgrade Database again after the error, it says that the database appears up to date. Perhaps the database is up to date and just has not updated in the Admin section?

I thought about just using Easy Populate and reinstalling ZenCart, but all my customer accounts and changes I've made to the site would be gone. So hopefully someone comes up with a fix for this, or I'll have to give in and reinstall after the weekend.

well, i fixed my issue. it turned out to be linked to the counter problem.

I had duplicates in my counter file since I upgraded wrong last time i did it.

heres the link to that thread http://www.zen-cart.com/forum/showthread.php?t=153617&highlight=counter+history

What I had to do was first enter the correct code in my includes/counter.php which is located on the 2nd page of that link.

Secondly i had to recreate the counter file itself which is done through entering a command string into the SQL patch.

then I just re-ran the zc_install and clicked on the 1.3.8 to 1.3.9 upgrade. it errored 3 times but ended up processing 32 commands for me.

My database now reads 1.3.9d :clap:

Thanks for everyones help and i hope this may help someone else

I did that fusionsp, but it did not work for me :(

I already had the correct code in the counter.php file, emptied my Counter History, then I ran that script, and ran the database update and received the same still. My Admin still says 1.3.8 for the database.

Everyone getting the 'utf8' error when upgrading the database, go do the fix DrByte posted at
http://www.zen-cart.com/forum/showpost.php?p=897548&postcount=6

It's just so simple it actually makes sense! I tried everything else listed on this site and none worked. But the fix DrByte found worked for me and my database is now 1.3.9d like it should be. Hope that works for everyone else :smile:

simply_sterling:

Everyone getting the 'utf8' error when upgrading the database, go do the fix DrByte posted at
http://www.zen-cart.com/forum/showpost.php?p=897548&postcount=6

It's just so simple it actually makes sense! I tried everything else listed on this site and none worked. But the fix DrByte found worked for me and my database is now 1.3.9d like it should be. Hope that works for everyone else :smile:

That was it!:clap: