forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error 1064 on synch procedure
- This topic is empty.
-
AuthorPosts
-
-
May 24, 2004 at 9:45 am #8448quartexMember
Hi,
I have in my log ftom synch operation tens 1064 Errors like this :
You have an error in your SQL syntax near 'ÌÌount(*) from `autor where `nome_autore_m`='Babyface/Reid, Antonio ''LA''' at line 1
You have an error in your SQL syntax near '¬¬ount(*) from `autor where `nome_autore_m`='Babyface/Reid, Antonio ''LA''' at line 1
You have an error in your SQL syntax near 'ount(*) from `autor where `nome_autore_m`='Babyface/Reid, Antonio ''LA'''' at line 1
Error No. 1064
You have an error in your SQL syntax near '¼¼ount(*) from `aut where `nome_autore_t`='Babyface/Reid, Antonio ''LA''' ' at line 1
Error No. 1064
Any ideas about problem ??
-
May 24, 2004 at 9:49 am #15867RiteshMember
Can you send me a backup of your database?
Information like OS, MySQL version would be very helpful.
-
May 24, 2004 at 9:55 am #15868quartexMember
Yes
sorry for this …
I am using mysql 3.23.52-log and 3.23-47-log running on linux both ….
-
May 24, 2004 at 10:11 am #15869quartexMember
I sent the backup of two tables with problem
-
May 24, 2004 at 10:52 am #15870quartexMember
Do you receivce the table backup ?
Sorry .. wrong info .. the source database is not on Linux is HP UX and teh destination is on LInux
-
May 24, 2004 at 11:30 am #15871RiteshMember
Yeah I got it 🙂
-
May 25, 2004 at 1:10 pm #15872quartexMember
Hi Ritesh,
any news about my synch problem ??
Thank you very much for all
-
May 25, 2004 at 1:52 pm #15873quartexMember
Hi,
Some problem is solved with delay of '' (double single quotes chars…escape it in SQL) but there are some errors in log not “easy to understand” like Query Empty and strange characters like ¼¼ not present in tables
Error No. 1064
You have an error in your SQL syntax near 'a%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'äää' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'ta/Bishop, Teddy/Cox, Bryan' and `cognome_autore_m`='' and `idbrano`='121206' at line 1
Error No. 1064
You have an error in your SQL syntax near 'Br%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'a%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'ta/Bishop, Teddy/Cox, Bryan' and `cognome_autore_t`='' and `idbrano`='121206' at line 1
Error No. 1064
You have an error in your SQL syntax near 'ount(*) from `aut where `nome_autore_t`='Watson, Bo/Babyface/Reid, Antoni' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'ÌÌount(*) from `aut where `nome_autore_t`='McCloud, Anita/Clement, Edmund ' at line 1
Error No. 1064
You have an error in your SQL syntax near 'ÄÄount(*) from `aut where `nome_autore_t`='Clifford, Linda/Dixon, Ernest/H' at line 1
Error No. 1064
You have an error in your SQL syntax near 'Brien, Gerald/Tyson, David' and `cognome_autore_t`='' and `idbrano`='121113'' at line 1
Error No. 1065
Query was empty
Error No. 1065
Query was empty
Error No. 1064
You have an error in your SQL syntax near 'A%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '¼¼' at line 1
Error No. 1064
You have an error in your SQL syntax near 'Br%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'Neil' and `cognome_autore_t`='' and `idbrano`='121157'' at line 1
Error No. 1064
You have an error in your SQL syntax near 'from `autoretest where `nome_autore_t`='Babyface/Reid, Antonio ''LA''' and `co' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near 'A%' group by 1 order by 2' at line 1
Error No. 1064
You have an error in your SQL syntax near '' group by 1 order by 2' at line 1
-
May 25, 2004 at 1:55 pm #15874quartexMember
A feature :
Why do you not write the key(s) value for the record(s) problem to identify it quickly ??
😛
-
May 25, 2004 at 6:04 pm #15875RiteshMember
We are looking your issue. Give us some time 🙂
-
May 28, 2004 at 1:25 pm #15876quartexMember
Sorry for this Ritesh,
I have to synch my data and I ask you your prevision date for any solution or hint …. or if I have to clean my data for '' character (hoping there will be the only 'strange' character …)
Thank you for your help
-
June 10, 2004 at 1:22 am #15877gohunderMember
Ritesh,
I have noticed that I only get the 1064 error when synchronizing with
and listing a subset of tables. Does this indicate that the problem is not with the database structures or table/field contents? Thank you
grant
-
June 10, 2004 at 1:30 am #15878gohunderMember
Sorry the xml tag did not appear in the post.
I get no errors with tables all=”yes” and when I use tables all=”no” and specify individual tables, with where statements, I seem to get the same number of 1064 errors as should match the where statements.
grant
I hope my xml substitutions are correct here.
-
June 10, 2004 at 3:45 am #15879RiteshMember
Mail me the XML file at [email protected]. Sample data and steps to reproduce the error would be great.
-
-
AuthorPosts
- You must be logged in to reply to this topic.