Jump to content
  • 0

SQL Error When i put this armor For ct2.4


FDB

Question

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`30000	Black Vesper Noble  Heavy Breastplate		chest	true	heavy	7520	fine_steel	s' at line 2
[Err] INSERT INTO `armor` VALUES
`30000	Black Vesper Noble  Heavy Breastplate		chest	true	heavy	7520	fine_steel	s84	0	-1	-1	250	0	0	55840000	2680	true	true	true	true	true	0-0	0-0;
`30001	Black Vesper Noble Heavy Gaiters		legs	true	heavy	3170	fine_steel	s84	0	-1	-1	156	0	0	34900000	1675	true	true	true	true	true	0-0	0-0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

And armor Sql is:

 

INSERT INTO 'armor'
30000	Black Vesper Noble  Heavy Breastplate		chest	true	heavy	7520	fine_steel	s84	0	-1	-1	250	0	0	55840000	2680	true	true	true	true	true	0-0	0-0;
30001	Black Vesper Noble Heavy Gaiters		legs	true	heavy	3170	fine_steel	s84	0	-1	-1	156	0	0	34900000	1675	true	true	true	true	true	0-0	0-0;
30002	Black Vesper Noble Heavy Gauntlet		gloves	true	none	510	fine_steel	s84	0	-1	-1	68	0	0	13960000	670	true	true	true	true	true	0-0	0-0;
30003	Black Vesper Noble Heavy Boots		feet	true	none	1070	fine_steel	s84	0	-1	-1	68	0	0	13960000	670	true	true	true	true	true	0-0	0-0;
30004	Black Vesper Tunic		chest	true	magic	1750	cloth	s84	0	-1	-1	125	0	637	41880000	2010	true	true	true	true	true	0-0	0-0;
30005	Black Vesper Noble Tunic {PvP}		chest	false	magic	1750	cloth	s84	0	-1	-1	125	0	637	41880000	2010	false	false	true	false	true	0-0	0-0;
30006	Black Vesper Circlet Robe		head	true	none	530	cloth	s84	0	-1	-1	101	0	0	17500000	840	true	true	true	true	true	0-0	0-0;
30007	Black Vesper Stockings Robe		legs	true	magic	850	cloth	s84	0	-1	-1	78	0	415	26175000	1256	true	true	true	true	true	0-0	0-0;
30008	Black Vesper Gloves Robe		gloves	true	none	510	cloth	s84	0	-1	-1	68	0	0	13960000	670	true	true	true	true	true	0-0	0-0;
30009	Black Vesper Shoes Robe		feet	true	none	1070	cloth	s84	0	-1	-1	68	0	0	13960000	670	true	true	true	true	true	0-0	0-0;
30011	Black Vesper Noble Light Breastplate		chest	true	light	4140	wood	s84	0	-1	-1	187	0	0	41880000	2010	true	true	true	true	true	0-0	0-0;
30012	Black Vesper Noble Heavy Helmet		head	true	none	530	fine_steel	s84	0	-1	-1	101	0	0	17500000	840	true	true	true	true	true	0-0	0-0;
30013	Black Vesper Noble Light Leggings		legs	true	light	1320	wood	s84	0	-1	-1	117	0	0	26175000	1256	true	true	true	true	true	0-0	0-0;
30014	Black Vesper Noble Light Gloves		gloves	true	none	510	wood	s84	0	-1	-1	68	0	0	13960000	510	true	true	true	true	true	0-0	0-0;
30015	Black Vesper Noble Light Boots		feet	true	none	1070	wood	s84	0	-1	-1	68	0	0	13960000	510	true	true	true	true	true	0-0	0-0;
30016	Black Vesper Noble Light Helmet		head	true	none	530	wood	s84	0	-1	-1	101	0	0	17500000	840	true	true	true	true	true	0-0	0-0;

 

I need asap reply with fix

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

30000  Black Vesper  Noble Breastplate {PvP}      chest  false  heavy  7520  fine_steel  s84  0  -1  -1  250  0  0  55840000  2680  false  false  true  false  true  0-0  0-0;

30001  Black Vesper  Noble Heavy Gaiters      legs  true  heavy  3170  fine_steel  s84  0  -1  -1  156  0  0  34900000  1675  true  true  true  true  true  0-0  0-0;

30002  Black Vesper Noble Heavy Gauntlet      gloves  true  none  510  fine_steel  s84  0  -1  -1  68  0  0  13960000  670  true  true  true  true  true  0-0  0-0;

30003  Black Vesper Noble Heavy Boots      feet  true  none  1070  fine_steel  s84  0  -1  -1  68  0  0  13960000  670  true  true  true  true  true  0-0  0-0;

30004  Black Vesper Tunic      chest  true  magic  1750  cloth  s84  0  -1  -1  125  0  637  41880000  2010  true  true  true  true  true  0-0  0-0;

30005  Black Vesper Noble Tunic {PvP}      chest  false  magic  1750  cloth  s84  0  -1  -1  125  0  637  41880000  2010  false  false  true  false  true  0-0  0-0;

30006  Black Vesper Circlet Robe      head  true  none  530  cloth  s84  0  -1  -1  101  0  0  17500000  840  true  true  true  true  true  0-0  0-0;

30007  Black Vesper Stockings Robe      legs  true  magic  850  cloth  s84  0  -1  -1  78  0  415  26175000  1256  true  true  true  true  true  0-0  0-0;

30008  Black Vesper Gloves Robe      gloves  true  none  510  cloth  s84  0  -1  -1  68  0  0  13960000  670  true  true  true  true  true  0-0  0-0;

30009  Black Vesper Shoes Robe      feet  true  none  1070  cloth  s84  0  -1  -1  68  0  0  13960000  670  true  true  true  true  true  0-0  0-0;

30011  Black Vesper Noble Leather Breastplate {PvP}      chest  false  light  4140  wood  s84  0  -1  -1  187  0  0  41880000  2010  false  false  true  false  true  0-0  0-0;

30012  Black Vesper Noble Heavy Helmet      head  true  none  530  fine_steel  s84  0  -1  -1  101  0  0  17500000  840  true  true  true  true  true  0-0  0-0;

30013  Black Vesper Noble Light Leggings      legs  true  light  1320  wood  s84  0  -1  -1  117  0  0  26175000  1256  true  true  true  true  true  0-0  0-0;

30014  Black Vesper Noble Light Gloves      gloves  true  none  510  wood  s84  0  -1  -1  68  0  0  13960000  510  true  true  true  true  true  0-0  0-0;

30015  Black Vesper Noble Light Boots      feet  true  none  1070  wood  s84  0  -1  -1  68  0  0  13960000  510  true  true  true  true  true  0-0  0-0;

30016  Black Vesper Noble Light Helmet      head  true  none  530  wood  s84  0  -1  -1  101  0  0  17500000  840  true  true  true  true  true  0-0  0-0;

 

Check you and your xml there is some wrong parts "bad writting"..

P.s-info. You can't equip normal cloaks on Black Vesper armors.Cya ;)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Helly everyone . I use L2jmobius interlude , i did everything , installed the db compiled the Build in eclipse Gameserver seems to lead OK , but it fails to connect to loginserver When i click to start the loginserver it says  "Loginserver terminated abnormally" This is wheat gameserver shows me :    [05/10 17:25:12] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:12] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:17] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:17] LoginServerThread: LoginServer not available, trying to reconnect... [05/10 17:25:22] LoginServerThread: Connecting to login on 127.0.0.1:9014 [05/10 17:25:22] LoginServerThread: LoginServer not available, trying to reconnect...   And This is my login config file:   # --------------------------------------------------------------------------- # Login Server Settings # --------------------------------------------------------------------------- # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # --------------------------------------------------------------------------- # Networking # --------------------------------------------------------------------------- # Bind ip of the LoginServer, use 0.0.0.0 to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 0.0.0.0 LoginserverHostname = 0.0.0.0 # Default: 2106 LoginserverPort = 2106 # The address on which login will listen for GameServers, use * to bind on all available IPs # WARNING: <u><b><font color="red">Please don't change default IPs here if you don't know what are you doing!</font></b></u> # WARNING: <u><b><font color="red">External/Internal IPs are now inside "ipconfig.xml" file.</font></b></u> # Default: 127.0.0.1 LoginHostname = 127.0.0.1 # The port on which login will listen for GameServers # Default: 9014 LoginPort = 9014 # --------------------------------------------------------------------------- # Database # --------------------------------------------------------------------------- # Specify the JDBC driver class for your database. # Default: org.mariadb.jdbc.Driver Driver = org.mariadb.jdbc.Driver # Database URL # Default: jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true URL = jdbc:mariadb://localhost/l2jmobiusinterlude?useUnicode=true&characterEncoding=utf-8&useSSL=false&connectTimeout=10000&interactiveClient=true&sessionVariables=wait_timeout=600,interactive_timeout=600&autoReconnect=true # Database user info. Default is "root" but it's not recommended. Login = root # Database user password, leave empty for no password. Password = root # Maximum number of database connections to maintain in the pool. # Default: 5 MaximumDatabaseConnections = 5 # Determine whether database connections should be tested for availability. # Default: False TestDatabaseConnections = False # --------------------------------------------------------------------------- # Automatic Database Backup Settings # --------------------------------------------------------------------------- # Generate database backups when server restarts or shuts down.  BackupDatabase = False # Path to MySQL bin folder. Only necessary on Windows. MySqlBinLocation = C:/xampp/mysql/bin/ # Path where MySQL backups are stored. BackupPath = ../backup/ # Maximum number of days that backups will be kept. # Old files in backup folder will be deleted. # Set to 0 to disable. BackupDays = 30 # --------------------------------------------------------------------------- # Thread Configuration # --------------------------------------------------------------------------- # Defines the number of threads in the scheduled thread pool. # If set to -1, this will be determined by available processors divided by 2. ScheduledThreadPoolSize = 2 # Defines the number of threads in the instant thread pool. # If set to -1, this will be determined by available processors divided by 2. InstantThreadPoolSize = 2 # --------------------------------------------------------------------------- # Security # --------------------------------------------------------------------------- # How many times you can provide an invalid account/pass before the IP gets banned. # Default: 5 LoginTryBeforeBan = 5 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. # Default: 900 (15 minutes) LoginBlockAfterBan = 900 # If set to True any GameServer can register on your login's free slots # Default: True AcceptNewGameServer = True # Flood Protection. All values are in milliseconds. # Default: True EnableFloodProtection = True # Default: 15 FastConnectionLimit = 15 # Default: 700 NormalConnectionTime = 700 # Default: 350 FastConnectionTime = 350 # Default: 50 MaxConnectionPerIP = 50 # --------------------------------------------------------------------------- # Misc Login Settings # --------------------------------------------------------------------------- # If False, the license (after the login) will not be shown. # Default: True ShowLicence = True # Default: True AutoCreateAccounts = True # Datapack root directory. # Defaults to current directory from which the server is started. DatapackRoot = . # --------------------------------------------------------------------------- # Scheduled Login Restart # --------------------------------------------------------------------------- # Enable disable scheduled login restart. # Default: False LoginRestartSchedule = False # Time in hours. # Default: 24 LoginRestartTime = 24    
    • or at least to tell you an update that sorry but still not at home.. 10 days is suspisious.. but he is long time offline from discord indeed... maybe something happened?
    • I never had problems with him. Again, Im not sure if he scammed or not. But 10+ days without answering after we already paid, its a bit sus. If you know you wouldnt be able to answer for a few days, after receiving and confirming the amount, why dont keep in touch? or just say "hey, dont send now because I will only be available after day x.".  
    • i used to ask him for stuff etc, i dont think he scammed ... if he does i will be suprised...
  • Topics

×
×
  • Create New...