« previous next »
Pages: 1 2 [All]

Topic: MySQL 5 Released!  (Read 6334 times)

0 Members and 1 Guest are viewing this topic.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
MySQL 5 Released!
« on: November 03, 2005, 03:29:18 pm »
http://www.mysql.com/

Big news... :)  bunch of work for Bonk...  :(
Logged

Offline Sirgod

  • Whooot Master Cattle Baron
  • Global Moderator
  • Vice Admiral
  • *
  • Posts: 27844
  • Gender: Male
Re: MySQL 5 Released!
« Reply #1 on: November 03, 2005, 08:00:44 pm »
Cracks the whip, Get her Done Bro.  ;D

stephen
Logged
"You cannot exaggerate about the Marines. They are convinced to the point of arrogance, that they are the most ferocious fighters on earth - and the amusing thing about it is that they are."- Father Kevin Keaney, Chaplain, Korean War

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #2 on: November 03, 2005, 11:22:57 pm »
awesome.
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #3 on: November 04, 2005, 07:08:54 am »
So far, the only hitch was getting our teamspeak server to connect to it. It required the following fix:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Took me about 4 hours to figure that out... what a headache.  :banghead: Hopefully posting this might save someone else the same trouble. Hopefully TeamSpeak might release a new version someday that uses newer mysql client libraries to avoid this, but they have been on RC2 for like the last three years or more...  ::) so it doesn't seem likely.

The Xenocorp.net/SFC2.Net server is updated. I have yet to update the Dynaverse.net and game servers to it. We really need to consolidate the DBs to a single server to save me these multiple updates. That won't happen till we get a new box for the Dynaverse.net webserver, then we can make this one a dedicated db server for all of Xenocorp/Dynaverse.net.

http://www.dynaverse.net/v2/dga_dnet_donations.php

« Last Edit: November 04, 2005, 07:19:30 am by Bonk »
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #4 on: November 05, 2005, 07:41:46 am »
Mmmmm... stored procedures...  (possibly significant for the serverkit development).  :thumbsup:

