Ad Widget

Collapse

Updated to 2.2.0 All went fine but Web Frontend has sql errors.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ejy
    Junior Member
    • Nov 2013
    • 2

    #1

    Updated to 2.2.0 All went fine but Web Frontend has sql errors.

    Compiled, back-up, installed, started waited for db upgrade all went fine.

    Going to the dash board display errors on the status boxes:

    Error in query [SELECT MAX(e.eventid) AS eventid,e.objectid FROM events e WHERE e.object=0 AND (e.objectid IN ('13501','13492','14287')) AND (e.value IN ('1')) AND e.value_changed=1 GROUP BY e.objectid] [Unknown column 'e.value_changed' in 'where clause']
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:569]
    mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:570]

    Other status boxes have more errors but leaving those out to keep this short.

    ideas?
  • ejy
    Junior Member
    • Nov 2013
    • 2

    #2
    Fixed my own issue....

    Be sure to backup then copy your new frontend/php files to the correct location.

    Sorry for the false alarm.

    Comment

    Working...