Loading...
 
Features / Usability

Features / Usability


[Solved] HTTP 500 error while accessing Control Panel -> Score

posts: 2 India

Hi,
I've recently installed Tiki 18.2 and things were working fine until yesterday, when suddenly, I wasn't able to access Score preferences from the Control Panel anymore. I can access all other preferences though. Please note that there has been no upgrades to the environment & other dependencies. I looked into the apache log and this is what it reports:

Wed Dec 12 10:45:20.633851 2018 :error pid 11311 client 192.168.1.62:33890 PHP Fatal error: Uncaught Error: Cannot use object of type stdClass as array in /var/www/html/tiki-18.2/lib/score/scorelib.php:157\nStack trace:\n#0 /var/www/html/tiki-18.2/admin/include_score.php(20): ScoreLib->get_all_events()\n#1 /var/www/html/tiki-18.2/tiki-admin.php(548): include_once('/var/www/html/t...')\n#2 {main}\n thrown in /var/www/html/tiki-18.2/lib/score/scorelib.php on line 157, referer: http://192.168.5.155/tiki/tiki-admin.php


I've tried some of the possible solutions suggested in troubleshooting section, for instance:

  1. Use Tiki Check to detect issues.
  2. Clear all Tiki caches by selecting Admin > Tiki Cache from the menu.
  3. Clear your browser's cache by using Ctrl+F5. Refer to your browser's help system for details.
  4. Clear your browser's cookies. Refer to your browser's help system for details.
  5. Try another browser, such as Firefox, Internet Explorer, Safari, Chrome, or Opera.
  6. Check your web server's error log. Any file or folder permission problems are commonly shown in the log.
  7. Are your Tiki file and folder perms configured properly? If you have shell access to the server, use sh setup.sh.
  8. Attempt to log out of your Tiki, then log in again.
  9. Check integrity of your files.
  10. Check in MySQL for the table tiki_actionlog to see what the latest changes were before the issue started.


The problem started when I was browsing the tiki_object_scores table via mysql interface, and I changed a score setting from the score preferences in Tiki UI. Please note that I did not explicitly modify the database manually. On trying to save the settings, I got HTTP 500 Error for the first time and rest is history.

Please also note that scoring mechanism appears to be working, since it is updating the score on performing configured actions.

Here is a screenshot from browser's javascript console:
Tiki Error
I have no idea what is going on so any help in this regard would be highly appreciated.

Thanks

posts: 2 India
So I just logged into the DB via mysql interface, and manually removed the score event entry that I was trying to remove in the original action via UI (when the problem first appeared), and the problem got solved. I'm not sure what the root cause was though. Perhaps, it appears that some action caused this table to be in an inconsistent state, or maybe, the data was cached somewhere, and, when I explicitly modified the DB, it burnt that cache and rebuilt the entries. I'm merely speculating here.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting