REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
My SQl error.
#1
Hello, I am using mybb 1.6
When I went to forums and posts, and went to make a new moderator for a particular forum.
I got this error.

Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'm.uid' in 'field list'
Query:
SELECT m.mid, m.uid, u.username FROM mybb_moderators m LEFT JOIN mybb_users u ON (m.uid=u.uid) WHERE fid='27'

Can someone please help me fix it.
Reply
#2
I went through it to, your using a plugin from 1.4, that is not compatible.

Reply
#3
@ Kaleb, so which plugin should I uninstall.
Reply
#4
Help me guys, I still need help.
Reply
#5
You should uninstall all your plugins, from 1.4.

Reply
#6
Can there be a mysql query which can solve this problem.
Reply
#7
Nope. You can manually add those in phpmyadmin..

Reply
#8
Have you tried re-downloading concrete5? Maybe you have a corrupted download.
Does GoDaddy have a control panel (I don't know anything about godaddy)? If so, look for something like phpmyadmin that you can use to configure your database
Reply
#9
When you are working with PHP and MySQL and encounter an error, it is helpful to receive more detailed information regarding the problem to point you in the direction of fixing it. You can use the mysql_error ( ) to get feedback from MySQL to your PHP document if you are encountering problems. It is phrased as: mysql_error ( [link_identifier] )

Here are some examples of how to utilize mysql_error ()

mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error())

This will return an error if there is a problem connecting to your MySQL database

$value = mysql_query($your_query) or die("A MySQL error has occurred.<br />Your Query: " . $your_query . "<br /> Error: (" . mysql_errno() . ") " . mysql_error())

When you encounter an error, this will return your custom message (A MySQL error has occurred.<br />) followed by a line number, and the actual error. ,..copied i have searched this information so shared her,..its useful one,..
When you are working with PHP and MySQL and encounter an error, it is helpful to receive more detailed information regarding the problem to point you in the direction of fixing it. You can use the mysql_error ( ) to get feedback from MySQL to your PHP document if you are encountering problems. It is phrased as: mysql_error ( [link_identifier] )

Here are some examples of how to utilize mysql_error ()

mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error())

This will return an error if there is a problem connecting to your MySQL database

$value = mysql_query($your_query) or die("A MySQL error has occurred.<br />Your Query: " . $your_query . "<br /> Error: (" . mysql_errno() . ") " . mysql_error())

When you encounter an error, this will return your custom message (A MySQL error has occurred.<br />) followed by a line number, and the actual error. ,.. i have searched this information so shared her,..its useful one,..
Reply
#10
Nopes, still not solved :-s
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Image Verfication Error. Arya 3 1,888 Dec 21, 2016, 06:13 AM
Last Post: walter
  MySubscription error.. AJRiley 3 1,798 Jun 19, 2016, 11:54 PM
Last Post: Jiant
  MyAwards SQL error when clicking "Activate" in Plugins Gh0st 1 1,226 Feb 11, 2016, 03:26 PM
Last Post: Gh0st
  MyBB Tabbed Menu Error Kiggoz 2 2,358 Jan 07, 2015, 11:13 AM
Last Post: Kiggoz
  MyBB MyAwards Error Red™ 3 2,793 Oct 31, 2014, 06:23 PM
Last Post: Nasyr

Forum Jump:


Users browsing this thread: 1 Guest(s)