Jump to content


Photo

ERROR 500

ERROR 500 x2_actions staff response

  • Please log in to reply
2 replies to this topic

#1 grimmmay

grimmmay

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 23 June 2017 - 08:50 PM

Hello,

I am getting the following error right after I log into the application.  The error also shows up when I click on the following tabs: Activity, Contacts, Accounts, Marketing, Leads, Opportunities, and some others.  However, some tabs like Admin, Email, Reports do not generate the error when I click on them.

 

What might be the issue here?  Thanks in advance for your help!

 

Error Code: 500
Error Message: The table "x2_actions" for active record class "Actions" cannot be found in the database.
Stack Trace: [click to toggle display]

CDbException in /home/wp_29ynvk/familyfuntwincities.com/crm/protected/modules/actions/models/Actions.php(173)
#0 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(Object(Actions))
#1 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/db/ar/CActiveRecord.php(138): CActiveRecord->getMetaData()
#2 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/modules/actions/models/Actions.php(173): CActiveRecord->__get('isNewRecord')
#3 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/db/ar/CActiveRecord.php(396): Actions->behaviors()
#4 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/models/X2Model.php(278): CActiveRecord::model('Actions')
#5 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/views/profile/_viewEvent.php(39): X2Model::model('Actions')
#6 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(130): require('/home/wp_29ynvk...')
#7 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/wp_29ynvk...', Array, false)
#8 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/zii/widgets/CListView.php(291): CBaseController->renderFile('/home/wp_29ynvk...', Array)
#9 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/zii/widgets/CBaseListView.php(181): CListView->renderItems()
#10 [internal function]: CBaseListView->renderSection(Array)
#11 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/zii/widgets/CBaseListView.php(164): preg_replace_callback('/{(\\w+)}/', Array, '{pager} {items}')
#12 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/zii/widgets/CBaseListView.php(149): CBaseListView->renderContent()
#13 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/controllers/x2base.php(829): CBaseListView->run()
#14 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/views/profile/_activityFeed.php(359): x2base->widget('zii.widgets.CLi...', Array)
#15 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(126): require('/home/wp_29ynvk...')
#16 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/wp_29ynvk...', Array, true)
#17 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(869): CBaseController->renderFile('/home/wp_29ynvk...', Array, true)
#18 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/views/profile/activity.php(61): CController->renderPartial('_activityFeed', Array)
#19 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(126): require('/home/wp_29ynvk...')
#20 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/wp_29ynvk...', Array, true)
#21 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(869): CBaseController->renderFile('/home/wp_29ynvk...', Array, true)
#22 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/controllers/x2base.php(727): CController->renderPartial('activity', Array, true)
#23 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/controllers/ProfileController.php(1601): x2base->render('activity', Array)
#24 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/actions/CInlineAction.php(49): ProfileController->actionActivity()
#25 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#26 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(133): CController->runAction(Object(CInlineAction))
#27 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/controllers/x2base.php(579): CFilterChain->run()
#28 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#29 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#30 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#31 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(1145): CFilter->filter(Object(CFilterChain))
#32 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(Object(CFilterChain))
#33 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#34 /home/wp_29ynvk/familyfuntwincities.com/crm/protected/controllers/x2base.php(579): CFilterChain->run()
#35 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#36 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#37 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#38 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#39 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#40 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/filters/CFilterChain.php(130): CFilter->filter(Object(CFilterChain))
#41 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(291): CFilterChain->run()
#42 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#43 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CWebApplication.php(282): CController->run('activity')
#44 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/web/CWebApplication.php(141): CWebApplication->runController('profile/activit...')
#45 /home/wp_29ynvk/familyfuntwincities.com/crm/framework/base/CApplication.php(185): CWebApplication->processRequest()
#46 /home/wp_29ynvk/familyfuntwincities.com/crm/index.php(65): CApplication->run()
#47 {main}

X2Engine Version: 6.6
PHP Version: 7.0.14

 



#2 X2Raymond

X2Raymond

    Advanced Member

  • Administrators
  • 972 posts
  • LocationSanta Cruz, CA

Posted 27 June 2017 - 10:04 AM

Is this instance a new installation of X2CRM? It sounds as if the application installation did not fully complete, or that a different database is configured. Please verify your database settings in the file protected/config/X2Config.php and ensure that the database you initially installed to is still configured. Then, please examine your MySQL tables and verify the presence of the base tables, like x2_actions, x2_contacts, x2_accounts, etc, with the command "SHOW TABLES;"

 

The reason that some of the pages do not lead to those errors is that data may not be being loaded on those pages. This is usually the case for more visual pages, like the admin panel.



#3 grimmmay

grimmmay

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 10 July 2017 - 07:52 PM

Thanks for your reply!  It turns out that the issue was caused when my hosting provider restored my DB they renamed some tables with a strange prefix in the name.  Once I removed the name prefix on a few tables, all was well again.







Also tagged with one or more of these keywords: ERROR 500, x2_actions, staff response

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users