Can't get the github version to work

[Ovidiu Pacuraru]

Beta10 was working with glitches so I thought to try the latest from github. 

Deleted my version, dropped the tables, cloned the one from git and am hitting quirks.

I admit I only copied the content of the webapp folder into my root.

install works flawless then seeing this as soon as I want to login: 

2016/04/15 10:58:55 [error] 26394#26394: *374 FastCGI sent in stderr: "PHP message: PHP Catchable fatal error:  Argument 1 passed to InstanceMySQLDAO::getByOwner() must be an instance of Owner, null given, called in /var/www/clients/client2/web77/web/_lib/controller/class.InsightStreamController.php on line 161 and defined in /var/www/clients/client2/web77/web/_lib/dao/class.InstanceMySQLDAO.php on line 232" while reading response header from upstream, client: 51.254.252.83, server: smstats.foodandchatter.co.za, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/lib/php5-fpm/web77.sock:", host: "smstats.foodandchatter.co.za"

[Ovidiu Pacuraru]

After hitting all sort of problems, I manually imported all teh needed tables from teh sql installation files and can now install and login but cannot do anythign as I am stopped by this message:

 Database error! ThinkUp could not execute the following query: SELECT id, full_name, email, is_admin, is_activated, last_login, email_notification_frequency, is_free_trial, joined, membership_level FROM tu_owners ORDER BY last_login DESC; Details: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_free_trial' in 'field list'

So what is the deal here, is ThinkUp from GitHub not free to use? Why is it looking for a missing is_free_trial column?

[Moussa Clarke]

You probably need to upgrade the database schema - I had a similar issue (for reference, I'm on commit d708ac07d13c965f22b8437bdb6ca0721010d0d6 dated 26/01/16)

Try cd into webapp/install/cli/ and run php upgrade.php --with-new-sql

Your mileage may vary with that though. It didn't work for me, just threw a different error, so I wound up looking at webapp/install/sql/build-db_mysql-upcoming-release.sql and running the SQL manually in phpMyAdmin to create the necessary tables/columns etc as the app throws errors, which (eventually!) seems to work fine. Switch on debug in the config so you can see what's happening.

I'm guessing you might also have some luck if you rename that last file to build-db_mysql.sql (replacing the other one) and start the installation from scratch? I haven't checked the code to see if it actually uses that script on install, but it would make sense.

Hope that helps!