forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: JeffB on September 06, 2016, 02:11:58 am

Title: Critical error message asking for log in
Post by: JeffB on September 06, 2016, 02:11:58 am

Hello.. recently I had a customer ask why he had to log in to see the gallery I have. Its not supposed to ask for a password so I went over and checked it out. This was the error message I am getting now.

While executing query 'SELECT cid, lft, rgt, name, description, thumb, depth AS level, '0' AS alb_count
        FROM cpg143_categories
        WHERE depth BETWEEN 0 + 1 AND 0 +
       
        ORDER BY lft' in index.php on line 303

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 'ORDER BY lft' at line 5


I've checked with my web hosting company as it appears this was something they did on their end (A back up gone wrong etc. etc.)  They checked into it but said they couldn't find the issue or fix it. I wanted to ask here for some help or guidance before I re-upload anything. So whats going on with my gallery and how can I fix it. Thanx

Title: Re: Critical error message asking for log in
Post by: JeffB on September 06, 2016, 02:13:06 am

P.S. Here is the link to my gallery.

http://www.transamcuda.com/gallery/index.php (http://www.transamcuda.com/gallery/index.php)

Title: Re: Critical error message asking for log in
Post by: Αndré on September 06, 2016, 09:05:51 am

Please update your gallery to the latest stable release as described in the docs and check if the error still exists.

I currently just get the login page. If we need to login to see the error message, please provide a test user account (no admin account!).