Are the Lancaster and Glasgow guide admins still on this list? If not, is anyone in touch with them? Their guides have been down for a while now - if they're not coming back, we should take them off the front page of openguides.org - and if they would like to come back, we should try to help!
Kake
Kake L Pugh wrote:
Are the Lancaster and Glasgow guide admins still on this list? If not, is anyone in touch with them? Their guides have been down for a while now - if they're not coming back, we should take them off the front page of openguides.org - and if they would like to come back, we should try to help!
I'm still here. Lancaster's guide is down because I had problems with database load (similar to London's, I think) and partly because I haven't had the time to keep it going. If anyone ever found the solution to the database problem, it's not a big job to bring things back online (it's all still there, I just renamed the index CGI script)
C
On Sun 24 Feb 2008, Clair openguides-lancaster@nimoll.co.uk wrote:
I'm still here.
Hurrah!
Lancaster's guide is down because I had problems with database load (similar to London's, I think) and partly because I haven't had the time to keep it going. If anyone ever found the solution to the database problem, it's not a big job to bring things back online (it's all still there, I just renamed the index CGI script)
Did you check that all the required indexes are there in the database? ISTR they weren't being properly created in MySQL. If you are running on MySQL then this would be the thing to check - I'm not sure off the top of my head what the MySQL syntax is for showing this, but I expect someone else can chime in here.
Kake
On Sun 24 Feb 2008, Kake L Pugh kake@earth.li wrote:
Did you check that all the required indexes are there in the database?
Clair, did you get a chance to check this yet? Do you need any syntax help?
Kake
Kake L Pugh wrote:
On Sun 24 Feb 2008, Kake L Pugh kake@earth.li wrote:
Did you check that all the required indexes are there in the database?
Clair, did you get a chance to check this yet? Do you need any syntax help?
I completely forgot to check :p There's indexes there, and they all seem right (node has primary index on id; content - node_id, version; internal_links - link_from, link_to; metadata has node_id, version, among others)
I think due to lack of time needed to keep the guide running/up to date on my end, you probably should take the link off the openguides frontpage for now?
Clair
openguides-dev@lists.openguides.org