MyBB Community Forums

I tried to install mybb. I use xampp for local installation on my Vista-PC (my personal learn-area)

On Step Table creation I get following error-message:

Connection to the database server and table you specified was successful.
Database Engine: MySQLi 5.5.8
The MyBB database tables will now be created.
Creating table mybb_adminlog...
---------------
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 'TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9
Query:
CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

Before installation (via phpmyadmin) I created a Database named mybb with the Kollation: "utf8_unicode_ci"

My SQL-Server Statistic show me following entries:

* Server: localhost via TCP/IP
* Server Version: 5.5.8
* Protokoll-Version: 10
* Benutzer(User): root@localhost
* MySQL-Zeichensatz(fontset): UTF-8 Unicode (utf8)


Please help me ... many thanks

Best regards ... tc

Here you go!

http://community.mybb.com/thread-72832.html

Or straight to the point: http://dev.mybboard.net/projects/mybb/re...sions/5299

Take all of the files in that repository and replace them, according to given directory.

Thanks for great and very fast help!

OK, one error less ...


But warning:

Warning [2] Invalid argument supplied for foreach() - Line: 1582 - File: ...xampp\htdocs\mybb\install\index.php PHP 5.3.5 (WINNT)
File Line Function
...xampp\htdocs\mybb\install\index.php 1582 errorHandler->error
...xampp\htdocs\mybb\install\index.php 183 create_tables

All tables have been created, click Next to populate them.


Before next step (NO ONE TABLE WAS CREATED) I get a new error:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mybb.mybb_attachtypes' doesn't exist
Query:
INSERT INTO mybb_attachtypes (atid, name, mimetype, extension, maxsize, icon) VALUES (1, 'ZIP File', 'application/zip', 'zip', 1024, 'images/attachtypes/zip.gif');

That's odd. I don't know why that would happen :/.

Use xampplite
I also encounter that in Xampp Full

I use easyphp, lightweight and easy to use

Open ./install/resources/mysql_db_tables.php and find;

TYPE=

and change it to;

ENGINE=