adodb_mysql._execute(
SELECT
category_title,
..., false) % line 822, file: adodb.inc.php
adodb_mysql.execute(
SELECT
category_title,
..., false) % line 1390, file: adodb.inc.php
adodb_mysql.getrow(
SELECT
category_title,
...) % line 766, file: class.CamCategories.php
camcategories.getcategoryrelated(false) % line 143, file: site.php
include(/home/webv1ew5/public_html/site.php) % line 5, file: network.php
adodb_mysql._execute(SELECT
cameras.id,
cameras.name,
camera_page.s..., false) % line 822, file: adodb.inc.php
adodb_mysql.execute(SELECT
cameras.id,
cameras.name,
camera_page.s...) % line 925, file: class.Camera.php
camera.getcamerapagesforcategory(false) % line 178, file: site.php
include(/home/webv1ew5/public_html/site.php) % line 5, file: network.php
include(/home/webv1ew5/public_html/network.php) % line 3, file: index.php
Fatal error:
There is a database error in /home/webv1ew5/public_html/__kernel/classes/class.Camera.php on line 927
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 cameras.status=1
GROUP BY cameras.id' at line 22 query=SELECT
cameras.id,
cameras.name,
camera_page.short,
camera_page.description,
camera_page.camera_id,
camera_page.meta_title,
camera_page.meta_description,
camera_page.meta_keywords,
camera_page.page_url,
camera_page.gm_lat,
camera_page.gm_lng,
camera_page.gm_zoom
FROM cameras, camera_page, cam_categories, camera_categories_relation
WHERE
cameras.id=camera_page.camera_id AND
cam_categories.active=1 AND
camera_categories_relation.active=1 AND
camera_categories_relation.camera_id =cameras.id AND
camera_categories_relation.category_id = cam_categories.id AND
in /home/webv1ew5/public_html/__kernel/classes/class.Camera.php on line 927