Quote:
Config: LSQL v2.1.1, ActivePerl v5.6.1 build 633, Apache v1.3.27, MySQL 3.23.49-nt, Windows XP + SP1.
LSQL was brand newly installed. Nothing modified, just Debug level.
When I set debug level 2, and call page.cgi?d=1, the perl.exe hangs.
Using Debug level 1, everything works fine, no perl hangups.
Later, when I kill the hanged perl.exe, error 500 is displayed in the browser.
Also into the Apache error.log following is added:
-------------------------------------
[Thu Dec 26 16:13:55 2002] [info] Invoking CGI Command '"F:\Perl\bin\perl.exe" "c:\work\cgi-bin\lsql\page.cgi" '
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] Premature end of script headers c:/work/cgi-bin/lsql/page.cgi
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_Category at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_Links at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL (340) Creating new table object for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 120.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Loading state for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 178.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) State loaded for lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 182.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Connecting to database with 'DBI:mysql:links:localhost', 'links', '**********' at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 82.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Connected successfully to database. at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 87.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Table (340) Query SELECT COUNT(*) FROM lsql_CatLinks
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Preparing query SELECT COUNT(*) FROM lsql_CatLinks at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver/MYSQL.pm line 35.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL/sth (340) Executing query SELECT COUNT(*) FROM lsql_CatLinks
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Driver/MYSQL/sth/execute called at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 949 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Driver/MYSQL/sth=HASH(0x21d9fb8)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Table/do_query called at c:/work/cgi-bin/lsql/admin/GT/SQL/Table.pm line 865 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c), SELECT COUNT(*) FROM lsql_CatLinks , ARRAY(0x1a06234)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Table/select called at c:/work/cgi-bin/lsql/admin/GT/SQL/Base.pm line 277 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c), ARRAY(0x225ec88)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Base/count called at GT/SQL/Base/total line 292 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/SQL/Base/total called at c:/work/cgi-bin/lsql/admin/Links/Build.pm line 985 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/SQL/Table=HASH(0x1a2a10c)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/_grand_total called at Links/Build/build_home line 6 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/build_home called at c:/work/cgi-bin/lsql/admin/GT/Plugins.pm line 108 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/Plugins/dispatch called at c:/work/cgi-bin/lsql/admin/Links/Build.pm line 30 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/Plugins, c:/work/cgi-bin/lsql/admin/Plugins, build_home, *Links/Build/build_home, HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/Build/build called at c:/work/cgi-bin/lsql/admin/Links/User/Page.pm line 77 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (home, HASH(0x1a2e810)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/User/Page/generate_home_page called at c:/work/cgi-bin/lsql/admin/Links/User/Page.pm line 53 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) Links/User/Page/handle called at c:/work/cgi-bin/lsql/admin/GT/Plugins.pm line 108 with no arguments.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/Base (340) GT/Plugins/dispatch called at c:\work\cgi-bin\lsql\page.cgi line 25 with arguments
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] (GT/Plugins, c:/work/cgi-bin/lsql/admin/Plugins, handle_page, CODE(0x1ae2394)).
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1]
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] GT/SQL/Driver/MYSQL (340) Using stored connection DBI:mysql:links:localhost at c:/work/cgi-bin/lsql/admin/GT/SQL/Driver.pm line 77.
[Thu Dec 26 16:14:51 2002] [error] [client 127.0.0.1] Links/Link (340) Query:
-------------------------------------
The text above is the full error result. Not truncated.
BTW: I had to replace all :: to /, and all :space to space, because it seems the : hangs the GT Forum, when I click to Preview Post button! GT should investigate this GForum bug...
Paul, let me know, if you do these 2 cases with brand new LSQL v2.1.2 install, what result do you get?
If you need more info, let me know.