Author Topic: 4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error  (Read 5914 times)

0 Members and 1 Guest are viewing this topic.

Offline Sunny C.

  • Addicted member
  • ******
  • Posts: 1.805
  • I ♥ 4I
    • View Profile
4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error
« on: November 29, 2012, 02:34:49 PM »
Hallo zusammen,

ich habe für einem Freunde die Gallery von 1.7.7 auf 1.7.11 upgedatet.

Wenn ich das Plugin Migrate Keywords nutze, kommt folgender Error:

Quote
DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Kevin,Nowlan,Grimwood's,Daughter' WHERE image_id = 148 LIMIT 1;
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 's,Daughter'
WHERE image_id = 148 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dan,Brereton,World's,Finest' WHERE image_id = 232 LIMIT 1;
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 's,Finest' WHERE
image_id = 232 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Frazetta,Thun'da' WHERE image_id = 662 LIMIT 1;
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 'da' WHERE
image_id = 662 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Bill,Wray,Dexter's,Lab' WHERE image_id = 801 LIMIT 1;
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 's,Lab' WHERE
image_id = 801 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'O'Neil,League' WHERE image_id = 1608 LIMIT 1;
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 'Neil,League'
WHERE image_id = 1608 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Talia,Rha's,Batman,Hughes' WHERE image_id = 2757 LIMIT 1;
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 's,Batman,Hughes'
WHERE image_id = 2757 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'catwoman,ra's,al,ghul,talia' WHERE image_id = 3425 LIMIT 1;
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 's,al,ghul,talia'
WHERE image_id = 3425 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'O'Neill,LOEG' WHERE image_id = 3631 LIMIT 1;
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 'Neill,LOEG'
WHERE image_id = 3631 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Kevin,Nowlan,Lon,designs(Grimwood's,Daughter)' WHERE image_id = 4640 LIMIT
1;
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 's,Daughter)'
WHERE image_id = 4640 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'D'Anda,Hamner,Thundercats' WHERE image_id = 4940 LIMIT 1;
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
'Anda,Hamner,Thundercats' WHERE image_id = 4940 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Nightwing,Robin,Batman,Catwoman,Joker,Clayface,Penguin,Mr.,Zero,Ra's,Al,Ghu
l,Talia' WHERE image_id = 6421 LIMIT 1;
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 's,Al,Ghul,Talia'
WHERE image_id = 6421 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'SECRET,WAR,Dell'Otto' WHERE image_id = 7384 LIMIT 1;
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 'Otto' WHERE
image_id = 7384 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Bermejo,World's,Finest,Batman' WHERE image_id = 7878 LIMIT 1;
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 's,Finest,Batman'
WHERE image_id = 7878 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Bermejo,World's,Finest,Superman' WHERE image_id = 7879 LIMIT 1;
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
's,Finest,Superman' WHERE image_id = 7879 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Lee,Coup,D'Etat' WHERE image_id = 7998 LIMIT 1;
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 'Etat' WHERE
image_id = 7998 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Captain,America' WHERE image_id = 8884 LIMIT 1;
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
'Otto,Captain,America' WHERE image_id = 8884 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'D'ANDA,LION-O' WHERE image_id = 14604 LIMIT 1;
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 'ANDA,LION-O'
WHERE image_id = 14604 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Benes,Cheshire,Birds\' WHERE image_id = 15171 LIMIT 1;
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
''Benes,Cheshire,Birds\' WHERE image_id = 15171 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'dell'otto,captain,america,ultimate,origins,ultimatum' WHERE image_id =
29011 LIMIT 1;
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
'otto,captain,america,ultimate,origins,ultimatum' WHERE image_id = 29011
LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Wolverine' WHERE image_id = 16490 LIMIT 1;
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 'Otto,Wolverine'
WHERE image_id = 16490 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Captain,America' WHERE image_id = 16491 LIMIT 1;
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
'Otto,Captain,America' WHERE image_id = 16491 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Wolverine,X-Men' WHERE image_id = 16493 LIMIT 1;
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
'Otto,Wolverine,X-Men' WHERE image_id = 16493 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Wolverine' WHERE image_id = 16561 LIMIT 1;
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 'Otto,Wolverine'
WHERE image_id = 16561 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Highlander' WHERE image_id = 16562 LIMIT 1;
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 'Otto,Highlander'
WHERE image_id = 16562 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,X-Factor' WHERE image_id = 16563 LIMIT 1;
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 'Otto,X-Factor'
WHERE image_id = 16563 LIMIT 1' at line 1

DB Error: Bad SQL Query: UPDATE 4images_images SET image_keywords =
'Dell'Otto,Punisher' WHERE image_id = 16564 LIMIT 1;
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 'Otto,Punisher'
WHERE image_id = 16564 LIMIT 1' at line 1

Woran liegt das?

Rembrandt

  • Guest
Re: 4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error
« Reply #1 on: November 29, 2012, 03:46:55 PM »
Sehe gerade das du in den keywords hochkommatas drinnen hast, davon kommt der fehler.

versuche mal das, suche in der migrate_keywords.php:

'" . $image_keywords . "'


ersetze es mit:

'".mysql_real_escape_string($image_keywords)."'


mfg Andi

Offline Sunny C.

  • Addicted member
  • ******
  • Posts: 1.805
  • I ♥ 4I
    • View Profile
Re: 4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error
« Reply #2 on: November 29, 2012, 04:32:51 PM »
Danke, ich gebe bescheid nach dem Testen