Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

site down for maintance

Feb 5, 2002, 6:40 PM
QooQ
Veteran (1819 posts)
QooQ's avatar
Feb 5, 2002, 6:40 PM
Post #1 of 5
Views: 1743
Shortcut
Quote Reply
site down for maintance
that's funny ... this is running on my own machine and it's down ... Shocked

hmmm got some problems would somebody please help?

static pages don't like to show my categories
dynamic tells me my site is down
php is running like a charm


error :::::

Code:
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT * FROM lsql_ClickTrack WHERE ( ( Created < '2002-02-04' ) ) from Links::Build::build_reset_hits at (eval 8) line 9
GT::SQL::Driver::MYSQL::sth (1287): Executing query: DELETE FROM lsql_ClickTrack WHERE ( Created < '2002-02-04' ) from Links::Build::build_reset_hits at (eval 8) line 9
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'Yes' AND Add_Date < '2002-01-30' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at (eval 11) line 17
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'No' AND Add_Date >= '2002-01-30' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at (eval 11) line 26
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( ( isChanged = 'Yes' AND Mod_Date < '2002-01-30' AND isValidated = 'Yes' ) OR ( isChanged = 'Yes' AND isNew = 'Yes' AND isValidated = 'Yes' ) ) from Links::Build::build_changed_flags at (eval 13) line 24
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isChanged = 'No' AND Mod_Date >= '2002-01-30' AND Add_Date < '2002-01-30' ) from Links::Build::build_changed_flags at (eval 13) line 33
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_CatLinks from Links::Build::_grand_total at /Users/qooq/Sites/cgi-bin/linksSQL/admin/Links/Build.pm line 977
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE isValidated = 'No' from Links::Build::_grand_total at /Users/qooq/Sites/cgi-bin/linksSQL/admin/Links/Build.pm line 978
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT ID,Hits,isPopular FROM lsql_Links WHERE isValidated = 'Yes'
ORDER BY Hits DESC
LIMIT 1 from Links::Build::build_cool_flags at (eval 14) line 19
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT ID FROM lsql_Links WHERE ( isPopular = 'Yes' AND ID NOT IN (1) ) from Links::Build::build_cool_flags at (eval 14) line 31
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT * FROM lsql_Category WHERE FatherID = 0
ORDER BY Name from Links::Build::build_home at (eval 16) line 11
GT::SQL::Driver::MYSQL::sth (1287): Executing query: SELECT Add_Date,COUNT(*) FROM lsql_Links WHERE isNew = 'Yes' AND isValidated = 'Yes'
GROUP BY Add_Date
ORDER BY Add_Date DESC from Links::Build::build_new_index at (eval 20) line 10

hope this helps
openoffice + gimp + sketch ... Smile
Feb 5, 2002, 8:00 PM
Alex
Administrator (9387 posts)
Feb 5, 2002, 8:00 PM
Post #2 of 5
Views: 1697
Shortcut
Quote Reply
Re: [QooQ] site down for maintance In reply to
Hi,

Make sure you have debug set to 0, and that in Setup->Misc you have Disabled set to No.

Cheers,

Alex
--
Gossamer Threads Inc.
Feb 6, 2002, 6:29 AM
QooQ
Veteran (1819 posts)
QooQ's avatar
Feb 6, 2002, 6:29 AM
Post #3 of 5
Views: 1687
Shortcut
Quote Reply
Re: [Alex] site down for maintance In reply to
Hi alex,

I had those settings at first and switched them .... so back to what you suggested.

click "home page" after link -- clear // clicked my category "main1" and blank screen + no source.
static link produces the same effect.
dynamic link throws a 500 instead of a blank page.
php runs like a charm.

Code:
[Wed Feb 6 23:23:42 2002] [error] [client 127.0.0.1] Premature end of script headers: /Users/qooq/Sites/cgi-bin/linksSQL/page.cgi

only error is included.

Now, why would 2.05 run with no problems yet 2.1 is having all kinds of problems???? Unimpressed
openoffice + gimp + sketch ... Smile
Feb 6, 2002, 6:53 AM
QooQ
Veteran (1819 posts)
QooQ's avatar
Feb 6, 2002, 6:53 AM
Post #4 of 5
Views: 1674
Shortcut
Quote Reply
Re: [QooQ] site down for maintance In reply to
hmmm ... additional info.

perl -c page.cgi is no problem.

the index page for my category "main1" is blank .... note even 1 character.
openoffice + gimp + sketch ... Smile
Feb 6, 2002, 2:57 PM
QooQ
Veteran (1819 posts)
QooQ's avatar
Feb 6, 2002, 2:57 PM
Post #5 of 5
Views: 1652
Shortcut
Quote Reply
Re: [QooQ] site down for maintance In reply to
minor update.

something is strange here....
all links basically work except for ones that access anything in the pages/ directory ... ie new/category"main1"/rates(well obvious ... only 1 link and no votes)

hmmm ... gonna erase everything and try this again .... hope the 3rd time is the charm

nope ... 3rd time ... all settings as set by the installer .... Frown

4th install ... this time from the command line .... same results ....
::: side note .... categories won't build unless I use the staggered option ... then the directory is built.

here's more error code ... nothing informative though.
Code:
[Thu Feb 7 08:20:54 2002] [error] [client 127.0.0.1] File does not exist: /Users/qooq/Sites/pages/abcedefghi/index.html
[Thu Feb 7 08:22:38 2002] [error] [client 127.0.0.1] Premature end of script headers: /Users/qooq/Sites/cgi-bin/linksSQL/page.cgi
openoffice + gimp + sketch ... Smile

Last edited by:

QooQ: Feb 6, 2002, 3:29 PM