backdream Posted October 24, 2005 Posted October 24, 2005 THe Mysql 5 RC released. But the IPB seems do not support it, any idea?
Management Matt Posted October 24, 2005 Management Posted October 24, 2005 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.
Antony Posted October 24, 2005 Posted October 24, 2005 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?
Management Charles Posted October 24, 2005 Management Posted October 24, 2005 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 :)
backdream Posted October 24, 2005 Posted October 24, 2005 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...
Management Charles Posted October 24, 2005 Management Posted October 24, 2005 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.
backdream Posted October 24, 2005 Posted October 24, 2005 MySQL 5.0 Now Available for Production Use :blush:
marcele Posted October 24, 2005 Posted October 24, 2005 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 :)
marcele Posted October 24, 2005 Posted October 24, 2005 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
Adam Kinder Posted October 24, 2005 Posted October 24, 2005 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.htmlhttp://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.
marcele Posted October 24, 2005 Posted October 24, 2005 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 :(
Davidcopperfield Posted October 27, 2005 Posted October 27, 2005 Whjta can I do I shall have server with MYSQL 5 and that means that I shall not become a client :(
Coastie Posted October 27, 2005 Posted October 27, 2005 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
princetontiger Posted October 27, 2005 Posted October 27, 2005 I've noticed many hostings companies are moving away from MySQL 3.23.x to MySQL 4.0.x or 4.1.x.
Dark Phantom Posted November 4, 2005 Posted November 4, 2005 Incase anyone cares, IPB 2.1.3 works flawlessly with MySQL 5.0.15
bfarber Posted November 4, 2005 Posted November 4, 2005 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. :)
Coastie Posted November 7, 2005 Posted November 7, 2005 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?
.John. Posted November 7, 2005 Posted November 7, 2005 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.
Dark Phantom Posted November 7, 2005 Posted November 7, 2005 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.