Compiling 0.2.5 under Ubuntu

[Black Reaper]

Hello and thanks in advance for reading the thread. I am having several issues while trying to compile 0.2.5. To begin with, just to make sure I'm not mistaken there is no autogen.sh and so forth so to compile the only necessary step is 'make'?

Asuming that above is correct I get the following error when trying to compile that way:

/usr/bin/ld: cannot find -llua5.1-sql-sqlite
collect2: ld returned 1 exit status
make: *** [forgottenserver] Error 1

I've already installed all the packets from Elf's compiling tutorial, and I have tried to update and un/reinstall it. So neither of those are the problem and please do not direct me to his thread.

I found a thread with someone that had a similar problem to mine, but it seems the links posted there is no longer useful. http://otland.net/68772-post4.html

If anyone has a solution to this any help is appreciated.

 

[Migxxx]

if your going to use mysql, then compile it without sqlite just remove it from the makefile, i had the same problem and for make it simple i just removed the sqlite since i was going to use mysql and it worked like charm

 

[DedicatedOT]

sudo apt-get install liblua5.1-sql-mysql-dev liblua5.1-sql-mysql-2

 

[Black Reaper]

Was planning to use sqlite >.<, but if nothing works out I guess I'll have to settle with mysql for now.

@Dedicated.

liblua5.1-sql-mysql-dev is already the newest version.
E: Couldn't find package liblua5.1-sql-mysql

 

[DedicatedOT]

sudo apt-get install liblua5.1-sql-sqlite3-dev

SQLLite is the best.

 

[Black Reaper]

liblua5.1-sql-sqlite3-dev is already the newest version.

I'm fairly certain that I have already installed all the necessary libraries/packages.

 

[Black Reaper]

Bump.

 

[Mark]

Edit Makefile and change:
-llua5.1-sql-sqlite
to:
-llua5.1-sql-sqlite3

 

[Stenks]

It worked here, but there is no schema.mysql ...

 

[Black Reaper]

Everything compiled fine but characters aren't saving on logout, getting these kind of errors.

SQLITE ERROR sqlite_exec: UPDATE `players` SET `level` = 270, `group_id` = 1, `vocation` = 2, `health` = 1495, `healthmax` = 1495, `experience` = 324013275, `lookbody` = 39, `lookfeet` = 58, `lookhead` = 20, `looklegs` = 39, `looktype` = 328, `lookaddons` = 0, `maglevel` = 59, `mana` = 7895, `manamax` = 7895, `manaspent` = 94540, `soul` = 100, `town_id` = 1, `posx` = 1007, `posy` = 1034, `posz` = 7, `cap` = 3055, `sex` = 1, `lastlogin` = 1249421170, `lastip` = 16777343, `conditions` = x'', `redskulltime` = 0, `redskull` = 0, `lastlogout` = 0, `blessings` = 0, `guildnick` = '', `rank_id` = 0 WHERE `id` = 4 LIMIT 1; near "LIMIT": syntax error

 

[Black Reaper]

Bump.