Advanced search

Message boards : News : database fixed

Author Message
Travis Desell
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: 16 Jan 12
Posts: 1813
Combined Credit: 23,514,257
DNA@Home: 293,563
SubsetSum@Home: 349,212
Wildlife@Home: 22,871,482
Wildlife@Home Watched: 212,926s
Wildlife@Home Events: 51
Climate Tweets: 21
Images Observed: 774

              
Message 1606 - Posted: 11 Sep 2013, 15:29:35 UTC

Got things fixed faster than expected. Everything should be working now. Let me know if you run into any problems.

Profile Lemon
Send message
Joined: 10 May 13
Posts: 229
Combined Credit: 476,659
DNA@Home: 190,781
SubsetSum@Home: 225,957
Wildlife@Home: 59,921
Wildlife@Home Watched: 11,190,214s
Wildlife@Home Events: 0
Climate Tweets: 0
Images Observed: 0

        
Message 1607 - Posted: 11 Sep 2013, 15:37:51 UTC - in response to Message 1606.

validator is not running

Senilix
Send message
Joined: 2 Feb 12
Posts: 96
Combined Credit: 8,073,607
DNA@Home: 106,112
SubsetSum@Home: 114,729
Wildlife@Home: 7,852,766
Wildlife@Home Watched: 7,118,967s
Wildlife@Home Events: 1,563
Climate Tweets: 5
Images Observed: 26

            
Message 1608 - Posted: 11 Sep 2013, 15:47:14 UTC
Last modified: 11 Sep 2013, 15:53:04 UTC

Belden is working for me, but Blaisdell gives

MYSQL Error (1194): Table 'observations' is marked as crashed and should be repaired query: SELECT id, filename, duration_s, video_id from video_segment_2 vs2 WHERE vs2.crowd_status = 'UNWATCHED' AND vs2.release_to_public = true AND vs2.processing_status = 'DONE' AND species_id = 1 AND location_id = 2 AND vs2.crowd_obs_count < vs2.required_views AND NOT EXISTS (SELECT id FROM observations WHERE observations.video_segment_id = vs2.id AND user_id = 29) ORDER BY RAND() limit 1

Edit: Well, Belden shows a video, but 'submit' doesn't work.

Travis Desell
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: 16 Jan 12
Posts: 1813
Combined Credit: 23,514,257
DNA@Home: 293,563
SubsetSum@Home: 349,212
Wildlife@Home: 22,871,482
Wildlife@Home Watched: 212,926s
Wildlife@Home Events: 51
Climate Tweets: 21
Images Observed: 774

              
Message 1609 - Posted: 12 Sep 2013, 0:03:16 UTC - in response to Message 1608.

Belden is working for me, but Blaisdell gives

MYSQL Error (1194): Table 'observations' is marked as crashed and should be repaired query: SELECT id, filename, duration_s, video_id from video_segment_2 vs2 WHERE vs2.crowd_status = 'UNWATCHED' AND vs2.release_to_public = true AND vs2.processing_status = 'DONE' AND species_id = 1 AND location_id = 2 AND vs2.crowd_obs_count < vs2.required_views AND NOT EXISTS (SELECT id FROM observations WHERE observations.video_segment_id = vs2.id AND user_id = 29) ORDER BY RAND() limit 1

Edit: Well, Belden shows a video, but 'submit' doesn't work.


Should be fixed now! Sorry about the slow response, finally got out of an 8 hour marathon of teaching and meetings!

Profile Lemon
Send message
Joined: 10 May 13
Posts: 229
Combined Credit: 476,659
DNA@Home: 190,781
SubsetSum@Home: 225,957
Wildlife@Home: 59,921
Wildlife@Home Watched: 11,190,214s
Wildlife@Home Events: 0
Climate Tweets: 0
Images Observed: 0

        
Message 1610 - Posted: 12 Sep 2013, 0:43:40 UTC - in response to Message 1609.

The validator is now allowing Submit to work, but the status page still shows that it is disabled, and no validation is actually happening.

Travis Desell
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: 16 Jan 12
Posts: 1813
Combined Credit: 23,514,257
DNA@Home: 293,563
SubsetSum@Home: 349,212
Wildlife@Home: 22,871,482
Wildlife@Home Watched: 212,926s
Wildlife@Home Events: 51
Climate Tweets: 21
Images Observed: 774

              
Message 1635 - Posted: 16 Sep 2013, 17:06:24 UTC - in response to Message 1610.

The validator is now allowing Submit to work, but the status page still shows that it is disabled, and no validation is actually happening.


Should be fixed!


Post to thread

Message boards : News : database fixed