4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: TIMT on April 02, 2005, 11:30:53 PM

Title: DB Error after saving modification of a picture
Post by: TIMT 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

Title: Re: DB Error after saving modification of a picture
Post by: V@no 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.

Title: Re: DB Error after saving modification of a picture
Post by: TIMT 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.