gca release changes - possible hiccups on the site

ideology · Post by **ideology** » 19 January 08 9:18 am

hi,

we've done a slight back-end change which will allow releases to get out a lot faster.

in the past, developers would publish their changes to a development site which we would all play with for a while, then publish to a beta site where the beta testers would have a play, then eventually to production. this gave us pretty solid releases but took too long (basically due to i! being slack in pressing the button).

so we're experimenting with a change which means that when the developers commit new code into the system, it goes straight into the production site.

we expect that there will be a few hiccups as things that the developers didn't intend to release accidentally get released or things that different developers release interact in some unexpected ways, but think that it's worth trying!

please let us know if you see anything strange. hopefully with the new process it will be relatively quick to fix

fingers crossed!

Damo. · Post by **Damo.** » 19 January 08 9:47 am

Thanks i!
We appreciate the work you and the developers all put into the site.

Would a Sticky for reporting bugs be useful or better to have seperate threads?

SUBYDAZZ · Post by **SUBYDAZZ** » 19 January 08 9:48 am

Queries: Screen output of results show "No Cache Found"

Damo. · Post by **Damo.** » 19 January 08 10:07 am

SUBYDAZZ wrote:Queries: Screen output of results show "No Cache Found"

Your QLD unfound and available is giving that result but your other public ones are working.
Maybe you should check what you are filtering by and that you aren't excluding all cache types or something?

Edit: Just checked two of my queries that used to return a result and they aren't working either now?

NSW GCA caches (available excl locationless) (Public Query)
Recommended & available GCA Caches in NSW (Public Query)

Will go have a look if the filtering has changed...

Nope. Filter details are as I left them. Tried changing stuff and updating but still no result returned. Tried changing to all caches as well and still no result.

Created a new query with the same details for recommended & avail in NSW and no result returned. Removed the NSW and Australia, left sorting in distance from postcode 2000 and it does now return a result.
Might be something borked to do with the state filter?

Post by **CraigRat** » 19 January 08 10:22 am

Something is amiss, some work, some don't

I'm looking at it now

Damo. · Post by **Damo.** » 19 January 08 10:27 am

Damo. wrote: Created a new query with the same details for recommended & avail in NSW and no result returned. Removed the NSW and Australia, left sorting in distance from postcode 2000 and it does now return a result.
Might be something borked to do with the state filter?

Just added country back in and it borked it.

State alone selected seems to work, if it's filtered to Australia it doesn't.

Post by **CraigRat** » 19 January 08 11:14 am

Fixed.

hey i!, this is HEAPS better! Thanks for trusting us! MUHHAHAHAHAHAAHAHA

SUBYDAZZ · Post by **SUBYDAZZ** » 19 January 08 11:21 am

OK, how about this then, when adding a cache to my Watchlist on GCA I get this text at the top of the page:

debug: select count(*) as count from gca_hotlist where cacher='SUBYDAZZ' and type='W' and waypoint='GC18925';
debug: insert into gca_hotlist (cacher, waypoint, type) values ('SUBYDAZZ', 'GC18925', 'W');
debug: select gca_hotlist.type, count(*) as count from gca_hotlist, gca_cache where gca_hotlist.waypoint='GC18925' and gca_hotlist.waypoint=gca_cache.waypoint group by gca_hotlist.type;
debug: update gca_cache set recommended=0, watching=1, planning=0, hiderschoice=0 where waypoint='GC18925';
My Watchlist

debug: select gca_hotlist.id, gca_hotlist.waypoint, gca_hotlist.type as hottype, source, gca_cache.name, hidden, gca_cache.type as cachetype, archived, available, recommended, locale, gca_region.abbr AS state, gca_cache.state AS state_text, gca_country.name AS country, gca_cache.country AS country_text from gca_hotlist, gca_cache LEFT OUTER JOIN gca_country ON gca_cache.country=gca_country.code LEFT OUTER JOIN gca_region ON gca_cache.state=gca_region.code AND gca_cache.country=gca_region.country where cacher = 'SUBYDAZZ' and gca_hotlist.type = 'W' and gca_hotlist.waypoint = gca_cache.waypoint order by upper(gca_cache.name);

Post by **CraigRat** » 19 January 08 11:29 am

fixed

SUBYDAZZ · Post by **SUBYDAZZ** » 19 January 08 11:32 am

Wow, not bad

ideology · Post by **ideology** » 19 January 08 11:46 am

cool! thanks craigrat!

SUBYDAZZ · Post by **SUBYDAZZ** » 19 January 08 10:45 pm

OK, how about this one then

When I tried to upload a gallery pic for one of the caches I found today I got this instead:

Error:

Could not move file to temporary directory

The caches was this one: http://geocaching.com.au/cache/ga0970 I can't *log* it until I upload the photo as it is a logging requirement...

Post by **CraigRat** » 19 January 08 11:03 pm

SUBYDAZZ wrote:OK, how about this one then

When I tried to upload a gallery pic for one of the caches I found today I got this instead:

Error:

Could not move file to temporary directory

The caches was this one: http://geocaching.com.au/cache/ga0970 I can't *log* it until I upload the photo as it is a logging requirement...

I'll look at that tomorrow, it's troubling as I have not hacked the gallery code for over 6 months... I've noticed a few issues there that shouldn't be happening....

I'll fix it tomorrow, I've consumed a bit too much wine to safely hack code tonight

SUBYDAZZ · Post by **SUBYDAZZ** » 19 January 08 11:20 pm

LOL, fairy nuff, It's OK, you deserve a break

ideology · Post by **ideology** » 20 January 08 7:47 am

it could have been the way we changed the system yesterday. we simply pointed the gca website to the development site which didn't have the actual image subdirectory in it. we've moved the images subdirectory over. can you please have another go now and let us know if it works. thanks!