Post: #1

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?

Post: #2

is sphere connected to db??
pass and login are correct?
table names etc..

Post: #3

Yes, all is fine, with the older EXE of Sphere no erros occurs.

Post: #4

I found the problem, the "SELECT" command dont accept "*" clause, when I change to the name of columns no more errors occurs. Thanx all.

Post: #5

ty for posting the solution

Post: #6

But the problem persist when I use many fields (columns), heheh. Im trying to modify many scripts to minimize it, very dificult! heheh

Post: #7

are you using win or linux build?

here on win build I'm using DB.QUERY "SELECT * FROM ..." without any problem

Post: #8

Reading what you said it seems that it cannot handle as much information as it did before.

Post: #9

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.

Post: #10

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