I have board installed OK and was working OK, added 4 pics in a categiory (1 or 4) and as user added a pic without an (optional) thumbnail - approved pic but did not appear in Category (same as the other 4 pics).
Ran thumbmail feature which seemed to run OK BUT now cannot access at
http://www.dogtales.org.uk/gallery/
get this error (below), not being familar with PHP etc not sure what to do next - cannot re-install? Do I have delete and start afresh, what went wrong?
SELECT cat_id
FROM phpwebgallery_user_access
WHERE user_id =
;
[mysql error 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 '' at line 3
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dogtales/public_html/gallery/include/functions.inc.php on line 884
SELECT cat_id
FROM phpwebgallery_user_group AS ug INNER JOIN phpwebgallery_group_access AS ga
ON ug.group_id = ga.group_id
WHERE ug.user_id =
;
[mysql error 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 '' at line 4
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dogtales/public_html/gallery/include/functions.inc.php on line 884
DELETE FROM phpwebgallery_user_cache_categories
WHERE user_id =
;
[mysql error 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 '' at line 2
INSERT INTO phpwebgallery_user_cache_categories
(user_id,cat_id,max_date_last,count_images,count_categories)
VALUES(NULL,'7','2007-05-14 06:39:13','4','0')
, (NULL,'9',NULL,'0','0')
, (NULL,'8',NULL,'0','0')
, (NULL,'6',NULL,'0','0')
;
[mysql error 1062] Duplicate entry '0-7' for key 1
DELETE FROM phpwebgallery_user_cache
WHERE user_id =
;
[mysql error 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 '' at line 2
INSERT INTO phpwebgallery_user_cache
(user_id, need_update, forbidden_categories, nb_total_images)
VALUES
(,'false','0',4)
;
[mysql error 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 ''false','0',4)' at line 4
Warning: Cannot modify header information - headers already sent by (output started at /home/dogtales/public_html/gallery/include/functions.inc.php:867) in /home/dogtales/public_html/gallery/include/page_header.php on line 102