Timeline for Error 1146 while installing K2 extension
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 9, 2015 at 11:40 | comment | added | z3r0c001 | You need to maintain the same DB prefix throughout site. You cannot change it to any random string. If it is jos_. Then rename the table to jos_k2_categories. | |
| Feb 9, 2015 at 10:45 | comment | added | Splendid Digital Solutions | Just figured out database prefix bq1ry_ from Joomla backend, Global Configuration, Server option. Tried to change to jos_ which broke the website. Restored after accessing configuration.php from root of C-panel hosting and changing database prefix from jos_ to bq1ry_. | |
| Feb 8, 2015 at 10:18 | comment | added | Splendid Digital Solutions | @z3r0c001 I understand need to have jos_ as my database prefix. Right now, is bq1ry_ my database prefix? (bit.ly/1DRbWGj) If so, do I need to change to jos_? | |
| Feb 1, 2015 at 11:12 | comment | added | z3r0c001 | Take a look at this forum.joomla.org/viewtopic.php?t=282559 | |
| Jan 28, 2015 at 11:35 | comment | added | Splendid Digital Solutions | Could anyone suggest any other way to address 1146 error faced in this case as unable to download new applications. | |
| Jan 24, 2015 at 13:57 | comment | added | Splendid Digital Solutions | @Lodder Getting 1146 error. Under Extension Manager, Database 'Database table structure is up to date.' Under Joomla Update 'No Updates available. You already have the latest Joomla! version, 3.3.6.' Also, not upgraded from Joomla 2.5; fresh Joomla 3.0 site. | |
| Jan 24, 2015 at 13:25 | comment | added | Lodder | @BagraRajeev - Have a look at this and fix the database if any errors are shown: joomlabamboo.com/blog/how-to-joomla/… | |
| Jan 24, 2015 at 13:23 | comment | added | Splendid Digital Solutions | @Lodder Got message 'Your SQL query has been executed successfully.' Let me check about 1146 error after installing K2 extension. This problem is not limited to K2. Today morning, tried to install another extension (mod_news_pro_gk5_J!3) and got the same error. | |
| Jan 24, 2015 at 13:15 | comment | added | Lodder | @BagraRajeev - Your are on the Query tab. Go to the SQL tab instead, and paste it in there ;) | |
| Jan 24, 2015 at 13:14 | comment | added | Splendid Digital Solutions | @Lodder Trying to implement your advise. Pasted above code under 'SQL Query on Database iWebazoid'. On doing so, got message: 'You have to choose at least one column to display' (bit.ly/1yORo1Z). | |
| Jan 24, 2015 at 9:34 | comment | added | Lodder | @BagraRajeev - I've removed all the rubbish from the SQL dump in this answer and added your table prefix so you can now copy and paste it into PhpMyAdmin ;) | |
| Jan 24, 2015 at 9:33 | history | edited | Lodder | CC BY-SA 3.0 |
deleted 1295 characters in body
|
| Jan 24, 2015 at 3:13 | comment | added | Splendid Digital Solutions | @Lodder Could you kindly suggest a way (tutorial) for cleaning up the SQL dump relevant for my purpose as I have little idea about the same. | |
| Jan 23, 2015 at 11:50 | comment | added | Splendid Digital Solutions | Changed table name to bq1ry_k2_categories into the code. Should I paste the above query under SQL query in database iWebazoid keeping everything else as it is (print screen link for reference bit.ly/1xIGp5U). | |
| Jan 23, 2015 at 9:10 | comment | added | Lodder | I would suggest you clean up the SQL dump by removing all comments etc so that only the actual queries are there | |
| Jan 23, 2015 at 9:01 | history | answered | z3r0c001 | CC BY-SA 3.0 |