Advanced search  

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

Pages: [1]   Go Down

Author Topic: logging in after upgrading  (Read 5152 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.019 seconds with 19 queries.