Broken modules and a great big mess

                1.)    I tried to install the video module but keep getting the following error every time:

Installation of: VideosFailed

-- Changing database:
-- -- There are errors in the following MySQL queries:
-- -- Error:

INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`) VALUES(9, 'Videos', '_bx_videos_menu_profile', 'modules/?r=videos/albums/browse/owner/{profileNick}', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, '');

Now I have _bx_videos showing up under the MODULES in the admin panel but it is not actually in the installed Modules so I cannot uninstall it now.

            2.)    So from searches I thought if I install the profiler module it would help with the video module, not so. Now I get this when I navigate to my site:

Fatal error: Call to a member function getClassPrefix() on a non-object in /homepages/0/d410884199/htdocs/new5/templates/base/scripts/BxBaseSearchResultSharedMedia.php on line 134

I uninstalled the Profiler module, cleaned the cashe but the Fatal error still appears.

In an attempt to fix these issues I learned that to install the video module I need to have the allow view profiles turned on. I turned the profiles page back on and tried to reinstall the video mod but still no luck.

Can someone please shed some light on this for me, I would be greatly appreciative as I have countless hours into the site now and cannot start over.

Try that query in phpmyadmin on your test site so you don't totally screw up your real site's database.

I have a dev site that I do coding changes to and test out before copying the code to my live site.

Also, I have a bone stock 7.0.9 site, that if I get stuck, I go back to it, to see if it's my code, or a conflict.

They are just sub domains of my main site.

So, use phpmyadmin on a duplicate of your site and run that query.  If you get an error, that will get you headed in the right direction.  I have a feeling that row already exists in the table you are trying to install it to.

You'd have to delete that table and try the install again.

And maybe you'll find another one.  Delete it too!

This install problem occurs on sites that have a customized top menu. Make the change that is stated below then proceed to install the video mod again.

In modules/boonex/videos/install/sql/install.sql

Find :

INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`) VALUES(9, 'Videos', '_bx_videos_menu_profile', 'modules/?r=videos/albums/browse/owner/{profileNick}', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, '');

Replace with :

INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`) VALUES(9, 'Videos', '_bx_videos_menu_profile', 'modules/?r=videos/albums/browse/owner/{profileNick}', ifnull(@iCatProfileOrder,0), 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, '');

Wow, thank you soooo much modzzz, you rock. That worked great and my site is back. I can’t tell you how much I appreciate all the tips, fixes and suggestions.

Steve, thanks for the suggestions. It is a great idea to use the test site prior to changing the live site. I am currently implementing the changes now.

I'll give it a try and let you know if it works