vb.org Archive - Miscellaneous Hacks - Rotating Banner System

Been using this for a few months, but started receiving this error today. Any idea how to fix this?

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT *
FROM rbs_banners

Out of resources when opening file '/tmp/#sql_2fea_3.MYI' (Errcode: 24)

y2ksw

04-19-2015 06:25 AM

Quote:

Originally Posted by mikez006 (Post 2543427)

Sounds like an issue with MySQL. Probably your server crashed and tables need a repair.

y2ksw

04-19-2015 06:27 AM

Additionally, your temporary disk space may be full and then you will have to reboot the server, plus doing some cleaning in order to free space.

mattltm

04-20-2015 07:36 AM

Installed and working great now!

dwerden

05-15-2015 09:49 PM

I like the banner rotating system! I'm getting to know it so I can figure out the best way to use it.

Is there a way to clear the clicks for any/all banners I have built?

Thanks.

y2ksw

05-16-2015 07:56 AM

Quote:

Originally Posted by dwerden (Post 2545594)

I like the banner rotating system! I'm getting to know it so I can figure out the best way to use it.

Is there a way to clear the clicks for any/all banners I have built?

Thanks.

You can do this only by using a query, like:

Code:

UPDATE rbs_banners SET clicks=0

Eventually you also need to clear the rbs_hits table with

Code:

TRUNCATE TABLE rbs_hits

Ravitejag

05-19-2015 09:57 AM

1 Attachment(s)

Hey

I have been using the product for a little while now, can't believe I haven't noticed this before. I am unable to see any clicks on any of the banners.
I clicked on the banners and checked again, still no clicks. Can you help me fix this?(Attachment provided for the same)

Thanks

y2ksw

05-19-2015 03:44 PM

Quote:

Originally Posted by Ravitejag (Post 2545835)

If the banners are scripts, clicks are not counted, unless specifically crafted. Else, maybe the clicks option is disabled.

tomcoleman

05-20-2015 07:46 AM

does this work with 5.1.7?

y2ksw

05-20-2015 07:56 AM

Quote:

Originally Posted by tomcoleman (Post 2545936)

does this work with 5.1.7?

No. Version 5 has no software hooks which allow to modify page contents on the fly.

All times are GMT. The time now is 03:14 AM.

Page 270 of 289

270

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04575 seconds Memory Usage 1,740KB 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 (2)bbcode_code_printable (4)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: