ffalt/aufschreib

classify tweets & generate statistics

aufschreib's Issues

TypeError in "1 prepare.js" with usedb = true

I followed your setup guide and executed node "1 prepare.js" on step 4.

On the first run data/messages.json contained only your example (without semicolon and ellipsis of course), the second time data/messages.json was filled with random tweets via https://stream.twitter.com/1.1/statuses/filter.json. Both times the same error occurred (see console output)

The database contains a table tweets with all tweets from data/messages.json, but the site says

Nix :]

Running with usedb = false, the site shows all tweets and but doesn't work (that would be the another issue/fix).

Could you provide a sample data/messages.json that works for you with mysql?

Console Output:

    […]
[Tweets] Connecting to DB
[DB] Preparing Tweets
[DB] Creating Tables
[DB] Tweet Table Created
[DB] VoteUsers Table Created
[DB] Votes Table Created
[DB] Pumping Tweets to DB
[DB] Tweets stored

TypeError: undefined is not a function
    at /Users/ckintner/aufschreib/1 prepare.js:55:4
    at Query._callback (/Users/ckintner/aufschreib/tweets_mysql.js:139:4)
    at Query.Sequence.end (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/sequences/Sequence.js:66:24)
    at Query._handleFinalResultPacket (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/sequences/Query.js:139:8)
    at Query.OkPacket (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/sequences/Query.js:73:10)
    at Protocol._parsePacket (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/Protocol.js:169:24)
    at Parser.write (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/Parser.js:62:12)
    at Protocol.write (/Users/ckintner/aufschreib/node_modules/mysql/lib/protocol/Protocol.js:36:16)
    at write (_stream_readable.js:547:24)
    at flow (_stream_readable.js:556:7)

Additional information

I'm running

• Mac OS X 10.8.2
• node 0.10.0
• MySQL Ver 5.6.10 for osx10.7 on x86_64 (MySQL Community Server (GPL))
• mysql (node driver) 2.0.0-alpha7