Hello,
today i updated cs-cart multistore version from 4.0.3 to 4.2.2, everythings works pretty fine but when i enter in the admin panel i had the “store closed for maintenance”, i uncommented the line in config.php and got this error:
Message
[color=#000000]Incorrect key file for table '/tmp/#sql_fc3_0.MYI'; try to repair it [/color]b[/b]
[color=#000000]
SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, companies.company as company_name, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, cscart_seo_names.name as seo_name, IF(COUNT(IF(cscart_categories.company_id = products.company_id, NULL, cscart_categories.company_id)), 'Y', 'N') as is_shared_product FROM cscart_products AS products LEFT JOIN cscart_product_options_inventory as inventory ON inventory.product_id = products.product_id AND inventory.amount <= 0 LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'it' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'it' WHERE 1 AND products.tracking IN('B', 'O') AND IF(products.tracking = 'O', inventory.amount <= 0, products.amount <= 0) AND prices.usergroup_id IN (0) GROUP BY products.product_id[/color]
Error at
[color=#000000]app/Tygh/Database.php, line: 639[/color]
Backtrace
File: app/Tygh/Database.php Line: 322 Function: _error File: app/functions/fn.database.php Line: 130 Function: query File: app/controllers/backend/index.php Line: 77 Function: db_query File: app/functions/fn.control.php Line: 592 Function: include File: app/functions/fn.control.php Line: 380 Function: fn_run_controller File: admin.php Line: 26 Function: fn_dispatch
Tried to delete/rename the cache but doesn't work, someone knows how to fix it?
Thanks a lot
I has this morning an similar error.
Now everything workings fine.
Fout: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-40, 40' at line 1 (1064)
Aanvraag: SELECT SQL_CALC_FOUND_ROWS products., descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_descr.product_id IS NOT NULL, shared_descr.short_description, descr1.short_description) as short_description, IF(shared_descr.product_id IS NOT NULL, IF(shared_descr.short_description = '', shared_descr.full_description, ''), IF(descr1.short_description = '', descr1.full_description, '')) as full_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_keywords, descr1.meta_keywords) as meta_keywords, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_description, descr1.meta_description) as meta_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.search_words, descr1.search_words) as search_words, IF(shared_descr.product_id IS NOT NULL, shared_descr.promo_text, descr1.promo_text) as promo_text, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100))) as price, cscart_seo_names.name as seo_name FROM cscart_products as products LEFT JOIN cscart_product_features_values ON cscart_product_features_values.product_id = products.product_id AND cscart_product_features_values.lang_code = 'nl' LEFT JOIN (SELECT product_id, GROUP_CONCAT(cscart_product_features_values.variant_id) AS advanced_variants FROM cscart_product_features_values WHERE lang_code = 'nl' GROUP BY product_id) AS pfv_advanced ON pfv_advanced.product_id = products.product_id LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'nl' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'nl' LEFT JOIN cscart_ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'nl' AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0) WHERE 1 AND ( FIND_IN_SET('5941', advanced_variants)) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY products_categories.position asc LIMIT -40, 40
Traceren››
/index.php (fn_dispatch): 25
/app/functions/fn.control.php (fn_run_controller): 380
/app/functions/fn.control.php (include): 592
/controllers/frontend/product_features.php (fn_get_products): 180
/app/functions/fn.catalog.php (db_get_array): 7372
/app/functions/fn.database.php (call_user_func_array): 29
/app/Tygh/Database.php (getArray): 100
/app/Tygh/Database.php (query): 322
— — 11-09-2014, 07:52
Database (fout)
Fout: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 10' at line 1 (1064)
Aanvraag: SELECT cscart_news., descr.news, descr.description, cscart_companies.company as company, cscart_seo_names.name as seo_name FROM cscart_news LEFT JOIN cscart_news_descriptions AS descr ON descr.news_id = cscart_news.news_id AND descr.lang_code = 'nl' LEFT JOIN cscart_companies ON cscart_companies.company_id = cscart_news.company_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_news.news_id AND cscart_seo_names.type = 'n' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'nl' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_news.news_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'news')WHERE cscart_news.status = 'A' ORDER BY cscart_news.date desc LIMIT -10, 10
Traceren››
/index.php (fn_dispatch): 25
/app/functions/fn.control.php (fn_run_controller): 380
/app/functions/fn.control.php (include): 592
/app/addons/news_and_emails/controllers/frontend/news.php (fn_get_news): 38
/app/addons/news_and_emails/func.php (db_get_array): 123
/app/functions/fn.database.php (call_user_func_array): 29
/app/Tygh/Database.php (getArray): 100
/app/Tygh/Database.php (query): 322
Hello,
Please ask your server administrator to try repairing broken tables.
Also, the tmp folder on the server may be running out of space. Please check it.
tonysavino, address this issue to your server administrator. It is not related with CS-Cart software
[quote name='eComLabs' timestamp='1410447803' post='191978']
tonysavino, address this issue to your server administrator. It is not related with CS-Cart software
[/quote]
I am having the same problem. Can you tell me what you think the problem is so I can relay the message to my administrator.