[solved] DB error upgrade 9.3.1 Reply to topic

Currently using 9.2.9, when I do the upgrade to 9.3.1 (which I just downloaded), I'm getting a database error. This is the output generated with debug mode on. Not sure if this is what you need but it's all that it's showing besides the typical "A database error has occurred. The webmaster has been notified of the error."


Initiated by Bugger (Original Entry) - Comments Here Please.

I'm afraid that's not debug - that's just session data, so I've removed it.

Set these to "Yes":
Show PHP Warnings
Show PHP Notices
Show CMS Warnings
Show CMS Notices
Show database queries

Set "Show session data on error pages" to "No".

Then you will get some meaningful output.

I ran the 9.3.1 upgrade on another site and had no issues?

Was there an issue for Storez?

I'm just about ready to release v9.3.2 and would like to add the fix, if needed.

I installed 9.3.1 over 9.2.5 on my test site and it installed fine for me.
Un-install work without any problems as well

Sorry so late. For some reason, I didn't get a reply notification...

I turned on debugging before, but didn't scroll all the way to the bottom to see the actual results.

Anyhow, I'm running 9.2.9, I deactivate the module, upload the new files, then go to the "Upgrade" link from the "edit" link for the module, and here is what is produced...

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&upgrade=16 While executing query "ALTER TABLE cms_cart_cartitems ADD itemWeight DOUBLE(10,4) NOT NULL DEFAULT '0.0000'" the following error occured: Duplicate column name 'itemWeight' In: /home/smithsgr/public_html/modules/Storez/cpg_inst.php on line: 1057

Okay, now we can do something about it - for whatever reason, you have some fields added so the installer is choking on those.

You will need to manually edit your database, so a backup copy of the cms_cart_* fields, structure and data, is necessary.

Check if these tables/fields exist:
cms_cart_config - days_as_new cms_cart_cartitems - itemWeight cms_cart_options_selections - selectionWeight cms_cart_orders - orderFree cms_cart_orders_cartitems - prodFree cms_cart_orders_cartitems - itemWeight cms_cart_orders_cartitems_options - selectionWeight cms_cart_preorders - orderFree cms_cart_preorders_cartitems - prodFree cms_cart_preorders_cartitems - itemWeight cms_cart_preorders_cartitems_options - selectionWeight cms_cart_products - prodFree cms_cart_products - featured cms_cart_stores - products
DELETE any individual field (column) that exists then run the upgrade again.

Alternatively, if you only have a couple missing, list them so I can provide an adjusted cpg_inst.php file and we can proceed from there.

Seems to have worked. At least I got past the database error. I will check more thoroughly tomorrow, and report back. Thanx for all the help!