CS-Cart 4.17.1
Go to backoffice panel, with the global search at the top right, type v and go to: Sorry, service is temporarily unavailable.
You can check page source code to see error details at the bottom
this is the result of source code:
Tygh\Exceptions\AException
Message
The table ‘_search’ is full (1114)INSERT INTO _search (id, object, sort_field) SELECT cscart_orders.order_id, ‘orders’, cscart_orders.order_id FROM cscart_orders as cscart_orders LEFT JOIN cscart_users as issuers ON issuers.user_id = cscart_orders.issuer_id LEFT JOIN cscart_order_docs as invoice_docs ON invoice_docs.order_id = cscart_orders.order_id AND invoice_docs.type = ‘I’ LEFT JOIN cscart_order_docs as memo_docs ON memo_docs.order_id = cscart_orders.order_id AND memo_docs.type = ‘C’ WHERE 1 AND cscart_orders.is_parent_order != ‘Y’ AND (0 OR (cscart_orders.firstname LIKE ‘%v%’ OR cscart_orders.lastname LIKE ‘%v%’) OR cscart_orders.email LIKE ‘%v%’) GROUP BY cscart_orders.order_id
Error at
app/Tygh/Database/Connection.php, line: 1712
Backtrace
File:app/Tygh/Database/Connection.php
Line:1489
Function:throwError
File:app/Tygh/Database/Connection.php
Line:699
Function:execQuery
File:app/functions/fn.database.php
Line:138
Function:query
File:app/functions/fn.search.php
Line:200
Function:db_query
File:app/controllers/backend/search.php
Line:29
Function:fn_search
File:app/functions/fn.control.php
Line:722
Function:include
File:app/functions/fn.control.php
Line:458
Function:fn_run_controller
File:adminvk6.php
Line:27
Function:fn_dispatch
→
The error shows that the table _search is full. I’m not familiar with that table. Are you using a third party addon for search? Maybe the table needs to be optimized.?
This is default temporary table which is created during search process
I suggest to adjust the configuration parameters for temporary tables in MySQL.
Thank you;
given your great experience, is there a way to limit the CS-cart API to product tables only so that whoever has the key cannot access the tables relating to customers/orders?
Try to add specific user group with the required permissions to this account
How can configure database what am i doing for this error.
when write first search number like “8”. “1 2 3 4 5 6 7 8 9” the same error when write double digit number like "10 11 … etc. its gives search result but when one digit number gives error
Tygh\Exceptions\AException
Message
The table ‘_search’ is full (1114)INSERT INTO _search (id, object, sort_field) SELECT products.product_id, ‘products’, descr1.product FROM cscart_products as products LEFT JOIN cscart_images_links AS images_links ON products.product_id = images_links.object_id AND images_links.type=“M” AND images_links.object_type=“product” 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 = ‘tr’ LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘tr’ 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 WHERE 1 AND (((descr1.search_words LIKE ‘%8%’) OR descr1.product LIKE ‘%8%’ OR descr1.short_description LIKE ‘%8%’ OR descr1.short_description LIKE ‘%8%’ OR descr1.full_description LIKE ‘%8%’ OR descr1.full_description LIKE ‘%8%’ OR (descr1.meta_keywords LIKE ‘%8%’ OR descr1.meta_description LIKE ‘%8%’) OR products.product_code LIKE ‘%8%’ OR (cscart_seo_names.name LIKE ‘%8%’ )) OR ((descr1.search_words LIKE ‘%shoes%’) OR descr1.product LIKE ‘%shoes%’ OR descr1.short_description LIKE ‘%shoes%’ OR descr1.short_description LIKE ‘%shoes%’ OR descr1.full_description LIKE ‘%shoes%’ OR descr1.full_description LIKE ‘%shoes%’ OR (descr1.meta_keywords LIKE ‘%shoes%’ OR descr1.meta_description LIKE ‘%shoes%’) OR products.product_code LIKE ‘%shoes%’) OR ((descr1.search_words LIKE ‘%bag%’) OR descr1.product LIKE ‘%bag%’ OR descr1.short_description LIKE ‘%bag%’ OR descr1.short_description LIKE ‘%bag%’ OR descr1.full_description LIKE ‘%bag%’ OR descr1.full_description LIKE ‘%bag%’ OR (descr1.meta_keywords LIKE ‘%bag%’ OR descr1.meta_description LIKE ‘%bag%’) OR products.product_code LIKE ‘%bag%’)) AND prices.usergroup_id IN (0) AND products.product_type != ‘D’ GROUP BY products.product_id
Error at
app/Tygh/Database/Connection.php, line: 1713
Backtrace
File:app/Tygh/Database/Connection.php
Line:1490
Function:throwError
File:app/Tygh/Database/Connection.php
Line:700
Function:execQuery
File:app/functions/fn.database.php
Line:138
Function:query
File:app/functions/fn.search.php
Line:200
Function:db_query
File:app/controllers/backend/search.php
Line:29
Function:fn_search
File:app/functions/fn.control.php
Line:727
Function:include
File:app/functions/fn.control.php
Line:458
Function:fn_run_controller
File:excaihtiya1q2w.php
Line:21
Function:fn_dispatch
The error means that the temporary table in the database has reached its maximum size. Please contact hosting support with this issue
1 Like