- Posts: 2
- Home
- Forum
- Community Forum
- General discussions
- Book 2 different rate plans are adjacent
- Forum
- Community Forum
- Questions
- Installation/Upgrade
- Error installing Solidres: duplicate key in table '#_sr_geo_states
Error installing Solidres: duplicate key in table '#_sr_geo_states
- glenanpl
- Topic Author
- Offline
Less
More
9 months 1 week ago #20294
by glenanpl
Error installing Solidres: duplicate key in table '#_sr_geo_states was created 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
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
Please Log in or Create an account to join the conversation.
- solidres
- Offline
Less
More
- Posts: 2900
9 months 1 week ago #20295
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic Error installing Solidres: duplicate key in table '#_sr_geo_states
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,
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,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
- glenanpl
- Topic Author
- Offline
Less
More
- Posts: 2
9 months 1 week ago #20304
by glenanpl
Replied by glenanpl on topic Error installing Solidres: duplicate key in table '#_sr_geo_states
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
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.
- solidres
- Offline
Less
More
- Posts: 2900
9 months 1 week ago #20310
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic Error installing Solidres: duplicate key in table '#_sr_geo_states
Hi,
Make sure that you are using clean database that are not shared with any other programs.
Regards,
Make sure that you are using clean database that are not shared with any other programs.
Regards,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
- Stefanos
- Offline
Less
More
- Posts: 3
7 months 3 days ago #20418
by Stefanos
Replied by Stefanos on topic Error installing Solidres: duplicate key in table '#_sr_geo_states
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?
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.
- solidres
- Offline
Less
More
- Posts: 2900
7 months 1 day ago #20422
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic Error installing Solidres: duplicate key in table '#_sr_geo_states
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,
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,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
Moderators: solidres