Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Errors modifying links in admin

Quote Reply
Errors modifying links in admin
Hi,

I've just upgraded to Links SQL and tried doing the conversion process, but it didn't work right, but I did get my link fields transferred. I went ahead and added one through the admin and it worked ok, but when I tried to modify it, I got this:

Failed to execute query: 'UPDATE lsql_Links SET Status = ? , Zip_Code = ? , isChanged = ? , Gheight = ? , State = ? , URL = ? , Contact_Name = ? , Home_Phone = ? , isValidated = ? , CellPgr1 = ? , Anniversary = ? , CellPgr2 = ? , Hits = ? , Birthday1 = ? , Birthday2 = ? , Birthday3 = ? , Birthday4 = ? , isPopular = ? , Birthday5 = ? , Portrait2 = ? , Birthday6 = ? , Portrait3 = ? , Add_Date = ? , Portrait4 = ? , Birthday7 = ? , Title = ? , isbest = ? , Contact_Email = ? , Sitename = ? , Mod_Date = ? , Her = ? , Him = ? , Description = ? , LinkOwner = ? , Graphic = ? , Date_Checked = ? , Gwidth = ? , Rating = ? , City = ? , Email1 = ? , Email2 = ? , Email3 = ? , Address = ? , Email4 = ? , Email5 = ? , Email6 = ? , Email7 = ? , Recommended = ? , message1 = ? , message2 = ? , message3 = ? , Child1 = ? , Child2 = ? , Child3 = ? , Key = ? , Personal_Site = ? , Child4 = ? , Child5 = ? , Votes = ? , isNew = ? , Priority = ? , DateAdded = ? WHERE ID = ?' Reason: You have an error in your SQL syntax near 'Key = '' , Personal_Site = 'http://www.capital.org' , Child4 = '' , Child5' at line 1

Can someone tell me what I did?

Thanks in advance!
Perl Hopefull