Because of MySQL 5.6 to 5.7 Upgrade ?

[halimzhz]

Dear All,

I'm a web hosting company and today one of my client reported about he's SMF forum giving an error:

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

For your information i upgrade my MySQL from 5.6 to 5.7 few weeks ago and i dont do a test for this client forum, but i know when the server using MySQL 5.6, this client doesnt have any problem, what i found from Settings.php, the SMF version is 1.1

So is it possible to say the problem is because of MySQL 5.7 is not compatible with SMF 1.1 ? I did test with database connection and its not an issue with database username and password.

I hope somebody can advice on how to solve this problem. Thank you so much

[vbgamer45]

I don't think that would break it. Issues occur if you upgrade your PHP version past 5.6

[lurkalot]

I don't think that would break it. Issues occur if you upgrade your PHP version past 5.6

According to the requirements, it say's "SMF 1.1 will not work on PHP 5.5 and may not work correctly on PHP 5.4"

https://wiki.simplemachines.org/smf/SMF1.1:Requirements_and_recommendations

[Arantor]

SMF 1.1 uses the old MySQL adapter which won't work properly on MySQL 5.7. (PHP version is not MySQL version.)

Since 1.1 is not getting any fixes or patches, our advice would be to get your client to upgrade to a version that didn't originally come out 13 years ago, I.e. upgrade to 2.0.

[halimzhz]

Hi,

Thanks for all respond, that make me remind something when i compile PHP 5.3 with mysqlnd, that could be the issue, but i just advice the client to upgrade the SMF to the latest one, btw is there any issue if i directly upgrade SMF 1.1 to 2.1 instead of follow the step by upgrade to 2.0 and next is 2.1? Any experience on that ?

Thanks for advice

[Arantor]

We don't recommend that upgrade path at this time, we recommend 1.1 to 2.0 first. Note that 2.1 is not yet finished.

[halimzhz]

Hi,

Thanks for reply, now i'm doing upgrade, but i'm stuck at:

Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 3.
Executing: "Creating new tables and inserting default data..." (1 of 8 - of this script)

!!
Error!
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 'IGNORE TABLE smf_settings DROP PRIMARY KEY, ADD PRIMARY KEY (variable(30))' at line 1


I cant click Continue, please advice what should i do ? TQ so much

[halimzhz]

Hi,

Never mind, i found some of tables is corrupted and i restore from backup belong to MySQL 5.6, now i'm facing new error:

Converting other date columns...done
Checking for an old table...done
Creating "message_icons"...done
Inserting "message_icons"...done
Creating "package_servers"...done
Inserting "package_servers"...done
Updating flood control log...done
!!
Error!
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 'IGNORE TABLE smf_log_floodcontrol CHANGE COLUMN ip ip char(16) NOT NULL default ' at line 1


Now i'm lose on how to fix that, please help. TQ

[shawnb61]

In your forum root folder right now there should be a file named "upgrade_1-1.sql".

Open that file up and change all instances of "ALTER IGNORE TABLE" to "ALTER TABLE".   There should be 6 of them.

Hope this helps.

[halimzhz]

Thanks you so much, now problem solved.!!!

[shawnb61]

Good to hear!  I'll mark this one solved.