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

SQL errors when i apply a patch

 
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
 
Thread Tools
  #1  
Old 01-04-2009, 04:07 PM
 
modibaba modibaba is offline
 

Senior Member
  
Join Date: Mar 2008
Location: UK
Posts: 108
 

Default SQL errors when i apply a patch

I applied a sql patch part of the telafirma dynamc images mod but it failed and I got an email error message below, i appreciate if anyone can help:

SQL query : INSERT INTO `xcart_modules` VALUES (200, 'Dynamic_Images', 'This module dynamically generates new images from the larger images uploaded', 'Y')
Error code : 1062
Description : Duplicate entry '200' for key 1
Request URI: /admin/patch.php
__________________
X-Cart DB Version: 4.1.9 GOLD

Addons:
Amazon skin;
Fancy Categories;
Magnifier (enabled);
Survey (enabled);
CDSEO Pro;
Category SEO Map;
One Page Checkout;
Greet Visitor;
On_Sale;
Reply With Quote
  #2  
Old 01-04-2009, 06:05 PM
 
balinor balinor is offline
 

Veteran
  
Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253
 

Default Re: SQL errors when i apply a patch

Moving to Third Party Add-Ons
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
  #3  
Old 01-05-2009, 03:12 AM
  Vetrivel's Avatar 
Vetrivel Vetrivel is offline
 

eXpert
  
Join Date: Apr 2008
Posts: 398
 

Default Re: SQL errors when i apply a patch

do you have 200 modules in your store?

Noway
so First Check whether the "Dynamic_Images" is exist in your modules list.(ex:store/admin/modules.php)
if not then try the following patch instead of your patch
INSERT INTO `xcart_modules` ( `module_name` ,
`module_descr` ,
`active`
)
VALUES ('Dynamic_Images', 'This module dynamically generates new images from the larger images uploaded', 'Y');




Quote:
Originally Posted by modibaba
I applied a sql patch part of the telafirma dynamc images mod but it failed and I got an email error message below, i appreciate if anyone can help:

SQL query : INSERT INTO `xcart_modules` VALUES (200, 'Dynamic_Images', 'This module dynamically generates new images from the larger images uploaded', 'Y')
Error code : 1062
Description : Duplicate entry '200' for key 1
Request URI: /admin/patch.php
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 07:02 AM.

   

 
X-Cart forums © 2001-2020