View Single Post
  #4  
Old 02-27-2008, 03:15 PM
 
mltriebe mltriebe is offline
 

Senior Member
  
Join Date: Mar 2006
Posts: 137
 

Default Re: X-Cart Advanced Reviews 4.X

I fixed this one finally!!!!!

Apparently when the table in the data base for product_votes updates for this mod it also changes from auto_increment to just a blank. Therefore all the reviews were being created with the voted_id of "0" and that gave the error. Once I changed it back to auto increment the error went away.

Now, I just need to get all the reviews to list.

Mike

Error Code:

[19-Feb-2008 05:53:59] (shop: 19-Feb-2008 05:53:59) SQL error:
Site : http://www.XXXXXXXXXX.net
Remote IP : XX.XX.XXX.XXX
Logged as :
SQL query : INSERT INTO xcart_product_votes (remote_ip, vote_value, productid) VALUES ('XX.XX.XXX.XXX','5', '350')
Error code : 1062
Description : Duplicate entry '0' for key 1
Request URI: /product.php?mode=review&productid=350
Backtrace:
/home/bmkdesig/public_html/include/func/func.db.php:180
/home/bmkdesig/public_html/include/func/func.db.php:106
/home/bmkdesig/public_html/vote.php:75
/home/bmkdesig/public_html/product.php:155
__________________
X-Cart 4.3.1
Buy Together Module, AlteredCart
CDSEO Pro
One Page Checkout, AlteredCart
Smart Search, AlteredCart
On Sale, AlteredCart
Reply With Quote