Installing Boonex Core module gets MySQL error

Is this a new installation?  If so, how was it installed?

check the table and make sure that entry does not already exist.

It could be that a previous installation did not complete thus leaving behind the table; which is what Professor is asking you to check.

The error reporting from a failed installation of a module does not give enough information to track down why it failed.

I would suppose that there is no "Search" menu item, because module tries to add submenu to this menu item.

Some of the solutions:

- add search menu item back to the main menu

- comment out that line in module installation which adds this submenu link.

Yeah, this is a pain actually and happens with a lot of modules ... I am forever having to go and remove tables of unistalled modules.

New install

Found the problem:

The db table has a field "Order" which is a smallint(6), the Google Search install script does not correctly grab that value and tries to insert "@iCatOrder" instead of 4.

Go to /modules/boonex/google_search/install/sql directory and edit the install.sql file.

On line 35 replace @iCatOrder with a 4.

New install with standard issue files:

Just curious - how did you upload your files to your server, what ftp program did you use? Did you use filezilla by chance?

 
@iCatOrder is assigned at line 33

SET @iCatOrder := (SELECT MAX(`Order`)+1 FROM `sys_menu_top` WHERE `Parent` = 138 ORDER BY `Order` DESC LIMIT 1);

So if it is not properly finding the order, that would mean it could not find the "Search Home" menu entry which is suppose to have a parent id of 138. My guess it that entry does not exist. It is inserted when dolphin is installed. The only way it would not be there is if it was manually removed.

The modifying of the menu is usually what causes problems with modules when installing menu items.

I just had the exact same problem. 

used filezilla - clean install.

Gsearch install gave the same error, 

thing is, on the front end the search box was showing after the 'failed' install of the module.

So, applied the above fix, and un-installed it as don't want it. Cleared cache and the search box still shows!...

frustrating.

I had the same issue in 7.0.9

Try running this query in phpmyadmin

Let me know if it fails

ALTER TABLE `sys_menu_top` CHANGE `Order` `Order` SMALLINT( 6 ) UNSIGNED NULL DEFAULT '0'

I have had problems with using Filezilla to maintain Dolphin and have abandoned using Filezilla completely.  However, if you do want to continue using Filezilla, force all uploads to use binary mode, do not set it to auto, set it to always use binary.