Messages

1

Mods & Plugins (Requests & Discussions) / mod help....auto filling new fields

« on: April 01, 2003, 12:26:54 PM »

I’ve been playing around try to do this mod myself for the last couple days, and my limited knowledge of PHP is keeping me from getting any ware with it.

I've added new fields to my 4images gallery. After doing so, I noticed that you also have to add any new fields to the member_editimage.html in order for user to be able to edit there images. So, I did it, and that also works great. My problem is that any extra fields added to the member_editimage.html do not auto fill, like keywords and discretions fields do, so the user has to completely retype his info for these new fields.

How would you get these extra fields to auto fill in member_editimage.html????

Any help would be greatly appreciated

2

Tutorials / [Tutorial] Making additional field searchable

« on: March 28, 2003, 10:06:40 PM »

Chris - thanks for the quick reply

I've checked everything over 100 time and I still can't see anything wrong. What really gets me is that the first search field I added still works fine, but the rest don't.            
Anyone have any other ideas???????? Plaese

3

Tutorials / [Tutorial] Making additional field searchable

« on: March 28, 2003, 01:40:25 PM »

I'm having problems with making these fields searchable

I used the Mod to add extra fields ( 7 extra fields in total ) which worked fine...all the new fields dumped into the db fine and displayed fine.

Next, I followed this Mod to make these new fields searchable, and ran the rebuild search index tool,
witch gave me this error:

Code: [Select]

Processing image qqqqq, ID 9 ... OK
Processing image can, ID 10 ...
DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, edibility_match, habitat_match, range_match, season_match, sporecolor_match, mushroomshape_match, lookalikes_match) VALUES (10, 7, 0, 1, 1, 0), (10, 10, 0, 0, 1, 0)
Column count doesn't match value count at row 1
OK
Processing image asasas, ID 11 ...
DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, edibility_match, habitat_match, range_match, season_match, sporecolor_match, mushroomshape_match, lookalikes_match) VALUES (11, 12, 0, 0, 0, 0), (11, 13, 0, 0, 0, 0), (11, 14, 0, 0, 0, 0), (11, 15, 0, 0, 0, 0)
Column count doesn't match value count at row 1
OK


Search index rebuilt!




I them tried search my new fields, and found that I can search the first extra field I added, get a error when I try to search the rest of the new fields:

Code: [Select]

DB Error: Bad SQL Query: SELECT m.image_id FROM 4images_wordlist w, 4images_wordmatch m WHERE w.word_text LIKE 'rust' AND m.word_id = w.word_id AND m.sporecolor_match = 1
Unknown column 'm.sporecolor_match' in 'where clause'


I them tried to upload a new image, and got this error:

Code: [Select]

DB Error: Bad SQL Query: REPLACE INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match, edibility_match, habitat_match, range_match, season_match, sporecolor_match, mushroomshape_match, lookalikes_match) VALUES (12, 5, 0, 0, 0, 1), (12, 12, 0, 0, 0, 0), (12, 13, 0, 0, 0, 0), (12, 14, 0, 0, 0, 0), (12, 15, 0, 0, 0, 0)
Column count doesn't match value count at row 1


Can anyone tell me what I'm doing wrong? I understand that this error comes from adding different amount
of values in than there are columns, but I can't see where my error is....any ideas????

Code: [Select]

[/list:u]

4

Discussion & Troubleshooting / help

« on: March 28, 2003, 05:58:15 AM »

I've tried this Mod and it works great. After using it, I noticed that you also have to add any fields you add to the member_editimage.html in order for uses to be able to edit there images. So, I did it, and that also works great. My problem is that any extra fields added to the member_editimage.html do not auto fill, like keywords and discretions do. How would get these extra fields to auto fill in member_editimage.html.
I tried adding a PHP script to member_editimage.html that I have used before to grab a content and place then in the fields, but it seems that you can't but PHP tags inside the template html files.