Dynaverse.net

Off Topic => Engineering => Topic started by: Bonk on November 03, 2005, 03:29:18 pm

Title: MySQL 5 Released!
Post by: Bonk on November 03, 2005, 03:29:18 pm
http://www.mysql.com/

Big news... :)  bunch of work for Bonk...  :(
Title: Re: MySQL 5 Released!
Post by: Sirgod on November 03, 2005, 08:00:44 pm
Cracks the whip, Get her Done Bro.  ;D

stephen
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 03, 2005, 11:22:57 pm
awesome.
Title: Re: MySQL 5 Released!
Post by: Bonk 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

Title: Re: MySQL 5 Released!
Post by: Bonk 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
Title: Re: MySQL 5 Released!
Post by: 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
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 06, 2005, 06:45:41 pm
SMF 1.0.5 is allergic to MySQL 5.0.15. Grrrrrrr! >:( I tried to update Dynaverse.net this morning, it no worky... :(

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


Really? Thanks for letting me know.

Glad I waited to update.

Have you tried 1.1 RC1?
Title: Re: MySQL 5 Released!
Post by: 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.
Title: Re: MySQL 5 Released!
Post by: Bonk 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...).
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 07, 2005, 01:40:49 pm
Actually, it seems SMF will be patching both 1.0.5 and 1.1 RC1 shortly! :woot:

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

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

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.
Title: Re: MySQL 5 Released!
Post by: 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.
Title: Re: MySQL 5 Released!
Post by: MrCue on November 07, 2005, 04:47:41 pm
Search should be fixed over there now, they recently moved servers.
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 07, 2005, 05:12:00 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
Title: Re: MySQL 5 Released!
Post by: Bonk on November 07, 2005, 05:23:22 pm
Search should be fixed over there now, they recently moved servers.

Got a "search disabled - try again later" message yesterday.
Title: Re: MySQL 5 Released!
Post by: Bonk on November 07, 2005, 05:29:10 pm
I know. I deleted it.


Here is the forum I am currently working on.


[url]http://www.clanlessfraggers.com[/url]


Ah, I was going by your old sig.  The new site looks slick!  :thumbsup:
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 07, 2005, 05:31:32 pm
I know. I deleted it.


Here is the forum I am currently working on.


[url]http://www.clanlessfraggers.com[/url]


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...
Title: Re: MySQL 5 Released!
Post by: SkyFlyer 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:


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
Title: Re: MySQL 5 Released!
Post by: Bonk 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)
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 07, 2005, 10:50:40 pm
Oops... btw are u a charter member?
Title: Re: MySQL 5 Released!
Post by: Bonk on November 07, 2005, 10:54:21 pm
Nope, just your average whiner... ;)

http://www.simplemachines.org/community/index.php?action=profile;u=13702;sa=showPosts
Title: Re: MySQL 5 Released!
Post by: Bonk on November 08, 2005, 06:39:20 am
 :woot: Dynaverse.net updated!
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 08, 2005, 12:08:08 pm
i registered before you bonk :P

http://www.simplemachines.org/community/index.php?action=profile;u=6181
Title: Re: MySQL 5 Released!
Post by: Bonk 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
Title: Re: MySQL 5 Released!
Post by: MrCue on November 08, 2005, 05:19:29 pm
Aye, i came over from YaBBSE almost on day 1.

I went, YaBB -> YaBBSE -> SMF
Title: Re: MySQL 5 Released!
Post by: SkyFlyer 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.
Title: Re: MySQL 5 Released!
Post by: 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/
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 09, 2005, 02:50:54 pm
Yup, the original YaBB was writen in Perl and used text files to store all its information.

[url]http://www.yabbforum.com/[/url]


yup. I made a couple mods for it. I have a few perl books still in the shelf :D
Title: Re: MySQL 5 Released!
Post by: Bonk 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.
Title: Re: MySQL 5 Released!
Post by: Bonk 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...
Title: Re: MySQL 5 Released!
Post by: Bonk on November 11, 2005, 03:20:30 am
Registrations fixed. Temporary fix posted on SMF's forums.
Title: Re: MySQL 5 Released!
Post by: Bonk 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
Title: Re: MySQL 5 Released!
Post by: Bonk 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
Title: Re: MySQL 5 Released!
Post by: SkyFlyer on November 11, 2005, 09:24:24 pm
Thank you bonk. :)