[Solved]: Problem with Shopping Cart plugin [Solved]: Problem with Shopping Cart plugin
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

[Solved]: Problem with Shopping Cart plugin

Started by erika_conn, July 02, 2008, 12:27:39 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

erika_conn

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?

Stramm


erika_conn

That fixed everything.  Wow.  Thanks.