Trunk problems

[Kayan]

Hello i am using rev 669 from tags... without problems

i have compiled trunk for test. Have compiled without errors. i open server e go login e received this msg

mysql_store_result(): SELECT `id`, `password`, `type`, `premdays`, `lastday`, `k
ey`, `warnings` FROM accounts WHERE id = : MYSQL ERROR: You have an error in you
r SQL syntax; check the manual that corresponds to your MySQL server version for
 the right syntax to use near '' at line 1

My db no are corrupted i have used repair tables, and with rev 669 from tags i no have this problem in login..

Somebody can help me =\

 

[Mark]

trunk is not stable yet so it's not good for serious use, I'll look into that issue.

EDIT: I can't really see what would cause that, I've tried trunk with MySQL and it worked great.

 

[Kayan]

i have create new database, and have the problem angain =\ i go install last version of xampp to test

 

[Kayan]

#UP

anybody have this problem?

for me only at rev 669 work ,after all rev have this mysql error

 

[Lithium]

#up
im not have problems to login and i use latest rev of trunk

 

[Kayan]

grr..

but why at rev 669 it's work ;s

can you upload last trunk rev for me test ;~~

 

[Lithium]

Here the latest rev of trunk \/

 

[Kayan]

lol.... compiled for you it's work o shit my pc problem lol?

post please parameters, linkers you used

 

[Lithium]

linkers:
-lboost_system
-lgmp
-lluasql-mysql
-lluasql-sqlite3
-llua5.1
-lmysql
-lregex
-lsqlite3
-lwsock32
-lxml2
-lmysql
-lws2_32
-s
-Wl,-Map=forgottenserver.map

Compiler c++:
-D__USE_MYSQL__
-D__USE_SQLITE__
-D__EXCEPTION_TRACER__

 

[Kayan]

OK Thx, i have noticed this problem for me is only in CONSOLE, version GUI work

without problems

 

[Lithium]

ok i go try console here too for see if this happens

Edit: here works fine with console too

 

[ntmr]

May be he isn't using the correct parameters or rebuilding all.

 

[kofel]

For me trunk version working perfect, i no have any MySQL errors, and uptime is 23h because i must reboot computer , use console version.

 

[Kayan]

i have download all sources again, dev cpp and used parameters e linkers of lithium e now work Thx

 

[Lithium]

@kofel
oh nice you use latest rev? if you find bugs please post ^^

 

[tatu hunter]

@Lithium
I dunno why but I cant run the server, I downloaded the lastest source and compiled it, but when I open the server the window just closes, but when I try to open the server in another folder whitout .dlls the server open and give error dll missing.

I downloaded your TFS.exe compiled and I've the same problem...

Is needed a new dll or something?

-edit-
what are the params and linkers in your .dev?

thx;

 

[kofel]

Yes Lithium, i use latest revision and i can't find any bugs
Parameters:
-D__CONSOLE__
-D__USE_MYSQL__
-D__USE_SQLITE__
Linkers:
-O1
-lboost_system
-lgmp
-lluasql-mysql
-lluasql-sqlite3
-llua5.1
-lmysql
-lregex
-lsqlite3
-lwsock32
-lxml2
-lmysql
-lws2_32
-s

I used dll's pack 1.2 posted by Talaturen

 

[ntmr]

I'm compiling with these parameters and it's working.

C++ compiler:

-D__USE_MYSQL__
-D__USE_SQLITE__

Linker:

-O1
-lboost_system
-lgmp
-lluasql-mysql
-lluasql-sqlite3
-llua5.1
-lmysql
-lregex
-lsqlite3
-lwsock32
-lxml2
-lmysql
-lws2_32
-s

And don't forget to remove databasepgsql.* and databaseodbc.* from the project.

 

[Lithium]

@tatu hunter
you use linux? if you use linux you need make lastMotd.txt file, and if you use windows is good make too could be this who make not open

#Edit
i uploaded lastMotd.txt in latest commit rev 683 for fix this

 

[tatu hunter]

@up
Yes, I always used lastMotd.txt and playersRecord.txt...
and I'm using windows and linux heheh, but the problem was in the windows...

I downloaded your tfs.exe and it was with 3mb more!
I made new .dev file and added all linkers and params, now its working correctly! and it have 2,81mb...

ahh and Thx for your reply!