Phoca Forum

Get this error trying to upgrade but it shows it has upgraded and now have errors in Category's

500 - An error has occurred.

JDatabaseMySQL::query: 1146 - Table 'nfsda.jos_phocagallery_user_category' doesn't exist SQL=SELECT * FROM `jos_phocagallery_user_category` LIMIT 1;

Call stack
# Function Location
1 JAdministrator->dispatch() /home/nfsda/nfsda.org/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/nfsda/nfsda.org/administrator/includes/application.php:136
3 require_once() /home/nfsda/nfsda.org/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/nfsda/nfsda.org/administrator/components/com_phocagallery/admin.phocagallery.php:40
5 PhocaGalleryCpControllerPhocaGalleryinstall->upgrade() /home/nfsda/nfsda.org/libraries/joomla/application/component/controller.php:236
6 JDatabaseMySQL->loadResult() /home/nfsda/nfsda.org/administrator/components/com_phocagallery/controllers/phocagalleryinstall.php:832
7 JDatabaseMySQL->query() /home/nfsda/nfsda.org/libraries/joomla/database/database/mysql.php:355
8 JError->raiseError() /home/nfsda/nfsda.org/libraries/joomla/database/database/mysql.php:231
9 JError->raise() /home/nfsda/nfsda.org/libraries/joomla/error/error.php:171
10 JException->__construct() /home/nfsda/nfsda.org/libraries/joomla/error/error.php:136

Let me know what i could do to fix this.

Hi, while upgrading the debug mode should be disabled (there is some action which can cause error but it has no effect on running Phoca Gallery - it means if you will upgrade without enabling debug mode, nothing will happen there).

Jan