Hi I am new to K2 and installed latest version of Joomla, using default Beez template. I added a few menus, categories and articles also one module (Shackslides). I then installed K2 but have not been able to use any of it as I have errors whenever I do, I tried converting my joomla content and the results came back saying the process had completed but no categories or articles appear in K2. I switched on debugging and opened k2, the following error appeared.


500 - **An error has occurred.**
JDatabaseMySQL::query: 1146 - Table 'imoyes_pdpEU.wjnf6_k2_items' doesn't exist SQL=SELECT COUNT(*) FROM wjnf6_k2_items AS i WHERE trash=0

can anyone shed any light on this for me.

Thanks

Things are worse than I thought, after switching on debugging; I no longer have access to my site or the admin. When I login to the backend I just get a blank screen. Hope this is something you can help with??

Hi. The error tells you that a whole table is missing. Try to uninstall K2 and install it again, in case something went wrong during the installation. Note that uninstalling K2 will delete all your K2 data, so make sure to make a backup of them if you want to keep them.

Thanks for replying Lefteris Kavadas

K2 failed to import my joomla data so there is nothing to lose by uninstalling K2. Since I turned on the debugger my site is no longer accessible not even the back end. I can get as far as the joomla administrator login screen but when I log in I just get a blank screen so I can’t uninstall K2. When I try to access the front end from a browser I get the following screen (see Attached). This module has totally disabled my site and may have wiped out many hours of work adding content. If anyone has experience of this type of problem then I would be grateful for any advice on how to recover my site.

**Error**: 500
**You may not be able to visit this page because of:**

**an out-of-date bookmark/favourite**
**a search engine that has an out-of-date listing for this site**
**a mistyped address**
**you have no access to this page**
**The requested resource was not found.**
**An error has occurred while processing your request.**
**Please try one of the following pages:**

**Home Page**
**Search this site**
**If difficulties persist, please contact the System Administrator of this site and report the error below.**.

JDatabaseMySQL::query: 1146 - Table 'imoyes_pdpEU.wjnf6_k2_comments' doesn't exist SQL=SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname FROM wjnf6_k2_comments as c LEFT JOIN wjnf6_k2_items as i ON i.id=c.itemID LEFT JOIN wjnf6_k2_categories as category ON category.id=i.catid WHERE i.published=1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-09-24 18:48:57' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-09-24 18:48:57' ) AND i.trash=0 AND i.access IN(1,1) AND category.published=1 AND category.trash=0 AND category.access IN(1,1) AND c.published=1 ORDER BY c.commentDate DESC LIMIT 0, 5

Call stack
# Function Location
1 JSite->render() D:\hshome\imoyes\pideltapi.eu\index.php:48
2 JDocumentHTML->render() D:\hshome\imoyes\pideltapi.eu\includes\application.php:271
3 JDocumentHTML->_renderTemplate() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\document\html\html.php:433
4 JDocumentHTML->getBuffer() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\document\html\html.php:655
5 JDocumentRendererModules->render() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\document\html\html.php:371
6 JDocumentRendererModule->render() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\document\html\renderer\modules.php:39
7 JModuleHelper::renderModule() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\document\html\renderer\module.php:107
8 include() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\application\module\helper.php:175
9 modK2CommentsHelper::getLatestComments() D:\hshome\imoyes\pideltapi.eu\modules\mod_k2_comments\mod_k2_comments.php:49
10 JDatabase->loadObjectList() D:\hshome\imoyes\pideltapi.eu\modules\mod_k2_comments\helper.php:80
11 JDatabaseMySQL->execute() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\database\database.php:1100
12 JError::raiseError() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\database\database\mysql.php:548
13 JError::raise() D:\hshome\imoyes\pideltapi.eu\libraries\joomla\error\error.php:251

Disable the debugger by editing the configuration.php file by your own. After that try again to uninstall K2 and install it again. Not sure why the table is missing.

Thanks Lefteris, I dropped all the database tables and deleted all files/folders from my domain and restored using akeeba backup file. I took a backup of my site before installing K2, not sure if I want to go through that again I may try installing K2 on a demo site first.

Thanks anyway.
Moyzie

You are welcome.