MyBB Community Forums

Adding mods:
for some reason, when I attempt to add mods right now, the following error appears:

mySQL error: 1136
Column count doesn't match value count at row 1
Query: INSERT INTO mybb_moderators VALUES (NULL, '6', '24', 'yes', 'yes', 'yes', 'yes', 'yes')

I dont know what's wrong?

PM Pop-up box:

My PM pop-up box NEVER worked after I install PR2.. (even though the box is checked in Options).. What possibly went wrong?

Thanks all!

AQuarius Wrote:Adding mods:
for some reason, when I attempt to add mods right now, the following error appears:

mySQL error: 1136
Column count doesn't match value count at row 1
Query: INSERT INTO mybb_moderators VALUES (NULL, '6', '24', 'yes', 'yes', 'yes', 'yes', 'yes')

I dont know what's wrong?

PM Pop-up box:

My PM pop-up box NEVER worked after I install PR2.. (even though the box is checked in Options).. What possibly went wrong?

Thanks all!

Have you tried different browsers and cleared all internet files?

yes
pm is poping up now but I still can't add mods for some wierd reason

AQuarius Wrote:yes
pm is poping up now but I still can't add mods for some wierd reason

Could you please explain a bit more on the mods you are trying to ad?

Moderators, not mods, if that was a confusion.

Sorry about the delayed response to this thread..


Can you open admin/forums.php and search for the line which begins with:

			$db->query("INSERT INTO ".TABLE_PREFIX."moderators

Replace that entire line with this block of code:

			$newmod = array(
				"fid" => $fid,
				"uid" => $user['uid'],
				"caneditposts" => $caneditposts,
				"candeleteposts" => $candeleteposts,
				"canviewips" => $canviewips,
				"canopenclosethreads" => $canopenclosethreads,
				"canmanagethreads" => $canmanagethreads
				);

			$db->insert_query(TABLE_PREFIX."moderators", $newmod);

Let me know how you go,
Chris