Jump to content

Question

Posted

Hi,

I have problems with the database installer.

 

Sofware installed:

 

OpenJDK Runtime Environment (IcedTea 2.5.4) (7u75-2.5.4-1~trusty1)

OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)

MySQL - 5.5.41-0ubuntu0.14.04.1

 

Eclipse 3.8

 

Server files:

http://svn.l2jdp.com/branches/L2J_DataPack_IT/

 

This is my log (after running the database_installer.sh):

 

updates parser results. Last run: Fri Mar 20 19:57:45 ART 2015
050912-[1033].sql
ERROR 1061 (42000) at line 1: Duplicate key name 'key_item_id'
051016-[1334].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'custom_type1'
051103-[1438].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'clan_privs'
051104-[1447].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'wantspeace'
051112-[1505].sql
no errors
051112-[1506].sql
no errors
051129-[1670].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'crest_id'
051205-[1768].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'class_index'
051205-[1769].sql
no errors
051208-[1876].sql
no errors
060215-[c4_1489].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'crest_large_id'
060215-[c4req_update].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'type'
11012007_3477.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'paid'
20060305-[1575].sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'onlinetime'
20060314-[1581].sql
no errors
20060412.sql
ERROR 1060 (42S21) at line 21: Duplicate column name 'heading'
20060424b.sql
no errors
20060424.sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'friend_id'
20060527-[2012].sql
ERROR 1060 (42S21) at line 4: Duplicate column name 'in_jail'
20060712-[2209].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'periodOfDay'
20060712-[dp1888].sql
no errors
20060712-[dp1896].sql
no errors
20060720-[2229].sql
no errors
20060920-[dp2090].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'power_grade'
20060925-[dp2103].sql
no errors
20061010-[dp2162].sql
no errors
20061015-[dp2197].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
20070501.sql
no errors
update05052006.sql
no errors
update05092006.sql
no errors
update05152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'class_index'
update06072007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'owner_exp_taken'
update06082007.sql
no errors
update06122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'mana_left'
update09122007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'death_penalty_level'
update10152006.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'nobless'
update12092007.sql
no errors
update17092007.sql
no errors
update17112007.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'buff_index'
update20060522.sql
no errors
update20060607.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'isin7sdungeon'
update20060614.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'absorb_level'
update20061118.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reputation_score'
update20061124.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'last_recom_date'
update20061126.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reuse_delay'
update20061204.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'fornoble'
update20061206.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'lvl_joined_academy'
update20061207.sql
no errors
update20061208.sql
no errors
update20061223.sql
no errors
update20061230.sql
ERROR 1060 (42S21) at line 3: Duplicate column name 'auction_bid_at'
update20070101.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'varka_ketra_ally'
update20070210.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'dropable'
update20070216.sql
ERROR 1091 (42000) at line 1: Can't DROP 'objId'; check that column/key exists
update20070221.sql
no errors
update20070223.sql
ERROR 1091 (42000) at line 1: Can't DROP 'respawn_delay'; check that column/key exists
update20070303.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'ally_penalty_expiry_time'
update20070503-[dp2978].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'count'
update20070503-[dp2980].sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'item_skill_id'
update20070511.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'expBeforeDeath'
update20070601.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'lastServer'
update20070929-[dp3399].sql
no errors
update20071203.sql
no errors
update25052007.sql
ERROR 1091 (42000) at line 1: Can't DROP 'inDebt'; check that column/key exists

 

 

 

I also had some problems with Java and Eclipse, I ended up downloading the data using "wget -m -np" and using those files (maybe that's a problem)

 

Can someone help?

 

Thanks.

 

9 answers to this question

Recommended Posts

  • 0
Posted

What L2J Datapack should I use? I want a try an Interlude server. First I would like to with a Free one just to know if i can make it work. After that I will look foward buying one. 

At 1st I kept getting the error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" And I was able to solve it by creating the database in the mysql console and granting privilegies to root. At first I tryed with LAMPP and I couldn't gre throught error "Access denied for user 'root'@'localhost' (using password: YES)"

 

So...all this problems are because of the server files I am using?

 

Thank you all

  • 0
Posted

Checkout via eclipse, there is a svn link.

Ok, I'll do that. Just for curiosity...what's the difference between checking out data via eclipe and downloading the files with wget?

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Posts

    • IMPORTANT INFO: In a few days, I will switch to completely new code, written from scratch with a new download system, patch building and management system. The Updater will become true 2026 code with "foolproof systems". I'm going to create a Discord server for customers to request new ideas and features. FIRST CUSTOMERS ARE ALREADY USING THE NEW UPDATER ON LIVE SERVERS! Watch this topic for upcoming info because the new updater is around the corner! Yes, you can still use self-update on the previous updater! No, the new updater won't be compatible with the old patch system! A new build is required, but players who already have game files won't have to download the entire patch again! New templates and updates to existing templates are coming soon! Sneak peek:  
    • i used guytis IL project and source. i found in his project there are 3 Client version source... 1,CliExt_H5   --->this one cant be compiled in VS2005,i did know why..is it for H5 client? 2,CliExtNew  --->this one is IL version ,but when i compiled it and use it.player cant login game,MD5Checksum wrong.i check the source code,but not found any hints. 3,L2Server    --->this one for HB client?im not sure...   so my question is what are the differences between these three versions of cliext.dll?how can i fix the issue of the MD5Checksum not matching problem?   01/29/2026 21:04:11.366, [CCliExt::HandleCheckSum] Invalid Checksum[1130415144] vs [-721420287] packet[dd] len[29] sum[2698] key[30] HWID[] Account[]! 01/29/2026 21:04:11.366, SocketLimiter::UserSocketBadunknownprotocol 11111111111 01/29/2026 21:04:11.366, [usersocket]unknown protocol from ip[113.137.149.115]!      
    • ## [1.4.1] - 2026-01-29   ### ✨ New Features - **Short Description**: Server owners can add a short tagline (up to 240 characters) on the server info page, under the "Online" status. It appears in the server list (By Votes) for VIP, Gold VIP, and Pinned servers so players see a brief summary at a glance.   ### 🔄 Improvements - **Server Info Page**: Description field is limited to 3000 characters with a character counter; the textarea is vertically resizable. A second **Save Changes** button was added at the bottom (after the description) for easier saving. - **Server Name**: In My Servers → Edit, the server name is read-only and can no longer be changed (avoids accidental changes and naming conflicts). - **Server Rows (By Votes)**: Short descriptions wrap correctly and no longer affect row height; long text is clipped to two lines so the list stays tidy and consistent.   ---
    • @Celestine  sorry for mu question , and post it's to old but i want to ask  ?   do you have uncrypted interface x dat of this interface? i want to add custom autofarm button but when i open it with xdat say file seems  to be  encrypted. thanks!
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..