Support > cpg1.5 upgrading

Critical Error upgrading from 1.5.12 t0 1.5.40

(1/2) > >>

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:

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

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

Navigation

[0] Message Index

[#] Next page