Show Posts
196
Discussion & Troubleshooting / DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch
« on: July 22, 2013, 02:38:35 PM »
Hey all,
I'm new in working with 4images and have a little problem:
I've added two new image_fields and it worked perfect, but then I tried to show them also in the gallery search and then it happend:
Something went wrong.
Now, if you are trying to upload a picture and fill in some specific names in the fields "name", "Flugzeugtyp" and "Registration" you'll get an error message like this:
DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, reg_match, typ_match) VALUES (28, 30, 0, 0, 0)
Column count doesn't match value count at row 1
The strange thing is: This error message appears not always when uploading a picture.
I think it only appears if you type in two single words in one of the three fields named above.
But I'm not sure if this is right so I added a new category called "Test" where you can upload some pictures if you want to check that or something else.
Maybe this can help you: You also can not search for the "Registration" or the "Flugzeugtyp".
I hope you can help me! If you need some more information or the content of some files simlpy write it
I also speak German so an answer in German would also be very helpful!
Thanks a lot!
Patrick
I'm new in working with 4images and have a little problem:
I've added two new image_fields and it worked perfect, but then I tried to show them also in the gallery search and then it happend:
Something went wrong.
Now, if you are trying to upload a picture and fill in some specific names in the fields "name", "Flugzeugtyp" and "Registration" you'll get an error message like this:
DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, reg_match, typ_match) VALUES (28, 30, 0, 0, 0)
Column count doesn't match value count at row 1
The strange thing is: This error message appears not always when uploading a picture.
I think it only appears if you type in two single words in one of the three fields named above.
But I'm not sure if this is right so I added a new category called "Test" where you can upload some pictures if you want to check that or something else.
Maybe this can help you: You also can not search for the "Registration" or the "Flugzeugtyp".
I hope you can help me! If you need some more information or the content of some files simlpy write it
I also speak German so an answer in German would also be very helpful!
Thanks a lot!
Patrick