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

Fatal error: Range iterator outside integer range

Dec 10, 2003, 1:03 AM
maxpico
User (422 posts)
maxpico's avatar
Dec 10, 2003, 1:03 AM
Post #1 of 8
Views: 9490
Shortcut
Quote Reply
Fatal error: Range iterator outside integer range
I am running the latest Links SQL under mod_perl. WHen I click the build all link i Have the following:
Code:
Started at Wed Dec 10 09:55:40 2003.

Creating backup file ...
Done (0.67 s)

Resetting hits and rates ...
Done (0.03 s)

Updating New Flags ...
Done (0.02 s)

Updating Changed Flags ...
Done (0.01 s)

Updating Cool Flags ...
Done (0.03 s)

Building Home Page ...
Done (0.03 s)

Building What's New Index ...
Building Subpage: 2003-12-10 ...

A fatal error has occured:
Range iterator outside integer range at /path/to/site/isaac/admin/nph-build.cgi line 373.


Please enable debugging in setup for more details.


Stack Trace
======================================
Links (13339): Links::environment called at /path/to/site/isaac/admin/Links.pm line 431 with no arguments.
Links (13339): Links::fatal called at /path/to/site/isaac/admin/nph-build.cgi line 373 with arguments
    (Range iterator outside integer range at /path/to/site/isaac/admin/nph-build.cgi line 373.
        ).
Links (13339): main::_build_new called at /path/to/site/isaac/admin/GT/Plugins.pm line 108 with arguments
    (HASH(0x80b2b8)).
Links (13339): GT::Plugins::dispatch called at /path/to/site/isaac/admin/nph-build.cgi line 79 with arguments
    (GT::Plugins, /path/to/site/isaac/admin/Plugins, create_new, CODE(0x8728a0), HASH(0x80b2b8)).
Links (13339): main::build_all called at /path/to/site/isaac/admin/nph-build.cgi line 43 with no arguments.
Links (13339): main::main called at /path/to/site/isaac/admin/nph-build.cgi line 30 with no arguments.


System Information
======================================
Perl Version: 5.008001
Links SQL Version: 2.1.2
DBI.pm Version: 1.39
Persistant Env: mod_perl (0) SpeedyCGI (0)
@INC =
/path/to/site/isaac/admin
/System/Library/Perl/5.8.1/darwin-thread-multi-2level
/System/Library/Perl/5.8.1
/Library/Perl/5.8.1/darwin-thread-multi-2level
/Library/Perl/5.8.1
/Library/Perl
/Network/Library/Perl/5.8.1/darwin-thread-multi-2level
/Network/Library/Perl/5.8.1
/Network/Library/Perl
.

CGI INPUT
======================================
do => all

Apache error log:
Code:
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT * FROM lsql_ClickTrack WHERE ( ( Created < '2003-12-08' ) ) from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000876s from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::MYSQL::sth (13339): Executing query: DELETE FROM lsql_ClickTrack WHERE ( Created < '2003-12-08' ) from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000326s from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'Yes' AND Add_Date < '2003-12-03' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at Links::Build::build_new_flags line 15
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000598s from Links::Build::build_new_flags at Links::Build::build_new_flags line 15
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'No' AND Add_Date >= '2003-12-03' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at Links::Build::build_new_flags line 24
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.001851s from Links::Build::build_new_flags at Links::Build::build_new_flags line 24
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( ( isChanged = 'Yes' AND Mod_Date < '2003-12-03' AND isValidated = 'Yes' ) OR ( isChanged = 'Yes' AND isNew = 'Yes' AND isValidated = 'Yes' ) ) from Links::Build::build_changed_flags at Links::Build::build_changed_flags line 22
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.001842s from Links::Build::build_changed_flags at Links::Build::build_changed_flags line 22
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isChanged = 'No' AND Mod_Date >= '2003-12-03' AND Add_Date < '2003-12-03' ) from Links::Build::build_changed_flags at Links::Build::build_changed_flags line 31
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.002225s from Links::Build::build_changed_flags at Links::Build::build_changed_flags line 31
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_CatLinks from Links::Build::_grand_total at /path/to/site/isaac/admin/Links/Build.pm line 999
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000354s from Links::Build::_grand_total at /path/to/site/isaac/admin/Links/Build.pm line 999
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE isValidated = 'No' from Links::Build::_grand_total at /path/to/site/isaac/admin/Links/Build.pm line 1000
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000407s from Links::Build::_grand_total at /path/to/site/isaac/admin/Links/Build.pm line 1000
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT ID,Hits,isPopular FROM lsql_Links WHERE ( isValidated = 'Yes' AND Hits >= 0 )
ORDER BY Hits DESC
LIMIT 2 from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 17
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.008795s from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 17
GT::SQL::Driver::MYSQL::sth (13339): Executing query: UPDATE lsql_Links SET isPopular = 'No' WHERE NOT (isPopular = 'Yes' AND ID IN (76,1)) from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 37
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.007347s from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 37
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT * FROM lsql_Category WHERE FatherID = 0
ORDER BY Name from Links::Build::build_home at Links::Build::build_home line 9
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.001108s from Links::Build::build_home at Links::Build::build_home line 9
GT::SQL::Driver::MYSQL::sth (13339): 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 Links::Build::build_new_index line 8
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000844s from Links::Build::build_new_index at Links::Build::build_new_index line 8
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT Add_Date,COUNT(*) FROM lsql_Links WHERE isNew = 'Yes' AND isValidated = 'Yes'
GROUP BY Add_Date from main::_build_new at /path/to/site/isaac/admin/nph-build.cgi line 352
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000731s from main::_build_new at /path/to/site/isaac/admin/nph-build.cgi line 352
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT * FROM lsql_Links WHERE isNew = 'Yes' AND isValidated = 'Yes' AND Add_Date = '2003-12-10'
ORDER BY Add_Date DESC,Title
LIMIT 0, 25 from Links::Build::build_new_subpage at Links::Build::build_new_subpage line 25
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.001426s from Links::Build::build_new_subpage at Links::Build::build_new_subpage line 25
GT::SQL::Driver::MYSQL::sth (13339): Executing query: SELECT * FROM lsql_Reviews WHERE Review_Validated = 'Yes' AND ( Review_LinkID = 256 ) from Links::Link::add_reviews at /path/to/site/isaac/admin/Links/Link.pm line 377
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000513s from Links::Link::add_reviews at /path/to/site/isaac/admin/Links/Link.pm line 377
GT::SQL::Driver::MYSQL::sth (13339): Executing query:
SELECT lsql_CatLinks.LinkID, lsql_Category.Full_Name
FROM lsql_CatLinks, lsql_Category
WHERE lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.LinkID = '256')

