https://github.com/ThinkUpLLC/ThinkUp/issues/1908

[dosch]

Hey Thinkuppers,

Today I downloaded the latest code from Github. I really want to use your lovely work as it is truly a nice way to keep taps on my social networks.

But, I keep on running into the same issue as I did some months ago, and which still doesn't seem to be resolved. I ran the previous version of Thinkup for many years without any problems... so I really hope this is just a minor thing...

I followed the step-by-step installation guide without any issues, confirmed my account via the email link and then tried to login.

Subsequently I get the following error:

Database error! ThinkUp could not execute the following query: INSERT INTO tu_cookies (owner_email, cookie) VALUES (:email, :cookie) Details: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'thinkup.tu_cookies' doesn't exist

This is the same error as mentioned in this (closed) Github bug report. Gina Trapani closed that issue and pasted a link to the docs. But there I can't find the solution to this issue. I also already posted to this list in January in reply to someone else having the same issue. This person seemed to have resolved the issue bu running a database upgrade.

My host allows me to choose which PHP version I use, currently I am on 5.5. This seems to be alright.
I can not run the upgrade script from install/upgrade.php as only admins can do that, and I fail to login to prove I am an admin.
If I upgrade from the command line I get

Your ThinkUp database structure is up to date.

I'd be very happy if someone can give me a tip on how to make this work.
Thank you,
Dosch

[Moussa Clarke]

Hey there

Check my reply to Ovidiu - it might help you :-)

https://groups.google.com/d/msg/thinkup/X8gHUFcV2vU/6WMkKnXHBgAJ

[Moussa Clarke]

I can confirm that the following works, at least on my system :-)

Download the latest master from Github. Set up your database & user etc.

Rename the following file

/webapp/install/build-db_mysql-upcoming-release.sql

to

/webapp/install/sql/build-db_mysql.sql

(the latter file already exists, so you could either rename that too or just discard it)

Visit webapp/install in your browser - database schema should all be up to date.

If you still need to check for errors, just switch on debug in the config file. (config.inc.php)

$THINKUP_CFG['debug'] = true;

Hope that helps!

[Moussa Clarke]

oops, path for that file to rename should be

/webapp/install/sql/build-db_mysql-upcoming-release.sql

:)