forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: sophie on March 07, 2010, 08:15:17 pm

Title: [Solved]: Unknown column in field list
Post by: sophie 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!
Title: Re: Unknown column in field list
Post by: Joe Carver on March 07, 2010, 08:25:23 pm
Post a link to your Coppermine gallery. It's required when asking for support.
Title: Re: Unknown column in field list
Post by: sophie on March 07, 2010, 08:25:51 pm
http://avasydneyrodgers.com/portfolio/index.php
Title: Re: Unknown column in field list
Post by: phill104 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.
Title: Re: Unknown column in field list
Post by: sophie on March 07, 2010, 10:37:57 pm
Ok done :)
Title: Re: Unknown column in field list
Post by: phill104 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?
Title: Re: Unknown column in field list
Post by: sophie 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?
Title: Re: Unknown column in field list
Post by: phill104 on March 08, 2010, 12:16:31 pm
The modpack for 1.4.26 is available.

http://forum.coppermine-gallery.net/index.php/topic,63803.0.html
Title: Re: Unknown column in field list
Post by: sophie on March 08, 2010, 12:54:11 pm
Thanks! I didn't see that!
Thanks for all your help!