Database

[Rhumor]

Hey when I created a database in phpmyadmin, called TFS.
I press import and select theforgottenserver.sql and go.
But then It gives an error:


Error
SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL said:

#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 'IF EXISTS `oncreate_players`' at line 1

 

[Antrhaxcs]

... Download the lastest phpmyadmin....

 

[Rhumor]

!Bump~help please
that second part of the tutorial I readed about that - u root etc wont work for me with xampp

I have the latest xampp so probably the latest phpmyadmin

Edit: I updated it but it gives me error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I setup a config, and set my password and port socket etc.. still this error after I saved

 

[John3971]

i also have that problem i have apache2triad and version
"2.7.0-pl2" i don´t now how i should update myphpadmin to the newest so can someone help me?

 

[Mark]

Download v2.11 from http://phpmyadmin.net.

 

[John3971]

Download v2.11 from http://phpmyadmin.net.

yes i understand that but do i only overwrite the old files in phpmyadmin folder and then its done?

 

[Mark]

It should be, if there's any error just tell me and I'll give you the solution.

 

[John3971]

ok. Thanks

EDIT:
Its working now but i had to remove this to get everything in the database.

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 `guild_ranks`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `guild_invites`;
DROP TABLE IF EXISTS `players`;
DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `groups`;

i get this messages in index of phpmyadmin, were and what should i changes?

 

[Rhumor]

I updated pma but still gives THIS error:

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL said:

#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 'IF EXISTS `oncreate_players`' at line 1

 

[Jonern]

If the database got no tables from before, you can remove the part John3971 have in his post.

 

[Rhumor]

Well I deleted oncreate_players, then it says guilds and then I delete guilds and then next etc..

 

[akaah]

Hi. I Solucioned My Problem..


I Download Last Version Of Phpmyadmin



Thx All