2009-03-09, 10:17 PM
Hi,
I have been using MYBB since 2006, and was very happy with it.
Thank you for a great product.
I have always upgraded, and it worked good, until now.
The upgrade gives errors. Resulting in an error 40 and an endless upgrade cycle.
A new install does not work, because the Mysql version is to old (?) the installation gives an empty screen.
The empty database "exampledatabase.sql" does not work, but after putting quotes around some variables and removing the DEFAULT CHARSET=utf8 (not supported) it does.
But unfortunally, after this it still does not work:
SQL Error:
1193 - Unknown system variable 'NAMES'
Query:
SET NAMES 'utf8'
The sql version (4.0.24) -is- old, but I can't upgrade because of shared hosting. Using another hostingprovider is not easy because of current contracts.
It would have been nice if backward compatibility was maintained.
Thank you for a great product for so many years.
I know I should keep my expectations in line with the price I am paying.
I can only hope that my provider will upgrade the mysql in the near future.
Thanks for the hard work.
Oké. I have managed to bring the board back up.
I uploaded the complete 1.4.4 package.
I used the exampledatabase.sql to create the database structure (putting quotes around some variables like 'type' and 'field' and removing the DEFAULT CHARSET=utf8)
I manually edited the config.sample.php and renamed it to config.php
I removed the 'utf8' setting from config.sys.
I manually restored all table content to the empty 1.4.4 table structure from a backup (1.4.1 I believe).
I deleted the settings.php to get it rebuild from the database.
Everything is stable for now.
Thank you for your help. Maybe this solution can help others.
I have been using MYBB since 2006, and was very happy with it.
Thank you for a great product.
I have always upgraded, and it worked good, until now.
The upgrade gives errors. Resulting in an error 40 and an endless upgrade cycle.
A new install does not work, because the Mysql version is to old (?) the installation gives an empty screen.
The empty database "exampledatabase.sql" does not work, but after putting quotes around some variables and removing the DEFAULT CHARSET=utf8 (not supported) it does.
But unfortunally, after this it still does not work:
SQL Error:
1193 - Unknown system variable 'NAMES'
Query:
SET NAMES 'utf8'
The sql version (4.0.24) -is- old, but I can't upgrade because of shared hosting. Using another hostingprovider is not easy because of current contracts.
It would have been nice if backward compatibility was maintained.
Thank you for a great product for so many years.
I know I should keep my expectations in line with the price I am paying.
I can only hope that my provider will upgrade the mysql in the near future.
Thanks for the hard work.
Oké. I have managed to bring the board back up.
I uploaded the complete 1.4.4 package.
I used the exampledatabase.sql to create the database structure (putting quotes around some variables like 'type' and 'field' and removing the DEFAULT CHARSET=utf8)
I manually edited the config.sample.php and renamed it to config.php
I removed the 'utf8' setting from config.sys.
I manually restored all table content to the empty 1.4.4 table structure from a backup (1.4.1 I believe).
I deleted the settings.php to get it rebuild from the database.
Everything is stable for now.
Thank you for your help. Maybe this solution can help others.