forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: keyskeeper on April 24, 2008, 11:26:32 pm

Title: logging in after upgrading
Post by: keyskeeper on April 24, 2008, 11:26:32 pm

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:

Quote

While 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

Title: Re: logging in after upgrading
Post by: keyskeeper on April 24, 2008, 11:30:02 pm

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

Quote

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

Title: Re: logging in after upgrading
Post by: Stramm on April 25, 2008, 08:10:45 am

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

Title: Re: logging in after upgrading
Post by: kuul on August 09, 2009, 04:47:43 pm

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

Title: Re: logging in after upgrading
Post by: phill104 on August 09, 2009, 05:17:57 pm

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.