Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4252
Latest: Jwatson_785
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43228
Total Topics: 7514
Most Online Today: 113
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 78
Total: 78

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Anmer

Pages: [1] 2 3 ... 8
1
Support / Re: File Count
« on: November 11, 2023, 02:25:43 am »
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?

2
Support / File Count
« on: November 10, 2023, 10:30:29 am »
My hosting provider is now introducing file limits as well as disk space.

I have approx 85,000 bmp files in my Gallery.  Each one a small 6KB .bmp file, 85x20 pixels.

But the directory count is double that at 170k files.

Does an upload also create a thumbnail file?  And if so, is there an option to diable this, assuming it doesn't break Gallery?

3
Support / Re: SMF 2.1.4 Search
« on: September 22, 2023, 01:55:15 pm »
Thank you.

4
Support / Re: SMF 2.1.4 Search
« on: September 22, 2023, 02:43:48 am »
Thanks.

Installed 10 Beta1 and original Search issue resolved.  Well done.

However, if I make the same Search but uncheck all options, I'm getting results.  I would expect none?

If I make the same search but only check Search Exif Make I get no results, as expected, since this data isn't available for the uploaded images.

When searching and unchecking all options, what criteria is being used to return results?

5
Support / Re: SMF 2.1.4 Search
« on: September 20, 2023, 11:12:10 am »
PM sent with link.

6
Support / Re: SMF 2.1.4 Search
« on: September 20, 2023, 05:55:23 am »
I've exported all 26 x SM_Gallery tables.  How can I get them to you?

7
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 02:54:57 pm »
Do you need all the sm_gallery tables?

I can count 26.

8
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 01:47:42 pm »
I just did a GalleryPro search for "ANA" and left all options unchecked.  It retuuned over 800 results!

9
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 01:27:45 pm »
Yes I can confirm they're correct.  How do we fix the GalleryPro search?

10
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 11:13:44 am »
Hmm, not sure about the results?  Just noticed the list displayed is incomplete.  The SQL shows:

LIMIT 0,126

If I change this to a higher number I still only get to see 126 rows but there are more available?

Edit

Resolved the limit issue and can confirm the rogue files are not included in the SQL results.

The GalleryPro search with Search Picture Description unchecked includes results that aren't in the SQL search.

11
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 11:09:26 am »
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?

12
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 08:15:21 am »
Different error.

Is it a db path issue?

Code: [Select]
Error
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 smf_gallery_pic as p
LEFT JOIN smf_members AS m ON (m.id_member = p.id_member)
LEFT JOIN smf_gallery_usersettings AS s ON (s.id_member = m.id_member)
LEFT JOIN smf_membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
LEFT JOIN smf_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 smf_gallery_exif_data AS e ON (e.id_picture = p.id_picture)
LEFT JOIN smf_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[...]
MySQL said: Documentation

#1146 - Table 'ccfcbasi_KrystalOne.smf_gallery_pic' doesn't exist

13
Support / Re: SMF 2.1.4 Search
« on: September 19, 2023, 03:48:13 am »
Maybe I did something wrong but running the SQL against the forum db returns an error:

Code: [Select]
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

14
Support / Re: SMF 2.1.4 Search
« on: September 18, 2023, 01:14:25 pm »
"If I do the same search on a Category, I don't get any results where the input criteria exists in the description. "
Do you have the search description box checked?

No.  Unchecked in both searches.

If you have phpmyadmin I would the SQL query in there and see what data is displayed.

What query?

15
Support / Re: SMF 2.1.4 Search
« on: September 18, 2023, 10:49:37 am »
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:

Code: [Select]
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:

Code: [Select]
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?

Pages: [1] 2 3 ... 8

+- Recent Topics

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Request for admin notification by davejo
February 06, 2024, 09:02:12 am

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Clipboard image support for the editor by SMFHacks
January 29, 2024, 11:22:17 am

Release date? by SMFHacks
January 26, 2024, 02:00:45 pm

Powered by EzPortal