Jump to content


Photo

Getting 500 error on saving docs.


  • Please log in to reply
5 replies to this topic

#1 chad1964

chad1964

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 10 December 2020 - 08:10 AM

Here is the output - Any insight would be appreciated as I have even done multiple re-installs using php7.0 up to php7.3 to test to see if it was just this install.
 

It looks like the application ran into an unexpected error.

We apologize for the inconvenience and would like to do our best to fix this issue. If you would like to make a post on our forums we can actively interact with you in getting this resolved. If not, simply sending the error report helps us immensely and will only improve the quality of the software. Thanks!
Send Error Report
Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flhomesa_crm.x2_info_docs' doesn't exist
Stack Trace: [click to toggle display]
CDbException in /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(543)
#0 /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/flhomesandcondos/public_html/crm/protected/modules/docs/models/Docs.php(118): CDbCommand->queryAll()
#2 /home/flhomesandcondos/public_html/crm/protected/modules/docs/models/Docs.php(109): Docs->infoDocCheck()
#3 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveRecord.php(1132): Docs->afterSave()
#4 /home/flhomesandcondos/public_html/crm/protected/models/X2Model.php(904): CActiveRecord->update(NULL)
#5 /home/flhomesandcondos/public_html/crm/protected/modules/docs/controllers/DocsController.php(369): X2Model->save()
#6 [internal function]: DocsController->actionUpdate('53')
#7 /home/flhomesandcondos/public_html/crm/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DocsController), Array)
#8 /home/flhomesandcondos/public_html/crm/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DocsController), Object(ReflectionMethod), Array)
#9 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#10 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#11 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(586): CFilterChain->run()
#12 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#13 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#14 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#15 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#16 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#17 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#18 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(291): CFilterChain->run()
#19 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#20 /home/flhomesandcondos/public_html/crm/framework/web/CWebApplication.php(282): CController->run('update')
#21 /home/flhomesandcondos/public_html/crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('docs/docs/updat...')
#22 /home/flhomesandcondos/public_html/crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#23 /home/flhomesandcondos/public_html/crm/index.php(67): CApplication->run()
#24 {main}
X2Engine Version: 8.0
PHP Version: 7.1.33

 



#2 jack

jack

    Admin

  • Administrators
  • 66 posts

Posted 10 December 2020 - 11:42 AM

Comment out  line (109) Docs->infoDocCheck() in protected/modules/docs/models/Docs.php that should fix the issue, we will patch it in the next update.



#3 chad1964

chad1964

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 10 December 2020 - 05:44 PM

Confirm that this worked for me - ty.



#4 smurf291

smurf291

    Newbie

  • Members
  • Pip
  • 5 posts
  • LocationWaimate, New Zealand

Posted 15 January 2021 - 03:53 PM

Hi, had the same with the 500 Error, so followed the instructions as above, and now cannot access the editor and previous Email Template that was created, now shows nothing. Have reverted code back to original, however this not seem to have fixed the problem.

Can someone tell me where I can access this file - protected/modules/docs/models/Docs.php, and update.

 

This will hopefully fix current issue, although I doubt it will rectify the Error 500 issue.

 

Any assistance, guidance greatly appreciated



#5 jack

jack

    Admin

  • Administrators
  • 66 posts

Posted 19 January 2021 - 09:47 AM

Hi Smurf,
You can find the file in the location where you set up your x2 instance, typically it is in the "public_html" folder or what ever folder host the content for your website.
-Jack



#6 smurf291

smurf291

    Newbie

  • Members
  • Pip
  • 5 posts
  • LocationWaimate, New Zealand

Posted 20 January 2021 - 10:40 AM

Jack,

 

Thanks for that, appreciate the response, however I think I must not have explained myself properly. Was actually looking for the update file to upload and overwrite to see whether that would fix the issue. It didn't, so i went ahead and did a completely new install of X2CRM. Now on version 8 and issues still remain. Getting 500 Error on save docs, although docs are actually saved. Also getting 500 error on calendar creation and viewing, although have access to all calendar attributes via another user login, not system admin.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users