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: [Solved]: Unknown column in field list  (Read 12971 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.024 seconds with 20 queries.