EdwinMeijne
commented
9 years ago Hi
Yes, I was about to place the same bug here! What a coincidence!
Example:
/var/www/public/application/libraries/db-sync.phar user:pass@localhost:dbname user:pass@localhost:dbname_dest --tables='tag_to_tagfield' --execute
Executing
Table: tag_to_tagfield => tag_to_tagfield
Mismatch found in table: tag_to_tagfield => tag_to_tagfield Row: 1
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left, top, label, original_tag_id) VALUES ('1','1','67','41','askjf asdf sadf','' at line 2
QUERY: INSERT INTO tag_to_tagfield
(tag_id, tagfield_id, left, top, label, original_tag_id) VALUES (?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?),(?,?,?,?,?,?)
ON DUPLICATE KEY UPDATE tag_id = VALUES(tag_id), tagfield_id = VALUES(tagfield_id), left = VALUES(left), top = VALUES(top), label = VALUES(label), original_tag_id = VALUES(original_tag_id)
BIND: array (
0 => '1',
1 => '1',
2 => '67',
3 => '41',
4 => 'askjf asdf sadf',
5 => '9',
6 => '2',
7 => '1',
8 => '26',
9 => '65',
10 => 'asdfhelkrkjv',
11 => '10',
12 => '3',
13 => '1',
14 => '32',
15 => '57',
16 => 'asdfastaergsfdg',
17 => '4',
18 => '4',
19 => '1',
20 => '28',
21 => '3',
22 => 'asdfasfcx',
23 => '3',
24 => '5',
25 => '1',
26 => '15',
27 => '28',
28 => 'asdf',
29 => '6',
30 => '6',
31 => '1',
32 => '71',
33 => '35',
34 => 'jgk',
35 => '1',
36 => '7',
37 => '1',
38 => '26',
39 => '49',
40 => 'lkjlkj',
41 => '2',
42 => '8',
43 => '1',
44 => '68',
45 => '25',
46 => 'asdfesfgjzv',
47 => '8',
48 => '9',
49 => '1',
50 => '20',
51 => '73',
52 => 'sadgdhdfghrtgbrs',
53 => '7',
54 => '10',
55 => '2',
56 => '36',
57 => '18',
58 => 'asdf',
59 => '6',
60 => '11',
61 => '2',
62 => '52',
63 => '40',
64 => 'asdfesfgjzv',
65 => '8',
66 => '12',
67 => '3',
68 => '35',
69 => '57',
70 => 'asdfhelkrkjv',
71 => '10',
72 => '13',
73 => '3',
74 => '47',
75 => '21',
76 => 'asdfesfgjzv',
77 => '8',
78 => '14',
79 => '3',
80 => '8',
81 => '22',
82 => 'thefuck',
83 => '3',
) I have a column name called left, which gives the error. Also, if I put backticks around the query (as a test) it gives errors with the ?'s -> they might need to be backticked as well?
After I backticked those as well, it hangs on the
BIND array(
part...
If there is anything I can do to help let me know.
mrjgreen
ruslan-ushakov
Hello! There is a problem with the column names that contain reserved words. I get an error when I sync table contains a column called "return"