Amazon

DragonflyCMS Projects > Storez > [fixed] Database Error cpg_inst.php on line: 1142 > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

[fixed] Database Error cpg_inst.php on line: 1142 Reply to topic


During Upgrade of my test site I got this.

CMS Warning line 75: On /rfe/admin.php?op=modules&upgrade=32 While executing query "SELECT config_value FROM cms_cart_config WHERE config_name=companyCountry" the following error occured: Unknown column 'companyCountry' in 'where clause' In: /homepages/12/d91017768/htdocs/LocalQuality_com/rfe/modules/Storez/cpg_inst.php on line: 1142

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

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux infong 2.4 /5.0.91-log (client: 5.0.92)/5.2.17/9.3.3.0


Well, that was a damned stupid mistake Embarassed

Sorry - download updated.

I expect it was the same issue as reported by thewarden.

DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS

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


Still doing it for me. Was there a different file I should have downloaded? After reading your reply, I downloaded the storez package and started over. Still getting the error.

includes/db/db.php

* CMS Warning line 75: On /admin.php?op=modules&upgrade=17 While executing query "ALTER TABLE cms_cart_products ADD shiplength FLOAT(6,2) NOT NULL DEFAULT '0.00'" the following error occured: Duplicate column name 'shiplength' In: /home/smithsgr/public_html/modules/Storez/cpg_inst.php on line: 1104


Is this because the previous attempt did make some changes before getting the previous error? And now it's erroring?

L8r!
The Warden
www.smiths-grove.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.39 (Unix)/4.1.22-standard/5.2.4/CPG 9.2.1


Ok, since it appeared that the error was about an existing column, I went ahead and commented out lines 1104, 05, & 06 of cpg_inst.php, and tried again, and no more error. It seems to have worked. So far so good. Will this be ok??

L8r!
The Warden
www.smiths-grove.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.39 (Unix)/4.1.22-standard/5.2.4/CPG 9.2.1


Is this because the previous attempt did make some changes before getting the previous error? And now it's erroring?
Yes - your solution is the best way around it.

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

All times are Australia/Adelaide


Jump to: