Strange error regarding feeds | GitHub Installation | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
Strange error regarding feeds
No permission to create posts
July 17, 2015
4:02 am
Avatar
dvdl16
New Member
Members
Forum Posts: 2
Member Since:
July 17, 2015
sp_UserOfflineSmall Offline

Hi Thingspeak team!

First of all, thanks for this wonderful open source project.
I wanted to test it out by installing Thingspeak on Ubuntu. Everything installed successfully, and visiting localhost:3000 takes me to the correct page. Everything seems to be working fine, except the showing of charts. The text "Invalid channel" is displayed in the chart area. In the console, some calls fail (see error messages below).
Also, trying to view the data (e.g. localhost:3000/channels/2/feed.json?key=....) fails.

Data is logged successfully through the API (if I export the data, it is there). I'm using sqlite3.

Here is the error messages I'm getting:
http://qcfresh.com/ErrorMessage.html
http://qcfresh.com/ErrorMessage2.html

Any ideas?

July 17, 2015
8:41 am
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

You may want to try using MySQL instead. I'm not sure if sqlite3 has the ability to use the advanced indexes required for quick data retrieval, and we've never tested on sqlite3.

lee

July 17, 2015
10:20 am
Avatar
dvdl16
New Member
Members
Forum Posts: 2
Member Since:
July 17, 2015
sp_UserOfflineSmall Offline

Thanks Lee!

I was mistaken, I'm currently using postgresql (as I wanted to test it later on Heroku) - and I learned as per this link (http://blog.2ndquadrant.com/hinting_at_postgresql/), postgresql consciously doesn't support advanced indexes. I've removed the "FORCE INDEX" code from feed_factory.rb, and it seems it's working now! I'll monitor and check for performance issues, but I doubt it will be a problem with my small scale implementation.

I'll keep my options open to MySQL in the future.

Thanks so much! Smile

July 20, 2015
8:43 am
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

Glad you got things working. That index is important for quick retrievals at scale, but won't matter if you don't have too much data. I actually expected MySQL to use that index automatically (without it being forced); hopefully PostgreSQL will use the proper index. You can also try using MariaDB in the future, which should be a drop-in replacement for MySQL.

lee

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

khanhNguyen_CT, susyburr, quijano__, meosuckhoe, briskpanda, Dejw0089

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457