Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
56b mysql
Author Message
Coruja
Sphere Developer
*****

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

Dimension Shard

Post: #11
RE: 56b mysql
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
09-21-2017 04:20 AM
Find all posts by this user Like Post Quote this message in a reply
nori4
Apprentice
*

Posts: 11
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Sep 2017
Reputation: 0



Post: #12
RE: 56b mysql
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
(This post was last modified: 09-21-2017 07:17 AM by nori4.)
09-21-2017 06:06 AM
Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 246
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #13
RE: 56b mysql
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
(This post was last modified: 09-21-2017 07:24 AM by darksun84.)
09-21-2017 07:16 AM
Find all posts by this user Like Post Quote this message in a reply
nori4
Apprentice
*

Posts: 11
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Sep 2017
Reputation: 0



Post: #14
RE: 56b mysql
so i have just one way use the new script and cannot be fixed without?
09-21-2017 07:51 AM
Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 246
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #15
RE: 56b mysql
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.
09-21-2017 08:10 AM
Find all posts by this user Like Post Quote this message in a reply
nori4
Apprentice
*

Posts: 11
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Sep 2017
Reputation: 0



Post: #16
RE: 56b mysql
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
10-07-2017 04:06 PM
Find all posts by this user Like Post Quote this message in a reply
massis87
Journeyman
*

Posts: 82
Likes Given: 0
Likes Received: 1 in 1 posts
Joined: Jan 2017
Reputation: 0

D&W 8thAge

Post: #17
RE: 56b mysql
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.

There are worse ways to understand the sense of the word: no. Ranting
(This post was last modified: 10-07-2017 05:25 PM by massis87.)
10-07-2017 05:15 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
nori4
Apprentice
*

Posts: 11
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Sep 2017
Reputation: 0



Post: #18
RE: 56b mysql
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
(This post was last modified: 10-26-2017 06:18 AM by nori4.)
10-26-2017 05:22 AM
Find all posts by this user Like Post Quote this message in a reply
nori4
Apprentice
*

Posts: 11
Likes Given: 0
Likes Received: 0 in 0 posts
Joined: Sep 2017
Reputation: 0



Post: #19
RE: 56b mysql
any one can help?
have moved from 2008-2009 version sphere to newer 2013 and got this error with script.
10-28-2017 10:07 PM
Find all posts by this user Like Post Quote this message in a reply
darksun84
Sir Spamalot
****

Posts: 1,687
Likes Given: 246
Likes Received: 162 in 151 posts
Joined: Mar 2012
Reputation: 35



Post: #20
RE: 56b mysql
10-29-2017 12:57 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


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