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

    • I didn't use AI for this, I used untitledui, they have ready templates and blocks. And no, it's not shadcn, untitledui has their own design system.   For example, for the hero I used an iteration of this https://www.untitledui.com/react/marketing/hero-header-sections/hero-abstract-angles-04
    • A misaligned badge or a heavy shadow is not evidence of AI. If anything, small inconsistencies are usually proof of years of manual modifications layered over an old codebase. AI-generated UIs tend to be overly clean, symmetrical, and generic because models optimize for visual patterns, not long-term product evolution. What you’re calling “AI design” is actually a very common style in older gaming communities: strong gradients, metallic buttons, glow effects, dense information blocks, and high visual emphasis on rankings/votes/sponsors.    Also, good UI is contextual. A toplist platform for MMORPG servers is optimized differently than a modern SaaS dashboard or a portfolio site. Here, visibility, CTR, sponsor highlighting, fast scanning, and information density matter more than minimalist whitespace trends from Dribbble. And honestly, if the UI was actually generated by AI, it probably would’ve looked more modern and generic — not like a platform that clearly evolved piece by piece over many years 😄   The funny thing is that a lot of these new “AI web designers” can’t even write 20 lines of CSS by hand without ChatGPT holding their hand 😄    They see a shadow, a gradient, or a rounded border and instantly scream “AI-generated” because their entire understanding of design now comes from prompting tools instead of actually building interfaces from scratch. And honestly, @Elfo was right — your own website looks far more AI-generated you built it with Tailwind/shadcn-style aesthetics and probably Next.js ,m i right friend? you built it with Tailwind/shadcn-style aesthetics...  You literally scanned the entire site just to find a tiny shadow behind a button as “proof” 😂 Real developers know the difference between a handcrafted project that evolved over many years, and a generic AI-generated template pumped out in 30 seconds.       Anyway, no hard feelings. Different tastes, different opinions 🙂
    • If it is AI-generated, you used a really shit model. Even AI wouldn't be able to generate obvious errors like the badge misalignment.   I do find it funny, however, that out of everyone to accuse you, Splicho, who used AI to fully generate this https://nimeracp.com/, is the one to talk.
    • You’re free to dislike the design, that’s subjective and totally fine. But calling everything you personally don’t like “AI generated” is not really an argument 😄 The funny part is that the layout constraints you’re criticizing are actually intentional design decisions for toplist platforms — ads, rankings, visibility blocks, sponsor placements, and high information density. This isn’t a portfolio landing page or a SaaS dashboard where you can leave half the screen empty for aesthetics. Also, AI-generated UIs usually look generic, over-animated, inconsistent, and impractical for real long-term usage. Our platform has been evolving for years based on actual user behavior, server owner needs, CTR optimization, and functionality requirements. You may not like the visual style, and that’s okay. But confusing “I don’t like this design” with “this was made by AI” just shows you’re judging emotionally instead of technically. Anyway, appreciate the feedback. Good luck to you too 🙂
  • 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..