SMFHacks.com

Thanks.  I have "Generate medium size images" unchecked.  I assume this is the option?

Where do the thumbnails get used/displayed?  If I were to manually delete them from the Gallery folder, what would happen?

Thank you.

PM sent with link.

Do you need all the sm_gallery tables?

I can count 26.

Yes I can confirm they're correct.  How do we fix the GalleryPro search?

Thanks, that worked.  Prefix was "SM" not "SMF".

The SQL returned 126 rows compared to over 800 using GalleryPro search with Search Picture Description unchecked.  Sample results attached.

Not sure where we go next?

Maybe I did something wrong but running the SQL against the forum db returns an error:

Error
Static analysis:

32 errors were found during analysis.

Unexpected character. (near "{" at position 298)
Unexpected character. (near "}" at position 308)
Unexpected character. (near "{" at position 337)
Unexpected character. (near "}" at position 347)
Unexpected character. (near "{" at position 403)
Unexpected character. (near "}" at position 413)
Unexpected character. (near "{" at position 482)
Unexpected character. (near "}" at position 492)
Unexpected character. (near "{" at position 590)
Unexpected character. (near "}" at position 600)
Unexpected character. (near "{" at position 726)
Unexpected character. (near "}" at position 736)
Unexpected character. (near "{" at position 804)
Unexpected character. (near "}" at position 814)
An alias was previously found. (near "}" at position 308)
Unexpected token. (near "}" at position 308)
Unexpected token. (near "gallery_pic" at position 309)
Unrecognised keyword. (near "as" at position 321)
Unexpected token. (near "p" at position 324)
An alias was previously found. (near "}" at position 347)
Unrecognised keyword. (near "AS" at position 356)
Unexpected token. (near "m" at position 359)
Unexpected token. (near "m" at position 365)
Unexpected token. (near "." at position 366)
Unexpected token. (near "id_member" at position 367)
Unexpected token. (near "=" at position 377)
Unexpected token. (near "p" at position 379)
Unexpected token. (near "." at position 380)
Unexpected token. (near "id_member" at position 381)
Unexpected token. (near ")" at position 390)
This type of clause was previously parsed. (near "LEFT JOIN" at position 393)
Unrecognised statement type. (near "LEFT JOIN" at position 393)
SQL query: Copy Documentation

SELECT p.id_picture, p.id_cat, p.commenttotal, p.keywords, p.filesize, p.thumbfilename, p.approved, p.views, p.id_member, m.real_name, p.date, p.mature, v.id_picture as unread, mg.online_color, p.title, p.rating, p.totalratings, p.totallikes, (p.rating / p.totalratings ) AS ratingaverage FROM {db_prefix}gallery_pic as p LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_member) LEFT JOIN {db_prefix}gallery_usersettings AS s ON (s.id_member = m.id_member) LEFT JOIN {db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP)) LEFT JOIN {db_prefix}gallery_log_mark_view AS v ON (p.id_picture = v.id_picture AND v.id_member = 1 AND v.user_id_cat = p.USER_ID_CAT) LEFT JOIN {db_prefix}gallery_exif_data AS e ON (e.id_picture = p.id_picture) LEFT JOIN {db_prefix}gallery_catperm AS c ON (c.id_group IN (1,8,9) AND c.id_cat = p.id_cat) WHERE (((s.private =0 OR s.private IS NULL ) AND (s.password = '' OR s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.approved =1) OR (p.approved =1 AND p.USER_ID_CAT =0 AND (c.view IS NULL OR c.view =1))) AND p.approved = 1 AND (p.title LIKE '%ANA%' ) GROUP BY p.id_picture ORDER BY p.id_picture DESC LIMIT 0,126;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}gallery_pic as p
LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_m...' at line 5

Sorry if I'm not posting the logs correctly.

OK, let me recap.

If I do a Gallery Search and select only "Search Picture Title", the results include images where the input criteria exists in the description but not the Title.

If I do the same search and choose a Category, the results only include images where the criteria exists in the Title.

I just searched Gallery wide for "ANA" with only Search Picture Title checked.  I got 7 pages of results including the attached example where ANA doesn't exist in the Title.

This is the error log for that Search:

SELECT
p.id_picture, p.id_cat, p.commenttotal, p.keywords, p.filesize, p.thumbfilename, p.approved, p.views,
p.id_member, m.real_name, p.date, p.mature, v.id_picture as unread, mg.online_color,
p.title, p.rating, p.totalratings, p.totallikes, (p.rating / p.totalratings ) AS ratingaverage
FROM {db_prefix}gallery_pic as p
LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_member)
LEFT JOIN {db_prefix}gallery_usersettings AS s ON (s.id_member = m.id_member)
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
LEFT JOIN {db_prefix}gallery_log_mark_view AS v ON (p.id_picture = v.id_picture AND v.id_member = 1 AND v.user_id_cat = p.USER_ID_CAT)
LEFT JOIN {db_prefix}gallery_exif_data AS e ON (e.id_picture = p.id_picture)
LEFT JOIN {db_prefix}gallery_catperm AS c ON (c.id_group IN (1,8,9) AND c.id_cat = p.id_cat)

WHERE (((s.private =0 OR s.private IS NULL ) AND (s.password = '' OR s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.approved =1) OR (p.approved =1 AND p.USER_ID_CAT =0 AND (c.view IS NULL OR c.view =1))) AND p.approved = 1 AND (p.title LIKE '%ANA%' )
GROUP BY p.id_picture ORDER BY p.id_picture DESC
LIMIT 0,126
If I do the same search on a Category, I don't get any results where the input criteria exists in the description.

Here is the Error log for that search:

SELECT
p.id_picture, p.id_cat, p.commenttotal, p.keywords, p.filesize, p.thumbfilename, p.approved, p.views,
p.id_member, m.real_name, p.date, p.mature, v.id_picture as unread, mg.online_color,
p.title, p.rating, p.totalratings, p.totallikes, (p.rating / p.totalratings ) AS ratingaverage
FROM {db_prefix}gallery_pic as p
LEFT JOIN {db_prefix}members AS m ON (m.id_member = p.id_member)
LEFT JOIN {db_prefix}gallery_usersettings AS s ON (s.id_member = m.id_member)
LEFT JOIN {db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
LEFT JOIN {db_prefix}gallery_log_mark_view AS v ON (p.id_picture = v.id_picture AND v.id_member = 1 AND v.user_id_cat = p.USER_ID_CAT)
LEFT JOIN {db_prefix}gallery_exif_data AS e ON (e.id_picture = p.id_picture)
LEFT JOIN {db_prefix}gallery_catperm AS c ON (c.id_group IN (1,8,9) AND c.id_cat = p.id_cat)

WHERE (((s.private =0 OR s.private IS NULL ) AND (s.password = '' OR s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.approved =1) OR (p.approved =1 AND p.USER_ID_CAT =0 AND (c.view IS NULL OR c.view =1))) AND p.id_cat = 43 AND p.approved = 1 AND (p.title LIKE '%ANA%' )
GROUP BY p.id_picture ORDER BY p.id_picture DESC
LIMIT 0,126
I hope that helps?