1 Topic by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Topic: NBN Species Dict Sync - not working?

I've just enabled the NBN species dict sync warehouse module and have tried to sync the taxon groups, but although it says it completes (after a minute or so), nothing appears in the database. Does this module not work?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: NBN Species Dict Sync - not working?

Actually, tell a lie, they're in the warehouse db; they're just not showing in the UI:

DB: https://gist.github.com/3874477
UI: http://i.imgur.com/7yrLd.png

That's surely not right? The Taxon Groups page should display the groups in the database, no?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

3 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: NBN Species Dict Sync - not working?

Indeed that is odd. What happens if you run the query 

select * from gv_taxon_groups

This is the same view used for grid population. Also if you have your logging level set to 4, then the application/logs folder will contain a log file with the actual query run to fill the grid.

John van Breda
Biodiverse IT

johnvanbreda's Website

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: NBN Species Dict Sync - not working?

Querying the view directly works:

https://gist.github.com/3874477

When I refresh the groups page, I'm not seeing any queries in the log. I'm on logging level 4 in config.php - $config['log_threshold'] = 4;

2012-10-12 14:46:55 +01:00 --- debug: Global GET, POST and COOKIE data sanitized
2012-10-12 14:46:55 +01:00 --- debug: Session Cookie Driver Initialized
2012-10-12 14:46:55 +01:00 --- debug: PgSQL Database Driver Initialized
2012-10-12 14:46:55 +01:00 --- debug: Database Library initialized
2012-10-12 14:46:55 +01:00 --- debug: Session Library initialized
2012-10-12 14:46:55 +01:00 --- debug: Auth Library loaded
2012-10-12 14:46:55 +01:00 --- debug: Cache Library initialized
2012-10-12 14:46:55 +01:00 --- debug: Auth Library loaded
2012-10-12 14:46:55 +01:00 --- debug: Session Library initialized

I've just done a TRUNCATE on the taxon_group table to clean it out and have tried re-running the sync, but it now doesn't work. A JS alert comes up, but it's empty:

http://i.imgur.com/EK3Bo.png

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

5 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: NBN Species Dict Sync - not working?

If anyone could supply me with a CSV of the groups that would probably serve just as well. I'm wondering if the NBN web services aren't functioning properly which is preventing the re-sync. I've just started getting the following error in my log:

2012-10-12 15:21:11 +01:00 --- error: NBN Dictionary Sync failed.
HTTP Error: socket read of headers timed out
Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website