[Solved]: Unknown column in field list [Solved]: Unknown column in field list
 

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

Main Menu

[Solved]: Unknown column in field list

Started by sophie, March 07, 2010, 08:15:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

sophie

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!

Joe Carver

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


phill104

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.
It is a mistake to think you can solve any major problems just with potatoes.

sophie


phill104

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?
It is a mistake to think you can solve any major problems just with potatoes.

sophie

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?

phill104

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

sophie

Thanks! I didn't see that!
Thanks for all your help!