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
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