MyBB Community Forums

Full Version: Error When Using Any Moderator Tools
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey guys! I keep getting this this error every time I try to use a moderator tool of any kind.

http://gyazo.com/f3cca31872e2f5927bb8d1bf225e8344

This is getting quite annoying as I cannot delete anything at all. It appears to be having an error putting my IP address into the moderator log but it doesn't have any trouble putting my IP address in the admin log. It also appears to be telling me how to fix the error but I did some searching and I cannot find the specified file or field anywhere in my MyBB control panel. Can anyone help with this? Thanks!
Did you try to upgrade from an older version of mybb?

I haven't really slept but from where i am sitting right now the column "ipaddress" shouldn't be there.
The MyBB version is 1.8.3
looks like the upgrade did not run fine.

anyway, you can run below SQL query to add that missing field (see common SQL queries guidance)
ALTER TABLE `mybb_moderatorlog` ADD ipaddress varbinary(16) NOT NULL;
(2015-02-11, 01:10 PM).m. Wrote: [ -> ]looks like the upgrade did not run fine.

anyway, you can run below SQL query to add that missing field (see common SQL queries guidance)

ALTER TABLE `mybb_moderatorlog` ADD ipaddress varbinary(16) NOT NULL;

How would I do that? I don't know how to access MyPHPAdmin.
Log into your hosting account. Then in CPanel find PHPMyAdmin and click it.