Database Error Got error 28 from storage engine on SELECT STRAIGHT_JOIN SQL_CALC_FOUND_ROWS * FROM tbl_products INNER JOIN tbl_products_languages ON p_id=plang_p_id INNER JOIN tbl_prodversions ON p_id=pv_p_id INNER JOIN tbl_productcategorylink ON p_id=pcl_p_id INNER JOIN tbl_categories ON pcl_cat_id=cat_id INNER JOIN tbl_categories_languages ON cat_id=clang_cat_id LEFT JOIN tbl_linkproductsbrands ON p_id=lkpbr_p_id LEFT JOIN tbl_brands ON lkpbr_brand_id=brand_id LEFT JOIN tbl_brands_languages ON brand_id=blang_brand_id LEFT JOIN tbl_linkfiles ON plang_id=lf_id AND lf_table='tbl_products_languages' LEFT JOIN tbl_files ON lf_file_id=file_id WHERE ((lf_id IS NULL AND file_nameid IS NULL) OR file_nameid='plang_main_picture_') AND (cat_id='17' OR cat_mothercat='17') AND plang_language = 'en' AND pv_live = 'yes' and p_live = 'y' and plang_live = 'y' group by p_id ORDER BY plang_orderbyvalue DESC LIMIT 0,10



DEBUG BACKTRACE:
#0 Database.m_error() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/db/database.class.php:77]
#1 Database.selectMany() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/ecommerce/products.class.php:1608]
#2 Products.sqlGetProductsByCategoryIdGetNr() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/ecommerce/products.class.php:441]
#3 Products.items() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/common/epaginatedlist.class.php:223]
#4 EPaginatedList.item_sequence() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/common/epaginatedlist.class.php:14]
#5 EPaginatedList.prepareItems() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:329]
#6 SkinParser.produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:139]
#7 GeneralParser.m_produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:26]
#8 GeneralParser.matchCallback() called at [:]
#9 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#10 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:105]
#11 GeneralParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:615]
#12 SkinParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:497]
#13 SkinParser.produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:139]
#14 GeneralParser.m_produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:26]
#15 GeneralParser.matchCallback() called at [:]
#16 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#17 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:105]
#18 GeneralParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:615]
#19 SkinParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:109]
#20 SkinLogic.m_parseSkin() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:42]
#21 SkinLogic.produceMarkupDefault() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/index.php:25]
#22 include() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/clean_url.php:536]

Database Error Got error 28 from storage engine on SELECT SQL_CALC_FOUND_ROWS *, DATE_FORMAT(blg_date, '%d %M %Y') as frm_blg_date, YEAR(blg_date) as blg_year, SUM(IF(bgc_live='yes',1,0)) nr_comments FROM tbl_blogs LEFT JOIN tbl_blog_comments ON blg_id=bgc_blg_id WHERE blg_live = 'yes' AND blg_archive = 'no' AND blg_language = 'en' GROUP BY blg_id ORDER BY blg_date DESC, blg_id DESC



DEBUG BACKTRACE:
#0 NewDatabase.m_error() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/db/newdatabase.class.php:82]
#1 NewDatabase.selectMany() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/db/newdatabase.class.php:96]
#2 NewDatabase.selectManyGetNr() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/cms/blog.class.php:1000]
#3 Blog.sqlGetLatestBlogEntriesGetNr() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/cms/blog.class.php:46]
#4 Blog.items() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/common/epaginatedlist.class.php:223]
#5 EPaginatedList.item_sequence() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/common/epaginatedlist.class.php:185]
#6 EPaginatedList.item() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:329]
#7 SkinParser.produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:139]
#8 GeneralParser.m_produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:26]
#9 GeneralParser.matchCallback() called at [:]
#10 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#11 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:71]
#12 GeneralParser.staticElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:29]
#13 GeneralParser.matchCallback() called at [:]
#14 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#15 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:71]
#16 GeneralParser.staticElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:29]
#17 GeneralParser.matchCallback() called at [:]
#18 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#19 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:105]
#20 GeneralParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:615]
#21 SkinParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:109]
#22 SkinLogic.m_parseSkin() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:42]
#23 SkinLogic.produceMarkupDefault() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/index.php:25]
#24 include() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/clean_url.php:536]
Premier Music International Limited
skip to navigation

Drumset

Drumset - cat-drumset

Search