I am encountering an error when trying to install HikaShop

  • Posts: 632
  • Thank you received: 25
  • Hikaserial Subscription Hikashop Multisite
2 weeks 6 days ago #372325

-- HikaShop version -- : 6.5.0
-- Joomla version -- : 6.1.1
-- PHP version -- : 8.3

Hello HikaShop support,

I am encountering an error when trying to install HikaShop for the first time on a Joomla website.
This is a fresh installation with no previous HikaShop data present.

Error messages shown after installation attempt:
1. Warning: Table 'ID470049_DemoAllUnited.r1e6l_hikashop_config' doesn't exist
2. Error: Error installing component

Could you please advise what might be causing this and what the recommended steps are to resolve it?

Thank you in advance.

Kind regards,
Lumiga

Kind regards,
Lumiga
Attachments:

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

  • Posts: 85860
  • Thank you received: 14106
  • MODERATOR
2 weeks 5 days ago #372333

Hi,

That error means HikaShop's database tables were not created during the installation, so the install could not finish (the config table it needs right after is therefore missing). The component files were copied, but the database step did not complete.

On a fresh install this almost always comes down to one of these, in order of likelihood:

1. Database user privileges. The MySQL user set in your Joomla configuration.php must be allowed to create tables (CREATE, ALTER, INDEX). On some shared or managed hosts the user only has SELECT/INSERT/UPDATE/DELETE, so the CREATE TABLE step fails and no tables are made. Ask your host to grant that database user full privileges on the database, then reinstall.

2. Incomplete or corrupted package. If the upload was truncated (server upload limit) or the download was incomplete, the install SQL gets cut off. Download a fresh copy from your account and install it again.

3. PHP limits. A low max_execution_time or memory_limit can interrupt the install part-way. Make sure max_execution_time is at least 60 and memory_limit at least 128M.

Before retrying, clear the failed attempt first: Extensions > Manage, search for hikashop and uninstall anything left over, so you start from a clean state.

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

  • Posts: 632
  • Thank you received: 25
  • Hikaserial Subscription Hikashop Multisite
2 weeks 1 day ago #372397

Hi Nicolas,

I had the hosting provider look into it, but there was nothing on their end that could be improved. I also downloaded a fresh installation file and checked the other points you mentioned, but everything looks correct there.

I then installed a clean new website on the same hosting environment and installed HikaShop on it — and that worked without any issues. So I suspect the problem is specific to the existing website.

What could be causing HikaShop to fail installation on this particular site? I am using AdminTools, and I also tried resetting the .htaccess to the default Joomla version, but that didn't help either.

Do you have any other ideas on how to resolve this?

In the Joomla log we see only this:
026-06-27T12:04:21+00:00 WARNING 212.83.80.222 jerror Table 'ID470049_DemoAllUnited.r1e6l_hikashop_config' doesn't exist

Kind regards,
Lumiga

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

  • Posts: 85860
  • Thank you received: 14106
  • MODERATOR
2 weeks 17 hours ago #372402

Hi,

Well, to me, the most likely is that the MySQL user account configured in the Joomla configuration cannot create the table during the installation. Did you use the same MySQL user account on both websites ?
Do you see any HikaShop table in the database after the failed installation ?

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

  • Posts: 632
  • Thank you received: 25
  • Hikaserial Subscription Hikashop Multisite
1 week 6 days ago #372412

Hi Nicolas,
After reading your last replay, I did an extra test using the same username and password on the same database. I first emptied the database, deleted all the website files, and installed a fresh Joomla 6.1.1.
After installing HikaShop on this clean setup, we don't experience any issues. So it appears that something within the existing website is causing the problem.
In the database of the website with the error, we can see the following HikaShop records in the extension table.
See images 201 and 202:




Kind regards,

Lumiga

Kind regards,
Lumiga
Attachments:
Last edit: 1 week 6 days ago by Lumiga.

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

  • Posts: 85860
  • Thank you received: 14106
  • MODERATOR
1 week 6 days ago #372414

Hi,

Try deleting this entry and then installing HikaShop again. Maybe that will help.

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

  • Posts: 632
  • Thank you received: 25
  • Hikaserial Subscription Hikashop Multisite
1 week 5 days ago #372428

Hi Nicolas,

We did that — see the screenshots before and after, and the error.
It's still not possible to install HikaShop on this site. After trying, the only thing we see installed is the component and plug-ins. But we do not see the plugins in Joomla..








After trying, the only thing we see installed is the component and plug-ins. But we do not see the plugins in Joomla..




Kind regards,
Lumiga
Attachments:
Last edit: 1 week 5 days ago by Lumiga.

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

  • Posts: 85860
  • Thank you received: 14106
  • MODERATOR
1 week 5 days ago #372434

Hi,

Your clean-site test is the key result: same host, same database, same MySQL user and a fresh package all install HikaShop fine, so the host, the database, the user privileges and the package are all ruled out. The cause is something inside this existing site that interrupts HikaShop's installer.

