THe Mysql 5 RC released. But the IPB seems do not support it, any idea?

MySQL 5 changes a lot - and how LEFT JOINS are formatted. We'd need to re-code a fair bit of IPB to make it work with MySQL 5.

MySQL 5 changes a lot - and how LEFT JOINS are formatted. We'd need to re-code a fair bit of IPB to make it work with MySQL 5.

Wouldn't you just be able to recode the DB drivers?

Wouldn't you just be able to recode the DB drivers?

Yes, I believe Matt was referring to recoding in his previous post. Of course IPB will be updated to use MySQL 5 in due course :)

MySQL 5 use restrict SQL, I install it and find IPB will run errors when access session table. It insert a string to a INT field, eg: location_1_id...

IPB does not yet support MySQL 5 so there will be issues... we will probably not work on adding official support until MySQL 5 is stable and proven.

MySQL 5.0 Now Available for Production Use

:blush:

MySQL 5 changes a lot - and how LEFT JOINS are formatted. We'd need to re-code a fair bit of IPB to make it work with MySQL 5.

Really?? Matt where did you find that ? Is it on MySQL's site ? I couldn't find that listed in the list of changes?
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

Wow MySQL 5 was certified for production use today :) ... it's been a long time coming.. ( Nice timing on the post lol )

Backdream .. what kind of errors are you getting? If its just a few field types that are set incorrectly in the IPB db schema it should be easy to fix.

I've already updated the db class to work with the php5 MySQLi interface .. MySQL 5 with MySQLi would be nice :)

MySQL 5 supports setting different "server SQL modes". Will IPB work if you specify mode to be 'MYSQL40' (Equivalent to NO_FIELD_OPTIONS, HIGH_NOT_PRECEDENCE.)? This would relax the new ANSI complience.

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Really?? Matt where did you find that ? Is it on MySQL's site ? I couldn't find that listed in the list of changes?

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html
Top one, it's a change related to grouping on Natural/Left Joins and such.

Thanks ze Kinder .. yep it looks like a lot of the sql for IPB needs to be re-done to work correctly with MySQL 5 :(

Whjta can I do I shall have server with MYSQL 5 and that means that I shall not become a client :(

I would be all for specific drivers designed to take advantage of different versions of MySQL. If you got it, flaunt it!!

3.23.x
4.0.x
4.1.x
5.0.x

I've noticed many hostings companies are moving away from MySQL 3.23.x to MySQL 4.0.x or 4.1.x.

Incase anyone cares, IPB 2.1.3 works flawlessly with MySQL 5.0.15

Incase anyone cares, IPB 2.1.3 works flawlessly with MySQL 5.0.15

So far as you have seen. We can't guarantee it's working flawlessly, however I do urge you to submit any bugs you find running with MySQL 5 to our bug tracker so that we *can* guarantee support for MySQL 5 in a future version. :)

4.x has the query cache, and 5.x has Stored Procedures.
the Query cache works independant of the coding, but Stored Procedures as far as I can tell need to be specifically coded for.

without a specific IPB SQL driver is there any advantage to running it on a v5.x install?

As said, support for mySQL5 is not currently available, and will be once the time comes.

It's just being stated by other customers that it works fine on PHP5, they can say whatever they want - but it's unsupported as of right now.

So far as you have seen. We can't guarantee it's working flawlessly, however I do urge you to submit any bugs you find running with MySQL 5 to our bug tracker so that we *can* guarantee support for MySQL 5 in a future version. :)

At the time, I posted that comment, I just knew it worked. Didn't know that only what didn't work was fixed.

Trust me, I will submit any bugs I find to the bug tracker.