I am running Links SQL under mod_perl. Everything is fine, but when a user submits a link, 'Add_Date' and 'Mod_Date' are both set to 0000-00-00. This does not happen when I am not running under mod_perl (then the correct dates are filled in).

Has anyone any ideas of what might be going wrong?

Ivan
-----
Iyengar Yoga Resources / GT Plugins

bump ....

Ivan
-----
Iyengar Yoga Resources / GT Plugins

You may try out to print out the value of Add_Date, when it gets from GT::Date::date_get in Add.pm/sub add_link.
my $today = GT::Date::date_get();
$input->{Add_Date} = $today;

Is it correct? Prints correct date?

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Thanks for the reaction.

I just tried this again, and when I submit a link locally, then it's no problem, but it was a problem a while ago when users submitted their links..... strange....

A related problem: under mod_perl, if I do "Build All", it marks all links as new, even if they are two years old. "Build Changed" sometimes works fine, but sometimes it also marks all links as new....

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Did you tried my suggestion?
Try it not just locally, but online. Do the mod online for a minute, try it out, then restore original Add.pm.

Let we see the result.

About the new links. New links are likely computed from Add_Date which is 0000-00-00, so I'm not wondering that they are signed as new, in some circumstances (though I did not check it).

If will print 0000-00-00 online for Add_Date, then the problem is in GT::Date::date_get().

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

I actually tried your suggestion, and I tried it online (when I say locally, I mean that I tested it with a browser that runs on the same machine as my server, i.e. my desktop machine is my server). It printed the correct date.

Ivan
-----
Iyengar Yoga Resources / GT Plugins