MyBB Community Forums

Always had this problem on this particular install but never did anything about it...

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'postoptions' doesn't have a default value
Query:
INSERT INTO mybb_modtools (type,threadoptions,name,description,forums) VALUES ('t','a:13:{s:12:\"deletethread\";s:1:\"0\";s:12:\"mergethreads\";s:1:\"0\";s:10:\"deletepoll\";s:1:\"0\";s:15:\"removeredirects\";s:1:\"0\";s:13:\"approvethread\";s:0:\"\";s:10:\"openthread\";s:5:\"close\";s:10:\"movethread\";i:0;s:18:\"movethreadredirect\";i:0;s:24:\"movethreadredirectexpire\";i:0;s:10:\"copythread\";i:0;s:10:\"newsubject\";s:9:\"{subject}\";s:8:\"addreply\";s:0:\"\";s:12:\"replysubject\";s:9:\"{subject}\";}','Something','Something interesting','')

Any ideas?

Thanks

EDIT - Sorry, I've put post tool when I mean thread tool - post tools seem to work fine.

I did a little playing around and I can't even work out what the postoptions field is for.

(2009-01-18, 04:59 AM)rh1n0 Wrote: [ -> ]I did a little playing around and I can't even work out what the postoptions field is for.

Yeah, me neither:s

Ah, it's used when adding/using the post tool option. So.. it shouldn't really be needing it for the thread tool feature as far as I can tell.

(2009-01-18, 05:04 AM)rh1n0 Wrote: [ -> ]Ah, it's used when adding/using the post tool option. So.. it shouldn't really be needing it for the thread tool feature as far as I can tell.

Think that it might be a bug?

(2009-01-18, 05:05 AM)TomL Wrote: [ -> ]Think that it might be a bug?

Possibly. But I don't understand why he gets an error and we/I don't. Also, the insert into query quoted above doesn't reference postoptions at all.

Maybe someone else will understand better.

I've not had the problem on any other installs.

Reupload ./admin/modules/config/mod_tools.php??

(2009-01-18, 04:16 PM)MattR Wrote: [ -> ]Reupload ./admin/modules/config/mod_tools.php??

Tried it, still get the error.

Ok can you give some actual reproduction steps?? As in what you're putting in??