FREE DELIVERY ON
28 DAY
QUALITY
01603 733020
MON - FRI - 8.30AM - 5:00PM
Secure Payments
Array
(
[0] => Array
(
[query] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,99' at line 21
[result] =>
[backtrace] => Array
(
[0] => Array
(
[file] => /var/www/clients/client0/web18/web/control/_classes/db.php
[line] => 71
[function] => db_query
[class] => db
[object] => db Object
(
[mysqli] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 290019
[server_info] => 5.7.33-0ubuntu0.16.04.1
[server_version] => 50733
[stat] => Uptime: 8362902 Threads: 12 Questions: 117590962 Slow queries: 0 Opens: 33231994 Flush tables: 1 Open tables: 2000 Queries per second avg: 14.061
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 4017504
[warning_count] => 1
)
[sqlquery] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
[numrows] =>
)
[type] => ->
[args] => Array
(
[0] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
[1] =>
)
)
[1] => Array
(
[file] => /var/www/clients/client0/web18/web/control/_classes/products.php
[line] => 59
[function] => query
[class] => db
[object] => db Object
(
[mysqli] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 290019
[server_info] => 5.7.33-0ubuntu0.16.04.1
[server_version] => 50733
[stat] => Uptime: 8362902 Threads: 12 Questions: 117590963 Slow queries: 0 Opens: 33231994 Flush tables: 1 Open tables: 2000 Queries per second avg: 14.061
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 4017504
[warning_count] => 1
)
[sqlquery] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
[numrows] =>
)
[type] => ->
[args] => Array
(
[0] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
)
)
[2] => Array
(
[file] => /var/www/clients/client0/web18/web/scripts/products/productlist.php
[line] => 65
[function] => getProducts
[class] => products
[object] => products Object
(
[producttable] => w_product_item
[categorytable] => w_product_categories
[p_c_jointable] => w_product_item_categories
[db] => db Object
(
[mysqli] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 290019
[server_info] => 5.7.33-0ubuntu0.16.04.1
[server_version] => 50733
[stat] => Uptime: 8362902 Threads: 12 Questions: 117590964 Slow queries: 0 Opens: 33231994 Flush tables: 1 Open tables: 2000 Queries per second avg: 14.061
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 4017504
[warning_count] => 1
)
[sqlquery] => Select
w_product_item.*,
w_product_categories.title as categorytitle,
w_product_categories.id as categoryid
From
w_product_categories Inner Join
w_product_item_categories On w_product_item_categories.categoryid =
w_product_categories.id Inner Join
w_product_item On w_product_item.id = w_product_item_categories.productid
Where
w_product_item.publish = 1
AND
w_product_item.disabled = 0
AND w_product_item.stocklevel > 0
Group By
w_product_item.id
Order By
LIMIT 0,99
[numrows] =>
)
)
[type] => ->
[args] => Array
(
[0] =>
[1] =>
[2] =>
[3] => 0
[4] => 99
[5] => 1
)
)
[3] => Array
(
[file] => /var/www/clients/client0/web18/web/pages/designer.php
[line] => 89
[args] => Array
(
[0] => /var/www/clients/client0/web18/web/scripts/products/productlist.php
)
[function] => include
)
[4] => Array
(
[file] => /var/www/clients/client0/web18/web/scripts/headscripts.php
[line] => 216
[args] => Array
(
[0] => /var/www/clients/client0/web18/web/pages/designer.php
)
[function] => include
)
[5] => Array
(
[file] => /var/www/clients/client0/web18/web/index.php
[line] => 2
[args] => Array
(
[0] => /var/www/clients/client0/web18/web/scripts/headscripts.php
)
[function] => include
)
)
)
)
Array
(
[id] => 12273464
[anonymous] => 1
[formhash] => d5a930c3a397fdc6b44e170c677c9c11021423fc
)
Array
(
[taxrate] => 20.00
[taxcalc] => 1.2
[carttitle] => Shopping List
[id] => 1931600
[orderhash] => 3TE1O104CH
[shipping_required] =>
)
Array
(
[page] => store
)