[SOLVED]Host switched form MySQL4 to MySQL5

[cbrin44]

Your phpBB Version: 2.0.22
phpBB Type: phpBB / IMPortal
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://www.millennyummarine.com

PHP Version:
MySQL Version: MySQL5


What was done before the problem appeared?
Installed on host with MySQL4


What was done to try to solve the problem?




De.scription and Message

Hello,

I am in the process of upgrading my site with 1.4.1.
Fresh install, just started applying my theme.
The host switched from MySQL4 to MySQL5, is there something easy to do to make it work? or would I be better off just doing a fresh install?

Thanks,
Christian

[found it]

If you have upgraded to 1.4.1 or are going to, it will work just fine on php5 and mysql5 as the present is built just to do that...

If you do recieve any errors for any reason please do not hesitate to let us know and we can help you fix them...

[Ma®©uS]

If you've got MySQL 5 try setting your e-Tegra setup to use MySQL Improved functionality.

In your config.php try setting your:

Line number On/Off | Expand/Contract | Select all

$dbms = 'mysql';

or possibly its:

Line number On/Off | Expand/Contract | Select all

$dbms = 'mysql4';

to:

Line number On/Off | Expand/Contract | Select all

$dbms = 'mysqli';

If it doesn't work or if errors occur just change it back... but it's worth trying to take advantage of the new version of MySQL as much as possible! <img>

Note: You also need to be using PHP5 to use "mysqli", it's not available on PHP4.

[cbrin44]

Hello,

Probably didn't clarify good enough.

I had my 1.4.1 site up and running great.
My host switched over to MySQl 5, then it stopped working.
I tried some of the fixes suggested here, to no avail.

I figured I wasn't that far into my theme and set-up, so I tried a fresh install.

I enter all the info. on the set-up page and this is the error I get:

"An error occurred trying to update the database
Field 'cat_desc' doesn't have a default value"

Any ideas??

Christian

[Drop-Forged]

If you are doing a fresh install you should, either

1. login to phpMyAdmin, and drop all the tables from your first unsuccessful install and then reinstall.

Or

2. Change the name of your prefix from phpbb_ to something else, (like imod_ or something) and then reinstall.

[cbrin44]

Hello,

Fresh Install.
I have tried dropping all tables and deleting the database.
I created a new one, same error. I tried a different prefix, same error. I have done this a few times.

The error is
"An error occurred trying to update the database
Field 'cat_desc' doesn't have a default value"

Is this a host issue? The sql version is, MySQL 5.1.15

This was a perfectly running 1.4.1 website till the host switched from MySQL 4.
He says it should be compatible.

Thanks,
Chrisitan

[cbrin44]

Update,
After trying different installs, I get the same error when trying to install 1.4.1(see previous post)

I cleared everything and did a fresh install of phpbb2.0.22, works great.
I then tried an upgrade to 1.4.1 seemed to work, forum would not display kept getting a netcletic/minical error and I coould not log in, locked. Tried the fixes for that, nothing.

I now have just a plain phpbb board.

Like I said, this was a fully functional 1.4.1 website till the host switched to mysql5.
I really like 1.4.1

Any help?

Christian

[Teelk]

Ask your host to switch "SQL Strict mode" to off.

[cbrin44]

That did it! Teelk
Thank you as usual for your GREAT support, everyone.

Thanks,
Christian