Error creating a new Board

[skb]

I tried to create a new Board, and ran across this error.

Field 'icon' doesn't have a default value
File: /home/diabesv6/public_html/Sources/Subs-Boards.php
Line: 896

Line 896 in that file just says "1"

Code Select Expand

// Insert a board, the settings are dealt with later.
$board_id = $smcFunc['db_insert']('',
'{db_prefix}boards',
$board_columns,
$board_parameters,
array('id_board'),
1
);

[Bigguy]

I just successfully created a board on my 2.1 install that was updated from GH the other day. It all went fine.

[Suki]

Does your 2.1 install is an upgrade from 2.0? Which 2.1 version do you have installed?

[skb]

Yes, I upgraded from 2.0.15. I am using 2.1 RC2.

Mods installed;

TinyPortal   1.6.2
Curve2 Color Changer   1.0
Email Obfuscator   1.1
BG Tracker   2.0.1  (custom mod)
Welcome Topic Mod   2.3a
Quick New Topic Button   1.1

[Kindred]

looks like you may have had an boardicon mod?

[skb]

No. I had never had any icons for categories / boards / topics. I tried installing a clean copy of Subs-Boards.php and retried. Still didn't work.

[Illori]

a clean file will not resolve this issue. you will need to find that column in the database and set a default value for it.

[skb]

OK. Had to change the value from 'None' to 'As Defined'. That worked.

[Obrieden]

I'm having a similar problem except that it's happening when attempting to post to an existing topic, or start a new one. Following is the error and information from the log

Type of error: Database
Database Error: Field 'edit_reason' doesn't have a default value
http://<our url name>/boards/index.php?action=post2;start=0;board=42
/home/<host name>/public_html/smf21/boards/Sources/Subs-Post.php (Line 1788).

The edit reason column is indeed null, should I modify it to contain something?

[Arantor]

Think it's currently set to "not null" which is what you should change.

[Kindred]

1- this is due to an edit reason mod....
2- please start your own thread next time -- especially since this one was already marked as solved