problem

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
ok b4 i get flamed on this i have spent a week trying to sort this out by searching the forum and trying what i know. I have a problem with lvls ive used 3.55 found here http://www.lomcn.co.uk/forum/showthread.php?52162-PtW-3G-The-One-Thread-You-Will-Ever-Need , installed server as guide has said, i can make an account but i cant lvl past 255 in lobby. When i do say lvl 256, in lobby im getting lvl 0 also in sql in Game3G tbl_character im getting the same. So i tried this post http://www.lomcn.co.uk/forum/showthread.php?58603-3G-CD-Known-Server-Fixes , so i have tried several diff databases also tried doing the bigint way as well. So would be gratefull if some one can point me in the right direction pls. Ive even tried re-installing everything inc windows and client getting abit fedup tbh/ Forgot to mention ingame it says im lvl 256 but not in lobby or sql
 
Sort by date Sort by votes
Serenity

Serenity

Dedicated Member
Dedicated Member
Jul 3, 2010
159
1
45
Its more then likely due to your using a 3.38 server database.. try looking for a 3.55 database should fix the problem..
 
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
Serenity said:
Its more then likely due to your using a 3.38 server database.. try looking for a 3.55 database should fix the problem..
Click to expand...

used those files you sent me bud they are the same, any hlp would b great. This is how it goes i log into the server with a gm char do the command @changelevel name 255, log out sql remembers that lvl so does lobby and ingame. When i lvl up to 256, sql resets me to lvl 0 as well as lobby but ingame im lvl 256

---------

can this be apart of the problem - copied from login server logs

