ktrose problems

Welcome in the osRose emulator Project.

Moderators: osRose dev team, ospRose dev team, osiRose dev team, Moderators

Re: ktrose problems

Postby harry12 on Wed May 21, 2014 5:40 am

PurpleYouko wrote:.

hi since my friend want to lay pre evo, i got roblem on creating account. whenver i make account there an error about ' last login' is there anyway in codeblocks that i can set default to 0. its not automatic though when i create account using cms or createlginaccount=1.
harry12
Pomic
Pomic
 
Posts: 83
Joined: Sun Feb 14, 2010 9:15 am

Re: ktrose problems

Postby PurpleYouko on Wed May 21, 2014 2:43 pm

'lastlogin' is just a text field into which the server puts a timestamp when you log in.

What error is it giving? Something to do with the line being too long maybe?
It should be set to a varchar with a length of 250. Doesn't seem likely that any timestamp will be longer than that. :?
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: ktrose problems

Postby moimoi250 on Fri Sep 26, 2014 9:47 am

hello

i have the same probleme

[FATAL ERROR] fri sep 26 10:30:59 2014 - Could not execute query: Data too long for column 'last login' at row 1

whith navicat in account table i have 250 in the column last login

finaly what is the problem...

and another probleme :

[WARNING] item count : 1
[FATAL ERROR] could not execute query: column count doesn't match value count a row 1

and after 2 min crash worldserver....

thank you in advance for your help...

(sorry for my english.this is a google traduction)
moimoi250
Little soul
Little soul
 
Posts: 7
Joined: Thu Sep 25, 2014 9:45 pm

Re: ktrose problems

Postby PurpleYouko on Fri Sep 26, 2014 2:14 pm

change the size of the 'last login' field to varchar 500

[WARNING] item count : 1
[FATAL ERROR] could not execute query: column count doesn't match value count a row 1

and after 2 min crash worldserver....

There isn't enough information here to diagnose the problem.
What table is this?
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: ktrose problems

Postby moimoi250 on Fri Sep 26, 2014 3:16 pm

ok

at first, I tried to create an account with the launcher, but I get an error on the loginserver:

Thu Sep 25 21:36:35 2014 - New Account created 'gm1'
Thu Sep 25 21:36:35 2014 - User disconnected
Thu Sep 25 21:37:24 2014 - User connected from 127.0.0.1
Thu Sep 25 21:37:24 2014 - User Login request received
Thu Sep 25 21:37:24 2014 - Could not execute query: Field 'lastlogin' doesn't have a default value
Thu Sep 25 21:37:24 2014 - Reconnecting to Mysql

then I did it manualy with Navicat in the account table.
and I had an error WorldServer:

