Welcome Guest ( Log In | Register )



 
Closed TopicStart new topic
> xMB-MySQL Problem: Unknown Column Error
Glockmeister
post May 12 2005, 08:23 AM
Post #1


Member - Active Contributor
Group Icon

Group: Members
Posts: 91
Joined: 30-April 05
Member No.: 4,549



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.


This post has been edited by microscopic^earthling: May 12 2005, 08:31 AM
Go to the top of the page
 
+Quote Post
miCRoSCoPiC^eaRt...
post May 12 2005, 08:29 AM
Post #2


PsYcheDeLiC dR3aMeR
Group Icon

Group: Admin
Posts: 2,242
Joined: 29-January 05
From: Nakorn Chaisri, Thailand
Member No.: 2,411
myCENTs:84.36



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
Go to the top of the page
 
+Quote Post
Glockmeister
post May 12 2005, 10:37 AM
Post #3


Member - Active Contributor
Group Icon

Group: Members
Posts: 91
Joined: 30-April 05
Member No.: 4,549



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.
Go to the top of the page
 
+Quote Post
Glockmeister
post May 12 2005, 10:49 AM
Post #4


Member - Active Contributor
Group Icon

Group: Members
Posts: 91
Joined: 30-April 05
Member No.: 4,549



Ok, fixed. Thanks for the help.
Go to the top of the page
 
+Quote Post
miCRoSCoPiC^eaRt...
post May 12 2005, 11:41 AM
Post #5


PsYcheDeLiC dR3aMeR
Group Icon

Group: Admin
Posts: 2,242
Joined: 29-January 05
From: Nakorn Chaisri, Thailand
Member No.: 2,411
myCENTs:84.36



Issue Resolved smile.gif Glad to be of help.

Topic Closed.
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Help! Problem With My Flash-Drive(2)
  2. Ip Problem(8)
  3. MSN Help(5)
  4. ATI Video Card Problem! Need Help(5)
  5. Problem Accessing My Cpanel(9)
  6. MySQL For EasyPHP Users(5)
  7. Einstein Quiz(30)
  8. Photosmart Printer Installs Automatically As "Unknown Device"(2)
  9. CuteNews: PHP-based Blog System - No MySQL(11)
  10. Blue Screen - irql_not_less_or_equal(35)
  11. Frustrating Problem With XP On Laptop(20)
  12. Problem With Drag And Drop (or So It Seems).(12)
  13. Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )(11)
  14. Php Tutorial: Making A Shoutbox(12)
  15. Strange Error When Trying To Install Fedora Core 9(6)
  1. Problem With Div's In Ie6 And Lower(4)
  2. Cpanel Error When Loggin In...(5)
  3. Mysql Overhead(3)
  4. Pc Problem(8)
  5. Graphics Driver Out...(2)
  6. Ffow: Frontlines: Fuel Of War(2)
  7. Php Configuration Error?(6)
  8. Which Language Is Easy And Secure Today For Web Development(2)
  9. Problem Setting Up Wireless Internet & Wireless Nintendo Wii(4)
  10. Login System(6)
  11. Boot Error On Customized Kernel [solved](2)
  12. System Is Crashed - Hardware Problem(3)
  13. Small Issues About Mysql Connector/j 5.1(2)


 



- Lo-Fi Version Time is now: 1st December 2008 - 11:54 PM