Manual uninstall of modules

Hi all,

I tried to install the Boonex Video module which failed with a message that there was a SQL error:
----------------
INSERT INTO `sys_menu_top`
(`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`,   `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`)
VALUES
(4, 'Videos', '_bx_videos_menu_profile', 'modules/?r=videos/albums/my/main|modules/?r=videos/albums/my/add/|modules/?r=videos/albums/my/manage/|modules/?r=videos/albums/my/disapproved/', @iCatProfileOrder, 'memb', '', '', '', 1, 1, 1, 'custom', '', 0, '');

----------------

Now my homepage is failing with an error of
Fatal error: Call to a member function getClassPrefix() on a non-object in /home/rednoodl/public_html_social/templates/base/scripts/BxBaseSearchResultSharedMedia.php on line 137

----------------

It seems that when a module install fails that it does not undo those install steps that had already run, so some manual clean up seems necessary.

I manually ran the sql commands in /modules/boonex/videos/install/sql/uninstall.sql thinking that this would amount to a manual uninstall. But the homepage still fails with the same error, which can be seen at http://social.rednoodle.com/index.php
(you'll see some diagnostic output I added to verify which module is causing the immediate problem)

Can anyone tell me what other steps I should do to effect a manual uninstall, and fix my homepage?

By the way, installation of the files module failed as well with a similar SQL message, so I'm guessing that once this error is cleared I'll have to go through a similar process for the files module.

Any help would be greatly appreciated.

Thanks.

- Brian

P.S. I'd appreciate any thoughts on why the module install failed initially as well. I did have the wall module installed at one point and then later uninstalled it, by way of background info.

My first suggestion is to go in cPanel

MySQL® Databases

and run a check, repair..

Hi Newton27,

Thanks for the reply. I ran a check but it found no errors. I ran a repair anyway and it didn't indicate that it changed anything (as expected at that point). And the homepage still shows the same error.

I think my problem lies elsewhere. But thanks again for the suggestion.

- Brian

This is version 7.0.x?

The installation failed because you have an adjusted menu system. To get the module to install, follow the steps below:

Open modules/boonex/videos/install/sql/install.sql

Find (all ocurrences) :

     @iCatProfileOrder

Replace with :

    ifnull(@iCatProfileOrder,1)

Re-upload the adjusted file and then perform the installation normally in the admin panel.

That worked.

Thanks modzzz!

P.S. If you have the time to respond again, can you explain what you meant about adjusted menu system? I don't remember modifying the php code for the top menu, are you referring to the changes I made using the "Navigation Menu" in the "Builders" section in the interface? Just want to know how I got myself into this. Thanks again.

Yes, changes you make to the navigation layout can break the installation. The install file for the default boonex mods do not perform proper checks for this.

Hi All,

New to Dolphin (and also new to using SQL), so any help would be appreciated.

Is there anyway to remove a particular SQL script? I tried to install 3rd party module (don't think I did it right), and now trying to install something else, but I think there's a conflict because of the script I put in. I already removed the coding I added to the CSS pages. 

I'd like to remove the following:

SELECT @iPCOrder:=MAX(`Order`) FROM `sys_page_compose` WHERE `Page`='index' AND `Column`='1';

INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES ('index', '1140px', 'View events on a Timeline', '_wall_pc_view', 1, @iPCOrder+1, 'PHP', 'return BxDolService::call(\'wall\', \'view_block_index_timeline\', array(0));', 1, 71.9, 'non,memb', 0);

What sort of command do I have to use to remove it?

Thanks,

MJ