logging in after upgrading logging in after upgrading
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

logging in after upgrading

Started by keyskeeper, April 24, 2008, 11:26:32 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

keyskeeper

I upgraded my gallery to 1.4.18 and all looks fine but upon logging in I receive a "Fatal Error: " screen.  I enabled debug mode through PHPMyAdmin.  It gives me the following output with the fatal error:

QuoteWhile executing query "SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u. AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `ihwat_gallery`.cpg1411_users AS u INNER JOIN `ihwat_gallery`.cpg1411_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2'" on Resource id #6

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 'AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_com' at line 1

keyskeeper

Just discovered that I also cannot view the full-size image when not logged into the gallery:

QuoteThere was an error while processing a database query.

While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u. AS avatar_url FROM cpg1411_comments AS c LEFT JOIN `ihwat_gallery`.cpg1411_users AS u ON c.author_id=u.user_id WHERE pid='5669' ORDER BY c.msg_id ASC" on Resource id #6

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 'AS avatar_url FROM cpg1411_comments AS c LEFT JOIN `ihwat_gallery`.cpg1411_users' at line 1

File: / . . . /include/functions.inc.php - Line: 248


(Sorry for the double post, I can't find an edit function.)

Stramm

Looks like you're using a not supported bridge file. The compatible bridges are listed in the announcement thread (smf, phpbb2, punbb).

kuul

I need help logging in at all....could someone help!! >:(

phill104

Quote from: kuul on August 09, 2009, 04:47:43 PM
I need help logging in at all....could someone help!! >:(

Please read the board rules before posting, you have broken about every rule there is.

Search the docs and board before posting.
Post in the right section.
Post a link to your affected gallery
Don't hijack an unrelated thread

Need I go on?

Locking.
It is a mistake to think you can solve any major problems just with potatoes.