The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb




SphereCommunity / General Discussion / News v / Updated MySQL client


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Updated MySQL client
Author Message
Coruja
Sphere Developer
*****

Posts: 987
Likes Given: 5
Likes Received: 226 in 187 posts
Joined: Jul 2012
Reputation: 7

Dimension Shard
Post: #1
Updated MySQL client
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
09-26-2015 07:39 AM
Find all posts by this user Like Post Quote this message in a reply
[+] 2 users Like Coruja's post
escribano
Journeyman
*

Posts: 170
Likes Given: 16
Likes Received: 32 in 23 posts
Joined: Nov 2012
Reputation: 2

Dragon Shard
Post: #2
RE: Updated MySQL client
Thankssssssss coruja!!!!!

That's awesome!!!!!!!!!!!!
(Thats what im talking about make sphere better)
UltimaPHP - OpenSource Ultima Online Server v0.1-pre-alpha under development, we need help!
09-27-2015 04:12 AM
Find all posts by this user Like Post Quote this message in a reply
Ultima One
Journeyman
*

Posts: 238
Likes Given: 7
Likes Received: 10 in 6 posts
Joined: Jan 2013
Reputation: 6

Ultima One
Post: #3
RE: Updated MySQL client
About time Big Grin

Thanks Smile
ULTIMA ONE
The modern, sphere powered Ultima Online server
09-28-2015 06:10 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
invernizzi
Apprentice
*

Posts: 24
Likes Given: 8
Likes Received: 1 in 1 posts
Joined: Jul 2016
Reputation: 0



Post: #4
RE: Updated MySQL client
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?
07-11-2016 06:45 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)

Contact Us | SphereCommunity | Return to Top | Return to Content | Mobile Version | RSS Syndication