installing modules gives errors

Oke I try the following modules to get installed, 
shared Music, result is:

Installation of: Shared Music Module 
-- 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` = 'shared_music',
`Eval` = 'return BxDolService::call(''shared_music'', ''get_member_menu_item'', array({ID}), ''Main'');',
-- -- 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';

Then the next one, shared video:

Installation of: Shared Video Module 
-- 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` = 'shared_video',
`Eval` = 'return BxDolService::call(''shared_video'', ''get_member_menu_item'', array({ID}), ''Main'');',
-- -- 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';


Without those two modules other like Shop, Wall will not be installed.

Lets go on, the next modules are not installed:

Installation of: Ads Module
-- 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 Module
-- 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: Poll Module
-- 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 Module
-- 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 + 1,
`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 + 1,
`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;
-- -- Error: Duplicate entry 'shoutbox_procces_smiles' for key 1

INSERT INTO 
`sys_options` 
SET
`Name` = 'shoutbox_procces_smiles',
`kateg` = @iKategId + 1,
`desc` = 'Allow to procces smile''s codes',
`Type` = 'checkbox',
`VALUE` = 'on',
`order_in_kateg` = 3;

I have some more like desktop and ads. but they have all the same database problem looks to me.

I believe your getting those errors because they are already installed at default. Scroll below the big list of Modules and you'll see like 6 which have yet to be installed. Try installing those. Start with Orca. Don't forget to follow the instructions in the drop menu :)

When I had it installed, there were zero modules installed --- everything was unticked.

What you see happening here is this: code that should have been evaluated is flooding inside the MySQL queries unevaluated, corrupting the query and installing half of the module, like this. Might be the same short tags issue (<? instead of <?PHP) reported in another thread that leaves code unevaluated...

Ghost: 
These errors are in the dropdown screen after try to install them. Orca was installed without problems.. Like other to, only these don't want be installed. And because the shared one are needed to get others to be installed..  so you see the dillemma :)

I do see. I had a similar issue. When I installed, I had most install by default. Then when installing the others I had to be sure to install this before that one. My biggest issue was Ads. It wouldn't install because it is missing the 'data' and 'images' folders. When I inputted them, I was able to complete all the install.

Just FYI -> I am on a dedicated that I control. If on a dedicated then we have a shot :) lol if on a sharred or VPS we may have issues. But check to insure that all your folders are in the right place via the SVN. I checked all module folders to understand its construction which made me comfortable to add some.

But all those Errors you get, I did not recieve because those Modules were loaded at install for me. I know every one hates reloading but it my be worth it in your case, but check folders. I think that might be your issue. Also ensure that those DB Tables exist as D6 is 147 Tables and D-Alpha is 248.

Did you load D-Alpha on a fresh clean DB? OR overwrite an existing one?

let me know :)

What version of Sql are you using? I am on MySQL 5.0 and experienced nothing like you both are experiencing??? Makes you go 'hmmm'

Let me know :) Thanks