MyBB Community Forums

I've trasfer my forum to another server..

At the beginning all ok but after i've a lot of problem to activate some plugin.

All MySql Error

Some of My Error:

Quote:SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'tid' at row 1
Query:
INSERT INTO mybb_templates (tid,title,template,sid) VALUES ('NULL','prostats','
{$trow_message_top} {$prostats_content} {$trow_message_down}
{$lang->prostats_prostats} {$lang->prostats_reload}
{$prostats_copyright}
','-1')

Oppure :

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

SQL Error:
1364 - Field 'description' doesn't have a default value
Query:
INSERT INTO mybb_settings (name,title,optionscode,value,disporder,gid) VALUES ('changfcb_turn','Enable chatbox ?','yesno','1','1','150')

Oppure :

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

SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('NULL','hidelinks_settings','Hide Links to Guests','Settings for Hide Links to Guests plugin.','100','no')

Please contact the MyBB Group for support.

How i can fix this mysql problem ?

It looks like MySQL on the new host is running in strict mode, ask your host if they can disable that.

but i cannot disable ?

Not you yourself but your host should be able to.

ok..

Now i send a ticket to the hoster.