Error updating HikaMarket to 2.1.0

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikashop Business
6 years 8 months ago #288965

-- HikaShop version -- : 3.3.0
-- HikaMarket version -- : 2.1.0
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.1.14
-- Error-message(debug-mod must be tuned on) -- : 1146 Table 'tlcs_.#__hikamarket_vendor_user' doesn't exist

I have just updated HikaMarket on my live site and when I click on 'Configuration' in the Hikamarket control panel the page formatting is lost and I get the following error at the bottom of the page:

1146 Table 'tlcs_.#__hikamarket_vendor_user' doesn't exist



There are no additional errors reported with error reporting to maximum.

Looking at the server log I see this error:
AH01071: Got error 'PHP message: PHP Notice: Uninitialized string offset: 0 in /var/www/vhosts/--mydomain--.com/httpdocs/administrator/components/com_hikamarket/classes/category.php on line 440\n', referer: https://--mydomain--.com/administrator/index.php?option=com_config

The strange thing is that I tested the upgrade on an off-line version of the site and it worked OK.

I will do some more testing.

Trevor

### Update ###
I have checked the database and the table hikamarket_vendor_user does not exist in either the test site or my off-line site. I have created the table using the code from install.hikamarket.php and the error has gone away. Does the table need populating? The site appears to be working OK but I will keep testing.

btw. I forgot to mention that I was updating from v2.0.1

Should install.hikamarket.php still be on the server?

Not important but I notice that in the file com_hikamarket/_database/install.sql the code to create the hikamarket_customer_vendor table is duplicated.

#### Another Update ####
I have tried the update on another site and again the hikamarket_vendor_user is not created.


Best regards
Trevor

Attachments:
Last edit: 6 years 8 months ago by trevsmiff.

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
6 years 8 months ago #288977

Hello,

The table creation query is in the installation script and in the install SQL file.
The update should have add that table ; it did when I tested the update on the demo website.
Maybe you got an issue during the update ; hard to tell like that but I will perform some new tests.

I would see to call the HikaShop "check database" function after the update.
You had the good reflex to use the "check database" in order to fix the DB issue.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikashop Business
6 years 8 months ago #288985

I have just tried again on another site and the installer reported that the install was successful. I ran the 'Check database' function and it reported:

Info Could not load columns from the table "hikamarket_vendor_user" : Table 'toozey.#__hikamarket_vendor_user' doesn't exist
OK Problem solved - table "hikamarket_vendor_user" created

There were a couple of errors in the server log:
AH01068: Got bogus version 105, referer: https://--myserver--.com/administrator/index.php?option=com_hikamarket&ctrl=update&task=install&fromversion=&update=0&freshinstall=0

(22)Invalid argument: AH01075: Error dispatching request to :, referer: https://--myserver--.com/administrator/index.php?option=com_hikamarket&ctrl=update&task=install&fromversion=&update=0&freshinstall=0

Hope that helps
regards
Trevor

Please Log in or Create an account to join the conversation.

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
6 years 8 months ago #288992

Hello,

1 - Yes, if the table is not created, it's logical that you got these messages from the HikaShop check database system.

2 - Thanks.
But unfortunately, it does not provide a useful information to understand what happened.

3 - What is your MySQL version ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 306
  • Thank you received: 42
  • Hikamarket Multivendor Hikashop Business
6 years 8 months ago #289023

Morning Jerome

Here is the system Information:

PHP: Built On 	Linux server2 2.6.32-042stab127.2 #1 SMP Thu Jan 4 16:41:44 MSK 2018 x86_64
Database Version: 	5.5.56-MariaDB
Database Collation: 	utf8_general_ci
Database Connection Collation: 	utf8mb4_general_ci
PHP Version: 	7.1.14
Web Server: 	Apache
WebServer to PHP Interface: 	fpm-fcgi
Joomla! Version: 	Joomla! 3.8.5 Stable [ Amani ] 6-February-2018 15:00 GMT
Joomla! Platform Version: 	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent: 	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0

I have a site that I can give you admin access to if it would help.

regards
Trevor

The following user(s) said Thank You: Jerome

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.071 seconds
Powered by Kunena Forum