Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Oracle and Build/Repair 'Can't Bind a Reference' Error with Win2K

Quote Reply
Oracle and Build/Repair 'Can't Bind a Reference' Error with Win2K
Hello,

I'm using Win2000 server with Oracle8i. I've read through the messages and haven't found this particular error. I'm thinking it's an Oracle specific problem.
I get the error both when using the build and repair tables. Anyone have any ideas?

Thanks,




Started at Thu Aug 8 14:17:32 2002.

Creating backup file ...
Done (5.00 s)

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

Updating New Flags ...
Done (1.00 s)

Updating Changed Flags ...
Done (0.00 s)

Updating Cool Flags ...
A fatal error has occured:Can't bind a reference (ARRAY(0x20bd5c0)) at C:\Web\pcgi/admin/GT/SQL/Driver/ORACLE.pm line 401.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (1768): Links::environment called at C:\Web\pcgi/admin/Links.pm line 430 with no arguments.
Links (1768): Links::fatal called at C:\Web\pcgi/admin/GT/SQL/Driver/ORACLE.pm line 401 with arguments
(Can't bind a reference (ARRAY(0x20bd5c0)) at C:\Web\pcgi/admin/GT/SQL/Driver/ORACLE.pm line 401.
).
Links (1768): GT::SQL::Driver::ORACLE::sth::execute called at C:\Web\pcgi/admin/GT/SQL/Table.pm line 949 with arguments
(GT::SQL::Driver::ORACLE::sth=HASH(0x20b69c4), No, Yes, ARRAY(0x20bd5c0)).
Links (1768): GT::SQL::Table::do_query called at C:\Web\pcgi/admin/GT/SQL/Table.pm line 537 with arguments
(Links::Link=HASH(0x20eb9d0), UPDATE lsql_Links SET isPopular = ? , Timestmp = SYSDATE WHERE isPopular = ? AND ID NOT IN ?, ARRAY(0x21c1e3c)).
Links (1768): GT::SQL::Table::update called at Links::Build::build_cool_flags line 36 with arguments
(Links::Link=HASH(0x20eb9d0), HASH(0x20e7994), GT::SQL::Condition=HASH(0x20c5164)).
Links (1768): Links::Build::build_cool_flags called at C:\Web\pcgi/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a5c8e8)).
Links (1768): GT::Plugins::dispatch called at C:\Web\pcgi/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, C:\Web\pcgi\admin/Plugins, build_cool_flags, *Links::Build::build_cool_flags, HASH(0x1a5c8e8)).
Links (1768): Links::Build::build called at C:\Web\pcgi\admin\nph-build.cgi line 677 with arguments
(cool_flags, HASH(0x1a5c8e8)).
Links (1768): main::_build_cool_flags called at C:\Web\pcgi\admin\nph-build.cgi line 74 with no arguments.
Links (1768): main::build_all called at C:\Web\pcgi\admin\nph-build.cgi line 44 with no arguments.
Links (1768): main::main called at C:\Web\pcgi\admin\nph-build.cgi line 31 with no arguments.


System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.1
DBI.pm Version: 1.28
Persistant Env: mod_perl (0) SpeedyCGI (0)
@INC =
C:\Web\pcgi/admin
C:/Perl/lib
C:/Perl/site/lib
.

CGI Cookies
======================================
IDN => 80S64.N3188S93.N09120609
PersonalLogin => name:admin key:a remember:undefined


