News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Mysql or mysqli

Started by zijO, January 23, 2017, 10:15:12 AM

Previous topic - Next topic

zijO

in the repair-settings.php it says

QuoteIn 2.1 Beta 3, mysqli was removed, this will put it back to mysql.

Does it mean we can not use it?


/etc/php/7.0/cli/conf.d/20-mysqli.ini,
mysqli
MysqlI Support => enabled
mysqli.allow_local_infile => On => On
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => no value => no value
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
mysqli.rollback_on_cached_plink => Off => Off
API Extensions => mysqli,pdo_mysql




Kindred

it means that the default will now always be mysqli, so there is no need to differentiate
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

vbgamer45

MySQLI is what you should use going forward. PHP7 and onwards only supports it.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Illori

Quote from: zijO on January 23, 2017, 10:15:12 AM
in the repair-settings.php it says

QuoteIn 2.1 Beta 3, mysqli was removed, this will put it back to mysql.

kindred if you read the message there it is the opposite of what you said. i think repair_settings.php has a typo in it.

Kindred

oh, yeah....  :) read too quickly.

Yes, that is a typo, it should say the reverse
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Jailer


Antes

We didn't have any problems related to MariaDB but no official support yet. Surely SMF 2.1 requires more testing under MariaDB.

Jailer

Well that's what I've got my sandbox running on now and it seems fine, was just curious of future support.

Antes

Quote from: Jailer on January 23, 2017, 06:50:23 PM
Well that's what I've got my sandbox running on now and it seems fine, was just curious of future support.

We can't just say "its supported" without properly testing it. Surely feedback from our community ease our work on certain point.

Thank you :)

zijO

So the message in repair settings is wrong.

When I change to mysqli it doesn't work.

Undefined type used in the database query. (inet:ip)

The process to change by my understanding is in Settings.php, change mysql to mysqli.

Advertisement: