Fórum OpenCart Brasil

Por um e-commerce livre, confiável e profissional

Suporte geral sobre problemas técnicos para OpenCart v1.x.
#60904
Olá amigos, sou novato na comunidade, comecei a usar opencart agora e estou com um problema em minha loja, está tudo tranquilamente e do nada aparece o erro, às vezes a página fica em branco, ou aparece o seguinte erro na administração:
Código: Selecionar todos
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 0,20' in /home/lojadodj/public_html/system/database/mysqli.php:41 Stack trace: #0 /home/lojadodj/public_html/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('SELECT * FROM p...') #1 /home/lojadodj/public_html/admin/model/catalog/product.php(398): DB->query('SELECT * FROM p...') #2 /home/lojadodj/public_html/admin/controller/catalog/product.php(349): ModelCatalogProduct->getProducts(Array) #3 /home/lojadodj/public_html/admin/controller/catalog/product.php(12): ControllerCatalogProduct->getList() #4 [internal function]: ControllerCatalogProduct->index() #5 /home/lojadodj/public_html/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #6 /home/lojadodj/public_html/vqmod/vqcache/vq2-system_engi in /home/lojadodj/public_html/system/database/mysqli.php on line 41
Tento acessar o site e página fica em branco. Esse problema está muito chato, alguém me ajuda a resolver?

Nos logs de erro aparece isso:
Código: Selecionar todos
2015-07-20 8:52:41 - PHP Notice:  Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '71' AND od.language_id = '2' ORDER BY o.sort_order in /home/lojadodj/public_html/system/database/mysql.php on line 50
2015-07-20 8:55:46 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:55:46 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 8:55:47 - PHP Notice:  Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '50' AND od.language_id = '2' ORDER BY o.sort_order in /home/lojadodj/public_html/system/database/mysql.php on line 50
2015-07-20 8:57:43 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:57:43 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 8:57:44 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:57:44 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 8:57:45 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:57:45 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 8:58:01 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:58:01 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 8:58:01 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2015-07-20 8:58:01 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2015-07-20 10:04:03 - PHP Notice:  Undefined index: enabled in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 248
2015-07-20 10:04:03 - PHP Notice:  Undefined index: popup_title in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 455
2015-07-20 10:04:26 - PHP Notice:  Undefined index: enabled in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 248
2015-07-20 10:04:26 - PHP Notice:  Undefined index: popup_title in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 455
2015-07-20 10:46:07 - PHP Notice:  Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/lojadodj/public_html/system/database/mysql.php on line 50
2015-07-20 10:46:08 - PHP Notice:  Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/lojadodj/public_html/system/database/mysql.php on line 50
Link do meu site: www.lojaimpactosom.com.br
Desde já agradeço.
#60915
já solicitou um suporte da hospedagem para ver se não é a conexão com banco de dados que está instável, não é possível precisar exatamente uma solução pois nessas duas linhas são erros de variáveis do tema.
2015-07-20 10:04:26 - PHP Notice: Undefined index: enabled in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 248
2015-07-20 10:04:26 - PHP Notice: Undefined index: popup_title in /home/lojadodj/public_html/vqmod/vqcache/vq2-catalog_view_theme_zMaxcart_template_product_product.tpl on line 455

e nessa já é conexão com banco de dados
2015-07-20 10:46:08 - PHP Notice: Error: Got error 28 from storage engine<br />Error No: 1030<br />SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /home/lojadodj/public_html/system/database/mysql.php on line 50