| View previous topic :: View next topic |
| Author |
Message |
doxic
Joined: 07 Oct 2008
Posts: 13
|
 Posted: Sat Jun 20, 2009 23:01 Post subject: instant 'Lost connection to MySQL server during query' |
 |
|
Hello again,
I've got a big Problem with my MySQL server, running on a webspace with the version 5.0.41.
The Problem is that i get the error Message "! SQL Error: Lost connection to MySQL server during query" directly after i started my nwn server via NWNX2. This happens with every command i try to execute.
Here's the nwnx_odbc log:
| Quote: | NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
o Logfile maximum size limit is: 1048576 bytes
o Log level: Everything will be logged.
o Using MySQL connection.
o Hooking SCO....hooked at 5d5830
o Hooking RCO....hooked at 5d5710
o Connect successful.
o Got request: select date(localtime()), time(localtime())
! SQL Error: Lost connection to MySQL server during query
o Empty set |
It's just strange, because if I'm using the MySQL server from a friend (version 4.1.10a) I don't get any errors.
I read somewhere that this error occurs, when using my mysql version, but I don't really know if it's true.
I can browse in the database without any problems with phpMyAdmin or the MySQL Query Browser, but it's just not possible to do anything with this db in nwn.
Does anyone know what to do?
Thanks,
doxic
*edit*:
I just took a look into the search function and found the post with the ping() function.
I don't know why and how, but if i make the script to execute the "select 1" command, the connection establishes and stays.
But I'm getting the "lost connection" message very often... :/ |
|
| Back to top |
|
 |
Fireboar
Joined: 17 Feb 2008
Posts: 323
|
| Posted: Sun Jun 21, 2009 21:26 Post subject: |
|
|
| So... why don't you update your MySQL version? |
|
| Back to top |
|
|
doxic
Joined: 07 Oct 2008
Posts: 13
|
| Posted: Tue Jun 23, 2009 0:03 Post subject: |
|
|
That's what I'm going to try now, but I don't know, if the server hosts will react to my request and that's why I created this topic  |
|
| Back to top |
|
|
Zebranky
Joined: 04 Jun 2006
Posts: 415
|
| Posted: Wed Jun 24, 2009 10:29 Post subject: |
|
|
Just a wild guess, but maybe the binary version of nwnx_odbc available for download was linked against a version of libmysqlclient with some kind of bug causing this. I just built the latest in Win32 SVN and uploaded it to http://mercuric.net/nwn/nwnx/nwnx_odbc-20090624.dll. Download and rename to nwnx_odbc.dll and give it a shot.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/
<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.
<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for? |
|
| Back to top |
|
|
doxic
Joined: 07 Oct 2008
Posts: 13
|
| Posted: Sun Jun 28, 2009 16:35 Post subject: |
|
|
Thanks, i'm going to try it out and write a little response  |
|
| Back to top |
|
|
doxic
Joined: 07 Oct 2008
Posts: 13
|
| Posted: Tue Jun 30, 2009 14:11 Post subject: |
|
|
Ok, I tried the new complied dll and everything worked fine 
It seems that this solved the Problem.
Thank you very much |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
