vb.org Archive - Major Additions

Hello this mod is awesome!

However, I noticed that not everything is showing up. The achievements and awards are not showing up on my own personal post bit. Not sure if something got mixed up or? They show up on my profile page, but not on my threads...

I have a bunch of achievements listed on my profile page, but they do not show up on my own postbit, they appear to be working for others, but for some reason not me. When I first installed the mod it worked, but now it doesnt. kind of weird.

Any help would be greatly appreciated!

osix	11-05-2012 01:15 AM

This is a great mod will it be updated to support 4.2.X

trackpads

11-10-2012 07:40 PM

I am getting these incredibly long queries in the slow query log for mysql. These are related to discussion ender, which I have already removed but are still showing up.

What should I do?

Thanks

-Jason

Code:



# Time: 121110 15:03:40

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 116.362738  Lock_time: 0.000086 Rows_sent: 1  Rows_examined: 3393026

SET timestamp=1352577820;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32258

                        AND T.dateline > 315532800 AND T.dateline < 1352577704

                        AND P.dateline > 315532800 AND P.dateline < 1352577704

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;





# Time: 121110 15:05:19

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 89.153733  Lock_time: 0.000073 Rows_sent: 1  Rows_examined: 3393026

SET timestamp=1352577919;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32262

                        AND T.dateline > 315532800 AND T.dateline < 1352577830

                        AND P.dateline > 315532800 AND P.dateline < 1352577830

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;

trackpads

11-10-2012 07:53 PM

Double

trackpads

11-10-2012 07:57 PM

Ok, I had deleted the award not set to Zero so I re imported the default awards and set to zero. However, now instead of scanning a bazillion rows it only scans 5-6 but still takes for ever.

Can I just remove this from the code so it doesnt do anything at all?

Code:

# Time: 121110 15:52:28

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 2.705497  Lock_time: 0.000074 Rows_sent: 1  Rows_examined: 1

SET timestamp=1352580748;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32317

                        AND T.dateline > 315532800 AND T.dateline < 1352580745

                        AND P.dateline > 315532800 AND P.dateline < 1352580745

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;

# Time: 121110 15:52:37

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 1.297763  Lock_time: 0.000075 Rows_sent: 1  Rows_examined: 5

SET timestamp=1352580757;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32320

                        AND T.dateline > 315532800 AND T.dateline < 1352580755

                        AND P.dateline > 315532800 AND P.dateline < 1352580755

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;

trackpads

11-10-2012 08:02 PM

Disabled the mod for now. Thanks, I really like it just got to get past the query.

MrSeth

11-13-2012 11:39 PM

Does this work for v4.2?

Aramist

11-20-2012 08:57 AM

Hi

I have just updated the mod and started getting this error on my mail box:

Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

SELECT

                dbtech_thanks_likes,

                dbtech_thanks_liked,

                dbtech_thanks_thanks,

                dbtech_thanks_thanked

                FROM vb_user

                WHERE userid = 1;



MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'

Error Number  : 1054

Request Date  : Tuesday, November 20th 2012 @ 09:02:45 AM

Error Date    : Tuesday, November 20th 2012 @ 09:02:46 AM

Script        : http://www.mysite.com/forum/cron.php?rand=1353409358

Any clue?

trackpads

11-24-2012 03:15 PM

Quote:

Originally Posted by Aramist (Post 2382825)

Hi

I have just updated the mod and started getting this error on my mail box:

Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

SELECT

                dbtech_thanks_likes,

                dbtech_thanks_liked,

                dbtech_thanks_thanks,

                dbtech_thanks_thanked

                FROM vb_user

                WHERE userid = 1;



MySQL Error   : Unknown column 'dbtech_thanks_likes' in 'field list'

Error Number  : 1054

Request Date  : Tuesday, November 20th 2012 @ 09:02:45 AM

Error Date    : Tuesday, November 20th 2012 @ 09:02:46 AM

Script        : http://www.mysite.com/forum/cron.php?rand=1353409358

Any clue?

did you check the overwrite box when importing the product?

This is your clue: MySQL Error : Unknown column 'dbtech_thanks_likes' in 'field list'

That means it didnt install correctly, your missing a database column in that table.

Hope this helps,

-Jason

trackpads

11-30-2012 12:32 AM

Quote:

Originally Posted by trackpads (Post 2380061)

Code:

# Time: 121110 15:52:28

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 2.705497  Lock_time: 0.000074 Rows_sent: 1  Rows_examined: 1

SET timestamp=1352580748;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32317

                        AND T.dateline > 315532800 AND T.dateline < 1352580745

                        AND P.dateline > 315532800 AND P.dateline < 1352580745

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;

# Time: 121110 15:52:37

# User@Host: members_prime[members_prime] @ localhost []

# Query_time: 1.297763  Lock_time: 0.000075 Rows_sent: 1  Rows_examined: 5

SET timestamp=1352580757;

SELECT

                        P.userid, COUNT(userid) AS times

                        FROM vb_thread AS T

                        INNER JOIN vb_post AS P ON T.lastpostid=P.postid

                        WHERE P.userid=32320

                        AND T.dateline > 315532800 AND T.dateline < 1352580755

                        AND P.dateline > 315532800 AND P.dateline < 1352580755

                        GROUP BY P.userid

                        ORDER BY P.dateline DESC, P.userid;

Anyone?

All times are GMT. The time now is 04:19 PM.

Page 249 of 270

249

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06153 seconds Memory Usage 1,768KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: