- Posts: 2
COMMUNITY FORUM
Unable to install K2 - SQL Error
- Bjorn van de Peut
-
Topic Author
- Offline
- New Member
Less
More
10 years 2 months ago #141088
by Bjorn van de Peut
Unable to install K2 - SQL Error was created by Bjorn van de Peut
I've just downloaded the latest K2 from the website, but I'm unable to install it on the latest Joomla (3.3.6).
When I click "Upload & Install" using "K2_v2.6.9.zip" on the extension manager, I'm being stopped by the following message:
SQL Error (1146): Table 'Certwell.suqva_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS `suqva_k2_categories`
I've made sure permission are set fine. I can install any other extension and/or template without any problems at all. The website is running on a dedicated server with root access should it be needed for some debugging.
Screenshot of error:
When I click "Upload & Install" using "K2_v2.6.9.zip" on the extension manager, I'm being stopped by the following message:
SQL Error (1146): Table 'Certwell.suqva_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS `suqva_k2_categories`
I've made sure permission are set fine. I can install any other extension and/or template without any problems at all. The website is running on a dedicated server with root access should it be needed for some debugging.
Screenshot of error:
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
10 years 2 months ago #141100
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Unable to install K2 - SQL Error
Hello,
There are probably files from a previous install/ update left in Joomla!'s tmp folder. Make sure to delete them and try again.
Let me know if the issue persists.
There are probably files from a previous install/ update left in Joomla!'s tmp folder. Make sure to delete them and try again.
Let me know if the issue persists.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Bjorn van de Peut
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 2
10 years 2 months ago #141103
by Bjorn van de Peut
Replied by Bjorn van de Peut on topic Unable to install K2 - SQL Error
It was a new / freshly installed Joomla. Only every failed attempt of trying to install K2 was inside the tmp folder.
I've managed to fix the issue myself by manually running K2_v2.6.9/administrator/components/com_k2/install.mysql.sql (after changing the table names appropiately). It installed perfectly fine afterwards. Seems like for some unknown reason the installer doesn't run the SQL file before trying to query the database. Obviously causing errors.
I've managed to fix the issue myself by manually running K2_v2.6.9/administrator/components/com_k2/install.mysql.sql (after changing the table names appropiately). It installed perfectly fine afterwards. Seems like for some unknown reason the installer doesn't run the SQL file before trying to query the database. Obviously causing errors.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
10 years 2 months ago #141105
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Unable to install K2 - SQL Error
Nice to hear that the issue is resolved.
Make sure to empty the /tmp folder afterwards.
Make sure to empty the /tmp folder afterwards.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.