forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › New problem with SJA
- This topic is empty.
-
AuthorPosts
-
-
July 4, 2005 at 11:15 am #18461
peterlaursen
ParticipantJust as I thought – the one missing was the one with this 'filnavn':
M:Peters MusikAntologierRêves d'Oasis Desert Blues 2 (1 of 2) 7 Gibran.mp3
escaping problem with d'Oasis when 'filnavn' not PK ? ??
NOTE: string d'Oasis occurs in more colums …
-
August 1, 2005 at 1:21 pm #18462
royvarley
MemberI'm getting similar problem on sync jobs.
When a data item contains ' I get an error in the log file:
Error No. 1064
You have an error in your SQL syntax near 's Quarry', `CostumeDescription`=NULL, `CompanyID`='1', `ProjectID`='15', `Sectio' at line 1
The data in the field was Mr Slate's Quarry
The record containing this field does not update.
-
August 1, 2005 at 1:59 pm #18463
peterlaursen
Participantthe ' -character must be escaped too so a true statement with your data would go
Quote:select 'Mr Slate's Quarry' like '%\'%'But all that should now be transparently handlet by SJA-sync (since 4.06 or maybe 4.07 as far as I remember). I do sync with these data regularly and have not observed any error. But I have hundreds of data to test with and shall do it If only you answer this
Which version of SQLyog are you using?
Would you mind pasting in the definition for the table ?
-
August 1, 2005 at 2:09 pm #18464
peterlaursen
ParticipantI can't reproduce the problem with 4.1 beta6!
Look at picture – there are lot's of apostrophs.
If I make a copy of that table and remove the ” ' “s from all data in the copy and run sync they are correctly sync'ed back to to data with apostroph's.
this one
Quote:`ProjectID`='15'really surprises me. '15' is a string ??
and this one
Quote:`Sectio'even more! starts with backquote and ends with apostroph ??
Do you use columns_selection or sql_where ?
-
August 1, 2005 at 10:17 pm #18465
royvarley
MemberSorry – SJA 4.05
In this case, Columns selection and SQL Where not used.
But since you say that should have been fixed at 4.06/07, I guess I'll try that.
-
August 1, 2005 at 11:15 pm #18466
royvarley
MemberTried with 4.07 download. SJA reports V4.1
Same problem.
Note that the error message puts single quotes around the text where it thinks there's an error. So the leading quote at 's Quarry and the trailing quote at Sectio' were supplied by SJA error reporting. '15' is ok – it's common practice to quote numerics in a SQL statement.
-
August 2, 2005 at 2:10 am #18467
Ritesh
MemberHave you tried with the Windows version?
BTW, can you mail me sample data to reproduce the error?
-
August 2, 2005 at 7:32 am #18468
royvarley
MemberRitesh, I'll start a new post for my issue – I hadn't intended to hijack Peter's thread, I thought it was the same problem – but maybe not.
-
-
AuthorPosts
- You must be logged in to reply to this topic.