Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: logging in after upgrading  (Read 5237 times)

0 Members and 1 Guest are viewing this topic.

keyskeeper

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
logging in after upgrading
« 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
Logged

keyskeeper

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: logging in after upgrading
« Reply #1 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.)
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: logging in after upgrading
« Reply #2 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).

kuul

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 25
Re: logging in after upgrading
« Reply #3 on: August 09, 2009, 04:47:43 pm »

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

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: logging in after upgrading
« Reply #4 on: August 09, 2009, 05:17:57 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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.