MyBB Community Forums
SQL Error during install - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: SQL Error during install (/thread-102855.html)



SQL Error during install - probably3 - 2011-08-31

Hello!
I've been trying to install mybb 1.6.4 on a server for a few hours now and I always get the same SQL error. I've search this forum, googled and yahooed and nothing I've found has been able to help. Thanks in advance for your help!

The server runs linux, PHP 5.2.10 and MySQL 4.1.22

Here's the error I get during the Table Creation step:

Quote:Database Engine: MySQLi 4.1.22

The MyBB database tables will now be created.
Creating table mybb_adminlog...done
Creating table mybb_adminoptions...done
Creating table mybb_adminsessions...done
Creating table mybb_adminviews...
MyBB SQL Error

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;




RE: SQL Error during install - Radebe - 2011-08-31

Are all the files uploaded?


RE: SQL Error during install - probably3 - 2011-08-31

Thanks for helping. I'm double checking.
What could be missing?

Edited: I've reuploaded all the files and started fresh. I'm am still getting the exact same error...


RE: SQL Error during install - Nathan Malcolm - 2011-08-31

You need MySQL 5.


RE: SQL Error during install - probably3 - 2011-08-31

Thanks for the help!


RE: SQL Error during install - StefanT - 2011-09-02

(2011-08-31, 04:53 PM)Malcolm. Wrote: You need MySQL 5.
No, MySQL 4.1 is still supported. This is just a bug: http://dev.mybb.com/issues/1676


RE: SQL Error during install - Matt - 2011-09-02

Honestly though, people shouldn't be using MySQL 4 these days, and if it's all your host offers then they suck and you should find a new one.