SMF enhanced integration mod available?

[Chuck S]

This is an old discussion back to life

You would use the contact us link in the site header for any support issue.

[skidpics]

Indeed - In my line of work, I have been very busy with the season and haven't much time to mess with anything.

I will pass along the details here in a bit. thanks Chuck!

[Chuck S]

have a good one yes this holiday season is passing by quickly and it is indeed busy out there.

[skidpics]

Thanks for the help Chuck - not sure what happened to that setting

[skidpics]

Chuck,

Ever since that was changed I show page generation time at the bottom of every page. I checked SMF and the 'Display Page Generation Time" is turned off, and does not show on the forum, but at the bottom of each PP page, I get this:

Page generated in 0.18347 seconds with 23 queries
1: SELECT varname,setting FROM pp_settings (0.00029 sec)
2: SELECT smf_members.ID_MEMBER,smf_members.memberName,smf_members.emailAddress,smf_members.passwd,smf_members.ID_GROUP,smf_members.timeOffset,smf_members.ID_THEME,smf_members.additionalGroups,smf_members.ID_POST_GROUP,smf_log_online.session,smf_members.passwordSalt FROM smf_members LEFT JOIN smf_log_online ON smf_log_online.ID_MEMBER='1' WHERE smf_members.ID_MEMBER='1' (0.00071 sec)
3: SELECT value FROM smf_settings WHERE variable ='theme_guests' (0.00007 sec)
4: SELECT value FROM smf_themes WHERE variable ='theme_url' AND ID_THEME = '1' (0.00006 sec)
5: SELECT groupid,cpaccess,modaccess,diskspace,uploadsize,uplimit,uploads,comments,editpho,editposts,useralbums,reqmod,canassign FROM pp_usergroups WHERE groupid=1 OR groupid=5 OR groupid=8 (0.00008 sec)
6: SELECT id,ugnoupload,ugnoview,password,cattype,ismember,catname,parent,children,thumbs,canzip,moderators,header,footer,headtags,subalbum FROM pp_categories (0.00036 sec)
7: SELECT username,mature FROM pp_users WHERE userid=1 LIMIT 1 (0.00061 sec)
8: SELECT id FROM pp_photos WHERE approved=0 (0.00007 sec)
9: SELECT count(*) FROM pp_messages WHERE userid=1 AND status=0 (0.00006 sec)
10: UPDATE IGNORE pp_users SET username='skidpics',laston=1229344223 WHERE userid=1 LIMIT 1 (0.00041 sec)
11: REPLACE INTO pp_iponline (ipaddr,userid,uid,date,what,item,agent,referer) VALUES ('75.32.51.38','skidpics',1,'1229344223','index','','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008102920 Firefox/3.0.4','http://skidpics.com/forum/index.php') (0.00049 sec)
12: DELETE FROM pp_iponline WHERE date < 1229343623 (0.00023 sec)
13: SELECT c.id, c.description, c.catorder, c.photos, c.posts, c.catdepth, p.id, p.bigimage, p.cat, p.approved, p.user, p.userid, p.date, p.width, p.height, p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.width, p2.height, com.username, com.id, com.date, com.photo FROM pp_categories c LEFT JOIN pp_photos p ON c.lastphoto=p.id LEFT JOIN pp_photos p2 ON c.thumbnail=p2.id LEFT JOIN pp_comments com ON com.id=c.lastpost ORDER BY c.catorder ASC (0.00043 sec)
14: SELECT cat,laston FROM pp_laston WHERE userid='1' (0.00020 sec)
15: SELECT item, count(*) FROM pp_iponline GROUP BY item (0.00042 sec)
16: SELECT user,userid,COUNT(*) AS pcount FROM pp_photos GROUP BY user ORDER BY pcount DESC LIMIT 5 (0.00013 sec)
17: SELECT count(*) AS vcount,avg(c.rating) AS avgr,p.cat,p.id,p.title,p.rating AS avgr FROM pp_comments c LEFT JOIN pp_photos p ON p.id=c.photo WHERE p.numcom > 1 GROUP BY c.photo ORDER BY avgr desc,vcount desc LIMIT 5 (0.00009 sec)
18: SELECT c.username,c.userid,c.cat,c.photo,c.comment,p.bigimage,p.cat,p.storecat,p.userid,p.width,p.height FROM pp_categories a LEFT JOIN pp_comments c ON a.id=c.cat LEFT JOIN pp_photos p ON p.id=c.photo WHERE comment != '' AND a.password = '' ORDER BY c.date DESC LIMIT 15 (0.00013 sec)
19: SELECT userid,date,uid,what FROM pp_iponline ORDER BY date DESC (0.00063 sec)
20: SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY rand_col DESC LIMIT 45 (0.02703 sec)
21: SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY rand_col DESC LIMIT 45 (0.02801 sec)
22: SELECT id,user,userid,cat,storecat,ismature,title,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY date DESC LIMIT 45 (0.00023 sec)
23: SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY views DESC LIMIT 45 (0.00020 sec)

Any suggestion on how to get rid of this? It appears that it only shows when logged in as Admin for sure.

[Chuck S]

Gone debug was on

[skidpics]

Thanks.

[Chuck S]

yeah once I saw on your site your SMF had your default style set to 0 which of course did not correspond to any actual theme on your site setting the default theme to 1 cured your issue so it did not actually end up being a photopost issue.

[skidpics]

what setting in the DB did you change? I switched themes, and the same thing happened..

[Chuck S]

All I did is make sure the default theme in the SMF database corresponded to an actual theme id, If its messing up again that might be an SMF bug because if you switch a theme it should be an integer like 1 2 3 which corresponds to an actual theme id in the database themes table. Yours was 0 before.

[skidpics]

The only thing I can find about themes in smf is the smf_themes..

Which one needs to be changed back to 1? All are listed as 1 under ID-Theme

[Chuck S]

In the smf settings table is a variable called default theme that needs to correspond to the correct default theme

Content visible to verified customers only.