Critical Error upgrading from 1.5.12 t0 1.5.40

[joe-lynn]

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

[ron4mac]

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

[joe-lynn]

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

[joe-lynn]

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

[joe-lynn]

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 :/

[ron4mac]

Can you provide a link to your site?

[joe-lynn]

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

[joe-lynn]

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

[ron4mac]

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

[joe-lynn]

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