20:01:22 Login Server initialized.
20:01:23 [GameServer/Conn] GameServer connected. (127.0.0.1): (1073)
20:02:02 [GameServer/Conn] GameServer connected. (127.0.0.1): (1077)
20:02:38 [LoginGate/Conn] LoginGate connected.(127.0.0.1): (1080)
20:31:22 [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
20:31:22 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
20:31:22 [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
20:31:22 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

-----------

ok to try andhelp this mess out ive taken some screen shots, this really doing my head in now i used to run a server and never had this problem. Pls can some one help i can install team viewer if some one wants to have a look, heres pics

http://i1140.photobucket.com/albums/n561/Craig_Burrell/SCREEN0023.jpg - as you see in this one im lvl 256
http://i1140.photobucket.com/albums/n561/Craig_Burrell/desktop.jpg - in this one you can see yhe problem on login server
http://i1140.photobucket.com/albums/n561/Craig_Burrell/sql.jpg - in this one you can see sql hasnt saved my lvl
 
Last edited by a moderator:
Upvote 0
woogyeman

woogyeman

Dedicated Member
Dedicated Member
Nov 23, 2010
75
5
35
Do A search here on Server files 3.55. it is a nice 3.55 English database that works well for startup Restore databases from there, if you still have problems it is not your database acting up it is a different SQL problem.
 
Last edited:
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
ok ive tried a diff comp and also another copy of sql, i no longer get the prob in sql, but still unable to get the lvls to save in sql, even tho ingame it still says true lvl. is there any where else in the database,s it saves ur lvl while logging out. BTW ive tried all databases on this forum i could find. What could be the problem with sql not saving the data properly when you log out

can this be apart of the problem i used KaoriMir3SetupChecker120 here is mt results

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 1 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Game Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Hero Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- SQL Checking Done ----------
 
Last edited:
Upvote 0
Zordon

Zordon

Golden Oldie
Golden Oldie
Apr 26, 2008
1,176
20
145
Manchester, UK
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
Zordon said:
You asked how I worked it out. Look at the screen, console is not showing properly for one. It ONLY show's all of the buttons properly if you have ALL setting in language options set to chinese prc.
Click to expand...

but as you can see i have installed chinesePRC bud
 
Upvote 0
Zordon

Zordon

Golden Oldie
Golden Oldie
Apr 26, 2008
1,176
20
145
Manchester, UK
ok so if you have tried every database for 3.55, its not the database. try checking the setup. also make sure you have the correct updates/service packs for sql
 
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
Zordon said:
ok so if you have tried every database for 3.55, its not the database. try checking the setup. also make sure you have the correct updates/service packs for sql
Click to expand...

ok im getting somewhere now ive gone from getting this -

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 1 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Game Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Hero Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- SQL Checking Done ----------

to getting this now -

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 1 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Base Data Database is connected successfully.
HL_Stditems table is healthy.
---------- Game Database (Direct) ----------
Game Database is connected successfully.
TBL_ABILITY has 1 rows.
---------- Hero Database (Direct) ----------
Hero Database is connected successfully.
rareitemsdata has 192 rows.
---------- SQL Checking Done ---------

so now gonna try databases now again

ok new problem in messing with database's ive done something, can anyone tell me what this is

¼ÓÔØINIÅäÖÃÎļþ³É¹¦£¡
²å¼þ²ÎÊýÓ¦Óóɹ¦£¡
±£´æ²å¼þ²ÎÊýµ½INIÎļþ³É¹¦£¡
¹ÖÎï˵»°Îļþ¼ÓÔسɹ¦!
×Ô¶¯¶¨Ê±½Å±¾Îļþ¼ÓÔسɹ¦!
ÕýÔÚ¿ªÊ¼ÔØÈëSQLÎïÆ·Êý¾Ý¿â.............¼Ç¼Êý=1404
×Ô¶¯ÎïÆ·È«·þ¹«¸æÎļþ¼ÓÔسɹ¦!
ÎïÆ·Êý¾Ý¿âÔØÈë³É¹¦£¡
ÕýÔÚ¿ªÊ¼ÔØÈëSQL¹ÖÎïÊý¾Ý¿â.............¼Ç¼Êý=359
¹ÖÎïÊý¾Ý¿âÔØÈë³É¹¦£¡
ÕýÔÚ¿ªÊ¼ÔØÈëSQLħ·¨Êý¾Ý¿â.............¼Ç¼Êý=67
ħ·¨Êý¾Ý¿âÔØÈë³É¹¦£¡
11:49:43:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 2E6F4E08
11:49:50:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:10:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:10:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:14:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
Reload Admin OK!

ive copied it from the blue box in c3.55 window
 
Upvote 0
Zordon

Zordon

Golden Oldie
Golden Oldie
Apr 26, 2008
1,176
20
145
Manchester, UK
Try restoring the databases. Its best not to do anything with them other than changing ip's, server name, until you have it fully working.
 
Upvote 0
jonathan508

jonathan508

Golden Oldie
Golden Oldie
Dec 27, 2007
623
11
125
Europe
mercury71 said:
ok im getting somewhere now ive gone from getting this -

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 1 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Game Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Hero Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- SQL Checking Done ----------

to getting this now -

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 1 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 1 rows.
---------- Manage Database (ODBC) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Base Data Database is connected successfully.
HL_Stditems table is healthy.
---------- Game Database (Direct) ----------
Game Database is connected successfully.
TBL_ABILITY has 1 rows.
---------- Hero Database (Direct) ----------
Hero Database is connected successfully.
rareitemsdata has 192 rows.
---------- SQL Checking Done ---------

so now gonna try databases now again

ok new problem in messing with database's ive done something, can anyone tell me what this is

¼ÓÔØINIÅäÖÃÎļþ³É¹¦£¡
²å¼þ²ÎÊýÓ¦Óóɹ¦£¡
±£´æ²å¼þ²ÎÊýµ½INIÎļþ³É¹¦£¡
¹ÖÎï˵»°Îļþ¼ÓÔسɹ¦!
×Ô¶¯¶¨Ê±½Å±¾Îļþ¼ÓÔسɹ¦!
ÕýÔÚ¿ªÊ¼ÔØÈëSQLÎïÆ·Êý¾Ý¿â.............¼Ç¼Êý=1404
×Ô¶¯ÎïÆ·È«·þ¹«¸æÎļþ¼ÓÔسɹ¦!
ÎïÆ·Êý¾Ý¿âÔØÈë³É¹¦£¡
ÕýÔÚ¿ªÊ¼ÔØÈëSQL¹ÖÎïÊý¾Ý¿â.............¼Ç¼Êý=359
¹ÖÎïÊý¾Ý¿âÔØÈë³É¹¦£¡
ÕýÔÚ¿ªÊ¼ÔØÈëSQLħ·¨Êý¾Ý¿â.............¼Ç¼Êý=67
ħ·¨Êý¾Ý¿âÔØÈë³É¹¦£¡
11:49:43:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 2E6F4E08
11:49:50:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:10:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:10:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
11:50:14:Access violation at address 0225A3B6 in module 'Holley_Mir3G.DLL'. Write of address 00000000
Reload Admin OK!

ive copied it from the blue box in c3.55 window
Click to expand...

Download another 3.55working.rar and copy Holley_Mir3G.DLL in ur server folder.
 
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
Zordon said:
Try restoring the databases. Its best not to do anything with them other than changing ip's, server name, until you have it fully working.
Click to expand...

databases r working and save lvls under lvl 255 when you go above lvl 255 sql will not save data it puts a 0 (zero) but in game your lvl is 256 or which ever lvl you are. So how can that be? ne clue bud. Thats why i was asking for help
 
Upvote 0
You must log in or register to reply here.
Top Bottom