ginatrapani/ThinkUp — Issue #1269: Front page database error due to a table prefix
Author: paazmaya
Created: 2012-03-07 23:12:07+00:00
State: open

After updating to the current master version:

Database error!
ThinkUp could not execute the following query:
SELECT p.post_text, l.expanded_url, ls.short_url, ls.click_count FROM thinkup_links_short ls INNER JOIN thinkup_links l ON l.id = ls.link_id INNER JOIN tu_posts p ON p.id = l.post_key WHERE p.author_username=:author_username AND p.network=:network AND ls.click_count > 0 AND p.in_retweet_of_post_id IS NULL GROUP BY short_url ORDER BY p.pub_date DESC LIMIT :limit
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tu_posts' doesn't exist

My config has table prefix different from the default, thus I am assuming that is the reason for this to fail.