MyBB Community Forums

Hi,

I'm suffering some difficulties while installing MyBB. This is not my first install, so I'm quite surprised with the SQL error.

It's a clean install with the latest downloadable MyBB version. No edits on the files of language packs added.

MySQL version 4.1.20, MySQL Character set is UTF-8. (Also selected that in the installation procedure).

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fields text NOT NULL, conditions text NOT NULL, custom_profile_fields text NOT' at line 7
Query:
CREATE TABLE mybb_adminviews ( vid int unsigned NOT NULL auto_increment, uid int unsigned NOT NULL default '0', title varchar(100) NOT NULL default '', type varchar(6) NOT NULL default '', visibility int(1) NOT NULL default '0', fields text NOT NULL, conditions text NOT NULL, custom_profile_fields text NOT NULL, sortby varchar(20) NOT NULL default '', sortorder varchar(4) NOT NULL default '', perpage int(4) NOT NULL default '0', view_type varchar(6) NOT NULL default '', PRIMARY KEY(vid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

The tables mybb_adminlog, mybb_adminoptions, mybb_adminsessions (first three in the row) are created without any problems.

Setting of the database in the Install is MySQL (not the improved, allthough I also tried that, and it gives the same error). Table prefix standard. Also all files and folders that need CMOD 666 and 777 have correct setting.

What could be the problem? I hope it isn't the SQL version, cause then I can start mailing for a server switch and also have to pay for that

Your host needs to upgrade MySQL to 5.0 or above. As a web host they know they shouldn't be using such an old version of MySQL.

That's what I thought

I hope I can get the provider to move the website for free. This isn't the first time I encountered this. First time with this forum though.

Thanks for the answer.