DragonflyCMS Projects > Storez > [solved] DB error upgrade 9.3.1 > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

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

L8r!
The Warden
www.smiths-grove.com

Please enter your server specs in your user profile! 😢


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?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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

Please enter your server specs in your user profile! 😢


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

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

L8r!
The Warden
www.smiths-grove.com

Please enter your server specs in your user profile! 😢


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.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


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!

L8r!
The Warden
www.smiths-grove.com

Please enter your server specs in your user profile! 😢

All times are Australia/Adelaide


Jump to: