[Skip to main content](#vessel-content)

#   Error updating HikaMarket to 2.1.0

##

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

8 years 8 months ago -  8 years 8 months ago [\#288965](#288965) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  *[Error updating HikaMarket to 2.1.0](/forum/22-market-bug-report/893982-error-updating-hikamarket-to-2-1-0#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&#95;.#&#95;&#95;hikamarket&#95;vendor&#95;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:  There are no additional errors reported with error reporting to maximum.  Looking at the server log I see this error:  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&#95;vendor&#95;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&#95;hikamarket/&#95;database/install.sql the code to create the hikamarket&#95;customer&#95;vendor table is duplicated.  #### Another Update #### I have tried the update on another site and again the hikamarket&#95;vendor&#95;user is not created.  Best regards Trevor")* was created by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")*

-- 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:
Code:

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

[ ![hm210error.jpg](/forum/attachment/42832) ](/forum/attachment/42832 "hm210error.jpg")

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

Looking at the server log I see this error: Code:

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

- [ ![hm210error.jpg](/forum/attachment/42832) ](/forum/attachment/42832 "hm210error.jpg") [ ](/forum/attachment/42832?download=1 "hm210error.jpg")

Last edit: 8 years 8 months ago by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mzk4Mi1lcnJvci11cGRhdGluZy1oaWthbWFya2V0LXRvLTItMS0wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

8 years 8 months ago [\#288977](#288977) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error updating HikaMarket to 2.1.0](/forum/22-market-bug-report/893982-error-updating-hikamarket-to-2-1-0#288977 "-- 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&#95;.#&#95;&#95;hikamarket&#95;vendor&#95;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:  There are no additional errors reported with error reporting to maximum.  Looking at the server log I see this error:  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&#95;vendor&#95;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&#95;hikamarket/&#95;database/install.sql the code to create the hikamarket&#95;customer&#95;vendor table is duplicated.  #### Another Update #### I have tried the update on another site and again the hikamarket&#95;vendor&#95;user is not created.  Best regards Trevor")*

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 &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mzk4Mi1lcnJvci11cGRhdGluZy1oaWthbWFya2V0LXRvLTItMS0wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

8 years 8 months ago [\#288985](#288985) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  Replied by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")* on topic *[Error updating HikaMarket to 2.1.0](/forum/22-market-bug-report/893982-error-updating-hikamarket-to-2-1-0#288985 "-- 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&#95;.#&#95;&#95;hikamarket&#95;vendor&#95;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:  There are no additional errors reported with error reporting to maximum.  Looking at the server log I see this error:  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&#95;vendor&#95;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&#95;hikamarket/&#95;database/install.sql the code to create the hikamarket&#95;customer&#95;vendor table is duplicated.  #### Another Update #### I have tried the update on another site and again the hikamarket&#95;vendor&#95;user is not created.  Best regards Trevor")*

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:
Code:

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:
Code:

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

Hope that helps
regards
Trevor

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mzk4Mi1lcnJvci11cGRhdGluZy1oaWthbWFya2V0LXRvLTItMS0wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

8 years 8 months ago [\#288992](#288992) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error updating HikaMarket to 2.1.0](/forum/22-market-bug-report/893982-error-updating-hikamarket-to-2-1-0#288992 "-- 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&#95;.#&#95;&#95;hikamarket&#95;vendor&#95;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:  There are no additional errors reported with error reporting to maximum.  Looking at the server log I see this error:  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&#95;vendor&#95;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&#95;hikamarket/&#95;database/install.sql the code to create the hikamarket&#95;customer&#95;vendor table is duplicated.  #### Another Update #### I have tried the update on another site and again the hikamarket&#95;vendor&#95;user is not created.  Best regards Trevor")*

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 &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mzk4Mi1lcnJvci11cGRhdGluZy1oaWthbWFya2V0LXRvLTItMS0wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

8 years 8 months ago [\#289023](#289023) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  Replied by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")* on topic *[Error updating HikaMarket to 2.1.0](/forum/22-market-bug-report/893982-error-updating-hikamarket-to-2-1-0#289023 "-- 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&#95;.#&#95;&#95;hikamarket&#95;vendor&#95;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:  There are no additional errors reported with error reporting to maximum.  Looking at the server log I see this error:  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&#95;vendor&#95;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&#95;hikamarket/&#95;database/install.sql the code to create the hikamarket&#95;customer&#95;vendor table is duplicated.  #### Another Update #### I have tried the update on another site and again the hikamarket&#95;vendor&#95;user is not created.  Best regards Trevor")*

Morning Jerome

Here is the system Information:
Code:

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](/forum/user/80-jerome "View Jerome's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mzk4Mi1lcnJvci11cGRhdGluZy1oaWthbWFya2V0LXRvLTItMS0wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile")

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.057 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
