4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 23, 2014, 11:56:04 PM

Login with username, password and session length
Search:     Advanced search
4images is now on facebook. Click here and become a fan!
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Issues / Ausgaben
| |-+  Discussion & Troubleshooting (Moderators: Acidgod, ivan, Rembrandt)
| | |-+  4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Print
Author Topic: 4images Update from 1.7.7 to 1.7.11 // Migrate Keywords error  (Read 2013 times)
Sumale.my
Addicted member
******
Offline Offline

Posts: 1787

Thank You
-Given: 161
-Receive: 75

Neverdie


View Profile
« 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  [Expand]
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?
Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4085

Thank You
-Given: 106
-Receive: 858

Vienna


View Profile WWW
« 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:
1
'" . $image_keywords . "'

ersetze es mit:
1
'".mysql_real_escape_string($image_keywords)."'

mfg Andi

Follow members gave a thank to your post:
Sumale.my

For this post, 1 member gave a thank you!
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Sumale.my
Addicted member
******
Offline Offline

Posts: 1787

Thank You
-Given: 161
-Receive: 75

Neverdie


View Profile
« Reply #2 on: November 29, 2012, 04:32:51 PM »

Danke, ich gebe bescheid nach dem Testen
Logged
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.156 seconds with 23 queries.