MyBB Community Forums
Error while creating tables - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Error while creating tables (/thread-218055.html)



Error while creating tables - Rikys - 2018-06-09

Sorry about this, but I get an error while creating the tables for MyBB in the installation wizard, and I haven't found any similar error in the forum.
Screen: https://prnt.sc/jt0f0r
MySQL server version is 8.0.11
Can someone help me with this?


RE: Error while creating tables - Serpius - 2018-06-10

(2018-06-09, 05:42 PM)Rikys Wrote: Sorry about this, but I get an error while creating the tables for MyBB in the installation wizard, and I haven't found any similar error in the forum.
Screen: https://prnt.sc/jt0f0r
MySQL server version is 8.0.11
Can someone help me with this?

Don't use MySQL, use MySQLi. It works much better with MySQLi. 

I am running MySQLi 5.6.36


RE: Error while creating tables - Matt - 2018-06-10

https://github.com/mybb/mybb/issues/2921

MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.


RE: Error while creating tables - Rikys - 2018-06-10

(2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921

MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.

I have tried but the MySQL server  don't start


RE: Error while creating tables - Serpius - 2018-06-10

(2018-06-10, 03:01 PM)Rikys Wrote:
(2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921

MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.

I have tried but the MySQL server  don't start

Please re-read my post #2.


RE: Error while creating tables - Rikys - 2018-06-10

(2018-06-10, 03:29 PM)Serpius Wrote:
(2018-06-10, 03:01 PM)Rikys Wrote:
(2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921

MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.

I have tried but the MySQL server  dont start

Please re-read my post #2.

Sorry but isn't MySQLi an extension of MySQL?


RE: Error while creating tables - Matt - 2018-06-11

MySQLi is just the PHP driver with MySQL rather than anything to do with MySQL itself, and you'll already be using that as I imagine you'll be using a modern version of PHP which won't even have the old non-i extension installed.

Do you manage the server yourself or do you have a server company run it for you? We wouldn't really be able to help with downgrading MySQL or any issues with it starting.


RE: Error while creating tables - Serpius - 2018-06-11

(2018-06-10, 03:38 PM)Rikys Wrote:
(2018-06-10, 03:29 PM)Serpius Wrote:
(2018-06-10, 03:01 PM)Rikys Wrote:
(2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921

MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.

I have tried but the MySQL server  dont start

Please re-read my post #2.

Sorry but isn't MySQLi an extension of MySQL?

Yes...

The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP scripting language to provide an interface with MySQL databases. There are three main API options when considering connecting to a MySQL database server: PHP's MySQL Extension. ... PHP Data Objects (PDO)

However...

You can't mix any of the three ( mysql_* , mysqli_* , PDO ) MYSQL API's from PHP together, it just doesn't work. 
It's even in the manual FAQ: It is not possible to mix the extensions.

Go here: MyBB Installation Manual and scroll down to the paragraph 'Database Engine' and it states "If you have the option between MySQL and MySQL Improved, usually the Improved is the better choice."

Just my 2 cents.