Unknown column 'ip' in 'field list

[Tourist4Life]

After upgrading to MODx 1.2 I'm getting the following error after logging in to the manager

« MODX Parse Error »
MODX encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Unknown column 'ip' in 'field list' »
SQL > REPLACE INTO taiyoage_newwestcondos.modx_active_users (internalKey, username, lasthit, action, id, ip) VALUES (2, 'dean', '1483652662', '3', 1, '75.139.99.105')
Basic info
REQUEST_URI : http://www.new-westminster-condo.ca/manager/index.php?a=3&id=1
Manager action : 3 - Viewing data for resource
Referer : http://www.new-westminster-condo.ca/manager/index.php?a=1&f=tree
User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36
IP : 75.139.99.105
Benchmarks
MySQL : 0.0038 s (1 Requests)
PHP : 0.7577 s
Total : 0.7615 s
Memory : 1.7790298461914 mb

Backtrace

1 include_once()
manager/index.php on line 181
2 DBAPI->query()
manager/includes/accesscontrol.inc.php on line 192

[Deesen]

Did you run /install ;-)? The DB needs to be updated.

[Tourist4Life]

After running install it breaks. I will start another thread with the issues related to this.

[Deesen]

As mentioned before you need to run /install and the upgrade-process for the DB to be updated.

https://github.com/modxcms/evolution/blob/develop/install/setup.sql#L38

[Deesen]

It seems your version of setup.sql is not up to date. Your mentioned line has been removed on 02.10.2016 so MODX 1.2 and 1.2.1 both should not contain it:

47e780e#diff-5ff3f70e00decfe74911717663cc01b6L753

[modxuser]

@Tourist4Life If this issue is resolved can you close it please, if you are not sure how to, take a look here