char server asking for what table?

[Kiriesani]

Getting this error and I'm not entirely sure what it means. Been trying to get this set up for a while and pretty frustrated. What is this table and where do I get it and put it? Nothing in the guides I look at lists this table? Or am I missing something else? I have no idea how to fix this. Thanks for any help.

 

[Info]: Start checking DB integrity
[SQL]: DB error - Table 'ragnarok.skill' doesn't exist
[Debug]: at C:\Users\crims\Desktop\rathena-master test\src\char\char.cpp:2332 - SELECT 1 FROM `skill` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)
 

[leew995]

A skill table is missing.

You are advised to search for it in main.sql in the sql directory and run it once.

Or you could wipe out the database completely and run the full main.sql file.

[Emistry]

--
-- Table structure for table `skill`
--

CREATE TABLE IF NOT EXISTS `skill` (
  `char_id` int(11) unsigned NOT NULL default '0',
  `id` smallint(11) unsigned NOT NULL default '0',
  `lv` tinyint(4) unsigned NOT NULL default '0',
  `flag` TINYINT(1) UNSIGNED NOT NULL default 0,
  PRIMARY KEY  (`char_id`,`id`)
) ENGINE=MyISAM;

you should check why its missing from your database or some failed queries execution.

[DevilingKing]

[SQL]: DB error - Table 'ragnarok.pet' doesn't exist
[Debug]: at char.cpp:2322 - SELECT 1 FROM `pet` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

can help?

[hendra814]

11 minutes ago, DevilingKing said:

[SQL]: DB error - Table 'ragnarok.pet' doesn't exist
[Debug]: at char.cpp:2322 - SELECT 1 FROM `pet` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

can help?

go to Rathena\sql-files folder, import mail.sql file

[DevilingKing]

can help me abot this?
Centos 7

[DevilingKing]

On 9/8/2023 at 2:23 PM, hendra814 said:

go to Rathena\sql-files folder, import mail.sql file

i have upload but still have erros

[hendra814]

1 minute ago, DevilingKing said:

i have upload but still have erros

are the error still same as your post?

[DevilingKing]

3 minutes ago, hendra814 said:

are the error still same as your post?

ya still same erro.. i have add you in Discord

[hendra814]

5 minutes ago, DevilingKing said:

ya still same erro.. i have add you in Discord

Sorry i can't login my discord right now, try run this sql script

 

main.sql

[DevilingKing]

1 minute ago, hendra814 said:

Sorry i can't login my discord right now, try run this sql script

 

main.sql 40 kB · 0 downloads

[hendra814]

can you try delete your database and create new one and import the file