Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Storez » [fixed] Database Error cpg_inst.php on line: 1142
[fixed] Database Error cpg_inst.php on line: 1142
A comprehensive shopping cart solution.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Storez

View previous topic :: View next topic  
Author Message
RickC
Manager
Manager

Offline Offline
Joined: Nov 09, 2006
Posts: 53
Location: Sharps Chapel, TN
PostPosted: Sat Nov 28, 2009 10:30 pm
Post subject: [fixed] Database Error cpg_inst.php on line: 1142

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.


RickC's 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
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Sun Nov 29, 2009 2:58 am
Post subject: Re: Database Error

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


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
thewarden
Nice Poster
Nice Poster

Offline Offline
Joined: Jul 14, 2008
Posts: 47

PostPosted: Mon Nov 30, 2009 4:11 am
Post subject: Re: [fixed] Database Error cpg_inst.php on line: 1142

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.

Quote::
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

thewarden's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.39 (Unix)/4.1.22-standard/5.2.4/CPG 9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
thewarden
Nice Poster
Nice Poster

Offline Offline
Joined: Jul 14, 2008
Posts: 47

PostPosted: Mon Nov 30, 2009 4:29 am
Post subject: Re: [fixed] Database Error cpg_inst.php on line: 1142

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

thewarden's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/1.3.39 (Unix)/4.1.22-standard/5.2.4/CPG 9.2.1
Back to top
View user's profile Send e-mail Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Mon Nov 30, 2009 6:16 am
Post subject: Re: [fixed] Database Error cpg_inst.php on line: 1142

Quote::
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.


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Storez
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum