Jump to content
  • 0

A tables missing from main sql server


Question

Posted

I got this notification when trying to run the server:
 

[Info]: Start checking DB integrity

: DB error - Incorrect table name ''
[Debug]: at char.cpp:2281 - SELECT 1 FROM `` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

Char-Server has terminated abnormally.
Restarting in 15 seconds, press Ctrl+C to cancel.

ShowInfo("Start checking DB integrity\n");
	for (i=0; i<ARRAYLENGTH(sqltable); i++){ //check if they all exist and we can acces them in sql-server
		if( SQL_ERROR == Sql_Query(sql_handle, "SELECT 1 FROM `%s` LIMIT 1;", sqltable[i]) ){
			Sql_ShowDebug(sql_handle);
			return false;
		}
	}

I dont know what's wrong with the line 2281, please help me to fix this error

2 answers to this question

Recommended Posts

  • 0
Posted

This line of code checks the following tables

		schema_config.char_db, schema_config.hotkey_db, schema_config.scdata_db, schema_config.cart_db, 
                schema_config.inventory_db, schema_config.charlog_db,
                schema_config.char_reg_str_table, schema_config.char_reg_num_table, schema_config.acc_reg_str_table,
                schema_config.acc_reg_num_table, schema_config.skill_db, schema_config.interlog_db, schema_config.memo_db,
		schema_config.guild_db, schema_config.guild_alliance_db, schema_config.guild_castle_db, 
                schema_config.guild_expulsion_db, schema_config.guild_member_db, 
                schema_config.guild_skill_db, schema_config.guild_position_db, schema_config.guild_storage_db,
		schema_config.party_db, schema_config.pet_db, schema_config.friend_db, schema_config.mail_db, 
                schema_config.auction_db, schema_config.quest_db, schema_config.homunculus_db, schema_config.skill_homunculus_db,
                schema_config.mercenary_db, schema_config.mercenary_owner_db,
		schema_config.elemental_db, schema_config.ragsrvinfo_db, schema_config.skillcooldown_db, schema_config.bonus_script_db,
		schema_config.clan_table, schema_config.clan_alliance_table, schema_config.mail_attachment_db, schema_config.achievement_table

so its either you have corrupted main.sql in which case you should try to redownload the whole server since there might be some files which are corrupted too.

or you haven't properly added the main.sql in your sql database

  • Like 1
  • 0
Posted
2 hours ago, randell1993 said:

so its either you have corrupted main.sql in which case you should try to redownload the whole server since there might be some files which are corrupted too.

or you haven't properly added the main.sql in your sql database

thank you very much for you help sir 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...