Errors when trying to install upgrade

-- url of the page with the problem -- : fireworksland.com/administrator/index.ph...ate=0&freshinstall=0
-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Safari 9.0.1
-- Error-message(debug-mod must be tuned on) -- : 1064 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 '' at line 1 SQL=UPDATE `msb9n_menu` SET `rgt`=`rgt`-0 WHERE `rgt`>=

I purchased the upgrade to 2.6.0 and am unable to install the file.
I tried both the .zip file and the tar.gz file
The file uploads and installs, with a couple of error messages, and then I get the message "Installation of the Component was Successful," but then I get the error message:

"An error has occurred.
1064 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 '' at line 1 SQL=UPDATE `msb9n_menu` SET `rgt`=`rgt`-0 WHERE `rgt`>="

See the attached screen shots. What do I do?

Hi,

Do you have the menu "HikaShop" present in backend ? If it is, so no issues.
The error just means that the installation was not able to create the main HikaShop menu in backend.

No HIkashop menu at all. I had uninstalled Hikashop 2.4.0. I guess this means I lost all my products. I will try to restore from a backup.
However, even with HikaShop 2.4.0 uninstalled, I still get the error message above when trying to install HikaShop 2.6.0, and no HikaShop menu is created in the back end.

Thank you. I restored a backup that had 2.4.0 installed, and I rebuilt the menus, then I installed 2.6.0 using the Extension Manager. The extension manager shows that 2.6.0 is installed, and the front end works fine. But... Hikashop does not appear in the back end under the "Components" menu. See the attached screen shot...

Hi,

Via your phpMyAdmin interface, please export the current database in order to have a backup.

Then execute the following MySQL query:

DELETE FROM #__menu WHERE (`menutype` = 'main' AND `alias` = 'hikashop') OR (`menutype` = 'menu' AND `link` LIKE '%com_hikashop%')

Thank you, but when I exectute that query I get the error message:

#1064 - 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 'WHERE 1' at line 1

The query was:
DELETE FROM #__menu WHERE (`menutype` = 'main' AND `alias` = 'hikashop') OR (`menutype` = 'menu' AND `link` LIKE '%com_hikashop%')

Hi,

My bad I forgot to mention that you have to replace "#_" by your database prefix.

OK, i executed the query

DELETE FROM msb9n_menu WHERE (`menutype` = 'main' AND `alias` = 'hikashop') OR (`menutype` = 'menu' AND `link` LIKE '%com_hikashop%')

and I get "0 rows deleted. (Query took 0.0011 seconds.)"

I reinstalled HikaShop 2.6.0 and I still have no HikaShop menu in the back end.

How do you rebuild the administrator menus?

Thank you. Yes, I have done that rebuild several times, reinstalled HikaShop several times, cleared the Admin cacne, everything several times. Still no Hikashop menu in the back end.

Well I guess my installation is really messed up... no Quickicons appear, even though the Quickicon plugins are enabled, including the HikaShop Quickicon. I will have to try to restore to a backup that works and try again... but that is what I've already tried.

I found this solution to the database menu table problem:
forum.joomla.org/viewtopic.php?f=625&t=632543&start=120

When I run the slbs.php file in that topic, I am able to rebuild the menus without error. It says "Successfully rebuilt."

When I try to install HikaShop 2.6.0 I get error messages and no Hikashop appears in the Components menu in the back end.

Then when I try to rebuild menus I get the error message:

Error
Rebuild failed: exception 'UnexpectedValueException' with message 'MenusTableMenu::getRootId' in /home/rjweaver/public_html/libraries/joomla/table/nested.php:1270 Stack trace: #0 /home/rjweaver/public_html/libraries/joomla/table/nested.php(1297): JTableNested->getRootId() #1 /home/rjweaver/public_html/plugins/system/jreviews_addonmenus/models/j3/item.php(1115): JTableNested->rebuild() #2 /home/rjweaver/public_html/administrator/components/com_menus/controllers/menus.php(108): MenusModelItem->rebuild() #3 /home/rjweaver/public_html/libraries/legacy/controller/legacy.php(728): MenusControllerMenus->rebuild() #4 /home/rjweaver/public_html/administrator/components/com_menus/menus.php(18): JControllerLegacy->execute('rebuild') #5 /home/rjweaver/public_html/libraries/cms/component/helper.php(392): require_once('/home/rjweaver/...') #6 /home/rjweaver/public_html/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent('/home/rjweaver/...') #7 /home/rjweaver/public_html/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent('com_menus') #8 /home/rjweaver/public_html/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #9 /home/rjweaver/public_html/libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute() #10 /home/rjweaver/public_html/administrator/index.php(47): JApplicationCms->execute() #11 {main}

I went to an earlier backup of my site, did all the updates, and iIt seems to be working except:

- No product images in Hiksahop pages.
- No "Hikashop" in the back end "Components" menu
- No "Hikashop" QuickIcon, even though the Hikashop Quickicon plug-in is enabled.

Where are the product images stored and how can I get them to appear on the pages?
Is there a URL I can enter to access the Hikashop back end?
Thank you

Thank you for your help. I uploaded the product images to media/com_hikashop/upload, as that is what is specified in the configuration settings. The images show on the product page, but they are all large - no thumbnails. Is there a way I get get Hikashop to generate the thumbnails again?
Thanks