Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

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

 
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
 
Thread Tools
  #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
  #2  
Old 01-29-2011, 03:47 AM
 
annasoaps annasoaps is offline
 

Advanced Member
  
Join Date: May 2007
Posts: 39
 

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

Oh, and the smiley with sun glasses up in the code is actually and 8 followed by a )
__________________
X-cart Version 4.1.7
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 10:51 AM.

   

 
X-Cart forums © 2001-2020