Post: #11

usually both MySQL client/server have version numbers, and both must be compatible with each other. Sphere 56b was released on 2009~2013, and since it uses an old MySQL client from these dates, maybe it will get some problems if you connect this old MySQL client on an new "2017" MySQL server

so ~maybe~ the best solution is update your sphere 56b to 56d (which already uses the latest MySQL client available) or downgrade your MySQL server to an old version

Post: #12

new 56d
i took just sphere.ini, mysql.dll, sphere.exe, spherecrypt.ini

CRITICAL:(sphereworld.scp,3269)Error Pri=2, Code=0, Desc='CTileTerrainType.ReadInfo: TileData Read', in GetItemData - [WORLDITEM i_multi_house_stone_plaster_small]
CRITICAL:(sphereworld.scp,104730)Error Pri=2, Code=0, Desc='CTileTerrainType.ReadInfo: TileData Read', in GetItemData - [WORLDITEM i_multi_shop_marble_small]
ERROR:(sphere_item_magic_weapon.scp,514)Setting new id for base type i_sword_viking_vanq not allowed
ERROR:(sphere_item_magic_weapon.scp,514)Setting new id for base type i_sword_viking_vanq not allowed
Loading save/spherechars.scp
CRITICAL:(spherechars.scp,149643)Error Pri=2, Code=0, Desc='CTileTerrainType.ReadInfo: TileData Read', in GetItemData - [WORLDITEM i_deed_villa_2story]
ERROR:(sphere_item_multis_houses_ships.scp,1284)Setting new id for base type i_deed_villa_2story not allowed
ERROR:(sphere_item_multis_houses_ships.scp,1284)Setting new id for base type i_deed_villa_2story not allowed
ERROR:(sphere_item_multis_houses_ships.scp,1202)Setting new id for base type i_deed_tower_wizard not allowed
ERROR:(sphere_item_multis_houses_ships.scp,1202)Setting new id for base type i_deed_tower_wizard not allowed
CRITICAL:(spherechars.scp,1045009)Error Pri=2, Code=0, Desc='CTileTerrainType.ReadInfo: TileData Read', in GetItemData - [WORLDITEM i_deed_cabin_log_2story]
ERROR:(sphere_item_provisions_deed.scp,236)Setting new id for base type i_deed_cabin_log_2story not allowed
ERROR:(sphere_item_provisions_deed.scp,236)Setting new id for base type i_deed_cabin_log_2story not allowed
ERROR:UID=04002e9f8, id=04123 'Viking Sword of Vanquishing', Invalid code=2230 (Item equipped in the trade window layer

Post: #13

Script pack for 56d is completelly different from the 56b one!

That means you can't simpy use a 56b worldsave file with a new 56d instalaltion

Post: #14

so i have just one way use the new script and cannot be fixed without?

Post: #15

Download the script pack from 56d and Sphere56d, and just test if your database scripts works
If they still don't work maybe there is a problem in the scripts.

Post: #16

so how i can fixed infinity loop ?
with that function

if !(<db.connected>)
db.connect <---- why ??? infinity loop not so often but sometimes and it is, any suggest ?
endif

Post: #17

nori u have 3 big problems.
1) db have different response versions and pings (depends if u pay for it or not), i mean u r using a db of your site and sphere in different host. better put them in same region or host, and pay for it if u can.
2) 56b + mysql is impossible to use it, as said coruja u have to downgrade your db mysql but i think is impossible do it alone.
3) upgrade from 56b to 56d isnt fast and easy, that errors is called by wrong defs, new defs for multi starts with m_xxx not with i_xxx. when u upgrade a sphere version you have to check spheredefs, spheremsg, spells,skills,revisions, fix bugs and fix new spheremechanics if u have custom shard.

(10-07-2017 04:06 PM)nori4 Wrote:  if !(<db.connected>)
db.connect <---- why ??? infinity loop not so often but sometimes and it is, any suggest ?
endif

not so often becouse sometimes is connect and sometimes not?
check point 1.
if u wanna do last try use 56c.

Post: #18

moved on 2016 release sphere and script not working
22:13:CRITICAL:(added_funcions.scp,2669)"Access Violation" (0x1251f4), in CScriptObj::Verb()
22:13:DEBUG:command 'DB.query' args '"SELECT * FROM bumbum WHERE rating = (SELECT MAX(rating) from bumbum)' [007962E0]

before when was 2009 sphere work everything fine
whats wrong?


22:13:DEBUG:__ thread (2228) __ | # | _____ function _____________ | ticks passed from previous function start ______
22:13:DEBUG:>> 2228 | 0 | CWorld::OnTick | +0
22:13:DEBUG:>> 2228 | 1 | CSector::OnTick | +0
22:13:DEBUG:>> 2228 | 2 | CItem::OnTick | +0
22:13:DEBUG:>> 2228 | 3 | CItem::OnTrigger | +0
22:13:DEBUG:>> 2228 | 4 | CScriptObj::OnTriggerScript | +0
22:13:DEBUG:>> 2228 | 5 | CScriptObj::OnTriggerRunVal | +0
22:13:DEBUG:>> 2228 | 6 | CScriptObj::OnTriggerRun | +0
22:13:DEBUG:>> 2228 | 7 | CScriptObj::OnTriggerRun | +0
22:13:DEBUG:>> 2228 | 8 | CItem::r_Verb | +0
22:13:DEBUG:>> 2228 | 9 | CObjBase::r_Verb | +0
22:13:DEBUG:>> 2228 | 10 | CScriptObj::r_Call | +0
22:13:DEBUG:>> 2228 | 11 | CScriptObj::OnTriggerRun | +0
22:13:DEBUG:>> 2228 | 12 | CItem::r_Verb | +0
22:13:DEBUG:>> 2228 | 13 | CObjBase::r_Verb | +0
22:13:DEBUG:>> 2228 | 14 | CScriptObj::r_Call | +0
22:13:DEBUG:>> 2228 | 15 | CScriptObj::OnTriggerRun | +0
22:13:DEBUG:>> 2228 | 16 | CItem::r_Verb | +47
22:13:DEBUG:>> 2228 | 17 | CObjBase::r_Verb | +0
22:13:DEBUG:>> 2228 | 18 | CScriptObj::r_Verb | +0 <-- exception catch point (below is guessed and could be incorrect!)
22:13:DEBUG:>> 2228 | 19 | CGFile::Close | +0

DB.query "SELECT uid FROM bumbum WHERE title = <def0.tra>"
if <DB.row.numrows>
DB.execute "UPDATE bumbum SET title = '0' WHERE uid = '<DB.row.uid>'"
endif

DB.query "SELECT * FROM bumbum WHERE rating = (SELECT MAX(rating) from bumbum)"
if <DB.row.numrows>
if (<DB.row.rating> >= <def0.req>)
DB.execute "UPDATE bumbum SET title = '<def0.tra>' WHERE uid = '<DB.row.uid>'"
uid.<DB.row.uid>.winner
else
serv.log 'INFORM' no winners yet
endif
endif

Post: #19

any one can help?
have moved from 2008-2009 version sphere to newer 2013 and got this error with script.

Post: #20

Try with a nightly build https://forum.spherecommunity.net/sshare.php?srt=4