Author Topic: FPP 1.10 + MessageQueue +MatrixTools + Cron + Twitter = :(  (Read 523 times)

Offline lightshow

  • Newbie
  • *
  • Join Date: Jan 2018
  • Location:
  • Posts: 1
  • Kudos: 0
FPP 1.10 + MessageQueue +MatrixTools + Cron + Twitter = :(
« on: January 09, 2018, 04:15:09 PM »
Howdy,

Ive read most of the threads pertaining to the Twitter plugin and getting it working.

Here is my active issue, I am hoping someone can help point me in the right direction.

1. Twitter app configured and operational.
   - It is actively writing to the DB, meaning I can tail the DB file directly and see the twitter messages stored.
Code: [Select]
tail /home/fpp/media/config/FPP.Twitter.db
�;�P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�B�WtablemessagesmessagesCREATE TABLE messages (messageID INTEGER PRIMARY KEY AUTOINCR1515532956| RT%2B%2540CoryKennedy%253A%2B%2540Dave_Cochran%2B%2540Ginsberg5150%2B%2523SecKC%2Bcan%2Bhelp%2521%2B%2Bhttps%253A%252F%252Ft.co%252FwS0wR1YAPY | Twitter | 950839256704012288
1515532956| RT%2B%2540CoryKennedy%253A%2BNeed%2Bsome%2Bhacking%2Bmusic%253F%2B%2B%2523SecKC%25E2%2580%2599s%2Bown%2B%2540jonny55555%2Bput%2Btogether%2Ba%2Bplaylist%2Bof%2Bsongs%2Bhe%2Bcommonly%2Bplays.%2B%2B%2523NEEDINPUT%2Bhttps%253A%252F%25E2%2580%25A6 | Twitter | 950839240350404610

2. MatrixMessage.log shows
2018-01-09 05:07:01 PM:  : [5718] MESSAGE QUEUE: getting NEW Twitter messages from Twitter /home/fpp/media/config/FPP.Twitter.db DB 2018-01-09 05:07:01 PM:  : [5718] MESSAGE QUEUE: plugin Twitter last read: 0 2018-01-09 05:07:01 PM:  : [5718] MESSAGE QUEUE: Writing high water mark for plugin: Twitter LAST_READ = 0

3. MessageQueue.log shows
2018-01-09 04:33:45 PM:  : [3553] CREATING Messages in db: : CREATE TABLE IF NOT EXISTS messages (messageID INTEGER PRIMARY KEY AUTOINCREMENT, timestamp int(16) NOT NULL, message varchar(255), pluginName varchar(64), pluginData varchar(64)); 2018-01-09 04:43:54 PM:  : [3557] plugin update file: /home/fpp/media/plugins/MessageQueue/pluginUpdate.inc 2018-01-09 04:43:55 PM:  : [3557] CREATING Messages in db: : CREATE TABLE IF NOT EXISTS messages (messageID INTEGER PRIMARY KEY AUTOINCREMENT, timestamp int(16) NOT NULL, message varchar(255), pluginName varchar(64), pluginData varchar(64));

4. Matrix Tools is working and my pixel overlay is also allowing me to display test or draw.

I think I have isolated the issue to matrix message not reading the db file correctly.  I have tried a handful of things including removing DB. various dev branches and having had any luck.



 

Back to top