http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #5 on: November 06, 2005, 07:27:41 am »
SMF 1.0.5 is allergic to MySQL 5.0.15. Grrrrrrr!  >:(  I tried to update Dynaverse.net this morning, it no worky...  :(

http://www.simplemachines.org/community/index.php?topic=55532.0
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #6 on: November 06, 2005, 06:45:41 pm »
Quote from: Bonk on November 06, 2005, 07:27:41 am
SMF 1.0.5 is allergic to MySQL 5.0.15. Grrrrrrr! >:( I tried to update Dynaverse.net this morning, it no worky... :(

http://www.simplemachines.org/community/index.php?topic=55532.0


Really? Thanks for letting me know.

Glad I waited to update.

Have you tried 1.1 RC1?
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #7 on: November 07, 2005, 07:05:40 am »
Actually, it seems SMF will be patching both 1.0.5 and 1.1 RC1 shortly!  :woot:

http://www.simplemachines.org/community/index.php?topic=55324.0

http://www.simplemachines.org/community/index.php?topic=55532.0

I'm holding off 1.1 till its non-"RC" as I'm hestiant because of all of our mods anyway.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #8 on: November 07, 2005, 10:48:30 am »
SMF MySQL 5.0.12 Compatibility patch released!  :thumbsup:

http://www.simplemachines.org/community/index.php?topic=55616.0

I'll update MySQL later today (will only be down an hour or so...).
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #9 on: November 07, 2005, 01:40:49 pm »
Quote from: Bonk on November 07, 2005, 07:05:40 am
Actually, it seems SMF will be patching both 1.0.5 and 1.1 RC1 shortly! :woot:

http://www.simplemachines.org/community/index.php?topic=55324.0

http://www.simplemachines.org/community/index.php?topic=55532.0

I'm holding off 1.1 till its non-"RC" as I'm hestiant because of all of our mods anyway.


I've been running it for a couple months now, and have yet to find any bugs in SMF itself. I ran into a couple bugs porting it to mambo, but those were because I used older templates (it was a quick fix). The only bug I found was the package manager wasn't working too well iirc.
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #10 on: November 07, 2005, 03:29:43 pm »
One word: Search.

SMF has yet to completely finish the search function. I understand they have made progress from 1.0.x but still have to disable it altogether quite frequently. A forum absolutley must have a working search function. (especially when the messages database is very large and there is a browsing load on the server).

P.S. I just took a quick peek at your site and got some error messages, ya might want to check it out if you're not currently working on it.
Logged

Offline MrCue

  • Site Designer
  • Lt.
  • *
  • Posts: 977
  • Gender: Male
  • Proud Father
    • Battleclinic
Re: MySQL 5 Released!
« Reply #11 on: November 07, 2005, 04:47:41 pm »
Search should be fixed over there now, they recently moved servers.
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #12 on: November 07, 2005, 05:12:00 pm »
Quote from: Bonk on November 07, 2005, 03:29:43 pm
One word: Search.

SMF has yet to completely finish the search function. I understand they have made progress from 1.0.x but still have to disable it altogether quite frequently. A forum absolutley must have a working search function. (especially when the messages database is very large and there is a browsing load on the server).

P.S. I just took a quick peek at your site and got some error messages, ya might want to check it out if you're not currently working on it.


I know. I deleted it.


Here is the forum I am currently working on.


http://www.clanlessfraggers.com
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #13 on: November 07, 2005, 05:23:22 pm »
Quote from: MrCue on November 07, 2005, 04:47:41 pm
Search should be fixed over there now, they recently moved servers.

Got a "search disabled - try again later" message yesterday.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #14 on: November 07, 2005, 05:29:10 pm »
Quote from: SkyFlyer on November 07, 2005, 05:12:00 pm
I know. I deleted it.


Here is the forum I am currently working on.


http://www.clanlessfraggers.com


Ah, I was going by your old sig.  The new site looks slick!  :thumbsup:
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #15 on: November 07, 2005, 05:31:32 pm »
Quote from: Bonk on November 07, 2005, 05:29:10 pm
Quote from: SkyFlyer on November 07, 2005, 05:12:00 pm
I know. I deleted it.


Here is the forum I am currently working on.


http://www.clanlessfraggers.com


Ah, I was going by your old sig. The new site looks slick! :thumbsup:


yes... i took it down maybe a year ago.

LOL

anyway, thanks... We're around 50,000 page refreshes a month currently, but we used to get around 100,000 before we changed sites... and gameservers... three times...
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #16 on: November 07, 2005, 07:45:09 pm »
No doubt Bonk and Mr. Cue have gotten this already... but if not:

MySQL AB recently announced their fifth version of MySQL to be ready for production use. Version 5 comes with a lot of new features, like stored procedures, triggers, and views. As of MySQL 5.0.12, a few changes have been made in the precedence of table joins. This causes some pages of Simple Machines Forum to stop working.

Simple Machines is therefore happy to release a compatibility patch for both 1.0.5 and 1.1 RC1. If you or your provider are planning on upgrading their MySQL server to 5.0.12 or higher, you can easily patch your forum in one of the following ways:
  • Use the package manager in your administration center - one click, and you're done.
  • Download the modification file, attached to this message, and modify the files manually according to it.
  • Download the modified files, also attached to this message and overwrite your current files with them.


Regardless of wether this patch is applied or not, SMF will install without a problem on a MySQL 5.0.12 server and the package manager will remain accessible.

To unsubscribe from these announcements, login to the forum and uncheck "Receive forum announcements and important notifications by email." in your profile.

You can view the full announcement by following this link:

http://www.simplemachines.org/community/index.php?topic=55616.0

Regards,
The Simple Machines Community Forum Team.

__________ NOD32 1.1278 (20051107) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #17 on: November 07, 2005, 10:21:37 pm »
Yup: http://www.dynaverse.net/forum/index.php/topic,163361808.msg1122647533.html#msg1122647533  ;)

Patch already applied, going to update MySQL this morning. (Forum was too busy yesterday)
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #18 on: November 07, 2005, 10:50:40 pm »
Oops... btw are u a charter member?
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #19 on: November 07, 2005, 10:54:21 pm »
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #20 on: November 08, 2005, 06:39:20 am »
 :woot: Dynaverse.net updated!
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #21 on: November 08, 2005, 12:08:08 pm »
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #22 on: November 08, 2005, 04:29:27 pm »
MrCue has us both beat - he's the original SMF fan around here:

http://www.simplemachines.org/community/index.php?action=profile;u=432

 :P
Logged

Offline MrCue

  • Site Designer
  • Lt.
  • *
  • Posts: 977
  • Gender: Male
  • Proud Father
    • Battleclinic
Re: MySQL 5 Released!
« Reply #23 on: November 08, 2005, 05:19:29 pm »
Aye, i came over from YaBBSE almost on day 1.

I went, YaBB -> YaBBSE -> SMF
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #24 on: November 09, 2005, 11:32:10 am »
I used to use YaBB when I had my 15mb space on my 56k connection...

IIRC it was flatfile,r ight? No mysql.
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline MrCue

  • Site Designer
  • Lt.
  • *
  • Posts: 977
  • Gender: Male
  • Proud Father
    • Battleclinic
Re: MySQL 5 Released!
« Reply #25 on: November 09, 2005, 02:32:34 pm »
Yup, the original YaBB was writen in Perl and used text files to store all its information.

http://www.yabbforum.com/
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #26 on: November 09, 2005, 02:50:54 pm »
Quote from: MrCue on November 09, 2005, 02:32:34 pm
Yup, the original YaBB was writen in Perl and used text files to store all its information.

http://www.yabbforum.com/


yup. I made a couple mods for it. I have a few perl books still in the shelf :D
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #27 on: November 09, 2005, 03:57:00 pm »
The Forge D2 server (ODIN) now updated to MySQL 5.

Just the Serverkit Development Testing / General D2 gaming server (THOR) remains.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #28 on: November 11, 2005, 02:55:34 am »
Updating to MySQL 5 has broken registrations on SMF, even with the MySQL 5.0.12 compatibility update installed. Working on a fix...
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #29 on: November 11, 2005, 03:20:30 am »
Registrations fixed. Temporary fix posted on SMF's forums.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #30 on: November 11, 2005, 02:09:29 pm »
Note also that the SMF database needs a correction to get reminders to work on a strict MySQL 5 installation.

http://www.simplemachines.org/community/index.php?topic=55616.60
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL 5 Released!
« Reply #31 on: November 11, 2005, 06:08:50 pm »
Seems merging/splitting topics may be an issue as well:

http://www.simplemachines.org/community/index.php?topic=55616.msg393517#msg393517
Logged

Offline SkyFlyer

  • D.Net Beta Tester
  • Commander
  • *
  • Posts: 4240
  • Gender: Male
Re: MySQL 5 Released!
« Reply #32 on: November 11, 2005, 09:24:24 pm »
Thank you bonk. :)
Logged
Life is short... running makes it seem longer.

"A god who let us prove his existence would be an idol" - Dietrich Bonhoeffer
Pages: 1 2 [All]
« previous next »