Hi,
I tried installing the Simple Messenger from admin menu (tools -> Module -> Simple Messenger). I am receiveing an error message and the Simple Messenger is not being installed. The error i received is pasted below
Installation of: Simple Messenger Failed
-- Changing database:
-- -- There are errors in the following MySQL queries:
-- -- Error: 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 '' at line 9
-- -- There are errors in the following MySQL queries:
-- -- Error: 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 '' at line 9
---- -- Error: 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 'Type` = 'linked_item', `Parent` = 4' at line 1
-- Dumping data for table `sys_menu_member`
--
INSERT INTO
`sys_menu_member`
SET
`Name` = 'bx_simple_messenger',
`Eval` = 'return BxDolService::call(''simple_messenger'', ''get_privacy_link'');',
`Type` = 'linked_item',-- -- Error: 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 '' at line 11
`Parent` = 4;
---- -- Error: 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 'order_in_kateg` = 1' at line 1
INSERT INTO
`sys_options`
SET
`Name` = 'simple_messenger_update_time',
`kateg` = @iKategId,
`desc` = 'Simple messenger update time (in milliseconds)',
`Type` = 'digit',
`VALUE` = '3000',
`check` = 'return is_numeric($arg0);',
`order_in_kateg` = 1;-- -- Error: 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 '' at line 9
INSERT INTO-- -- Error: 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 'order_in_kateg` = 2' at line 1
`sys_options`
SET
`Name` = 'simple_messenger_visible_messages',
`kateg` = @iKategId,
`desc` = 'The amount of messages visible in a chat window',
`Type` = 'digit',
`VALUE` = '25',
`check` = 'return is_numeric($arg0);',
`order_in_kateg` = 2;-- -- Error: 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 '' at line 9
INSERT INTO-- -- Error: 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 'order_in_kateg` = 3' at line 1
`sys_options`
SET
`Name` = 'simple_messenger_allowed_chatbox',
`kateg` = @iKategId,
`desc` = 'The amount of active chat box available for member',
`Type` = 'digit',
`VALUE` = '5',
`check` = 'return is_numeric($arg0);',
`order_in_kateg` = 3;-- -- Error: 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 '' at line 9
INSERT INTO-- -- Error: 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 'order_in_kateg` = 5' at line 1
`sys_options`
SET
`Name` = 'simple_messenger_blink_counter',
`kateg` = @iKategId,
`desc` = 'The amount of flashes (blinks) when the new messages are recieved',
`Type` = 'digit',
`VALUE` = '4',
`check` = 'return is_numeric($arg0);',
`order_in_kateg` = 5;
