SMFHacks.com

I have recently changed my server and from that time, I get thousands of error messages per hour on my forum using SMF Gallery Pro 6.0.5.

The error message is :
"8192: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead
Fichier: /home/path_to_forum_/Sources/Load.php(195) : runtime-created function
Ligne: 3"

I presume that there is a direct link with the Php release installed on the new server ?
Is there any modification to apply to the gallery in order to prevent this message to appear ?

Thanks for your hep,

JC

Hi,
Just upgraded to latest 5.0.10 release and this is the entry I get in error log for any picture displayed by visitors and members :

8: Undefined index: id_picture
Fichier: mypath/Themes/default/Gallery.template.php (view_picture sub template - eval?)
Ligne: 2338

Any idea to solve the issue ?

Thanks a lot

We implemented the fix and the corresponding query does not cause any problem until now.

But,

This one stills causes MySQL to hang :

Query_time: 622  Lock_time: 0  Rows_sent: 20  Rows_examined: 49299284
SELECT
                               max(com.ID_COMMENT) AS lastcomment, p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize,
                               p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.realName, p.date,
                               p.description, p.mature, v.ID_PICTURE as unread
                       FROM (forum1_gallery_pic as p, forum1_gallery_comment as com)


               LEFT JOIN forum1_members AS m  ON (m.ID_MEMBER = p.ID_MEMBER)
               LEFT JOIN forum1_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)
               LEFT JOIN forum1_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 0 AND v.user_id_cat = p.USER_ID_CAT)
                               LEFT JOIN forum1_gallery_catperm AS c ON (c.id_group IN (-1) AND c.id_cat = p.id_cat)
               WHERE (((s.private =0 || s.private IS NULL ) AND (s.password = '' || s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.approved =1) || (p.approved = 1 AND p.user_id_cat = 0 AND (c.view IS NULL || c.view = 1)))    GROUP BY p.ID_PICTURE
                       ORDER BY lastcomment desc
                       LIMIT 0, 20;

Any new fix ?

Is there any possibility to prevent users not to query the all gallery ?

SMF is 1.1.16 

Just ran and got this :

id    select_type    table    type    possible_keys    key    key_len    ref    rows    Extra

1    SIMPLE    com    ALL    NULL    NULL    NULL    NULL    2301    Using temporary; Using filesort
1    SIMPLE    p    ALL    PRIMARY,USER_ID_CAT    NULL    NULL    NULL    12100    Using where
1    SIMPLE    m    eq_ref    PRIMARY    PRIMARY    3    npnforum1.p.ID_MEMBER    1    Using index
1    SIMPLE    s    eq_ref    PRIMARY    PRIMARY    3    npnforum1.m.ID_MEMBER    1    Using where
1    SIMPLE    v    ref    user_id_cat,id_picture,id_member    id_picture    4    npnforum1.p.ID_PICTURE    7    

Here is the result of the query as requested :

# Query_time: 29  Lock_time: 0  Rows_sent: 1611  Rows_examined: 23626208

Will check your file and let you know ...

oopppss, just realized that phpMyAdmin allows only 30 results to be displayed.

I can ask my server admin to run the full query ...

I checked the forum but did not find an answer. Is there a way to prevent users to search the entire gallery ?

I actually have a gallery with 10000+ images and from time to time, the web server has to handle a long request. The last one is :

Query_time: 381
Lock_time: 0
Rows_sent: 10626
Rows_examined: 120771768

SELECT
                               COUNT(*) as total
                       FROM (forum1_gallery_pic as p, forum1_gallery_comment as com)

               LEFT JOIN forum1_members AS m  ON (m.ID_MEMBER = p.ID_MEMBER)
               LEFT JOIN forum1_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)
               LEFT JOIN forum1_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = 25659 AND v.user_id_cat = p.USER_ID_CAT)
                                       WHERE ((s.private =0 || s.private IS NULL ) AND (s.password = '' || s.password IS NULL ) AND p.USER_ID_CAT !=0 AND p.a
pproved =1) || (p.approved =1 AND p.USER_ID_CAT =0)   AND com.ID_PICTURE = p.ID_PICTURE GROUP BY p.ID_PICTURE;
I wonder how to prevent a guest user/registered user to start search a search.