forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 plugins => Topic started by: erika_conn on July 02, 2008, 12:27:39 pm

Title: [Solved]: Problem with Shopping Cart plugin
Post by: erika_conn on July 02, 2008, 12:27:39 pm
http://ceconn.com/photo_gallery

When I click on Images in Cart or Checkout, I get this error:

There was an error while processing a database query.
While executing query "SELECT * FROM cpg_shop_prices WHERE aid=" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

File: /home/cecon46/public_html/photo_gallery/include/functions.inc.php - Line: 249

That line has this:  cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);

I read some of the others who've received the same or similar error message and I tried the phpMyAdmin database repair but that did nothing.  There is a database in there called COPP1.  I have no idea how it got there.  Would that have been created by Coppermine?
Title: Re: Problem with Shopping Cart plugin
Post by: Stramm on July 02, 2008, 12:35:36 pm
Clear your cookies and retry.
Title: Re: Problem with Shopping Cart plugin
Post by: erika_conn on July 02, 2008, 01:10:20 pm
That fixed everything.  Wow.  Thanks.