Hi Uwe,
No success here. Created a new installation with a new database and a new user. Ran the setup and created the database tables. I wondered why it said the database version is 3.3.0 when installing 3.3.11, i meant the database version should be 3.3.7.
After a login test i deleted all the files and copied the 3.4.0 source in there, created the ENABLE_INSTALL_TOOL file and went through the setup again. Paths where OK, but the SQL statement was again not fine.
btw: i used the built in installation for both installations, i'm going to purge the database now and try to run the SQL files.
Daniel
Even if i run the SQL file first and try to update then i stuck at the error with the SQL syntax.
Hi Uwe,
My SQL client creates an error when running this query:
I needed to change the last line to the following:
Then the stored procedure is created without any error. As far as i understood from the manuals the last command is just to set back the Delimiter from $$ to ;
Daniel
No success here. Created a new installation with a new database and a new user. Ran the setup and created the database tables. I wondered why it said the database version is 3.3.0 when installing 3.3.11, i meant the database version should be 3.3.7.
After a login test i deleted all the files and copied the 3.4.0 source in there, created the ENABLE_INSTALL_TOOL file and went through the setup again. Paths where OK, but the SQL statement was again not fine.
btw: i used the built in installation for both installations, i'm going to purge the database now and try to run the SQL files.
PHP Code:
UPDATE tblVersion set major=3, minor=4, subminor=0
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 $$ DROP PROCEDURE IF EXISTS DROPFK $$ CREATE PROCEDURE DROPFK ( IN pa' at line 1
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 'END IF' at line 1
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 'END $$ DELIMITER' at line 1
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 '$$ ALTER TABLE tblACLs ENGINE=InnoDB' at line 1
PROCEDURE letonew.DROPFK does not exist
Can't create table 'letonew.#sql-1b3f_227' (errno: 121)
PROCEDURE letonew.DROPFK does not exist
Can't create table 'letonew.#sql-1b3f_227' (errno: 121)
PROCEDURE letonew.DROPFK does not exist
Can't create table 'letonew.#sql-1b3f_227' (errno: 121)
PROCEDURE letonew.DROPFK does not exist
PROCEDURE letonew.DROPFK does not exist
Can't create table 'letonew.#sql-1b3f_227' (errno: 121)
PROCEDURE letonew.DROPFK does not exist
Can't create table 'letonew.#sql-1b3f_227' (errno: 121)
Daniel
Even if i run the SQL file first and try to update then i stuck at the error with the SQL syntax.
Hi Uwe,
My SQL client creates an error when running this query:
PHP Code:
DELIMITER $$
DROP PROCEDURE IF EXISTS DROPFK $$
CREATE PROCEDURE DROPFK (
IN parm_table_name VARCHAR(100),
IN parm_key_name VARCHAR(100)
)
BEGIN
IF EXISTS (SELECT NULL FROM information_schema.TABLE_CONSTRAINTS
WHERE CONSTRAINT_SCHEMA = DATABASE() AND CONSTRAINT_NAME = parm_key_name) THEN
ALTER TABLE parm_table_name DROP FOREIGN KEY parm_key_name;
END IF;
END $$
DELIMITER ; $$
I needed to change the last line to the following:
PHP Code:
DELIMITER ;
Then the stored procedure is created without any error. As far as i understood from the manuals the last command is just to set back the Delimiter from $$ to ;
Daniel