|
Browse
|
|
|
Browse By MinistryMore.... |
Browse by Author |
Best Sellers this Month |
|
|
Search
Array
(
[0] => Array
(
[file] => /home/ibethel/public_html/store/includes/functions/database.php
[line] => 69
[function] => tep_db_error
[args] => Array
(
[0] => select distinct
p.products_id,
p.products_image,
p.products_price,
p.manufacturers_id,
pt.products_type_name,
pd.products_name,
p.products_tax_class_id,
if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price,
p.products_date_added,
p.products_image ,
xp.xsell_id
products_price
from products_type as pt, ((products p
left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G')
left join specials s on p.products_id = s.products_id),
products_xsell xp,
products_description pd
where
xp.products_id IN (2107/)
and p.products_id = xp.xsell_id
and pt.products_type_id = p.products_type
and pd.products_id = xp.xsell_id
and pd.language_id = '1'
and p.products_status = '1'
and p.products_group_access like '%G%'
order by rand(), xp.products_id asc limit 4
[1] => 1064
[2] => 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 ')
and p.products_id = xp.xsell_id
and pt.products_type_id = p.products_type
and' at line 20
)
)
[1] => Array
(
[file] => /home/ibethel/public_html/store/includes/modules/xsell_products_buynow.php
[line] => 40
[function] => tep_db_query
[args] => Array
(
[0] => select distinct
p.products_id,
p.products_image,
p.products_price,
p.manufacturers_id,
pt.products_type_name,
pd.products_name,
p.products_tax_class_id,
if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price,
p.products_date_added,
p.products_image ,
xp.xsell_id
products_price
from products_type as pt, ((products p
left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G')
left join specials s on p.products_id = s.products_id),
products_xsell xp,
products_description pd
where
xp.products_id IN (2107/)
and p.products_id = xp.xsell_id
and pt.products_type_id = p.products_type
and pd.products_id = xp.xsell_id
and pd.language_id = '1'
and p.products_status = '1'
and p.products_group_access like '%G%'
order by rand(), xp.products_id asc limit 4
)
)
[2] => Array
(
[file] => /home/ibethel/public_html/store/templates/content/product_info.tpl.php
[line] => 598
[args] => Array
(
[0] => /home/ibethel/public_html/store/includes/modules/xsell_products_buynow.php
)
[function] => include
)
[3] => Array
(
[file] => /home/ibethel/public_html/store/templates/Original_Bethel/content_guts.php
[line] => 67
[args] => Array
(
[0] => /home/ibethel/public_html/store/templates/content/product_info.tpl.php
)
[function] => require
)
[4] => Array
(
[file] => /home/ibethel/public_html/store/templates/Original_Bethel/main_page.tpl.php
[line] => 92
[args] => Array
(
[0] => /home/ibethel/public_html/store/templates/Original_Bethel/content_guts.php
)
[function] => require
)
[5] => Array
(
[file] => /home/ibethel/public_html/store/product_info.php
[line] => 49
[args] => Array
(
[0] => /home/ibethel/public_html/store/templates/Original_Bethel/main_page.tpl.php
)
[function] => require
)
)
1064 - 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 ')
and p.products_id = xp.xsell_id
and pt.products_type_id = p.products_type
and' at line 20select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pt.products_type_name, pd.products_name, p.products_tax_class_id, if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price, p.products_date_added, p.products_image , xp.xsell_id products_price from products_type as pt, ((products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G') left join specials s on p.products_id = s.products_id), products_xsell xp, products_description pd where xp.products_id IN (2107/) and p.products_id = xp.xsell_id and pt.products_type_id = p.products_type and pd.products_id = xp.xsell_id and pd.language_id = '1' and p.products_status = '1' and p.products_group_access like '%G%' order by rand(), xp.products_id asc limit 4
[TEP STOP]