+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Error using New SphereServer 56c (/Thread-Error-using-New-SphereServer-56c)
Error using New SphereServer 56c - invernizzi - 07-11-2016 06:46 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 sends 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?
RE: Error using New SphereServer 56c - rastrero - 07-12-2016 12:06 AM
is sphere connected to db??
pass and login are correct?
table names etc..
RE: Error using New SphereServer 56c - invernizzi - 07-12-2016 02:22 AM
Yes, all is fine, with the older EXE of Sphere no erros occurs.
RE: Error using New SphereServer 56c - invernizzi - 07-14-2016 05:18 AM
I found the problem, the "SELECT" command dont accept "*" clause, when I change to the name of columns no more errors occurs. Thanx all.
RE: Error using New SphereServer 56c - rastrero - 07-15-2016 06:03 AM
ty for posting the solution
RE: Error using New SphereServer 56c - invernizzi - 07-15-2016 02:04 PM
But the problem persist when I use many fields (columns), heheh. Im trying to modify many scripts to minimize it, very dificult! heheh
RE: Error using New SphereServer 56c - Coruja - 07-16-2016 07:05 AM
are you using win or linux build?
here on win build I'm using DB.QUERY "SELECT * FROM ..." without any problem
RE: Error using New SphereServer 56c - XuN - 07-16-2016 07:45 PM
Reading what you said it seems that it cannot handle as much information as it did before.
RE: Error using New SphereServer 56c - invernizzi - 07-20-2016 03:50 AM
Im using win version, perhaps the name of column is the problem, i need to test it, try to rename some large column names, and dont use "_" as separator.
But when I use the same command, but using less columns, no error occurs, strange. I will test more possibilitys.
RE: Error using New SphereServer 56c - invernizzi - 08-25-2016 06:33 AM
I need a help about this problem, any one can help me? I do a little test with my script, and share the result (Dialog):
DB.Query "SELECT serial,nome,venda,valor From uo_person Where venda=1 and server='HellFire' Order by nome Limit <Eval (<cTag.Dialogindex>)>,<Eval (<cTag.Dialogindex>+19)>";
For index 0 18
Serv.Log = "Index: <Eval <local.index>> Nome: <db.row.<Eval (<local.index>)>.nome> Valor: <db.row.<Eval <local.index>>.valor> Venda: <db.row.<Eval <local.index>>.venda>"
EndFor
LOG on sphere:
17:25:(CashShop_MySQL.scp,254)Index: 0 Nome: A p o l l o Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 1 Nome: Abdenago Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 2 Nome: Abstration Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 3 Nome: AnDrE Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 4 Nome: Angelflames Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 5 Nome: Axelrud Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 6 Nome: BoO Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 7 Nome: ByRoN Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 8 Nome: CerberuS Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 9 Nome: Cyclone Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 10 Nome: Dare Devil Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 11 Nome: Diabinha Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 12 Nome: Filth Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 13 Nome: Hawk Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 14 Nome: Igor Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 15 Nome: Jujuba Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 16 Nome: Kubuntu Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 17 Nome: Lucjonny Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 18 Nome: Papai Smurf Valor: 0 Venda:
The name of person is correct, but "valor" (expected value 1) and "venda" (expected values like 5000, 10000...) not. This columns are INT, im using the last Nightly Build.
The character set of my table is UTF8 and engine is MyISAM