Ow! Bad pun! No fair hitting a guy like that on a Friday! :) I renamed the columns in the schema, and added column="..." entries in the transfer.xml. Now I'm waiting for my app to time out (since I don't have rights to do it by hand).
Ken On Dec 12, 4:58 pm, "Mark Mandel" <[email protected]> wrote: > Could be 'left', you are right there too. > > Mark > > > > On Sat, Dec 13, 2008 at 9:56 AM, Doug Giles <[email protected]> wrote: > > > Maybe it's complaining about the column named 'left', which is a MySQL > > function. > > > -Doug > > > On Dec 12, 5:39 pm, "Mark Mandel" <[email protected]> wrote: > >> What is the exact error from mySQL? > > >> I'm going to guess that 'TOP' is a reserved word, but without the > >> error I'm not sure. > > >> Mark > > >> On Sat, Dec 13, 2008 at 9:17 AM, Ken Cummins <[email protected]> > >> wrote: > > >> > I'm using MySQL 5 and Transfer 1.1 on CF MX 7. I have my transfer.xml > >> > set up correctly (I think), but whenever I try to save one of my > >> > objects, I get an SQL error that spans several pages (Java > >> > stacktraces). > > >> > The first apparently usable info from the errors is that the following > >> > is labeled 'SQL': > > >> > INSERT INTO userproductphotos > >> > (photono,path,top,left,height,width,pageno,userproductkey) VALUES > >> > ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param > >> > 6) , (param 7) , (param 8) ) > > >> > The "top level" error is a 1064 error in the SQL near > >> > '...pageno,userproductkey) VALUES ('. > > -- > E: [email protected] > W:www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
