Menu

Topic-icon Security Check Pro wont install database error 1164

  • thewedge
  • thewedge's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 months 1 week ago #6068 by thewedge
I tried to install your pro version. I get this error

JInstaller: :Install: Error SQL Table 'databasename.#__securitycheckpro_storage' doesn't exist
Extension Update: SQL error processing query: DB function failed with error number 1146
Table 'vtc2015.#__securitycheckpro_storage' doesn't exist
SQL =

ALTER TABLE `#__securitycheckpro_storage` CHANGE `key` `storage_key` varchar(255) NOT NULL;

databasename isn't the name of the database just a filler for this post.

I then tried to install the sql into the MySQL database. It then told me I had an issue with utf8. I upgraded my database to Mysql 5.5.55 which gave me the other utf84. The database installed. I tried again installing the component as the table is there now. I am still getting the same error. How do I fix this?

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

More
3 months 1 week ago #6069 by Jose
Hi thewedge,

You should not get the issue with MySQL 5.4 or lower (it's fully tested in those environments)... What's the database collation? Other customers got similar issues if it's set to utf8mb4.

Regards,
Jose

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

Time to create page: 0.082 seconds
Powered by Kunena Forum

Login or Sign In