Database Error
Got error 28 from storage engine
on
SELECT `cat_url_tag`, `clang_name`, `clang_desc`, `file_name`, `file_path`, clang_language, cat_base_cat_id
FROM `tbl_categories`
INNER JOIN `tbl_categories_languages` ON `clang_cat_id` = `cat_id`
LEFT JOIN `tbl_linkfiles` ON `lf_id` = `clang_id` AND `lf_table` = 'tbl_categories_languages'
LEFT JOIN `tbl_files` ON `file_id` = `lf_file_id`
WHERE `cat_mothercat` = 19
AND cat_live = 'y' AND clang_live = 'y'
ORDER BY `cat_orderbyvalue` DESC, `clang_name`
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/categories.class.php:130]
#2 Categories.subCatList() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:329]
#3 SkinParser.produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:139]
#4 GeneralParser.m_produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:26]
#5 GeneralParser.matchCallback() called at [:]
#6 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#7 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:105]
#8 GeneralParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:615]
#9 SkinParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:497]
#10 SkinParser.produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:139]
#11 GeneralParser.m_produceElement() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:26]
#12 GeneralParser.matchCallback() called at [:]
#13 preg_replace_callback() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:110]
#14 GeneralParser.parse() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/generalparser.class.php:105]
#15 GeneralParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinparser.class.php:615]
#16 SkinParser.parseFile() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:109]
#17 SkinLogic.m_parseSkin() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/classes/parser/skinlogic.class.php:42]
#18 SkinLogic.produceMarkupDefault() called at [/var/www/vhosts/www.premier-percussion.com/httpdocs/index.php:25]
#19 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 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='19' OR cat_mothercat='19')
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]
New pedal timpani unveiled
11 February 2020
Ulf Wadenbrandt appointed Premier orchestral ambassador
13 April 2018
Premier win MIA industry award for its Modern Classic drum set
21 November 2014
Premier to attend the NAMM Show 2013
8 January 2013
Premier cover feature in this month's Rhythm
26 October 2012
August update from our General Manager
04 September 2014
July update from our General Manager
21 July 2014
Julien Brown Guest Blog
09 December 2013
Joe Lazarus of Voodoo Six
19 November 2013
Wilkie Wilkinson Guest Blog
11 November 2013
Cassell The BeatMaker
18 October 2013
Seb's Guest Blog
02 October 2013
Ged Lynch guest blog
29 August 2013
Pat Lundy of Funeral for a Friend
18 July 2013
Greenie's Guest Blog
09 July 2013
Michael Spearman of Everything Everything
18 June 2013
Welcome to our new blog feature
01 March 2012
Timpani
Orchestral Series
Mallets
Accessories
