Help Mysql

[den4is]

Hello there..
Anyone know what the hell this is

MySQL ERROR mysql_real_query: SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 515 ORDER BY `sid` DESC Table '.\armonia\player_depotitems' is marked as crashed and should be repaired

data/movements/scripts/tp spawn.lua:onStepIn

> MySQL ERROR mysql_real_query: SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 515 ORDER BY `sid` DESC Table '.\armonia\player_depotitems' is marked as crashed and should be repaired

Those errors
Please help quickly, REP ++
!ySQL ERROR mysql_real_query: DELETE FROM `player_depotitems` WHERE `player_id` = 719 Table '.\armonia\player_depotitems' is marked as crashed and should be repaired

 

[Specjalist]

try executing command:

REPAIR TABLE player_depotitems;

then:

CHECK TABLE player_depotitems;

and post results

 

[den4is]

Where to write that.. Please tell me more exactly.

I going to : localhost/phpmyadmin log in and then going to

Player_deposititem
and what then?

Table player_depotitems has been flushed ( Query took 0.0006 sec )
FLUSH TABLE `player_depotitems`


Your SQL query has been executed successfully
FLUSH TABLE `player_depotitems`
..
i PRESSed something flush the table

 

[Specjalist]

so, you deleted player_depotitems?

when you are logged into your database (using phpmyadmin) there is an icon SQL (above database name, under PHPMYADMIN logo), press it and then paste those codes... unless your player_depotitems dissapeared

 

[den4is]

Can you do it for me or help me thoug msn or teamviewer?
Please..

 

[den4is]

add : [email protected]
plaease help

 

[den4is]

BUMP, I Need help fast!

 

[Nikkster]

The error tells you to repair it, so go to your phpmyadmin and then to the player_depotitems. Repair the table manually,

or

Go to SQL and paste the SQL code that another user posted here. Then press "Go".

However, if you have deleted that table and don't have any important characters/accounts in your database you just need to re-import your database and the case will be fixed.

If I am not wrong, you can also import your database again, the table that is removed will be there again (after the import) and nothing else will be done, because it will only tell you alot of errors like "Dublicate" and so on ~~

 

[Tropix]

nikkster u are sexy back

 

[Bintzer]

The error tells you to repair it, so go to your phpmyadmin and then to the player_depotitems. Repair the table manually,

or

Go to SQL and paste the SQL code that another user posted here. Then press "Go".

However, if you have deleted that table and don't have any important characters/accounts in your database you just need to re-import your database and the case will be fixed.

If I am not wrong, you can also import your database again, the table that is removed will be there again (after the import) and nothing else will be done, because it will only tell you alot of errors like "Dublicate" and so on ~~

Actually it will drop all his tables and add them again.

To get it to do that (what Nikkster said) delete these lines out of your schema.mysql before you import it again:

DROP TRIGGER IF EXISTS `oncreate_players`;
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DROP TRIGGER IF EXISTS `ondelete_players`;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
DROP TRIGGER IF EXISTS `ondelete_accounts`;

DROP TABLE IF EXISTS `player_depotitems`;
DROP TABLE IF EXISTS `tile_items`;
DROP TABLE IF EXISTS `tiles`;
DROP TABLE IF EXISTS `bans`;
DROP TABLE IF EXISTS `house_lists`;
DROP TABLE IF EXISTS `houses`;
DROP TABLE IF EXISTS `player_items`;
DROP TABLE IF EXISTS `player_skills`;
DROP TABLE IF EXISTS `player_storage`;
DROP TABLE IF EXISTS `player_viplist`;
DROP TABLE IF EXISTS `player_spells`;
DROP TABLE IF EXISTS `player_deaths`;
DROP TABLE IF EXISTS `guild_ranks`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `guild_invites`;
DROP TABLE IF EXISTS `global_storage`;
DROP TABLE IF EXISTS `players`;
DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `groups`;
DROP TABLE IF EXISTS `server_record`;
DROP TABLE IF EXISTS `server_motd`;
DROP TABLE IF EXISTS `server_reports`;
DROP TABLE IF EXISTS `server_config`;

 

[den4is]

How to repair it :O ?
Btw: Its solwed

now i got
- Table '.\armonia\player_items' is marked as crashed and should be repaired
ALTER TABLE `player_items` ENGINE = MYISAM