from Links::Build::build_new_subpage at Links::Build::build_new_subpage line 46
GT::SQL::Driver::MYSQL::sth (13339): Query execution took: 0.000562s from Links::Build::build_new_subpage at Links::Build::build_new_subpage line 46
Range iterator outside integer range at /path/to/site/isaac/admin/nph-build.cgi line 373.

Please help!
Thank you
Max
The one with Mac OS X Server 10.4 :)
Jan 25, 2004, 2:30 AM
maxpico
User (422 posts)
maxpico's avatar
Jan 25, 2004, 2:30 AM
Post #2 of 8
Views: 9223
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
This was gone after the upgrade of MySQL to 4.0.11 but now it suddendly reappered... I am Running LinksSQL under mod_perl

Code:
Started at Sun Jan 25 11:23:34 2004.

Creating backup file ...
Done (0.67 s)

Resetting hits and rates ...
Done (0.03 s)

Updating New Flags ...
Done (0.02 s)

Updating Changed Flags ...
Done (0.01 s)

Updating Cool Flags ...
Done (0.02 s)

Building Home Page ...
Done (0.03 s)

Building What's New Index ...
Building Subpage: 2004-01-25 ...

A fatal error has occured:
Range iterator outside integer range at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 373.


Please enable debugging in setup for more details.


Stack Trace
======================================
Links (25873): Links::environment called at /Library/WebServer/Documents/isaac/admin/Links.pm line 431 with no arguments.
Links (25873): Links::fatal called at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 373 with arguments
    (Range iterator outside integer range at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 373.
        ).
Links (25873): main::_build_new called at /Library/WebServer/Documents/isaac/admin/GT/Plugins.pm line 108 with arguments
    (HASH(0x80b270)).
Links (25873): GT::Plugins::dispatch called at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 79 with arguments
    (GT::Plugins, /Library/WebServer/Documents/isaac/admin/Plugins, create_new, CODE(0x8728a0), HASH(0x80b270)).
Links (25873): main::build_all called at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 43 with no arguments.
Links (25873): main::main called at /Library/WebServer/Documents/isaac/admin/nph-build.cgi line 30 with no arguments.


System Information
======================================
Perl Version: 5.008001
Links SQL Version: 2.1.2
DBI.pm Version: 1.39
Persistant Env: mod_perl (0) SpeedyCGI (0)
@INC =
Max
The one with Mac OS X Server 10.4 :)
Jan 30, 2004, 11:32 AM
maxpico
User (422 posts)
maxpico's avatar
Jan 30, 2004, 11:32 AM
Post #3 of 8
Views: 9234
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
GT? Crazy
Max
The one with Mac OS X Server 10.4 :)
Feb 2, 2004, 6:47 AM
maxpico
User (422 posts)
maxpico's avatar
Feb 2, 2004, 6:47 AM
Post #4 of 8
Views: 9212
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
Please, can I have some support?
Thanks
Max
The one with Mac OS X Server 10.4 :)
Feb 24, 2004, 3:54 AM
maxpico
User (422 posts)
maxpico's avatar
Feb 24, 2004, 3:54 AM
Post #5 of 8
Views: 9149
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
Again, anyone? Unimpressed
Max
The one with Mac OS X Server 10.4 :)
Feb 24, 2004, 4:25 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Feb 24, 2004, 4:25 AM
Post #6 of 8
Views: 9163
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
Afraid I don't know what is happening there, but have you tried emailing support directly? support@gossamer-threads.com.

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!
Feb 24, 2004, 4:30 AM
maxpico
User (422 posts)
maxpico's avatar
Feb 24, 2004, 4:30 AM
Post #7 of 8
Views: 9138
Shortcut
Quote Reply
Re: [Andy] Fatal error: Range iterator outside integer range In reply to
Thanks, I will.
I thought other users may be interested in that.. Isn't better to reply here in the forum?
Max
The one with Mac OS X Server 10.4 :)
Feb 24, 2004, 4:53 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Feb 24, 2004, 4:53 AM
Post #8 of 8
Views: 9162
Shortcut
Quote Reply
Re: [maxpico] Fatal error: Range iterator outside integer range In reply to
When you know what the problem is (i.e whats causing it, and a potential fix), its always nice to post something here, so people can gain from your problem :)

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!