JDatabaseMySQL::query: 1146 - Table 'jos_jce_plugins' doesn't exist SQL=SELECT id FROM jos_jce_plugins
|
 |
 |
|
Tutorials -
Joomla
|
|
Written by Ross Alvarez
|
|
Saturday, 14 March 2009 07:30 |
|
While installing JCE Component for Joomla 1.5, it gives me the following error: JDatabaseMySQL::query: 1146 - Table 'ivibe_joomla.jos_jce_plugins' doesn't exist SQL=SELECT id FROM jos_jce_plugins
Here's what I did to resolve it...
500 - An error has occurred.
|
|
JDatabaseMySQL::query: 1146 - Table 'jos_jce_plugins' doesn't exist SQL=SELECT id FROM jos_jce_plugins
| Call stack |
| # |
Function |
Location |
| 1 |
JAdministrator->dispatch() |
/public_html/j15/administrator/index.php:67 |
| 2 |
JComponentHelper->renderComponent() |
/public_html/j15/administrator/includes/application.php:136 |
| 3 |
require_once() |
/public_html/j15/libraries/joomla/application/component/helper.php:162 |
| 4 |
JCEHelper->checkPlugins() |
/public_html/j15/administrator/components/com_jce/jce.php:75 |
| 5 |
JDatabaseMySQL->loadResult() |
/public_html/j15/administrator/components/com_jce/helper.php:47 |
| 6 |
JDatabaseMySQL->query() |
/public_html/j15/libraries/joomla/database/database/mysql.php:355 |
| 7 |
JError->raiseError() |
/public_html/j15/libraries/joomla/database/database/mysql.php:231 |
| 8 |
JError->raise() |
/public_html/j15/libraries/joomla/error/error.php:171 |
| 9 |
JException->__construct() |
/public_html/j15/libraries/joomla/error/error.php:136 |
|
Solution: I have root access to my server so this is pretty easy for me.
- Unzip com_jce_151.zip
- Find which file is creating the table by typing the command:
find . | xargs grep jce_plugins
The following file creates the missing table: /administrator/components/com_jce/sql/install.mysql.sql
- Execute the SQL manually from mysql prompt to create the missing table or you can do it via phpMyAdmin by cutting and pasting the SQLs
Obviously there is a bug with the JCE Component installer. If the developer reads this my environment is PHP 5.x on 64bit AMD server.
|
|
Last Updated on Saturday, 14 March 2009 21:54 |
