Solved SQL Error

[tae]

Im having trouble with SQL. ive read all the tutorials and did exactly what it said but i keep getting an error could anyone help me i also tried SQLite

Error

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL said: Documentation
#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

 

[Xenios]

Are you using the lastest phpmyadmin?

 

[tae]

idk i guess i downloaded from a tutorial off another forum :x

 

[Jester]

Download Xampp again from the official site.

 

[tae]

now it says

 Forbidden

You don't have permission to access /xampp on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

 

[ntmr]

Try http://127.0.0.1/xampp

 

[tae]

it still says the same thing as i but in last post :< i really wanna use SQL :'/

 

[Snel pUppie]

I would recommend wamp server in front of xamp server.

 

[Mark]

phpMyAdmin under version 2.11 doesn't support triggers. You can download the latest phpMyAdmin version at http://phpmyadmin.net.

 

[tae]

mm i got 2 problems now where do i put the new phpmyadmin? and why wont MySQL start?

 

[JayBeee]

1. paste it in your \xampp\phpmyadmin folder 2. I've got no idea, I've got the same problem, and I can't seem to get it running, in any other way that using the mysql_start and mysql_stop in my xampp folder.

 

[tae]

ok im using sqlite and i made a gm but i cant do any commands any help?

 

[JayBeee]

Are you sure that you made the GM by changing both Account type to "5" and player group to "2"?

 

[tae]

:O didnt know i was supose to do that :x fixing now

 

[JayBeee]

Tell me if it's working.

 

[Fikko]

Dude Nicaw explain how use the forgotten server with his account page lok at this video in his page: http://nicaw.net/index.php?pg=aac.php&aac=help.htm

If you don't trust in the link go to nicaw.net then click on help, and see the video and follow the steps.. thats the best guide of ever

 

[tae]

@up it didnt work but is ther an acc site for SQLite
and @empty yea it did work