vb.org Archive - Anti-Spam Options - [GlowHost] Spam-O-Matic

Started getting this error last few days.

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM glowhostspamomatic_remotecache WHERE `date` < DATE_SUB(NOW(), INTERVAL 30 DAY);;

MySQL Error : Table '.glowhostspamomatic_remotecache' doesn't exist
Error Number : 1146
Request Date : Friday, January 17th 2014 @ 12:04:10 PM
Error Date : Friday, January 17th 2014 @ 12:04:10 PM
Script : http://www.bayoujeepersoffroad.com/m...p?do=addmember
Referrer : http://www.bayoujeepersoffroad.com/m...p?do=checkdate
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version :

Have you looked in your database to make sure the table is still there?

vbresults

01-18-2014 07:35 PM

Quote:

Originally Posted by bayoujeeper (Post 2475007)

Run this query with phpMyAdmin:

Code:

CREATE TABLE `glowhostspamomatic_remotecache`(

        `date` DATETIME NOT NULL,

        `field` VARCHAR(20) NOT NULL,

        `is_spambot` INT NOT NULL,

        `data` VARCHAR(255) NOT NULL

)

dai-kun

01-23-2014 04:13 AM

Have error trying to delete a user from admincp:

Quote:

Database error in vBulletin 4.2.2:

Invalid SQL:

DELETE FROM vb4_pm WHERE pmtextid IN (SELECT pmtextid FROM vb4_pmtext WHERE fromuserid = 620058);

MySQL Error : The total number of locks exceeds the lock table size
Error Number : 1206
Request Date : Wednesday, January 22nd 2014 @ 09:56:04 PM
Error Date : Wednesday, January 22nd 2014 @ 09:56:08 PM
Script : http://web.com/forum/admincp/glowhos...m_ban&u=620058
Referrer : http://web.com/forum/admincp/glowhos...nfirm&u=620058
IP Address : xxxxxx
Username : Dai-kun
Classname : vB_Database
MySQL Version : 5.1.72-cll

Thanks

ozzy47

01-23-2014 04:18 AM

That is a server issue.

MySQL is trying to tell you that it doesn’t have enough room to store all of the row locks that it would need to execute your query. The only way to fix it for sure is to adjust innodb_buffer_pool_size and restart MySQL. By default, this is set to only 8MB, which is too small for anyone who is using InnoDB to do anything.

SPEEDKILLZ

01-23-2014 04:41 AM

Ok i have ran this mod on all my boards 4.2.1 and below. So i installed on my 4.2.2 board. Everything seemed to work nice so i created a new account to test it. Well when creating an account i noticed after you select agree and submit that it just loads and loads and loads it dosen't stop until you hit stop or refresh then you can go back to the forum and log in. I did this a few times and every time was the same. Then i disabled the mod to check and it goes perfect. Mod is still currently disabled. Waiting on a fix.

dai-kun

01-23-2014 05:02 AM

Quote:

Originally Posted by ozzy47 (Post 2476173)

That is a server issue.

MySQL is trying to tell you that it doesn?t have enough room to store all of the row locks that it would need to execute your query. The only way to fix it for sure is to adjust innodb_buffer_pool_size and restart MySQL. By default, this is set to only 8MB, which is too small for anyone who is using InnoDB to do anything.

Thanks, is fixed. :)

CPOWA

01-26-2014 09:59 PM

Installed - Thank You, GlowHost.com !

SPEEDKILLZ

01-27-2014 03:19 AM

anyone

Max Taxable

01-27-2014 03:27 AM

Quote:

Originally Posted by SPEEDKILLZ (Post 2476177)

There's no "fix." It is not uncommon for this Mod to block legitimate would-be users.

ForceHSS

01-27-2014 04:03 AM

Quote:

Originally Posted by SPEEDKILLZ (Post 2476177)

Post screenshots of the settings

All times are GMT. The time now is 01:01 PM.

Page 321 of 350

321

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03940 seconds Memory Usage 1,747KB 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 (1)bbcode_code_printable (6)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: