backdream Posted October 24, 2005 Share Posted October 24, 2005 THe Mysql 5 RC released. But the IPB seems do not support it, any idea? Link to comment Share on other sites More sharing options...
Management Matt Posted October 24, 2005 Management Share 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. Link to comment Share on other sites More sharing options...
Antony Posted October 24, 2005 Share 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? Link to comment Share on other sites More sharing options...
Management Charles Posted October 24, 2005 Management Share 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 :) Link to comment Share on other sites More sharing options...
backdream Posted October 24, 2005 Share 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... Link to comment Share on other sites More sharing options...
Management Charles Posted October 24, 2005 Management Share 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. Link to comment Share on other sites More sharing options...
backdream Posted October 24, 2005 Share Posted October 24, 2005 MySQL 5.0 Now Available for Production Use :blush: Link to comment Share on other sites More sharing options...
marcele Posted October 24, 2005 Share 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 :) Link to comment Share on other sites More sharing options...
marcele Posted October 24, 2005 Share 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 Link to comment Share on other sites More sharing options...
Adam Kinder Posted October 24, 2005 Share 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. Link to comment Share on other sites More sharing options...
marcele Posted October 24, 2005 Share 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 :( Link to comment Share on other sites More sharing options...
Davidcopperfield Posted October 27, 2005 Share 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 :( Link to comment Share on other sites More sharing options...
Coastie Posted October 27, 2005 Share 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 Link to comment Share on other sites More sharing options...
princetontiger Posted October 27, 2005 Share 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. Link to comment Share on other sites More sharing options...
Dark Phantom Posted November 4, 2005 Share Posted November 4, 2005 Incase anyone cares, IPB 2.1.3 works flawlessly with MySQL 5.0.15 Link to comment Share on other sites More sharing options...
bfarber Posted November 4, 2005 Share 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. :) Link to comment Share on other sites More sharing options...
Coastie Posted November 7, 2005 Share 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? Link to comment Share on other sites More sharing options...
.John. Posted November 7, 2005 Share 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. Link to comment Share on other sites More sharing options...
Dark Phantom Posted November 7, 2005 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.