Xampp

[Onizuka]

What does this mean and how can i fix this? Am trying to import .sql file database from tfs

Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;


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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1

 

[ExibeR]

Looks like the query doesn't match your database.

 

[Onizuka]

What about this one?

TEP 2

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't open SQLite database. Possible reasons:
C:/Users/Michael/Desktop/TibiaMap/Mystic Spirit/forgottenserver.s3db - file isn't valid SQLite database.
C:/Users/Michael/Desktop/TibiaMap/Mystic Spirit/forgottenserver.s3db - doesn't exist.

 

[Onizuka]

Soz for double post@

Am using a

xampp 1.6.8
And Tfs Mystic spirit 2.1

Anything wrong with that?


Thankss!!

 

[ExibeR]

Because you are running a MySQL database, and your config.lua is set to use SQLite

 

[Onizuka]

k thanks again

1 more, when i set up from sqlite to mysql i get this error then

STEP 2

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/Users/Michael/Desktop/TibiaMap/Mystic Spirit/config.lua .
3. MySQL user, password, database or host is wrong.

Also i did set the database and password as well

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "xxxxxxx"
mysqlDatabase = "xxxxxx"
mysqlPort = 3306

??:S

Thanks for helping me out mate! know am annoying lol ><

 

[ExibeR]

Yes, but you gotta change:

sqlType = "sqlite"

to

sqlType = "mysql"

 

[Onizuka]

yeh i did that, but i still get this error.. :S

1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/Users/Michael/Desktop/TibiaMap/Mystic Spirit/config.lua .
3. MySQL user, password, database or host is wrong.

 

[ExibeR]

So you have your server DB in MySQL DB with the correct name?
The user name, and password is corrent?
Do you have a htdocs file which prevents connection from "localhost"?

Try importing your schema.mysql again.
And import it in the DB this time, not your AAC...

 

[Onizuka]

thanks for quick answer ! anyways here's exactly what i do

1.The file is called Forgottenserver.sql and i import that then i get the error shown on top first page i posted

_______________________________

Some settings in config lua.:

-- SqLite
sqliteDatabase = "forgottenserver.s3db"

-- SQL
sqlType = "mysql"
passwordType = "plain"

______________________________________________

other:

-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "averise23"
mysqlDatabase = "RealMap842"
mysqlPort = 3306

____________________________________


I dont think i have any files that block connection

I've portforwarded 80/3306/7171

My firewall is disabled and such


I've tried re-importing database again

Forgottenserver.sql

And i keep getting same error


Yes user and password is correct

 

[ExibeR]

Did you delete your old database? And then create a new DB called RealMap842, and then import forgottenserver.sql
By the way, which distro are you using?

 

[Onizuka]

Tfs Mystic spirit 0.2.1.0 or in other words 2.1

Also when i was installing Xampp i forgot about this, am not sure it this can be the problem thought

Important ms vista note! because an activated visa user account control (UAC) on your system some functions of xampp are possibly restricted. With UAC pease avoid to install xampp to C:/program files ( because of not enough write permissions. or deactive UAC ( with msconfig ) after this Setup.

thanks! and Ill try that above ^ what you posted

 

[ExibeR]

Tfs Mystic spirit 0.2.1.0 or in other words 2.1

Also when i was installing Xampp i forgot about this, am not sure it this can be the problem thought



thanks! and Ill try that above ^ what you posted

Install Xampp in:
c:/
not
C:/Programfiles

That will solve the problem.

 

[Onizuka]

Well it didnt solve the problem ;/ but thanks for helping me out!


Any other suggestions that i could try?:S

Thanks!