upgrading database questions

09 Jun 2010, 20:37

#1

Zen Follower

Join Date:: Jun 2008
Posts:: 204
Plugin Contributions:: 0

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:

09 Jun 2010, 21:43

#2

robwuk

Zen Follower

Join Date:: Aug 2005
Posts:: 458
Plugin Contributions:: 0

Re: upgrading database questions

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

10 Jun 2010, 01:07

#3

fusionsp

Zen Follower

Join Date:: Jun 2008
Posts:: 204
Plugin Contributions:: 0

Re: upgrading database questions

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:

10 Jun 2010, 08:50

#4

robwuk

Zen Follower

Join Date:: Aug 2005
Posts:: 458
Plugin Contributions:: 0

Re: upgrading database questions

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

10 Jun 2010, 10:00

#5

frank18

Deceased

Join Date:: Nov 2007
Posts:: 3,427
Plugin Contributions:: 2

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

10 Jun 2010, 12:32

#6

robwuk

Zen Follower

Join Date:: Aug 2005
Posts:: 458
Plugin Contributions:: 0

Re: upgrading database questions

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

Rob

10 Jun 2010, 13:43

#7

rodg

Deceased

Join Date:: Jan 2007
Posts:: 6,263
Plugin Contributions:: 3

Re: upgrading database questions

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

10 Jun 2010, 13:52

#8

frank18

Deceased

Join Date:: Nov 2007
Posts:: 3,427
Plugin Contributions:: 2

Re: upgrading database questions

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

11 Jun 2010, 01:26

#9

fusionsp

Zen Follower

Join Date:: Jun 2008
Posts:: 204
Plugin Contributions:: 0

Re: upgrading database questions

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

11 Jun 2010, 01:29

#10

branden

New Zenner

Join Date:: Apr 2010
Posts:: 50
Plugin Contributions:: 0

Re: upgrading database questions

Same problem here, upgrading from 1.3.8 to 1.3.9d.

11 Jun 2010, 16:22

#11

branden

New Zenner

Join Date:: Apr 2010
Posts:: 50
Plugin Contributions:: 0

Re: upgrading database questions

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'

11 Jun 2010, 17:33

#12

branden

New Zenner

Join Date:: Apr 2010
Posts:: 50
Plugin Contributions:: 0

Re: upgrading database questions

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.

11 Jun 2010, 17:45

#13

buzzfever

New Zenner

Join Date:: Oct 2009
Posts:: 39
Plugin Contributions:: 0

Re: upgrading database questions

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.

11 Jun 2010, 18:42

#14

branden

New Zenner

Join Date:: Apr 2010
Posts:: 50
Plugin Contributions:: 0

Re: upgrading database questions

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?

11 Jun 2010, 18:44

#15

buzzfever

New Zenner

Join Date:: Oct 2009
Posts:: 39
Plugin Contributions:: 0

Re: upgrading database questions

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

11 Jun 2010, 19:10

#16

simply_sterling

New Zenner

Join Date:: Jun 2009
Posts:: 12
Plugin Contributions:: 0

Re: upgrading database questions

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.

12 Jun 2010, 01:04

#17

fusionsp

Zen Follower

Join Date:: Jun 2008
Posts:: 204
Plugin Contributions:: 0

Re: upgrading database questions

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

12 Jun 2010, 17:21

#18

simply_sterling

New Zenner

Join Date:: Jun 2009
Posts:: 12
Plugin Contributions:: 0

Re: upgrading database questions

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.

14 Jun 2010, 15:42

#19

simply_sterling

New Zenner

Join Date:: Jun 2009
Posts:: 12
Plugin Contributions:: 0

Re: upgrading database questions

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:

14 Jun 2010, 17:29

#20

branden

New Zenner

Join Date:: Apr 2010
Posts:: 50
Plugin Contributions:: 0

Re: upgrading database questions

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: