Error installing Solidres: duplicate key in table '#_sr_geo_states

More
3 months 3 weeks ago #20294 by glenanpl
Hello,
The configuration:
Solidres 3.0.1
Joomla 4.4.1
PHP 8.0, 8.1 and/or 8.2
I get an error message when installing Solidres
JInstaller: :Install: SQL error Can't write; duplicate key in table '#_sr_geo_states'
Extension installation aborted.
Package Install: There was an error installing an extension: com_solidres.zip
danger
Error installing package

I've tried simplifying the table and recompressing the archive, but it still doesn't work with more error messages.
The installation worked on another sub-domain on the same host with a Joomla 4.3.4 version.
Does anyone have any idea why this is happening?
Thanks for the feedback
PL
Attachments:

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

More
3 months 3 weeks ago #20295 by solidres
Hi,

You should uninstall Solidres, then go to database and remove all remaining tables prefixed by "#__sr", then you can install it again to avoid that issue.

Regards,

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

More
3 months 3 weeks ago #20304 by glenanpl
Hello,
I have tried several times, but without success at OVH.
I've tried locally and it's OK, but an error with the database for a transfer to OVH.
I had hosting with o2switch to test and now it works.
I'm continuing my investigations to find out if the application meets our needs.
Best regards,
PL

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

More
3 months 3 weeks ago #20310 by solidres
Hi,

Make sure that you are using clean database that are not shared with any other programs.

Regards,

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

More
1 month 2 weeks ago #20418 by Stefanos
Even if you use clean database, removing all "#__sr" tables, does not work for Joomla 5!
Also , CANNOT uninstall it.
Also the error is there for almost every Solidres version (6 different stable ones) installation tries.
It simply cannot be installed.
Any good TECHNICAL suggestions?

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

More
1 month 2 weeks ago #20422 by solidres
Hi,

Solidres installation in Joomla 5 worked fine for us, you can test with a brand new Joomla 5 installation to confirm.

Make sure that you do not use Solidres installed in some 3rd template provider template quickstart packages.

Regards,

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

Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?