xxxxxxxxxx Posted January 6, 2004 Share Posted January 6, 2004 I got this error 1030 - Got error 127 - when a was adding more products in my site my store have like 200 product today when i try to insert like 30 more product this error appears in all pages my site work good before adding this new products, this error message in all the pages and now i cant see the review,leguange counter and date information panel but my admin page work perfect but i try to make a back up and the error appear there and now i cant make a back up please help me.how to fix this 1030 - Got error 127 from table handler select p.products_id, pd.products_name, p.products_ordered from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '3' order by p.products_ordered DESC, pd.products_name limit 10 [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted January 6, 2004 Share Posted January 6, 2004 most likely corruption in the data you are trying to add Link to comment Share on other sites More sharing options...
241 Posted January 6, 2004 Share Posted January 6, 2004 I got this error 1030 - Got error 127 - when a was adding more products in my site my store have like 200 product today when i try to insert like 30 more product this error appears in all pages my site work good before adding this new products, this error message in all the pages and now i cant see the review,leguange counter and date information panel but my admin page work perfect but i try to make a back up and the error appear there and now i cant make a back up please help me.how to fix this 1030 - Got error 127 from table handler select p.products_id, pd.products_name, p.products_ordered from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '3' order by p.products_ordered DESC, pd.products_name limit 10 [TEP STOP] Looks like the problem is with the third language description for product,possibly a ' in the description in the sql without a \ before it as in jusqu'? instead of jusqu\'? If you can work out the product and language, (I would take a guess at a standard os install third language being Spanish, I had a similar problem but with Italian) then you could enter the sql and do a manual change for that product. Do you know the product_id for the last 30 entries? Does the error only appear in one language or all languages? No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
241 Posted January 6, 2004 Share Posted January 6, 2004 can you post a url to the site? No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
xxxxxxxxxx Posted January 6, 2004 Author Share Posted January 6, 2004 thank you i fix the problem Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.