Jump to content

  •  

firstookami

Member Since 21 Jul 2014
Offline Last Active Aug 04 2014 09:29 AM
-----

Posts I've Made

In Topic: no sql items available

29 July 2014 - 07:16 AM

Hello,

 

that last error is gone : i have manually delete the row on the table interreg with mysql workbench and also manually update it :

 

INSERT INTO `interreg` (`varname`, `value`) VALUES
('unique_id', '0');

 

then all is fine now.

 

I have also find some people fix that kind of error when they rebuild the table with these parameters :

 

CREATE TABLE IF NOT EXISTS `interreg` (
`varname` varchar(11) NOT NULL,
`value` varchar(20) NOT NULL,
PRIMARY KEY (`varname`)
) ENGINE=MyISAM;
INSERT INTO `interreg` (`varname`, `value`) VALUES
('unique_id', '0');

 

Was not necessary in my case.

 

 

I don't have so much time this week but i will try to rebuild new server and see if i can fix some part of the "position laag" issue. (on server side)

 

 

o/


In Topic: no sql items available

25 July 2014 - 04:24 PM

huuuum ... but i already got a line with these values on this table ...

In Topic: no sql items available

25 July 2014 - 01:04 AM

I have made 3 other servers tonight :s

 

2 hercules servers with different sources/setup (2 clean setup with separate folders and databases)

 

1 mix hercules/rathena (one big epic fail, database looks really good but i was not able to run the server)

 

Finally i have keep my old hercules database from the first 2 new try , and i have run my first hercules server (from yesterday) : it's works ! (just that error on map server : "itemdb_uid_load: Unable to fetch unique_id data" , but don't seem important).

 

I don't really understand why, but i will not complain ^^

 

Thank you again for your time Dastgir, i will try again and again (but less faster) to made one hercules server without any error, i will keep you inform.


In Topic: no sql items available

24 July 2014 - 08:28 AM

In fact, when i setup 'yes' instead of 'no' on inter-server.conf at 'use_sql_item_db:' line, there i got error message and i'm not able to got any item on game.

When i setup no (mean i use txt instead of sql) i got 0 error on server and my SQL database is working well (my inventory table is updated when i loot in game).

Anyway, it's probably map-server conf, maybe char-server conf mistake as you supposed.

So thanks for the track, i will reload clean conf and setup it again tonight.

I will also keep you informed.