Started at Wed Jan 16 20:07:22 2002.

Creating backup file ...
Done (2.27 s)

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

Updating New Flags ...
A fatal error has occured:Can't use an undefined value as an ARRAY reference at /home/mysite//cgi-bin/admin/GT/SQL/Base.pm line 180.
Please enable debugging in setup for more details.

If I can try to Build Staggered
This is the results:
Started at Wed Jan 16 20:13:55 2002.

Building Home Page ...
A fatal error has occured:Can't call method "fetchrow_hashref" on an undefined value at (eval 12) line 7.
Please enable debugging in setup for more details.

I have enabled debugging, but It don't show any error !!!!!

---

Thanks in Advance
Bye From Italy

Is your SQL stuff all set correctly? It sounds like the script can't access the SQL database, and is therefore returning blank values, which the script obviously can't do anything with!

What happens if you try and add a link? (to test if the SQL database is connected and working ok).

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!

As Andy said, that error can occur if mysql isn't running or if it is restarting.

Maybe you just happened to try when your host was restarting.

I've testing Mysql is running fine !!!!
Someone can Help Me????

---

Thanks in Advance
Bye From Italy

Can you turn debugging on, try again and then paste the debugging info here.

I have turned debugging on, but It dont' says nothing !!!!!
Help ME

---

Thanks in Advance
Bye From Italy

We can't help unless you show us what it says. We may spot something. Or do you mean it says absolutely nothing?

This is the error, I have abilitaded the debugging:
Started at Fri Jan 18 12:29:52 2002.

Creating backup file ...
Done (1.33 s)

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

Updating New Flags ...
A fatal error has occured:Can't use an undefined value as an ARRAY reference at /home/mysite/cgi-bin/admin/GT/SQL/Base.pm line 180.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (11447): Links::environment called at /home/mysite/cgi-bin/admin/Links.pm line 487 with no arguments.Links (11447): Links::fatal called at /home/mysite/cgi-bin/admin/GT/SQL/Base.pm line 180 with arguments (Can't use an undefined value as an ARRAY reference at /home/mysite/cgi-bin/admin/GT/SQL/Base.pm line 180.
).Links (11447): GT::SQL::Base::count called at Links::Build::build_new_flags line 24 with arguments (Links::Link=HASH(0x859de44), GT::SQL::Condition=HASH(0x859ddcc)).Links (11447): Links::Build::build_new_flags called at /home/mysite/cgi-bin/admin/GT/Plugins.pm line 98 with arguments (HASH(0x8418b8c)).Links (11447): GT::Plugins::dispatch called at /home/mysite/cgi-bin/admin/Links/Build.pm line 30 with arguments (GT::Plugins, /home/mysite/cgi-bin/admin/Plugins, build_new_flags, *Links::Build::build_new_flags, HASH(0x8418b8c)).Links (11447): Links::Build::build called at nph-build.cgi line 654 with arguments (new_flags, HASH(0x8418b8c)).Links (11447): main::_build_new_flags called at nph-build.cgi line 71 with no arguments.Links (11447): main::build_all called at nph-build.cgi line 43 with no arguments.Links (11447): main::main called at nph-build.cgi line 30 with no arguments.

System Information
======================================
Perl Version: 5.006001
Links SQL Version: 1.2 dev
DBI.pm Version: 1.15
Persistant Env: mod_perl (0) SpeedyCGI (0)
DBI::errstr = fetch() without execute()
@INC =
/home/mysite/cgi-bin/admin
/usr/local/lib/perl5/5.6.1/i686-linux
/usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux
/usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl
.

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


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /home/mysite/public
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/mysite/cgi-bin/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => it
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => www.mysite.com
HTTP_REFERER => http://www.mysite.com/cgi-bin/admin/admin.cgi?page=build_nav.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING => do=all
REMOTE_ADDR => 223.90.12.24
REMOTE_PORT => 4440
REMOTE_USER => admin
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/admin/nph-build.cgi?do=all
SCRIPT_FILENAME => /home/mysite/cgi-bin/admin/nph-build.cgi
SCRIPT_NAME => /cgi-bin/admin/nph-build.cgi
SERVER_ADDR => 217.73.234.232
SERVER_ADMIN => info@mysite.com
SERVER_NAME => www.mysite.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.9 (Unix) Debian/GNU mod_jk PHP/3.0.18
UNIQUE_ID => PEgHMNlJ6ugAACylmqc

HELP ME !!!!!

---

Thanks in Advance
Bye From Italy

That looks almost definatly a mySQL database problem! Are you absolutly sure you have the correct database; your username you are using is allowed to access that database, and the host you provided is correct?

I don't think anything else, IMO, would cause this problem. If your confused with the MySQL stuff, you may wanna let your host have a look.

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!

Try setting 1 link as new and see if that solves it.

-OR-

In GT::SQL::Base I think you could change line 180 from:

return $sth->fetchrow_arrayref->[0];

to

return $sth->fetchrow_arrayref->[0] || 0;

Not 100% sure though.

Sorry !!! I've Try to mod.
return $sth->fetchrow_arrayref->[0] || 0;
but It's the same, I have cheked mysql database connection in on !!!!!
Help Me !!!!

---

Thanks in Advance
Bye From Italy

Sorry my fault, you should put the code back how it was...it is dying before that point.

Just try setting a link as new and trying again.

I've resolved by restoring a backup file !!!!

Thanks !!!!!

---

Thanks in Advance
Bye From Italy