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

HELP! SQL error

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 06-06-2004, 03:18 PM
 
bluecat bluecat is offline
 

X-Adept
  
Join Date: Nov 2002
Posts: 674
 

Default HELP! SQL error

Can anyone please help me on this and tell me what this means and/or how to fix it? I cannot clone or add any products to my database. Here is the error I get:

Code:
INVALID SQL: 1054 : Unknown column 'meta_keys' in 'field list' SQL QUERY FAILURE: UPDATE xcart_products SET product... (goes on further listing the product)
__________________
--------------------
X-Cart Gold 4.1.11
Linux/Apache
--------------------
Reply With Quote
  #2  
Old 06-07-2004, 06:45 AM
  lildawg's Avatar 
lildawg lildawg is offline
 

X-Adept
  
Join Date: Jan 2003
Location: Utah
Posts: 686
 

Default

I fixed this earlier today. You had a customization in your old version of x-cart and when you had me move your info to your new server I left added fields in your database as I assumed you would still need them. I did make you a backup this morning and then removed the added columns you had in your products table and then cloned a product and created a new product just to make sure it worked. This is now a fixed problem. Solution for anyone esle was to remove the added fields.
Reply With Quote
  #3  
Old 06-07-2004, 02:23 PM
 
bluecat bluecat is offline
 

X-Adept
  
Join Date: Nov 2002
Posts: 674
 

Default

Thank you lildawg, I can breath again.
__________________
--------------------
X-Cart Gold 4.1.11
Linux/Apache
--------------------
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design



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 08:00 AM.

   

 
X-Cart forums © 2001-2020