Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Development

Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum)

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2006, 01:59 AM
sesmar
I built it I will Support it!
 
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default

Quote:
Originally Posted by Gameross
Either case, you should be working with developers to impliment this change and not doing your own thing and splintering Emu developement. Just seems to make sense.
The devs have released the newest version of the emu (0.7.0-801) to be compatable with MySql 5. However, after I downloaded the binaries and upgraded to MySql 5 (since I have been waiting for an offical release for this) I was getting client not compatable errors. Figuring this may have something to do with it the precompiled binaries having been compiled on a machine still using the MySql 4.0.x include and lib files I grabed the source and recomplied it, as it was, with the MySql 5 lib and include files. After doing this the server booted right up for me. Only problem was once I logged in and tried to cast a spell it would crash everytime.

So all I did was grab the 800 version source and made the few minor changes to the source (mostly changing the any reference to condition in sql statements to _condidtion) to make it compatable with MySql 5 as well. I recompiled the server booted it up logged in and it works great. I could not get the Zone to output debug information for some reason so I was unable to see what was causing the crashes. This is something I am working on now.
__________________

Last edited by sesmar; 06-17-2006 at 10:14 AM..
Reply With Quote
  #2  
Old 06-17-2006, 03:34 AM
aza77
Hill Giant
 
Join Date: Dec 2004
Posts: 126
Default

looks like the problem just appears at windows servers ... i tried 801 with mysql 5.0.20 and 5.0.22 and it works without problems @linux
__________________
- http://www.eqemu-paradigma.de -

Last edited by aza77; 06-17-2006 at 11:43 AM..
Reply With Quote
  #3  
Old 06-17-2006, 07:10 AM
Coleshadowblades
Fire Beetle
 
Join Date: Jun 2006
Posts: 23
Default

I fail to see how it can be a windows specific error to be honest... Seems alot of the bugs in the code get pawned off as a windows error simply cause noone wants to just plain fix them all around.

See here are a few issues ive noticed...

Dirty code

all the devs aint on the same page with the style of coding to be employed thereby all doing their own thing and this shows in the code

instead of coding to work on both types of syste (windows and linux) The devs seem to only wish to develop based on linux.

Now when ya got people like sesmar (And im learning pretty quick thanks to him) Who do stuff for windows instead of a thank you for getting it working we get accused of splintering the project... Got news for you i prefer linux however im smart enough to know itll NEVER be as used nor popular as windows
Reply With Quote
  #4  
Old 06-17-2006, 07:23 AM
gottasummer
Discordant
 
Join Date: Mar 2004
Location: New Hampshire, USA
Posts: 267
Default

I can see how it is a precompiled binary specific error.

The MySQL includes and libraries that are in this build must (well, I don't know about must... but SHOULD) be the same as those that are in use on that system.

If I build EQEmu with MySQL version X.XX, the machine I put it on should also run MySQL version X.XX
Reply With Quote
  #5  
Old 06-17-2006, 07:27 AM
Coleshadowblades
Fire Beetle
 
Join Date: Jun 2006
Posts: 23
Default

I said WINDOWS specific meaning everyone says "oh thats a windows only error" instead of actually fixing it they pawn it off on windows and just leave it be lol
Reply With Quote
  #6  
Old 06-17-2006, 08:33 AM
Coleshadowblades
Fire Beetle
 
Join Date: Jun 2006
Posts: 23
Default

this post is precisly why people dont share their fixes and such with the community... I am removing the binaries can a mod please delete the posts reguarding getting it to work with mysql 5 made by me please?

EDIT the binaries are no longer available for download

Last edited by Coleshadowblades; 06-17-2006 at 04:35 PM.. Reason: update
Reply With Quote
  #7  
Old 06-17-2006, 09:41 AM
WildcardX
Developer
 
Join Date: Apr 2003
Posts: 589
Default

I was gonna post the following SQL changes needed for MySQL 5 support, but I see two of the SQL lines are already posted here... Anyway, you need to do the following SQL:

alter table account change packencrypt packencrypt blob NULL;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;
Reply With Quote
  #8  
Old 06-18-2006, 02:33 PM
johane
Sarnak
 
Join Date: Sep 2005
Location: Gold Coast, Oz
Posts: 69
Default

Quote:
Originally Posted by Coleshadowblades
I said WINDOWS specific meaning everyone says "oh thats a windows only error" instead of actually fixing it they pawn it off on windows and just leave it be lol

I don't recall the exact fix, but this is probably due to the changes in how case is handled in table and field names that happen in MySQL 5. The Windows bit is due to Windows being ^&%*&%* about case handling in general.

There's a setting you can use in my.conf to use "old style" case handling for Windows machines. Look it up.

There's also new string handling functions that should be used, but I can't recall exactly what they are. Most people I know just don't let Windows try to be a server that runs MySQL....

Note that this is not intended to be a flame of any kind. But that's probably why you've got the error.
Reply With Quote
  #9  
Old 06-18-2006, 02:52 PM
mattmeck
Guest
 
Posts: n/a
Default

The flame war stops now, I dont care who you are or what you have done.

Stop now, you want to flame take it to PM's.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:08 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3