• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

[Help Needed] Triggers

justin234

justin234

New Member
Joined
Jan 22, 2008
Messages
999
Reaction score
4
I get this Error, I dont know what to Add to Fix.
Do You Know?

Code: 
#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

Code: 
CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|
 
Last edited:
Sort by date Sort by votes
It looks like your phpmyadmin version is out of date.

Try to update it to the latest version.
 
Upvote 0 Downvote
Im still having this problem,
I even updated my PHPmyadmin.

I think the database is messed up.

EDIT:
When I re-installed Xampp 1.6.8
It had some warning about UAC with Vista.

How some features wouldnt work correctly...
and my "Apache" wont run now.

Whats The Deal?
 
Last edited:
Upvote 0 Downvote
How could it be my PHPMYADMIN?

I erased my 1.6.7 version from my comp completely.
Installed 1.6.8, even made a password for "Root"

Isnt that updated?
 
Upvote 0 Downvote
Upvote 0 Downvote
I Re-Installed Xampp,
Added the PHPMYADMIN files in the folder.

Error:

Code: 
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

NOW MYSQL WONT RUN!
IT AUTOMATICALLY STOPS!
WTF IS GOING ON THIS PISSES ME OFF!
 
Last edited:
Upvote 0 Downvote
Back
Top