ENVIRONMENT
======================================
ALLUSERSPROFILE => C:\Documents and Settings\All Users
CLASSPATH => C:\ORANT8i\orb\classes\yoj.jar;C:\ORANT8i\orb\classes\share.zip
COMMONPROGRAMFILES => C:\Program Files\Common Files
COMPUTERNAME => WEBMOM
COMSPEC => C:\WINNT\system32\cmd.exe
CONTENT_LENGTH => 0
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => C:\Web\pcgi\admin/tmp
HTTPS => off
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => IDN=80S64.N3188S93.N09120609; PersonalLogin=name%3Aadmin%20key%3Aa%20remember%3Aundefined
HTTP_HOST => webmom.j.nsa
HTTP_REFERER => http://webmom.j.nsa/pcgi/admin/admin.cgi?page=home_left.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
INSTANCE_ID => 1
LOCAL_ADDR => 7.209.32.177
NUMBER_OF_PROCESSORS => 2
ORACLE_HOME => c:\orant8i
OS => Windows_NT
OS2LIBPATH => C:\WINNT\system32\os2\dll;
PATH => C:\Perl\5.005\bin\MSWin32-x86-object;C:\Perl\5.005\bin;c:\Perl\bin;C:\Perl\5.005\bin\MSWin32-x86-object;C:\Perl\5.005\bin;C:\ORANT8i\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\ORANT\BIN;C:\Program Files\Common Files\Network Associates\VirusScan Engine\4.0.xx\;C:\ORANT8i\orb\bin;C:\Program Files\Right Now Technologies\Right Now Web\bin
PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PATH_INFO => /pcgi/admin/nph-build.cgi
PATH_TRANSLATED => C:\Web\pcgi\admin\nph-build.cgi
PERL5DB => BEGIN { require 'C:\PROGRA~1\ACTIVE~1\PerlDB.pl' }
PROCESSOR_ARCHITECTURE => x86
PROCESSOR_IDENTIFIER => x86 Family 6 Model 7 Stepping 3, GenuineIntel
PROCESSOR_LEVEL => 6
PROCESSOR_REVISION => 0703
PROGRAMFILES => C:\Program Files
REMOTE_ADDR => 7.209.32.177
REMOTE_HOST => 7.209.32.177
REQUEST_METHOD => GET
SCRIPT_NAME => /pcgi/admin/nph-build.cgi
SERVER_NAME => webmom.j.nsa
SERVER_PORT => 80
SERVER_PORT_SECURE => 0
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Microsoft-IIS/5.0
SYSTEMDRIVE => C:
SYSTEMROOT => C:\WINNT
TEMP => C:\WINNT\TEMP
TMP => C:\WINNT\TEMP
USERPROFILE => C:\Documents and Settings\Administrator
WINDIR => C:\WINNT
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT * FROM lsql_ClickTrack WHERE ( ( Created < '2002-08-06' ) ) from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::ORACLE::sth (1768): Executing query: DELETE FROM lsql_ClickTrack WHERE ( Created < '2002-08-06' ) from Links::Build::build_reset_hits at Links::Build::build_reset_hits line 7
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'Yes' AND Add_Date < '2002-08-01' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at Links::Build::build_new_flags line 15
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isNew = 'No' AND Add_Date >= '2002-08-01' AND isValidated = 'Yes' ) from Links::Build::build_new_flags at Links::Build::build_new_flags line 24
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( ( isChanged = 'Yes' AND Mod_Date < '2002-08-01' 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::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ( isChanged = 'No' AND Mod_Date >= '2002-08-01' AND Add_Date < '2002-08-01' ) from Links::Build::build_changed_flags at Links::Build::build_changed_flags line 31
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_CatLinks from Links::Build::_grand_total at C:\Web\pcgi/admin/Links/Build.pm line 985
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE isValidated = 'No' from Links::Build::_grand_total at C:\Web\pcgi/admin/Links/Build.pm line 986
GT::SQL::Driver::ORACLE::sth (1768): Executing query: SELECT ID,Hits,isPopular FROM lsql_Links WHERE ( isValidated = 'Yes' AND Hits >= 0 )
ORDER BY Hits DESC
from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 17
GT::SQL::Driver::ORACLE::sth (1768): Executing query: UPDATE lsql_Links SET isPopular = 'No' , Timestmp = SYSDATE WHERE isPopular = 'Yes' AND ID NOT IN 'ARRAY(0x20bd5c0)' from Links::Build::build_cool_flags at Links::Build::build_cool_flags line 36
Can't bind a reference (ARRAY(0x20bd5c0)) at C:\Web\pcgi/admin/GT/SQL/Driver/ORACLE.pm line 401.