Error In Sql Syntax

[Lotion Lars]

#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


I got this msg when i uploaded my database to my localhost site,
anyone jnows how to fix this?

Lotion

 

[Bam]

What version of TFS are you using?

 

[Lotion Lars]

What version of TFS are you using?

im using version 0.2.2.0

 

[Bam]

Oh I really don't have any knowledge of 0.2 .. But try looking in ur database after the ondelete_accounts and make sure everything looks right.

 

[Lotion Lars]

Oh I really don't have any knowledge of 0.2 .. But try looking in ur database after the ondelete_accounts and make sure everything looks right.

I have been looking at it for houers, but cantfiggure it out

this is what that segment looks like:
DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|
Can you tell whats wrong?
you're help is apreciated, thanks.
Lotion

 

[Bam]

Is that really taken from the database? Cause that doesnt look like a valid table to me.

 

[Lotion Lars]

Is that really taken from the database? Cause that doesnt look like a valid table to me.

It is taken from my database, and it has left me clueless:S

 

[Bam]

It's weird that you got commands in ur accounts table..

Or, it is in ur accounts table right?

 

[Migxxx]

Is that really taken from the database? Cause that doesnt look like a valid table to me.

Because it isn't a table is a trigger had to be a damn rep seeker answering without the minimal knowladge

@Thread update your phpmyadmin and if the problem persist update your mysql....

 

[Bam]

Atleast I was trying since nobody else does, go flame someone else asshole.

 

[dragoon]

Man, I have a Error #1064 also but its dif from that but i cant find crap out to fix it