New problem with SJA

[peterlaursen]

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

[royvarley]

I'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.

[peterlaursen]

the ' -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 ?

[peterlaursen]

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

[royvarley]

Sorry – 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.

[royvarley]

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

[Ritesh]

Have you tried with the Windows version?

BTW, can you mail me sample data to reproduce the error?

[royvarley]

Ritesh, 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.

[Author]

Posts