Installing modules errors

I managed to install all modules except: Ads, Blog, Events, Groups, Poll, Shoutbox, Simple Messenger and Store..

Operation Results
Installation of: Ads 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_ads',
`Eval` = 'require_once( BX_DIRECTORY_PATH_ROOT . ''modules/boonex/ads/ads_get_member_menu_list.php'' );\r\nreturn getMemberMenuAdsList({ID});',
-- -- 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 '`Parent` = '1', `Type` = 'linked_item'' at line 1
    `Parent` = '1',
`Type` = 'linked_item';
Installation of: Blog 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_blogs',
`Eval` = 'return BxDolService::call(''bx_blogs'', ''get_member_menu_item'', array({ID}));',
-- -- 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'' at line 1
	`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 '`Parent` = '1'' at line 1
	`Parent` = '1';
Installation of: Events 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_events',
`Eval` = 'return BxDolService::call(''events'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
    `Type` = 'linked_item',
`Parent` = '1';
Installation of: Groups 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_groups',
`Eval` = 'return BxDolService::call(''groups'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
    `Type` = 'linked_item',
`Parent` = '1';
Installation of: Poll 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 5
    INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_poll',
`Eval` = 'return BxDolService::call(''poll'', ''get_member_menu_link'', array(''{ID}''));',
-- -- 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 '`Parent` = '1', `Type` = 'linked_item'' at line 1
        `Parent` = '1',
`Type` = 'linked_item';
Installation of: Shoutbox 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 11
    --

INSERT INTO
`sys_options`
SET
`Name` = 'shoutbox_update_time',
`kateg` = @iKategId,
`desc` = 'Shoutbox update time (in milliseconds)',
`Type` = 'digit',
`VALUE` = '5000',
`check` = 'return is_numeric($arg0);',
-- -- 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
        `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 
`sys_options`
SET
`Name` = 'shoutbox_allowed_messages',
`kateg` = @iKategId,
`desc` = 'The number of the saved messages',
`Type` = 'digit',
`VALUE` = '15',
`check` = 'return is_numeric($arg0);',
-- -- 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
        `order_in_kateg` = 2;
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
    --
-- 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'');',
-- -- 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
        `Type`   = 'linked_item', 
`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 '' at line 11
    --

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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `order_in_kateg` = 5;
Installation of: Store 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_store',
`Eval` = 'return BxDolService::call(''store'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
    `Type` = 'linked_item',
`Parent` = '1';
Quote · 8 Jul 2009

Same errors here

Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

Kids first
Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

I'll try that, thanks!

Quotes are working for me..

Quote · 9 Jul 2009

i am getting similar issues, therefore it can't be just random or user error.

here is the log of errors, hope it helps!

Installation of: Blog 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_blogs',
`Eval` = 'return BxDolService::call(''bx_blogs'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
	`Type` = 'linked_item',
`Parent` = '1';

Installation of: Events 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_events',
`Eval` = 'return BxDolService::call(''events'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
`Parent` = '1';
 `Type` = 'linked_item',

Installation of: Groups 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_groups',
`Eval` = 'return BxDolService::call(''groups'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
    `Type` = 'linked_item',
`Parent` = '1';

Installation of: Poll 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 5
    INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_poll',
`Eval` = 'return BxDolService::call(''poll'', ''get_member_menu_link'', array(''{ID}''));',
-- -- 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 'Parent` = '1', `Type` = 'linked_item'' at line 1
        `Parent` = '1',
`Type` = 'linked_item';

Installation of: Quotes Failed
-- Introduction from vendor: An error occured. Contact with module's vendor

Installation of: Shoutbox 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 11
    --

INSERT INTO
`sys_options`
SET
`Name` = 'shoutbox_update_time',
`kateg` = @iKategId,
`desc` = 'Shoutbox update time (in milliseconds)',
`Type` = 'digit',
`VALUE` = '5000',
`check` = 'return is_numeric($arg0);',
-- -- 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
        `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 
`sys_options`
SET
`Name` = 'shoutbox_allowed_messages',
`kateg` = @iKategId,
`desc` = 'The number of the saved messages',
`Type` = 'digit',
`VALUE` = '15',
`check` = 'return is_numeric($arg0);',
-- -- 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
        `order_in_kateg` = 2;

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
    --
-- 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'');',
-- -- 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
        `Type`   = 'linked_item', 
`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 '' at line 11
    --

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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `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 
`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);',
-- -- 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
        `order_in_kateg` = 5;

Installation of: Store 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 5
INSERT INTO 
`sys_menu_member`
SET
`Name` = 'bx_store',
`Eval` = 'return BxDolService::call(''store'', ''get_member_menu_item'', array({ID}));',
-- -- 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` = '1'' at line 1
    `Type` = 'linked_item',
`Parent` = '1';
Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

You're brilliant! Laughing

It worked.. Thanks!

All modules installed and working.. except videos and sounds where I still have that file not found error when trying to play :(

Any ideas?

Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

You're brilliant! Laughing

It worked.. Thanks!

All modules installed and working.. except videos and sounds where I still have that file not found error when trying to play :(

Any ideas?

What worked uploading in binary?  Did you have to do a full and complete upload again to resolve this?  I'm having issues with the Instant Messenger module.

Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

You're brilliant! Laughing

It worked.. Thanks!

All modules installed and working.. except videos and sounds where I still have that file not found error when trying to play :(

Any ideas?

What worked uploading in binary?  Did you have to do a full and complete upload again to resolve this?  I'm having issues with the Instant Messenger module.

Yes, full upload and every module is installed.. still I can't get videos and sound module working (playing)..

Quote · 9 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

good shooting there killerhai, i do all of my installs from wget and unzip, that way i am sure to get all the files that i need. or so far that has been the case. also guys what is your php build?

Regards,

DosDawg

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 10 Jul 2009

The only module what is not working is the quote. 
I think there are some other things on your site... 
maby a wrong upload?
The best you can upload every thing in Binairy mode.

good shooting there killerhai, i do all of my installs from wget and unzip, that way i am sure to get all the files that i need. or so far that has been the case. also guys what is your php build?

Regards,

DosDawg

I have php 5.1.6..

Quote · 10 Jul 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.