What you are seeing fits that exactly. HikaShop creates its database tables and then, in a second automatic step right after the component is registered, installs its bundled plugins and modules. On this site that run is being aborted partway: the component and plugin entries get written to the extensions table, but the tables (including hikashop_config) are never created and the plugins never finish registering, which is why Joomla does not list them.

So we need to find what aborts the install on this site. The most likely cause is a third-party system plugin or a security tool throwing an error or blocking part of the install. Since you have Admin Tools, that is the first suspect. Note that resetting the .htaccess does not turn off Admin Tools' PHP-level firewall: that part runs as the System - Admin Tools plugin, so it was still active in your tests.

Please try this:

1. Get the real error. The "table doesn't exist" log line is only the downstream symptom, not the cause. Set Global Configuration > Server > Error Reporting to Maximum and Debug to Yes, then retry the install and note the exact error shown. Also check the server PHP error_log, and Admin Tools > Web Application Firewall > Security Exceptions Log, to see if anything was blocked during the install.

2. Temporarily disable the third-party system plugins, Admin Tools in particular (unpublish the System - Admin Tools plugin), then install HikaShop again. If it works, re-enable them one at a time to find the one responsible.

3. Start each retry from a clean state: delete the leftover HikaShop rows you can see in the extensions table (the com_hikashop component and the hikashop plugins) before reinstalling, so the install does not trip over half-installed entries.

Send us the exact errors from step 1. We might be able to find out the issue with them.

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

  • Posts: 632
  • Thank you received: 25
  • Hikaserial Subscription Hikashop Multisite
5 days 7 hours ago #372527

I've removed everything except Akeeba Backup and YOOtheme. I emptied the database of everything HikaShop had added, and I had the Joomla core files reinstalled. I then made a backup and tried installing HikaShop again. But it still won't work. I've restored the backup so you can take a look yourself to see what's going on ;-) I'm completely stumped.

I've also done step 1 as you described it, and the results are attached.

I don't see any messages appearing on screen other than the standard message this ticket is about.

The errorlog:
[Tue Jul 07 16:48:08.321825 2026] [error] [pid 2904836] apache2_util.c(275): [client 2a02:a420:21d1:a051:28f8:629b:5c2f:a343:0] [client 2a02:a420:21d1:a051:28f8:629b:5c2f:a343] ModSecurity: Rule 62df7e97d720 [id "35013"][line "40"] - Execution error - PCRE limits exceeded (-8): (null). [hostname "support.allunited.club"] [uri "/administrator/index.php"] [unique_id "9f9b0a6cce9948bfa3c99215b3881418"] See also the eccess log file [attachment=63287]The-accesslog.txt[/attachment][file "/usr/local/httpd/conf/modsecurity-crs/activated-rules/modsecurity_00_combell.conf"][line "40"] - Execution error - PCRE limits exceeded (-8): (null). [hostname "support.allunited.club"] [uri "/administrator/index.php"] [unique_id "9f9b0a6cce9948bfa3c99215b3881418"]

See also the eccess log file

This attachment is hidden for guests.
Please log in or register to see it.

Kind regards,
Lumiga

This message has an attachment file.
Please log in or register to see it.

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

  • Posts: 85860
  • Thank you received: 14106
  • MODERATOR
4 days 22 hours ago #372530

Hi,

That log line is the answer we were missing. The install is being aborted by ModSecurity, the web application firewall running at your host's Apache level, not by anything inside Joomla:

ModSecurity: Rule [id "35013"][line "40"] - Execution error - PCRE limits exceeded (-8)
[file ".../modsecurity-crs/activated-rules/modsecurity_00_combell.conf"]
[uri "/administrator/index.php"]

What happens: HikaShop's install sends a large request to /administrator/index.php. One of your host's firewall rules (id 35013, in a Combell ruleset file) tries to scan that request, its regular expression hits the PCRE backtracking limit and errors out (that is the -8), and the error kills the request in the middle of the install. So the component and plugin rows get written to the extensions table, but the CREATE TABLE step never runs, which is exactly the "hikashop_config doesn't exist" symptom.

This also explains everything else you found. It is at the web-server level, so removing your Joomla plugins, reinstalling the core and resetting the .htaccess could not change it, and the clean test site only worked because the same rule did not trip there.

Only your host can change this. Go back to them, this time with the exact rule instead of just "the install fails". The rule file is theirs (modsecurity_00_combell.conf, so this is Combell), and ask them to either:

1. whitelist or disable ModSecurity rule id 35013 for /administrator/index.php on this site, or
2. raise the PCRE limits (SecPcreMatchLimit and SecPcreMatchLimitRecursion) so the rule can finish evaluating the request instead of erroring.

Either one lets the install request through and the tables get created. If your hosting control panel has a ModSecurity on/off switch, you can also disable it just for the install and turn it back on afterwards.

Before the next attempt, delete the leftover HikaShop rows from the extensions table again so you start from a clean state.

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

Time to create page: 1.649 seconds
Powered by Kunena Forum