MyBB Central

Full Version: My SQl error.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
I went through it to, your using a plugin from 1.4, that is not compatible.
@ Kaleb, so which plugin should I uninstall.
Help me guys, I still need help.
You should uninstall all your plugins, from 1.4.
Can there be a mysql query which can solve this problem.
Nope. You can manually add those in phpmyadmin..
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
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,..
Nopes, still not solved :-s