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

RickC Offline Joined: Nov 10, 2006 Posts: 53 Location: Flint Township, MI 0 👍 / 0 👎	Sun Nov 29, 2009 6:30 am 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. Please enter your server specs in your user profile! 😢
Phoenix Offline Joined: Mar 18, 2004 Posts: 1543 Location: Netosphere 0 👍 / 0 👎	Sun Nov 29, 2009 10:58 am Well, that was a damned stupid mistake Sorry - download updated. I expect it was the same issue as reported by thewarden. • Donations & Audit for DragonflyCMS • Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
thewarden Offline Joined: Jul 15, 2008 Posts: 47 0 👍 / 0 👎	Mon Nov 30, 2009 12:11 pm 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 Please enter your server specs in your user profile! 😢
thewarden Offline Joined: Jul 15, 2008 Posts: 47 0 👍 / 0 👎	Mon Nov 30, 2009 12:29 pm 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 Please enter your server specs in your user profile! 😢
Phoenix Offline Joined: Mar 18, 2004 Posts: 1543 Location: Netosphere 0 👍 / 0 👎	Mon Nov 30, 2009 2:16 pm 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 Post new topic Reply to topic Forum Index > eCommerce > Storez Page 1 of 1

Terms of Use : Phoenix Netology : © 2004 - 2021

Interactive software released under GNU GPL, Code Credits, Privacy Policy