troubles updating from 1.38 to 1.50

Hi,

I think I've read all the tutorials, and many threads here, but perhaps it's my comprehension of English, or just my mind which is not set right; however I am trying to upgrade from 1.38 to 1.50.

After many tries, and retries, I have managed to have zen-cart 1.5 with db of 1.39h
And of course I get the warning to update the database to higher level (1.50)

Here's the tools >> server info

Zen Cart 1.5.0
Livello Patch Database: 1.3.9h
v1.3.9h [2012-06-22 14:14:18] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2012-06-22 14:07:57] (Version Update 1.3.7->1.3.8)
v1.3.8 [2009-09-18 06:28:56] (Nuova installazione)

I guess you don't need translation, but for the sake of complete info here it is
Livello Patch Database: 1.3.9h >>> database patch level
(Version Update 1.3.8->1.3.9h) >>> version update
(Version Update 1.3.7->1.3.8) >>> version update
(Nuova installazione) >>> new installation

I am using the Italian version of zen-cart, and in the 1.50 zc_install/sql there wasn't any mysql_upgrade_zencart_xxx_to_yyy.sql

I copied these three from the English package
mysql_upgrade_zencart_137_to_138.sql
mysql_upgrade_zencart_138_to_139.sql
mysql_upgrade_zencart_139_to_150.sql

And as you can see it did upgrade from 1.38 to 1.39

But when I try to go to 1.50 I get
"WARNING: An Error occurred, please refresh the page and try again."

I had checked only the upgrades
from 1.37 to 1.38,
from 1.38 to 1.39,
from 1.39 to 1.50
a few times, getting errors, then I did only the first two, and apparently it worked, and now when I try the latter (1.39 to 1.50) I get the error (WARNING).

When I access the directory I do see the "store": all products, etc. save the info pages (shipping, tos, etc.)

I also think I messed up the original site/directory as in the tool >> server info I see
Zen Cart 1.3.8a
Patch: 1::
Livello Patch Database: 1.3.9h
v1.3.9h [2012-06-22 14:14:18] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2012-06-22 14:07:57] (Version Update 1.3.7->1.3.8)
v1.3.8 [2009-09-18 06:28:56] (Nuova installazione)

Thank you

I think I fixed it.
Can you please confirm if it is ok?

This is what I did:

I installed a new zencart 1.50
I then exported about 30 tables (the ones I had my data in) from the 1.39 version database
I deleted the corresponding tables form the new install (database version 1.50)
I imported the tables I previously saved from the database v.1.39 into the new database v.1.50

Now at the new install tools >> server info I see
Zen Cart 1.5.0
Livello Patch Database: 1.5.0
v1.5.0 [2012-06-23 09:03:08] (Nuova installazione)
v1.5.0 [2012-06-23 09:03:08] (Nuova installazione)

And of course I do see the products, orders, etc.
I have to check it all in details, but I am optimistic, specially if you confirm what I did is ok.

Thank you

What you did is definitely not recommended. Whether you get away with it or not, I cannot say.

Rob

Thanks Rob.

I know, indeed I tried to follow the instructions, but somewhere either I missed something (high probability), or something didn't go as expected.

I hope someone can tell me what to look for potential risks I am going to face, or if there is a way out of it.

I suppose, to properly advise whether you're going to have problems, we'd have to know which tables you imported and which you didn't. And whether you did the database upgrade step after import, and so on. Not enough details yet to be sure. (Not that I could be sure anyway, but perhaps someone more experienced could assess the situation.)

Rob

Thank you Rob

And whether you did the database upgrade step after import, and so on.

Hmmmm ... was there an upgrade step to do? I missed that for sure, care to refresh it for me please?

Anyhow, I attach the tables list, and the sql file (from which I removed all the data of the INSER INTO, but they where imported correctly to the new db)

keneso:

Hmmmm ... was there an upgrade step to do? I missed that for sure, care to refresh it for me please?

In your download of the ZC 1.5.0 package, in the docs folder, have a look at the file 2.readme_how_to_upgrade.html. That explains it clearly. If you didn't do that in your first attempt, that would explain the problem.

Rob

rstevenson:

In your download of the ZC 1.5.0 package, in the docs folder, have a look at the file 2.readme_how_to_upgrade.html. That explains it clearly. If you didn't do that in your first attempt, that would explain the problem.

Ohhh ... that one ...
Yes, I had read it, and tried to follow it in the first place, but like said (or implied) in the opening post I must have not comprehended it well, and perhaps missed something, and that's why I got to this point.

That explains it clearly.

Obviously not for me. ;)

Anyhow, now I tried to upgrade the last 1.50 installation, to not let anything untried, and I get this
"WARNING: An Error occurred, please refresh the page and try again."

I then renamed my admin, and I tried to access the admin, and luckily it works, while in the previous tries it wouldn't.
I checked again the server info, and it reports
Zen Cart 1.5.0
Livello Patch Database: 1.5.0
v1.5.0 [2012-06-23 09:03:08] (Nuova installazione)
v1.5.0 [2012-06-23 09:03:08] (Nuova installazione)

So we are back at post #2 ?!

I've run out of ideas. :blink:

I guess if you're satisfied that you got all your data in your imports from the old db, and the site seems to be working both for customers and from the admin point of view, then you might as well just go ahead.

Rob

Thank you very much for your effort Rob, I really appreciate.
I think I'll go with your suggestion and risk it, but meanwhile I am trying another approach:

I duplicated the live 1.38, and tried upgrading it to 1.39, and then to 1.50
All fine and smooth in the 1.38 to 1.39
Unfortunatelly no luck with 1.39 to 1.50
Where I do get again the
"WARNING: An Error occurred, please refresh the page and try again."

I am attaching the error logs to se if maybe DrByte can shed some light into it for me.
I noticed in one of the logs there is some Italian word, with accented characters, might that be one of the issues?

Also another peculiarity of the Italian version is they have removed basically all the sql upgrade files from zc_install/sql including mysql_upgrade_zencart_139_to_150.sql which I took from the English version.
Another fact is they have bundled the currency/language in header mod.

All the versions 1.38 - 1.39 - 1.50 I am using are the Italian version releases.

Is there a particular reason why you can't use the official English version of Zen Cart and simply add the italian language files afterward?

The error messages indicate that there are SQL errors occurring because of apostrophes etc in the error messages. Whether that's a programming bug or not, I haven't investigated. But it seems likely that if you were to use the entire english /zc_install/ folder instead of an unofficial one from another language, that things would go better for you.

1. Delete your zc_install folder
2. Replace it with the official english zc_install folder
3. Re-import your 1.3.8 database
4. Re-run zc_install and choose Database-Upgrade

keneso, can you check your messages. i left you one

Thank you DrByte.

DrByte:

Is there a particular reason why you can't use the official English version of Zen Cart and simply add the italian language files afterward?

Not really, I thought they only added the language files, plus the currency/language add-on, hence one download, one upload ... obviously I was wrong.
For the next ones I'll follow your suggestion, promise.

Now to the upgrade:
It worked ... almost.

I got a few warnings

62 statements processed.
Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

From the db exceptions table

(1, 'sql/mysql_zencart.sql', 'Impossibile creare la tabella nochex_apc_transactions perchè già presente', '2009-09-18 06:28:56', 'CREATE TABLE nochex_apc_transactions ('),
(2, 'sql/mysql_zencart.sql', 'Impossibile creare la tabella nochex_sessions perchè già presente', '2009-09-18 06:28:56', 'CREATE TABLE nochex_sessions ('),
(3, 'sql/mysql_zencart.sql', 'REASON_TABLE_NOT_FOUND CHECK PREFIXES!', '2009-09-18 06:28:56', 'ALTER TABLE linkpoint_api CHANGE COLUMN zen_order_id order_id int(11) NOT NULL default ''0'';'),
(4, 'sql/mysql_upgrade_zencart_139_to_150.sql', 'Cannot drop index page_accessed on table admin_activity_log because it does not exist.', '2012-06-26 05:33:29', 'ALTER TABLE admin_activity_log DROP INDEX page_accessed;'),
(5, 'sql/mysql_upgrade_zencart_139_to_150.sql', 'Cannot drop index access_date on table admin_activity_log because it does not exist.', '2012-06-26 05:33:29', 'ALTER TABLE admin_activity_log DROP INDEX access_date;'),
(6, 'sql/mysql_upgrade_zencart_139_to_150.sql', 'Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.', '2012-06-26 05:33:29', 'ALTER TABLE admin_activity_log ADD INDEX idx_page_accessed_zen (page_accessed);'),
(7, 'sql/mysql_upgrade_zencart_139_to_150.sql', 'Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.', '2012-06-26 05:33:29', 'ALTER TABLE admin_activity_log ADD INDEX idx_access_date_zen (access_date);');

And perhaps worse than that when trying to access the admin, I get the zencart welcome page, where it tells you there are two reasons if you see this page, one is the first time, and the other being:

"Your files /includes/configure.php e/o /admin/includes/configure.php have wrong paths and/or db connection is wrong."

I have checked, the config files, and seems the paths are ok, but I might have missed something?

Honestly I am not very much interested into getting to the admin of this install, as it was made just for upgrade purpose, if you tell me I can make a fresh install, and export the upgraded database into the new install.
I mean I export, and save this last database, and then crate a new directory, and install zencart 1.50 into it, and then import the saved database; given the warnings above are not an issue.

Update on not being able to get to the admin area.

I compared the admin/includes/configure.php paths of this upgrade, and a fresh install, and noticed a couple differences, I fixed them, and now it's all fine.
I can access the admin, and the server info tells me the db and the site are 1.50.

Now I have one question, and one issue:

I do notice there are the following 4 tables in the upgraded db, whereas in the fresh install of v.1.50 they are lacking, shall I just delete them?

customers_wishlist
ezpages_content
nochex_apc_transactions
nochex_sessions

Now I have the utf8 problem, I am reading thru the various post, though it's more confusing every other post I read.
If you have a quick fix to share here I don't mind. ;)

Thank you

keneso:

Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.

SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.
Those can be safely ignored. They are a result of trying to do cleanup which may have already been done previously.

keneso:

I do notice there are the following 4 tables in the upgraded db, whereas in the fresh install of v.1.50 they are lacking, shall I just delete them?

customers_wishlist
ezpages_content
nochex_apc_transactions
nochex_sessions

-customers_wishlist -- was an unused table in Zen Cart. It is not automatically removed by the upgrade script because some addons have used it, and Zen Cart wouldn't want to delete your data mistakenly.

• ezpages_content -- comes from another addon, and is not part of original Zen Cart files
• nochex tables -- are only created if you use the nochex addon payment module

keneso:

Now I have the utf8 problem, I am reading thru the various post, though it's more confusing every other post I read.
You will have character-set problems if you were using a different character set in your old version and don't tell your new version to use the same old character set.
http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8
Set your language files to use the same character-set as you had in your old site.

DrByte:

You will have character-set problems if you were using a different character set in your old version and don't tell your new version to use the same old character set.
http://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-8859-1-to-utf8
Set your language files to use the same character-set as you had in your old site.

Thank you.

I had read that, plus a few more on this, but I'm still confused, and MAKING confusion ... hell, I have problems encoding my browser ...

Anyway, if you can kindly compare the two sets, and tell me where to make the changes I'll surely appreciate it much.

ita01 is the one that shows correctly, and is the db referenced to in post #2 of this thread
it's visible at mulkhosting dot com / zencart/ITA_01

demo150 is the one with the problematic display, and is the one you assisted me in upgrading
it's visible at tesserasconti dot com / demo150

Sorry, I'm confused by your post and your files. So I offer this instead (this is what the FAQ article I mentioned is telling you):

a) what was the CHARSET and setlocale() from your OLD site's english.php and italian.php language files?
b) use those SAME settings in your NEW site
c) and set the DB_CHARSET in your new configure.php accordingly.

Sorry for creating confusion ... you can imagine what's in my head!

Anyhow, thank you very much for the "translation" of that tutorial, it helped me better understand it.
Nevertheless I did exactly that, duplicating the original site's settings, and it didn't work, BUT that made me try and duplicate the settings of the "site" on my post #2 (the same making me open this thread, alas ita01), and it did the trick.

For clarity (I hope) here the settings:

original site
english.php >> en_US.ISO_8859-1
italian.php >> Italian
configure >> NO charset

demo150 not ok
english.php >> en_US
italian.php >> it_IT.ISO_8859-1
configure >> utf8

ita_01 ok and duplicated for demo150
english.php >> en_US
italian.php >> it_IT.UTF-8
configure >> utf8

Thank you for the kind and patient support.

That's bizarre, because it looks backwards to what should work.
There must be more going on there than just the information posted.
But, glad it's working for you.