Author Topic: DB Error after saving modification of a picture  (Read 3350 times)

0 Members and 1 Guest are viewing this topic.

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
DB Error after saving modification of a picture
« on: April 02, 2005, 11:30:53 PM »
Hi everybody

when I save a modification of a picture (e.g. description), I get the following error-message:

DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, vorname_match, name2_match) VALUES (92, 1298, 0, 1, 0), (92, 880, 0, 1, 0), (92, 1303, 0, 1, 0), (92, 1306, 0, 1, 0), (92, 889, 0, 1, 0)
Column count doesn't match value count at row 1
Bild erfolgreich bearbeitet

What is the problem?

Thank you for helping me!

Serge

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error after saving modification of a picture
« Reply #1 on: April 02, 2005, 11:48:24 PM »
the number of field specifyed does not match with number of values.
in your case 7 fields specifyed and only 5 values avalable.
Your first three "must do" before you ask a question:
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)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline TIMT

  • Hero Member
  • *****
  • Posts: 505
    • View Profile
Re: DB Error after saving modification of a picture
« Reply #2 on: April 03, 2005, 10:15:59 AM »
the problem is because of my modification regarding

[Tutorial] Making additional field searchable
http://www.4homepages.de/forum/index.php?topic=1313.msg5562#msg5562

I posted there my questions. The search with the additionals fields doesn't work.
I copied the modificated php- and html-files in a new environment without changing the db.
That's the reason for the db error.

I disabled my modifications regarding
http://www.4homepages.de/forum/index.php?topic=1313.msg5562#msg5562
and now the db error doesn't appear anymore.

Nevertheless the search-problem isn't solved...

Thanks v@no for your help.