When I try to import the db_triggers.sql I receive the following error, see below. I hesitate to modify the db_triggers.sql file without knowing if the changes will cause more problems. Does anyone have some insight on this problem? Thank you for any help.
Error
SQL query:
DELIMITER $$-- Error messages for mysql
DELETE FROM error$$ INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to change time sheet status.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to delete time sheet unless status is edit.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to delete time sheet that has items.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet is not editable(2).\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet's rate is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not editable: user not a project member.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Invalid date.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Invalid time duration.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not deletable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task has pending tasks.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Must use: call change_task_status(taskID,status)\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task cannot be pending itself.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task belongs to wrong project.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Absence must have a start and end date.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time not recorded. Task has been closed for too long.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Parent task loops not permitted.\n\n"
)$$-- if (NOT something) doesn't work for NULLs
DROP FUNCTION IF EXISTS empty $$ CREATE FUNCTION empty(
str TEXT
) RETURNS BOOLEANDETERMINISTIC BEGIN RETURN str = '' OR str IS NULL ;
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 $$
DELETE FROM error$$
INSERT INTO error (errorID) VALUES ("\n\nAL' at line 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When I try to import the db_triggers.sql I receive the following error, see below. I hesitate to modify the db_triggers.sql file without knowing if the changes will cause more problems. Does anyone have some insight on this problem? Thank you for any help.
Error
SQL query:
DELIMITER $$-- Error messages for mysql
DELETE FROM error$$ INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to change time sheet status.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to delete time sheet unless status is edit.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Not permitted to delete time sheet that has items.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet is not editable(2).\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time sheet's rate is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not editable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not editable: user not a project member.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Invalid date.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Invalid time duration.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task is not deletable.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task has pending tasks.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Must use: call change_task_status(taskID,status)\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task cannot be pending itself.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Task belongs to wrong project.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Absence must have a start and end date.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Time not recorded. Task has been closed for too long.\n\n"
)$$
INSERT INTO error( errorID )
VALUES (
"\n\nALLOC ERROR: Parent task loops not permitted.\n\n"
)$$-- if (NOT something) doesn't work for NULLs
DROP FUNCTION IF EXISTS empty $$ CREATE FUNCTION empty(
str TEXT
) RETURNS BOOLEANDETERMINISTIC BEGIN RETURN str = '' OR str IS NULL ;
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 $$
DELETE FROM error$$
INSERT INTO error (errorID) VALUES ("\n\nAL' at line 1
Anonymous,
what version of allocPSA are you using? What OS and what version of MySQL?
-- Con