Error in Mysql Server '-'

[gamaster]

well today we went to change the database in mssql for mysql, but when I put the script appeared a mysql error. This error is common?
The record also is not working and that problem on my site, if someone has a registry script to send?
Thanks.

Images:
Create Mysql Database:
http://www.picpanda.com/images/ctk88gqrli77zm5bo9y.png

Error after you have applied the script '-' :
http://www.picpanda.com/images/5d7nsdp2b19xdqug9wsq.png

Page of register:
http://www.picpanda.com/images/nrm5cki2e2tat8468ebe.png
Error In register '-' :
http://www.picpanda.com/images/b04zby70nrspgxw05j8a.png

can see that it appears that the server is online '-'
Thank await answers.

[MentaL]

[Romulan]

You use MSSQL syntax to create your database in your MySQL server.... That's why it's not working.

You should use the dbo dump from beastie release on the forum to create your database.

Aslo, i think your register script use MSSQL syntax too. That's why the mysql denied the request.

[gamaster]

thanks Romulan you are saved my life '-'

[Romulan]

Check the attachment. It's the dbo dump for mysql and the register script + status script fixed by me (the original is bugged).

Feel free to edit it

beastie-mysql.zip

[gamaster]

Thanks very much Romulan :D

---------- Post added at 09:47 PM ---------- Previous post was at 09:30 PM ----------

Error persists :/ :

Error

SQL query:

DELIMITER $$--
-- Процедуры
--
CREATE DEFINER = `root`@`localhost` PROCEDURE `acquireuserpasswd` ( IN name1 VARCHAR( 64 ) , out uid1 INTEGER, out passwd1 VARCHAR( 64 ) ) BEGIN DECLARE passwdtemp VARCHAR( 64 ) ;

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 'DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `acquireuserpasswd`(in' at line 1

[Romulan]

Delete your actual database and make a fully new one from the dump i gived to you.