This may have been covered in other posts, but I cannot find a decent answer
I am using SMF2.0
I had to move severs from one using MYSQL/php5.6 to MYSQLi/php5.6
I did a backup of the old database in myphpAdmin in zip format.
I then created a new database on the new server MYSQLi/php5.6.
I reinstalled from scratch SMF2.0 into the new server database, then did an import of the old database zip file into the new database.
I then popened the forum and all the settings for the new database are there in Maintenance section, But there are no members or posts or anything else.
What have I done wrong??
http://wiki.simplemachines.org/smf/Hosting_-_How_do_I_move_my_SMF_forum_to_a_different_host
Hi
Thanks for the quick answer, I uploaded the repair.settings.php, then ran it
It confirmes that all the settings for the database are correct, but I noticed that it would not let me set MYSQLi
So I changed this in settings.php.
I get the message Table 'db672766193.smf_settings' doesn't exist
????
Trevor
I don't think that 2.0 defines mysqli.....
Quote from: Kindred on March 08, 2017, 07:20:15 AM
I don't think that 2.0 defines mysqli.....
at this time SMF 2.0 does not support mysqli, it only supports mysql. once SMF 2.0.14 is released it should support mysqli.
Or if you cannnot wait, install the following modification which works quite well.
http://custom.simplemachines.org/mods/index.php?mod=3469
Hi
Again thanks for the advice.
I had already changed mysql to mysqli in settings.php
so the result from the forum is still Table 'db672766193.smf_settings' doesn't exist
Trevor
then either your database name is incorrect or the prefix is incorrect.
Did you install the mod Shambles mentioned?
you changed it in settings.php -- but, as stated, SMF 2.0.x does not currently support mysqli as an option... so, that is your problem right there.
Change it back to mysql.