Compare thousands of products & services!
You are here: Home ·  Electronics ·  TV and Video ·  Camcorders
Expert reviews

SQL ERROR [ mysql4 ]

Got error 28 from storage engine [1030]

SQL

SELECT r.our_article_id, r.publish_date, r.test_comment, r.test_comment_good, r.test_comment_bad, r.test_comment_bottomline, r.score, r.max_score, (r.score/r.max_score)*100 as avg_score ,r.url, r.url_active, r.language_id, p.product_name, s.name as testsite_name, s.url as testsite_url, s.image as testsite_image, a.award_name, a.award_image_80, a.award_image_original, l.landcode, l.image as language_images, l.landcode, p.product_name FROM product_reviews r LEFT JOIN products p ON p.our_article_id = r.our_article_id LEFT JOIN test_sites s ON r.test_site_id = s.site_id LEFT JOIN test_sites_awards a ON r.award_id = a.award_id LEFT JOIN languages l ON r.language_id = l.language_id LEFT JOIN language_sortorder ls ON ls.language_sort_id = r.language_id AND ls.language_id = 11 WHERE 1=1 AND ( 1=2 OR r.our_article_id='C6C7BF60-C62D-2104-60C9-D1DE75F4346F' OR 1=2 ) ORDER BY sort_order_id ASC, publish_date DESC LIMIT 10

BACKTRACE


FILE: var/www/testseek.couk/includes/db/mysql.php
LINE: 136
CALL: dbal->sql_error()

FILE: var/www/testseek.couk/includes/db/mysql.php
LINE: 194
CALL: dbal_mysql->sql_query()

FILE: var/www/testseek.couk/includes/db/dbal.php
LINE: 138
CALL: dbal_mysql->_sql_query_limit()

FILE: var/www/testseek.couk/export/search_v3.0.php
LINE: 1015
CALL: dbal->sql_query_limit()

FILE: var/www/testseek.couk/export/search.php
LINE: 46
CALL: do_product_search()



Best Deals!

Canon Legria HF R106
From £137.99Camcorders
Panasonic HDC-SD40
From £249.68Camcorders
Panasonic HX-WA10
From £289.00Camcorders
Samsung HMX-H300
From £179.99Camcorders
JVC GZ-HM445
From £154.99Camcorders
Sony HDR-CX115
From £399.99Camcorders
Sony DCR-SX34
From £333.18Camcorders
Panasonic HDC-SD90
From £499.99Camcorders
Sony HDR-TD20VE
From £1149.99Camcorders
Sony HDR-TG3
From £280.00Camcorders