+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: General Discussion (/Forum-General-Discussion)
+--- Forum: News (/Forum-News)
+--- Thread: Updated MySQL client (/Thread-Updated-MySQL-client)
Updated MySQL client - Coruja - 09-26-2015 07:39 AM
Some weeks ago the MySQL client used on Sphere 0.56c got updated from version 4.1.18 to 6.1.6.
All MySQL functions on sphere stay exactly the same as always, but now running on a much more improved code, because the old version was released on 2006 (9 years ago) and now we're using the latest 2015 release.
Sphere requires the libMySQL.dll file to enable MySQL functions, and this file also got updated.
So to keep everything working fine and without errors, we highly recommend update this file to the latest version avaible on the nightlies page:
http://nightly.prerelease.sphere.torfo.org
RE: Updated MySQL client - escribano - 09-27-2015 04:12 AM
Thankssssssss coruja!!!!!
That's awesome!!!!!!!!!!!!
(Thats what im talking about make sphere better)
RE: Updated MySQL client - Ultima One - 09-28-2015 06:10 PM
About time
Thanks
RE: Updated MySQL client - invernizzi - 07-11-2016 06:45 AM
Hi folks,
I need some help to use new version of Sphere, my server uses MySQL 5.1, and I trying to update Sphere, but I have some problems:
Using SphereServer 0.56c Pre-releases and MySQL.dll from tha same download page (http://prerelease.sphere.torfo.org/index.php), when I use any DB.QUERY the console send an error:
17:34:CRITICAL:(Funcoes_MySQL.scp,113)"Access Violation" (0xdde14), in CScriptObj::Verb()
17:34:DEBUG:command 'DB.Query' args '"SELECT * From uo_person Where serial='0ec35e' and server='HellFire';' [13D38D74]
17:34:DEBUG:__ thread (172) __ | # | _____ function _____________ | ticks passed from previous function start ______
17:34:DEBUG:>> 172 | 0 | CWorld::OnTick | +0
17:34:DEBUG:>> 172 | 1 | CGObList::DeleteAll | +0
17:34:DEBUG:>> 172 | 2 | CClient::CharDisconnect | +0
17:34:DEBUG:>> 172 | 3 | CChar::OnTrigger | +0
17:34:DEBUG:>> 172 | 4 | CScriptObj::OnTriggerScript | +0
17:34:DEBUG:>> 172 | 5 | CScriptObj::OnTriggerRunVal | +0
17:34:DEBUG:>> 172 | 6 | CScriptObj::OnTriggerRun | +0
17:34:DEBUG:>> 172 | 7 | CChar::r_Verb | +0
17:34:DEBUG:>> 172 | 8 | CObjBase::r_Verb | +0
17:34:DEBUG:>> 172 | 9 | CScriptObj::r_Call | +0
17:34:DEBUG:>> 172 | 10 | CScriptObj::OnTriggerRun | +0
17:34:DEBUG:>> 172 | 11 | CScriptObj::OnTriggerRun | +0
17:34:DEBUG:>> 172 | 12 | CChar::r_Verb | +0
17:34:DEBUG:>> 172 | 13 | CObjBase::r_Verb | +500
17:34:DEBUG:>> 172 | 14 | CScriptObj::r_Verb | +0 <-- exception catch point (below is guessed and could be incorrect!)
17:34:DEBUG:>> 172 | 15 | CGFile::Close | +16
17:34:CRITICAL:(Funcoes_MySQL.scp,113)"Access Violation" (0xdde14), in CScriptObj::Verb()
17:34:DEBUG:command 'DB.Query' args '"SELECT * From uo_person Where serial='0ec35e' and server='HellFire';' [13D38D74]
I try to use the Nightly, with new MYSQL.DLL, but SphereServer dont initialize, an error in "KERNEL" occur.
Any one can help?