View Single Post
Old 11-06-2007, 02:28 PM  
razoor
Senior Member
 
Join Date: Oct 2006
Posts: 163
Default

When i try to make the tables i get these error.
Beats me what it means.
But if i use the "old" sql file from 2.0 then it works, but then version 3 isnt working at all and i get some errors when i add users/groups

And im a totally newbie when it comes to mysql. =)
MySQL Version 5.0.45

Code:
Warning: Do not know how to handle this statement at line 6:
CREATE PROCEDURE io_user_lock(IN pName VARCHAR(65), IN pExpire INT, IN pTimeout INT, IN pOwner VARCHAR(36))
BEGIN
proc:BEGIN
  DECLARE elapsed FLOAT UNSIGNED DEFAULT 0;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 10:
DECLARE sleep   FLOAT UNSIGNED DEFAULT 0.2;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 12:
WHILE elapsed < pTimeout DO
    UPDATE io_user SET lockowner=pOwner, locktime=UNIX_TIMESTAMP()
      WHERE name=pName AND (lockowner IS NULL OR (UNIX_TIMESTAMP() - locktime) > pExpire);
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 16:
IF ROW_COUNT() > 0 THEN
      LEAVE proc;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Warning: Do not know how to handle this statement at line 18:
END IF;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
razoor is offline   Reply With Quote