coppermine-gallery.com/forum

Hello
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.

Carl

Quote from: joe-lynn on January 23, 2016, 04:01:47 PM
I followed instructions here http://documentation.coppermine-gallery.net/en/upgrading.htm

It appears that you may not have run the update script (as directed).

Thanks so much.
I did that and it says everything has been done on the page.
How would I rectify this?
Carl

Ugh! I took off the www. and all is well :)
Except my logo didn't replace the coppermine one for some reason.
As I said I'm very novice, just self taught in this stuff the last 5 years or so. I guess I'll eventually figure it out :)

Thanks again,
Carl

Well now and I just realized now it only works when I'm logged in.
Seeing another critical error:

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

I'm lost :/

Can you provide a link to your site?

Yes Sir
Its right here http://www.joe-lynn.com/
The Coppermine is the "Gallery" tab at the top left on main menu.

I could also provide the debug info.
Parts of the gallery work fine. Search, admin and such. All the images load fine.

I'm not seeing any errors. What isn't working?

Oh my. Just looked on firefox and looks good.
I wonder what's up with my browser. I've cleared the browser's cache (ctrl + F5) a dozen times and no change except that one flash then back to this http://www.joe-lynn.com/images/random/cr-err.jpg
Sorry for wasting your time on this but there was initially a problem.
I will try restarting the browser and if still needed I'll restart my PC.
Thank you, you've been very helpful, enjoy the rest of the weekend,
Carl