Database error with "Files"

Getting REALLY frustrated with this platform.  I decided that there should be some pages that I can monetize.  There were failures on some plugins so I had to follow the gopher down the hole that led to installing the "files" plugin.  Now my menu is showing a new link and I get the following error when trying to install the module "files"

Installation of: Files Failed

 

 

-- 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(4, 'Files', '_bx_files_menu_profile', 'modules/?r=files/albums/my/main/|modules/?r=files/albums/my/add/|modules/?r=files/albums/my/manage/|modules/?r=files/albums/my/disapproved/', @iCatProfileOrder, 'memb', '', '', '', 1, 1, 1, 'custom', '', 0, '');
Quote · 21 Jul 2014

http://www.mancaveland.com

Quote · 21 Jul 2014

I yanked the "files" menu from the site so it would not show, but still getting the error when trying to install the module.

Quote · 21 Jul 2014

Search that table for any entries for the Files module, delete them, then clear Dolphin's cache. Re-try the installation.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 21 Jul 2014

These problems only occur on sites where the menu has been adjusted by custom templates etc. Modify the file shown below and re-upload to your server then the install should be fine.

In modules\boonex\files\install\sql\install.sql

Find two occurences of :

     @iCatProfileOrder,

Replace both occurences with :

    IFNULL(@iCatProfileOrder, 1),

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 21 Jul 2014

Modzzz, I followed old instructions with the following and it seems to have installed correctly.  Can you explain the difference between your suggestion and this one please?

 

In modules/boonex/files/install/sql/install.sql


Find (2 occurrences) :

, @iCatProfileOrder,

Replace with :

, '@iCatProfileOrder',

Quote · 21 Jul 2014

Just different ways of accomplishing the same thing. 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 21 Jul 2014
 
 
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.