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: [Solved]: Unknown column in field list  (Read 12876 times)

0 Members and 1 Guest are viewing this topic.

sophie

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
[Solved]: Unknown column in field list
« on: March 07, 2010, 08:15:17 pm »

Enabled debug mode when Fatal error: came up
Here is what it says:

While executing query "SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `soproy5_copp12`.cpg_users AS u INNER JOIN `soproy5_copp12`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1'" on Resource id #6

mySQL error: Unknown column 'u.avatar_url' in 'field list'

Anyone know what to do?
Thanks!
« Last Edit: March 08, 2010, 05:17:15 pm by Joachim Müller »
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Unknown column in field list
« Reply #1 on: March 07, 2010, 08:25:23 pm »

Post a link to your Coppermine gallery. It's required when asking for support.

sophie

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Unknown column in field list
« Reply #3 on: March 07, 2010, 08:45:19 pm »

Start by upgrading to 1.4.26 as you are a little out of date. The table the error refers to is something to do with the modpack but upgrade first and then we'll look further.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

sophie

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Unknown column in field list
« Reply #4 on: March 07, 2010, 10:37:57 pm »

Ok done :)
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Unknown column in field list
« Reply #5 on: March 07, 2010, 11:34:52 pm »

Has that cured your problem? Do you use the modpack (there is a version for 1.4.26) or do you need a specific feature of the modpack that cannot be achieved with one of the available plugins?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

sophie

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Unknown column in field list
« Reply #6 on: March 08, 2010, 11:55:42 am »

Yes and No because I was trying to install Stramm and it has worked on all the other coppermines using the 1.4.25 as the 6 is not available... however do you have any ideas on how Stramm can work without getting the error?
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: Unknown column in field list
« Reply #7 on: March 08, 2010, 12:16:31 pm »

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

sophie

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Re: Unknown column in field list
« Reply #8 on: March 08, 2010, 12:54:11 pm »

Thanks! I didn't see that!
Thanks for all your help!
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.