Install modules

Hi All hope you can help

When i try to install module  i get:

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', `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
    `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

Can someone please help

Than you

Quote · 13 Jul 2009

Hi,

We must transfer the files on your server in binary!

Quote · 13 Jul 2009

Thank you i will try to re upload in binary Laughing

Quote · 14 Jul 2009

I don't understand this, and I am getting the same error messages.   The modules are installed from the control panel, so they are already on the server.   Most people just use Filezilla or something similar, don't they?    Does anyone know what might be causing this?

Quote · 14 Jul 2009

I had those errors when trying to install them and i found that if i go back and try to install them again i get all in but the quotes module. I used my file manager and uploaded and unzipped with it and had no permission problems. I also did NOT use binary either.

You possess an intuitive intelligence so powerful it can help you heal, and relieve stress.
Quote · 16 Jul 2009

 

I don't understand this, and I am getting the same error messages.   The modules are installed from the control panel, so they are already on the server.   Most people just use Filezilla or something similar, don't they?    Does anyone know what might be causing this?

 Rob, I learned early that when you use Auto mode of transfer on your FTP that it can miss entire files on the upload, but if you set it to upload binary every time that it catches every file and every keystroke and does not bugger up the code like auto does.  Auto does it as pure text, which we know, not all the code is.

 

This isn't to say that someone couldn't do an auto upload and still get it, there FTP may be set to Binary as the upload manner and thus they'd never know that it did it.  A straight text upload will almost always screw up on things like java and flash files.  Just look under the options tab of your FTP and you'll see "Transfers" and you can set it up that way.

Quote · 16 Jul 2009

I use WSFTP which has options that allow me to configure file extensions to be transfered in ascii. So i have mine set to binary as the default and to auto switch to ascii on extensions i listed to be transferd as such.

So yes, Some files must be uploaded as binary. So as others have suggested. Try uploading things again.

https://www.deanbassett.com
Quote · 16 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.