View Single Post
  #1  
Old 01-29-2011, 03:46 AM
 
annasoaps annasoaps is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 39
 

Default Error when applying SQL patch (for Advanced Product Ratings and Reviews)

Good morning!

I bought Advanced Product Ratings and Reviews yesterday from WebsiteCM, and when I was going to install it I ran into problems right away. Step 1 was to install SQL patches, and the first patch (patch.sql) gave me this error:

*/ CREATE TABLE bcse_prnr_reviews( id int(11) not null auto_increment, productid int(11) not null default '0', remote_ip varchar(15) not null default '', login varchar(32) not null, ratings_overall decimal(9, not null default '0.0', votes_score decimal(9, not null default '0.0', /* "most helpful" score */ timestamp int(11) not null default '0', status char(1) not null default 'P', imported char(1) not null default 'N', primary key(id) /* Either remote_ip or login can be used as a key */ )

I have no idea what this means (and Mommy brain doesn't help! haha! I feel so stupid sometimes ). Anyways, stay on topic!

I tried to send in a support ticket with WebsiteCM but got error messages there to (!), so I emailed them. I haven't heard back yet, and now it's weekend so I assume they are closed. Soooo... just in case some kind soul here knows what the message above means and what I can do about it, I thought I should check here too. Thank you!!
__________________
X-cart Version 4.1.7
Reply With Quote