Fri Sep 26 15:54:23 2014 - XPRate: 2 Map XP rate: 2 for map 0
Fri Sep 26 15:54:23 2014 - Selected Character moi Class 0 GM status: 0 DEV status 0
Fri Sep 26 15:54:23 2014 - Loading union data
Fri Sep 26 15:54:23 2014 - starting PY quest load
Fri Sep 26 15:54:24 2014 - Could not execute query: Data too long for column 'lastlogin' at row 1
Fri Sep 26 15:54:24 2014 - Reconnecting to Mysql
Fri Sep 26 15:54:24 2014 - User 'gm1'(#14) logged in with character 'moi'
Fri Sep 26 15:54:24 2014 - XPRate: 2 Map XP rate: 2 for map 20
Fri Sep 26 15:54:28 2014 - User 'gm1'(#14) assigned id #4321
Fri Sep 26 15:54:33 2014 - Data Saved for char 'moi'
Fri Sep 26 15:54:33 2014 - User Disconnected

Then when I play and buy items, I have this error WorldServer

Fri Sep 26 00:01:25 2014 - XPRate: 2 Map XP rate: 2 for map 22
Fri Sep 26 00:01:25 2014 - Could not execute query: Column count doesn't match value count at row 1
Fri Sep 26 00:01:25 2014 - Reconnecting to Mysql
Fri Sep 26 00:01:25 2014 - Data Saved for char 'moi'
Fri Sep 26 00:02:19 2014 - Buying /selling from NPC 1034. Buycount: 1, Sellcount: 0
Fri Sep 26 00:02:19 2014 - item count: 1
Fri Sep 26 00:02:19 2014 - Could not execute query: Column count doesn't match value count at row 1
Fri Sep 26 00:02:19 2014 - Reconnecting to Mysql
Fri Sep 26 00:02:25 2014 - XPRate: 2 Map XP rate: 2 for map 22
Fri Sep 26 00:02:48 2014 - Buying /selling from NPC 1034. Buycount: 4, Sellcount: 0
Fri Sep 26 00:02:48 2014 - item count: 1
Fri Sep 26 00:02:48 2014 - item count: 2
Fri Sep 26 00:02:48 2014 - item count: 3
Fri Sep 26 00:02:48 2014 - item count: 4
Fri Sep 26 00:02:48 2014 - Could not execute query: Column count doesn't match value count at row 1
Fri Sep 26 00:02:48 2014 - Reconnecting to Mysql
Fri Sep 26 00:02:54 2014 - XPRate: 2 Map XP rate: 2 for map 22
Fri Sep 26 00:02:54 2014 - XPRate: 2 Map XP rate: 2 for map 22
Fri Sep 26 00:02:55 2014 - XPRate: 2 Map XP rate: 2 for map 22
Fri Sep 26 00:02:56 2014 - XPRate: 2 Map XP rate: 2 for map 22

to be more precise, when I installed the database, table "runtime" was empty.

thank you for your future response
moimoi250
Little soul
Little soul
 
Posts: 7
Joined: Thu Sep 25, 2014 9:45 pm

Re: ktrose problems

Postby PurpleYouko on Fri Sep 26, 2014 3:54 pm

Are you using the correct database?
KTRose uses a completely different database than other osrose servers. Most of the tables are not compatible.

Unfortunately the console output doesn't tell us very much about the actual database queries that caused the problems.
Try looking in your server Binary/log folder
You will see a file called queries.txt

The last few entries in this file should relate to the ones that failed when you started your server.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: ktrose problems

Postby moimoi250 on Fri Sep 26, 2014 4:36 pm

I rebuilt everything from start

for database I took it : https://subversion.assembla.com/svn/ktrose-source/
and server, I took it : KT-Rose Updated 2013 : chrome://mega/content/secure.html#!8Fs0xZRa!YPyk7RyXP5GhYHDFesoEpER6Yo48CqF-rRyQMhSd0xQ

once installed, do I start the client,
first error :evil: :evil: :evil: :

Fri Sep 26 17:13:13 2014 - Connecting to MySQL
Fri Sep 26 17:13:13 2014 - MySQL Ping Timeout: 28740 seconds
Fri Sep 26 17:13:13 2014 - Connected to MySQL server
Fri Sep 26 17:13:13 2014 - Server started on port 29000 and is listening.
Fri Sep 26 17:15:47 2014 - User connected from 127.0.0.1
Fri Sep 26 17:15:47 2014 - User Login request received
Fri Sep 26 17:15:47 2014 - Could not execute query: Field 'lastlogin' doesn't have a default value
Fri Sep 26 17:15:47 2014 - Reconnecting to Mysql
Fri Sep 26 17:15:47 2014 - New Account created 'gm1'
Fri Sep 26 17:15:47 2014 - User disconnected
Fri Sep 26 17:16:14 2014 - User connected from 127.0.0.1
Fri Sep 26 17:16:14 2014 - User Login request received
Fri Sep 26 17:16:14 2014 - Could not execute query: Field 'lastlogin' doesn't have a default value
Fri Sep 26 17:16:14 2014 - Reconnecting to Mysql
Fri Sep 26 17:16:14 2014 - New Account created 'gm1'
Fri Sep 26 17:16:14 2014 - User disconnected

and the queries.txt:

Fri Sep 26 17:13:13 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:20 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:20 2014 - DELETE FROM channels WHERE id=1
Fri Sep 26 17:13:20 2014 - INSERT INTO channels (id,name,host,port,connected,maxconnections,owner) VALUES (1,'Server 1','127.0.0.1',29100,0,0,0)
Fri Sep 26 17:13:20 2014 - SELECT id,logo,back,name,cp,grade,slogan,news FROM list_clan
Fri Sep 26 17:13:24 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:24 2014 - SELECT exp_rate, drop_rate, zuly_rate, blue_chance, stat_chance, slot_chance, refine_chance, rare_refine, kill_on_fail, spawntype, player_damage, monster_damage, player_acc, monster_acc, pvp_acc, skill_damage, dropmultiple, attkmult, skillmult, dropdelay, basedroprate, ktpointrate, movespeedmod, maxlevel FROM list_config
Fri Sep 26 17:13:24 2014 - SELECT id,npc,ltbstring,questnpc,questltb FROM ltb
Fri Sep 26 17:13:25 2014 - SELECT * FROM new_drops
Fri Sep 26 17:13:25 2014 - SELECT id,itemtype,min,max,prob FROM list_skillbooks
Fri Sep 26 17:13:25 2014 - SELECT id, srcx, srcy, srcmap, destx, desty, destmap FROM list_telegates
Fri Sep 26 17:13:25 2014 - SELECT id,x,y,map,radius,type FROM list_respawnzones
Fri Sep 26 17:13:25 2014 - SELECT id, map, montype, min, max, respawntime, x, y, radius, spawntype, triggermontype, triggerammount, agressive, areatrigger, lim, spawnk, aip, refvar, refval FROM list_special_spawns
Fri Sep 26 17:13:25 2014 - SELECT type,map,dir,x,y,dialogid FROM list_npcs
Fri Sep 26 17:13:25 2014 - SELECT mapid,wpnum,mapx,mapy,wptype FROM list_waypoints
Fri Sep 26 17:13:25 2014 - UPDATE accounts set online=false
Fri Sep 26 17:13:25 2014 - DELETE FROM channels WHERE id=2
Fri Sep 26 17:13:25 2014 - INSERT INTO channels (id,name,host,port,connected,maxconnections,owner) VALUES (2,'Channel 1','127.0.0.1',29200,0,500,1)
Fri Sep 26 17:13:25 2014 - INSERT INTO runtime (starttime,hours) VALUES ('Fri Sep 26 17:13:25 2014 ',0)
Fri Sep 26 17:13:25 2014 - SELECT id FROM runtime
Fri Sep 26 17:15:47 2014 - SELECT id,password,accesslevel,online FROM accounts WHERE username='gm1'
Fri Sep 26 17:15:47 2014 - INSERT into accounts (username,password,accesslevel) values ('gm1','336c2a61cbcad892fbb473027da9d8ba',100)
Fri Sep 26 17:16:14 2014 - SELECT id,password,accesslevel,online FROM accounts WHERE username='gm1'
Fri Sep 26 17:16:14 2014 - INSERT into accounts (username,password,accesslevel) values ('gm1','336c2a61cbcad892fbb473027da9d8ba',100)
Fri Sep 26 17:22:50 2014 - SELECT thisrev FROM backupstorage WHERE owner=0
Fri Sep 26 17:22:50 2014 - INSERT INTO backupstorage (owner,itemid,itemtype,refine,durability,lifespan,count,stats,socketed,appraised,slot,trans_action,datestamp,thisrev) VALUES('0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|70|71|72|73|74|75|76|77|78|79|80|81|82|83|84|85|86|87|88|89|90|91|92|93|94|95|96|97|98|99|100|101|102|103|104|105|106|107|108|109|110|111|112|113|114|115|116|117|118|119|120|121|122|123|124|125|126|127|128|129|130|131|132|133|134|135|136|137|138|139|140|141|142|143|144|145|146|147|148|149|150|151|152|153|154|155|156|157|158|159|160','2','Fri Sep 26 17:22:50 2014 ','1')
Fri Sep 26 17:22:50 2014 - UPDATE accounts SET online=false where id=0

and account table is empty :roll:

what should I do????
moimoi250
Little soul
Little soul
 
Posts: 7
Joined: Thu Sep 25, 2014 9:45 pm

Re: ktrose problems

Postby PurpleYouko on Fri Sep 26, 2014 5:11 pm

OK I did some digging

The problem is not with the server.
It's with your MYSQL settings. Possibly you are running a newer version than was available when we first made the server.

This is caused by the STRICT_TRANS_TABLES SQL mode defined in the %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem.

Source

Another person posted this
When I had this same problem with mysql5.6.20 installed with Homebrew, I solved it by going into my.cnf
nano /usr/local/Cellar/mysql/5.6.20_1/my.cnf
Find the line that looks like so:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Comment above line out and restart mysql server
mysql.server restart
Error gone!


You could also work around it by actually adding a default value to the offending field in the DB table
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: ktrose problems

Postby moimoi250 on Fri Sep 26, 2014 5:47 pm

it's good,it's alive,alivvveeeeeeeee :D :D :D :D

I'm with the main task of mysql standard way ,the problem is corrected
may be that with all this gonna work :D :D

thank you so much you're the BOSSS.... :mrgreen: :mrgreen: :mrgreen: :mrgreen:

we'll see the next error in game..... :roll:
moimoi250
Little soul
Little soul
 
Posts: 7
Joined: Thu Sep 25, 2014 9:45 pm

Previous

Return to Support - OspRose Emulator

Who is online

Users browsing this forum: No registered users and 5 guests