I want to leave Groups intact and create another module called Clubs. I copied Groups Module and renamed everything.
Installation of: Clubs 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 'INSERT INTO `sys_objects_actions` (`Caption`, `Icon`, `Url`, `Script`, `Eval`, `' at line 1
INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES
('Clubs', '0', 'bx_photos', '0', 'active'),
('Social Clubs', '0', 'bx_clubs', '0', 'active'),
('Sports Clubs', '0', 'bx_clubs', '0', 'active'),
INSERT INTO `sys_objects_actions` (`Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`) VALUES
('{TitleEdit}', 'modules/boonex/clubs/|edit.png', '{evalResult}', '', '$oC alt= $GLOBALS[''oBxClubsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''edit/{ID}'';', '0', 'bx_clubs'),
('{TitleDelete}', 'modules/boonex/clubs/|action_block.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oC alt= $GLOBALS[''oBxClubsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''delete/{ID}'';', '1', 'bx_clubs'),
('{TitleShare}', 'modules/boonex/clubs/|action_share.png', '', 'showPopupAnyHtml (''{BaseUri}share_popup/{ID}'');', '', '2', 'bx_clubs'),
('{TitleBroadcast}', 'modules/boonex/clubs/|action_broadcast.png', '{BaseUri}broadcast/{ID}', '', '', '3', 'bx_clubs'),
('{TitleJoin}', 'modules/boonex/clubs/|user_add.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oC alt= $GLOBALS[''oBxClubsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''join/{ID}/{iViewer}'';', '4', 'bx_clubs'),
('{TitleInvite}', 'modules/boonex/clubs/|club_add.png', '{evalResult}', '', '$oC alt= $GLOBALS[''oBxClubsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''invite/{ID}'';', '5', 'bx_clubs'),
('{AddToFeatured}', 'modules/boonex/clubs/|star__plus.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oC alt= $GLOBALS[''oBxClubsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''mark_featured/{ID}'';', '6', 'bx_clubs'),
('{TitleManageFans}', 'modules/boonex/clubs/|action_manage_fans.png', '', 'showPopupAnyHtml (''{BaseUri}manage_fans_popup/{ID}'');', '', '8', 'bx_clubs'),
('{TitleUploadPhotos}', 'modules/boonex/clubs/|action_upload_photos.png', '{BaseUri}upload_photos/{URI}', '', '', '9', 'bx_clubs'),
('{TitleUploadVideos}', 'modules/boonex/clubs/|action_upload_videos.png', '{BaseUri}upload_videos/{URI}', '', '', '10', 'bx_clubs'),
('{TitleUploadSounds}', 'modules/boonex/clubs/|action_upload_sounds.png', '{BaseUri}upload_sounds/{URI}', '', '', '11', 'bx_clubs'),
('{TitleUploadFiles}', 'modules/boonex/clubs/|action_upload_files.png', '{BaseUri}upload_files/{URI}', '', '', '12', 'bx_clubs'),
('{TitleSubscribe}', 'action_subscribe.png', '', '{ScriptSubscribe}', '', '13', 'bx_clubs'),
('{evalResult}', 'modules/boonex/clubs/|club_create.png', '{BaseUri}browse/my&bx_clubs_filter=add_club', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_clubs_action_add_club'') : '''';', '1', 'bx_clubs_title'),
('{evalResult}', 'modules/boonex/clubs/|clubs.png', '{BaseUri}browse/my', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_clubs_action_my_clubs'') : '''';', '2', 'bx_clubs_title'),
('{evalResult}', 'modules/boonex/clubs/|clubs.png', '{BaseUri}', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_clubs_action_clubs_home'') : '''';', '2', 'bx_clubs_title');
Your help is greatly appreciated.