Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.
Navigation

Switch from PDO Driver to MySQLi

Last updated on 4 years ago
Posted 4 years ago
I have real problems with site speed, and I think it's because PDO driver.

How can I switch to MySQLi?

I tried using the install.php for this (changed php-fusion version in phpMyAdmin to an older one). I did the "upgrade" with MySQLi driver, but when it ended, I couldn't login anymore (same with other users).
So, how can I switch it without this problems?
Thanks!
FalkFalk
Posted 4 years ago
$pdo_enabled = 0; in config.php
Any issues related to the new MySQLi driver need to be specified and with an error report to it in order to nail it swift.
Posted 4 years ago
I got no error in Error Log about this, but the site it's working very slow. I found out that PDO is much slower than MySQLi, so I thought to give it a try!
FalkFalk
Posted 4 years ago
I tried to replicate your issue with no success, I disabled PDO (0) in config so I am running on new mysqli driver. The logout and login works just fine for me and other basic commands seems to also work at an glance. If you don´t have any errors I can´t do much more than that atm.
Posted 4 years ago
It's ok for me to if I disable it in config.php. The problem was when I used the install.php.
But I noticed something (using Septenary theme). My website logo isn't shown, but when I had that error, the logo was visible. Also icons under the banner : News, Articles, Gallery, Downloads, are also not shown, but at that time, it were.
What could be the problem?
FalkFalk
Posted 4 years ago
The link thing was issued earlier, https://github.com/PHPFusion/PHPFusion/issues/1168
It seems to be connected to permalinks but for the rest I am at lost with no error reports generated.
mysqli are quite new tho, it has not been put to test so much yet. Chan completed it just recently.
The whole system will be tested and re-evaluated by me from a to z in all modes once I am done with our Hosting Services that we want to offer with 9, if nothing else then I will know what is ok and not for the most part.
Posted 4 years ago
The problem is tha I don;t even have permalinks options in my Admin Panel. I cannot access that settings.
The most common error I got in forum is when I or a user are posting :

Quote

There was an error while processing your request.


Or sometimes it just loads for 1 minute and than gives a blank page. On refresh, sometimes it makes double post.
ChanChan
Posted 4 years ago
Please do me a favor, I just need your current SQL table structure. Can you export it without data and attach it as zip files here.

See image for settings. (Structure without Data).
Chan attached the following file:
Posted 4 years ago
Thanks!
foc_in_gaura attached the following file:
gpszone-structure.zip [6.61kB / 190 Downloads]
ChanChan
Posted 4 years ago
Give me a day or two.
ChanChan
Posted 4 years ago
https://github.com/PHPFusion/PHPFusion/issues/1167

Basically, what I did was, delete config_temp.php - remember your old prefix cookie and table prefix before you do that.
Then I import into my MySQL - into a table called "gpzone",
Then, in the table form, all I did was just put in the information as required.
Then the table builds.

I tried with blank fields as well.

I tried on v7's installer, then run install, OK.
I tried on v7's installer, then I delete config.php and run install, OK
I tried on v9's installer, then I delete config.php and run install, OK
I tried on v7's installer, then I deliberately change site version to version 3. Ran upgrade, OK.
I tried on v9's installer, then I deliberately change site version to version 3. Ran upgrade, OK.

Those having problems with upgrade, just make sure you run your installer without config.php
Those having permanent white screens - delete your browser cache.

Note: I put the message status and shut down the Jquery meter for faster performance of the installer. it's a failed attempt anyway. I'll just erase the whole code of the stupid progress meter and shorten down the message status.
Posted 4 years ago
The upgrade works like charm, I never said it didn't (after you solved that mysql fields issue).
My problem si only for performance. I contacted my hosting company. I'm now waiting for a answer from them. I asked them if I can switch to PHP7.
ChanChan
Posted 4 years ago
Now, I'm very glad to hear the upgrade works. OK, for performance site issue, I'll work on the issues when it is available to me this week.
You can view all discussion threads in this forum.
You cannot start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
You cannot set up a bounty in this discussion thread.
Moderator: Support Team
Users who participated in discussion: Falk, Chan, foc_in_gaura,