I'm trying to make my website more secure and I noticed my gallery needs to be updated.
I followed instructions here http://documentation.coppermine-gallery.net/en/upgrading.htm
Everything seemed to go well and when I ran the update it showed everything has been done and I ran the version check and its like nothing was updated and getting critical errors.
At first when I clicked the link from my gallery it looked of except needed my new logo. but if I clicked the logo to go to the gallery home page it gives errors. In the meantime I replaced my logo and now the gallery doesn't load at all.
Its giving this error now
While executing query 'SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
FROM cpg_categories AS c
INNER JOIN cpg_albums AS r ON r.category = c.cid
WHERE c.depth >= 0 + 1
ORDER BY ' in index.php on line 340
mySQL 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 '' at line 7
Also saw this
File: /home2/skip2000/public_html/gallery/include/functions.inc.php - Line: 272
It seems like maybe just something simple *hopes
Thanks in advance for any help with this. I'm not very good with this kind of thing and maybe missed something that should have been obvious.