xMB-MySQL Problem: Unknown Column Error

Glockmeister

May 12 2005, 08:23 AM

I've been trying to install a hack, membergroups, into my XMB Forum, but I seem to have this error.

MySQL encountered the following error: Unknown column 'groupname' in 'field list'
In the following query: SELECT groupname FROM xmb_membergroups WHERE groupname = 'WA-NS'

Can someone help me?

Notice from m^e:

Topic edited to reflect content suitably. "MySQL Problem" doesn't say anything about the problem. Be more specific in your topic titles.

Comment/Reply (w/o sign-up)

miCRoSCoPiC^eaRthLinG

May 12 2005, 08:29 AM

Your error message clearly states what the problem is - the field named groupname is missing from your MySQL database.

Check your hack installation instructions again - usually all these hacks contain a separate script that you've to run prior to installing the hack. This script will connect to your db and create the appropriate tables and fields required for the hack to function properly. If you go ahead and simply install the hack - quite obvious it wouldn't find the desired location to store it's data in... There's no other problem - but this... so cross-check your hack again for that script... or some instructions to insert the fields manually..

Regards,
m^e

Comment/Reply (w/o sign-up)

Glockmeister

May 12 2005, 10:37 AM

QUOTE (microscopic^earthling @ May 12 2005, 06:29 PM)

Your error message clearly states what the problem is - the field named groupname is missing from your MySQL database.

Check your hack installation instructions again - usually all these hacks contain a separate script that you've to run prior to installing the hack. This script will connect to your db and create the appropriate tables and fields required for the hack to function properly. If you go ahead and simply install the hack - quite obvious it wouldn't find the desired location to store it's data in... There's no other problem - but this... so cross-check your hack again for that script... or some instructions to insert the fields manually..

Regards,
m^e

I tried the script, so i might try manually putting it in this time.

Comment/Reply (w/o sign-up)

Glockmeister

May 12 2005, 10:49 AM

Ok, fixed. Thanks for the help.

Comment/Reply (w/o sign-up)

miCRoSCoPiC^eaRthLinG

May 12 2005, 11:41 AM

Issue Resolved

Glad to be of help.

Topic Closed.

Comment/Reply (w/o sign-up)