Alex, After a successful import I go the following error from build:-

A fatal error has occured:
Can't handle date: 0 at GT/Date.pm line 483.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (13704): Links::environment called at Links.pm line 442.
Links (13704): Links::fatal called at GT/Base.pm line 251.
Links (13704): GT::Base::error_handler called at GT/Date.pm line 483.
Links (13704): GT::Date::_calc_my called at GT/Cache.pm line 67.
Links (13704): GT::Cache::FETCH called at GT/Date.pm line 454.
Links (13704): GT::Date::timegm called at GT/Date.pm line 414.
Links (13704): GT::Date::timelocal called at GT/Date.pm line 259.
Links (13704): GT::Date::_format_date called at GT/Date.pm line 512.
Links (13704): GT::Date::_transform called at GT/Cache.pm line 67.
Links (13704): GT::Cache::FETCH called at GT/Date.pm line 231.
Links (13704): GT::Date::date_transform called at Links/SiteHTML.pm line 43.
Links (13704): Links::SiteHTML::site_html_link called at GT/Plugins.pm line 66.
Links (13704): GT::Plugins::dispatch called at Links/SiteHTML.pm line 28.
Links (13704): Links::SiteHTML::display called at (eval 23) line 68.
Links (13704): Links::Build::build_category called at GT/Plugins.pm line 66.
Links (13704): GT::Plugins::dispatch called at Links/Build.pm line 43.
Links (13704): Links::Build::build called at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0-beta1/admin/nph-build.cgi line 492.
Links (13704): main::_build_category called at GT/Plugins.pm line 66.
Links (13704): GT::Plugins::dispatch called at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0-beta1/admin/nph-build.cgi line 81.
Links (13704): main::build_all called at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0-beta1/admin/nph-build.cgi line 35.
Links (13704): main::main called at /home/sites/site1/web/cgi-bin/lsqldev-2.0.0-beta1/admin/nph-build.cgi line 22.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.0-beta1
DBI.pm Version: 1.14
@INC =
/usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i386-linux
/usr/lib/perl5/site_perl/5.005
.


Looking thru the debug output and with some help from mysqlman I found the problm. I had some links (137 to be exact) with add_date and mod_date as 0000-00-00. I have no idea how they got that way but they do not cause a build problem in Links-sql 1.13. I fixed them with mysqlman and then build ran successfully and everthing looks good. Would it be possible for build to avoid blowing up on this or maybe have import set a default date when it finds this??

Hi,

Can you do me a favour and check to see if the dates were 0000-00-00 in your old version, or if the import changed the dates?

Cheers,

Alex

--
Gossamer Threads Inc.

Alex, The add and mod dates are 0000-00-00 in the 1.13 database. I had a very strange server crash Nov 03 and I suspected some file corruption. I had problems such as backups that would not restore correctly and other weird things. The server crashed again on Nov 11 (it ate the hardrive). Thats when I found the backup problems and had to manually rebuild databases. I think all the offending links were done with mysqlman so the problem was probably related to it not setting a default date of now.
I also got a new server.
I just checked links-sql shows a default of now, mysqlman shows 0000-00-00.