Environment: Apache 2.0, PHP 4.2.2, MySQL 3.23.54
Error occured durring install of SITR 2.0.6
I launched SITR, selected install, entered MySQL ID and
Password and received the following error from
script_load.php.
Fatal Error... Unable to Proces Query:
Error Code: 1064
Descriptiono: You have an error in you SQL syntax near
'' at line 1
Query: INSERT INTO sys_language_keys
(language_id,language_key,language_language_id,language_value)
VALUES ('', 'PendingDocuments',
The last INSERT in the install.sql file is:
INSERT INTO sys_language_keys
(language_id,language_key,language_language_id,language_value)
VALUES ('', 'PendingDocuments',
'1', 'My Documents Pending Approval');
~
If the unnecessary new lines are removed then the
install completes without error.
Here is the modified INSERT statement:
INSERT INTO sys_language_keys
(language_id,language_key,language_language_id,language_value)
VALUES ('', 'PendingDocuments', '1', 'My Documents
Pending Approval');
~
Modified install.sql file.