Hi!

hmm .. i got an error .. it says

GT::SQL::error = Failed to execute query: '
SELECT Links.Contact_Email, Users.Email
FROM Links, Users
WHERE Links.LinkOwner = Users.Username
AND (( Links.Contact_Email LIKE '%_%' OR Users.Email LIKE '%_%' ) AND Users.ReceiveMail = 'Yes')

' Reason: Unknown column 'Links.Contact_Email' in 'field list'
DBI::errstr = Unknown column 'Links.Contact_Email' in 'field list'

any idea?

Gregor

Hi,

Did you upgrade from 2.0.x to 2.0.5? We have had problems on some systems where the upgrade did not add the contact name and email fields.

You should go to Database->Links->Properties->Add Column and add 'Contact_Name' and 'Contact_Email' fields to your database (type = char, size = 255).

Cheers,

Alex
--
Gossamer Threads Inc.

yep i upgraded it to 2.0.5 .. i'll try what u have suggested
thanx

Gregor