Jump to the post that solved this thread.
Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved SQL Error during install
#1
Not Solved
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;

Jump to the post that solved this thread.


Messages In This Thread
SQL Error during install - by probably3 - 2011-08-31, 01:41 PM
RE: SQL Error during install - by Radebe - 2011-08-31, 02:08 PM
RE: SQL Error during install - by probably3 - 2011-08-31, 02:15 PM
RE: SQL Error during install - by Nathan Malcolm - 2011-08-31, 04:53 PM
RE: SQL Error during install - by probably3 - 2011-08-31, 08:35 PM
RE: SQL Error during install - by StefanT - 2011-09-02, 07:01 AM
RE: SQL Error during install - by Matt - 2011-09-02, 08:06 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)