_vf2.vf_UserCategory\' doesn\'t exist'

privateryan0

i get the following error when i try to access the homepage however i am able to access the dashboard
vanilla installed using Installatron
ive been searching around but couldnt find anything helpful
any ideas?

Table 'website_vf2.vf_UserCategory' doesn't exist
The error occurred on or near: /home/website.net/library/database/class.database.php

418: $this->closeConnection();

419: continue;

420: }

421:

422: trigger_error($message, E_USER_ERROR);

423: }

424:

425: }

426:

Backtrace:

/home/website.net/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/home/website.net/library/database/class.database.php:422] PHP::trigger_error();

[/home/website.net/library/database/class.sqldriver.php:1663] Gdn_Database->query();

[/home/website.net/library/database/class.sqldriver.php:884] Gdn_SQLDriver->query();

[/home/website.net/applications/vanilla/models/class.categorymodel.php:733] Gdn_SQLDriver->getWhere();

[/home/website.net/applications/vanilla/models/class.categorymodel.php:158] CategoryModel::joinUserData();

[/home/website.net/applications/vanilla/models/class.categorymodel.php:80] CategoryModel::categories();

[/home/website.net/applications/vanilla/models/class.discussionmodel.php:1132] CategoryModel::categoryWatch();

[/home/website.net/applications/vanilla/controllers/class.discussionscontroller.php:131] DiscussionModel->getCount();

[/home/website.net/applications/vanilla/controllers/class.discussionscontroller.php:131] DiscussionsController->index();

[/home/website.net/library/core/class.dispatcher.php:329] PHP::call_user_func_array();

[/home/website.net/index.php:44] Gdn_Dispatcher->dispatch();

Variables in local scope:

[Sql] 'select *
from vf_UserCategory UserCategory
where UserID = :UserID'

[InputParameters] array (
':UserID' => '1',
)

[Options] array (
'Type' => 'select',
'Slave' => NULL,
'ReturnType' => 'DataSet',
)

[ReturnType] 'DataSet'

[tries] 2

[try] 0

[PDO] array (
)

[PDOStatement] false

[ex] array (
)

[message] 'Table \'website_vf2.vf_UserCategory\' doesn\'t exist'

[code] 1146

[state] '42S02'

Need Help?

If you are a user of this website, you can report this message to a website administrator.

If you are an administrator of this website, you can get help at the Vanilla Community Forums.
Additional information for support personnel:

Application: Vanilla
Application Version: 2.2
PHP Version: 5.6.15
Operating System: Linux
Server Software: LiteSpeed
Referer: http://website.net/
User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:43.0) Gecko/20100101 Firefox/43.0
Request Uri: /discussions
Controller: PHP
Method: trigger_error

hgtonight

Check that the database website_vf2 exists and your db user has permissions to view, insert, and alter the db.

privateryan0

i can create user accounts through dashboard so db access is fine

is the vf_UserCategory table normal?? why would my install create all tables but UserCategory?

this is my db table list

vf_Activity
vf_ActivityComment
vf_ActivityType
vf_AnalyticsLocal
vf_Attachment
vf_Ban
vf_Category
vf_Comment
vf_Conversation
vf_ConversationMessage
vf_Discussion
vf_Draft
vf_Invitation
vf_Log
vf_Media
vf_Message
vf_Permission
vf_Photo
vf_Regarding
vf_Role
vf_Session
vf_Spammer
vf_Tag
vf_TagDiscussion
vf_User
vf_UserAuthentication
vf_UserAuthenticationNonce
vf_UserAuthenticationProvider
vf_UserAuthenticationToken
vf_UserComment
vf_UserConversation
vf_UserDiscussion
vf_UserMerge
vf_UserMergeItem
vf_UserMeta
vf_UserPoints
vf_UserRole

privateryan0

so looks like the issue was with Installatron
dont really know why
with Softaculous installer no problems

x00

go to

/utility/structure and run it.