Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Modify.cgi Error

Quote Reply
Modify.cgi Error
When trying to modify a link from the html pages calling modify.cgi I am receiving Internal Server Errors. When I check the error log - Premature end of script headers: /xxx/xxx/xxx/xxx/xxx/modify.cgi.
I am running links version 3.0.3 and have not modified the templates for this.
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
There is a bug in v3.0.3. I did a fresh install and the same thing happens, so there is a bug in v3.0.3 when trying to use modify.cgi from the modify html pages. This error does not happen when using modify.cgi from admin.
500 screen error,
premature ending of script headers in error log
and debug log is too long to post but the short version is GT::SQL::Driver::MYSQL::sth (21864)
Since no one else seems to be having this problem maybe it's my setup?
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
Hi,

Not a lot that can be done with the debugging info you've provided =) (it doesn't show anything interesting, so it could be a million and one things Pirate).

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Modify.cgi Error In reply to
Oka I gave it another try and the problem is coming from the pages side and not the admin side. Here is the complete error-

[Mon Jul 4 10:18:03 2005] [error] [client 69.105.0.198] Premature end of script headers: /home/kiesysc/public_html/cgi-bin/glinks/modify.cgi
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT Full_Name FROM glinks_Category WHERE (ID = 8) from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 468
' WHERE LinkID = 15 from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 459
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT Username,LinkID,ChgRequest FROM glinks_Changes WHERE LinkID = 15 from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 459
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT * FROM glinks_Changes WHERE (LinkID = 15) from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 446
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT LinkID FROM glinks_Changes WHERE LinkID = 15 from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 444
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Changes.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Changes.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Changes.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT glinks_Category.ID,glinks_Category.Full_Name FROM glinks_CatLinks,glinks_Category WHERE glinks_CatLinks.CategoryID = glinks_Category.ID AND (glinks_CatLinks.LinkID = '15') from Links::Table::Links::get_categories at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Table/Links.pm line 488
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT * FROM glinks_Links WHERE ID = 15 AND LinkOwner = 'jgkiefer' from Links::User::Modify::modify_link at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 298
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT * FROM glinks_Category ORDER BY Full_Name from Links::Tools::category_list at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Tools.pm line 1598
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT COUNT(*) FROM glinks_Links WHERE ((ExpiryCounted = 1 AND isValidated = 'Yes')) from Links::Table::Category::new at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Table/Category.pm line 58
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT * FROM glinks_Users WHERE (Username = 'jgkiefer') from Links::Authenticate::auth_get_user at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Authenticate.pm line 112
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
' WHERE session_id = '4a47954719f7f803972ae8cd78b62a5d' from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 180
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT session_id,session_user_id,session_date,session_data FROM glinks_Sessions WHERE session_id = '4a47954719f7f803972ae8cd78b62a5d' from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 180
GT::SQL::Driver::MYSQL::sth (1685): Executing query: SELECT * FROM glinks_Sessions WHERE (session_id = '4a47954719f7f803972ae8cd78b62a5d' AND session_date > 1120475883) from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 140
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::Config (1685): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1685): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1685): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '1', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
[Mon Jul 4 10:17:57 2005] [error] [client 69.105.0.198] File does not exist: /home/kiesysc/public_html/404.shtml
[Mon Jul 4 10:17:57 2005] [error] [client 69.105.0.198] File does not exist: /home/kiesysc/public_html/favicon.ico
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT COUNT(*) FROM glinks_Editors WHERE (Username = 'jgkiefer') from Links::Utils::is_editor at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Utils.pm line 26
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Editors.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Editors.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Editors.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT * FROM glinks_Category ORDER BY Full_Name from Links::Tools::category_list at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Tools.pm line 1598
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT CategoryID FROM glinks_CatLinks WHERE LinkID = 15 from Links::User::Modify::_modify_passed_in at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 174
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_CatLinks.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT * FROM glinks_Links WHERE ID = 15 AND LinkOwner = 'jgkiefer' AND (isValidated = 'Yes') from Links::User::Modify::_modify_passed_in at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/User/Modify.pm line 170
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT COUNT(*) FROM glinks_Links WHERE ((ExpiryCounted = 1 AND isValidated = 'Yes')) from Links::Table::Category::new at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Table/Category.pm line 58
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Category.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Links.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT * FROM glinks_Users WHERE (Username = 'jgkiefer') from Links::Authenticate::auth_get_user at /home/kiesysc/public_html/cgi-bin/glinks/admin/Links/Authenticate.pm line 112
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Users.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
' WHERE session_id = '4a47954719f7f803972ae8cd78b62a5d' from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 180
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT session_id,session_user_id,session_date,session_data FROM glinks_Sessions WHERE session_id = '4a47954719f7f803972ae8cd78b62a5d' from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 180
GT::SQL::Driver::MYSQL::sth (1632): Executing query: SELECT * FROM glinks_Sessions WHERE (session_id = '4a47954719f7f803972ae8cd78b62a5d' AND session_date > 1120475876) from GT::Session::SQL::load at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Session/SQL.pm line 140
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/glinks_Sessions.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
GT::Config (1632): Adding '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' to the regular cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 177.
GT::Config (1632): Not loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' from cache at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 163.
GT::Config (1632): Loading '/home/kiesysc/public_html/cgi-bin/glinks/admin/defs/database.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '1', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/kiesysc/public_html/cgi-bin/glinks/admin/GT/Config.pm line 145.
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
Mmm.. what server type are you on? Unix or IIS?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Modify.cgi Error In reply to
Linux
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
Do you have nph-headers enabled? (just clasping at straws here, as the debug info posted didn't help much Unsure).

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Modify.cgi Error In reply to
I just checked and yes I do.
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
Mmm Unsure Unless I'm allowed to take a look, I'm not sure how much more I can debug for you ... its a bit of a hard one (could be many things). Normally, its either the path to perl, CHMOD, or folder CHMOD set too high/low.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Modify.cgi Error In reply to
I did a fresh install and everything is updated. An am still receiving errors when trying to use modify.cgi from the users display (Not the admin). I will send you a pm with access info. Thanks
Quote Reply
Re: [jgkiefer] Modify.cgi Error In reply to
Those error logs don't show anything wrong happenning. Make sure you copy the proper part of the error log.

Adrian
Quote Reply
Re: [brewt] Modify.cgi Error In reply to
In Reply To:
Take a look at this thread, it looks like DBD::mysql 3.0 has some issues:

http://www.gossamer-threads.com/...orum.cgi?post=283715
[/quote]

Thanks!
Once I down-graded the problem was resolved.