Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 02 Dec 2014, 14:07
dj83 dj83 is offline
 
Join Date: Sep 2013
Spam-o-matic database error

Hello,

I am trying to install spam-o-matic but I keep getting the following error...
How can I fix this?

Database error in vBulletin 3.8.2:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vb_glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number : 1064
Request Date : Tuesday, December 2nd 2014 @ 09:01:31 AM
Error Date : Tuesday, December 2nd 2014 @ 09:01:31 AM
Script : http://myurl.com/admincp/plugin.php?do=productimport
Referrer : http://myurl.com/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.40-36.1
Reply With Quote
  #2  
Old 02 Dec 2014, 14:13
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Should work if you remove


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

from the installation code.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 02 Dec 2014, 14:25
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
You should be posting this in the plugin for support but try Dave's post first
Reply With Quote
  #4  
Old 02 Dec 2014, 22:50
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
And if that does not work you can try to change:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

To


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

instead.
Reply With Quote
  #5  
Old 02 Dec 2014, 22:55
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
No, no, no, not TYPE=ENGINE; it's ENGINE=MyISAM;
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #6  
Old 02 Dec 2014, 22:59
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by ozzy47 View Post
No, no, no, not TYPE=ENGINE; it's ENGINE=MyISAM;
Ok I know there were some mods that you had to change that bit or at least I've had to change it because it disliked my server for whatever reason.
Reply With Quote
  #7  
Old 02 Dec 2014, 23:02
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Right but it is not TYPE=Engine, that is just wrong.

The older TYPE= option was synonymous with ENGINE=. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #8  
Old 02 Dec 2014, 23:04
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by ozzy47 View Post
Right but it is not TYPE=Engine, that is just wrong.

The older TYPE= option was synonymous with ENGINE=. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.
Ok Well hopefully the other suggestions have helped him/her out.
Reply With Quote
  #9  
Old 02 Dec 2014, 23:24
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Sure, either removing TYPE=MyISAM; or changing it to ENGINE=MyISAM; will allow the OP to import the mod.

But any issues after that, the OP will have to ask for support in the modifications thread.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #10  
Old 02 Dec 2014, 23:52
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by ozzy47 View Post
Sure, either removing TYPE=MyISAM; or changing it to ENGINE=MyISAM; will allow the OP to import the mod.

But any issues after that, the OP will have to ask for support in the modifications thread.
OH GEEZ, I'm having such a brain fart! Ok yeah that is what I've done before. Sorry for my dyslexia before lol.
Reply With Quote
  #11  
Old 02 Dec 2014, 23:54
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
It happens to all of us brother.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #12  
Old 12 Dec 2014, 01:47
dj83 dj83 is offline
 
Join Date: Sep 2013
Thanks!
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Administrative and Maintenance Tools Suppress-o-matic - Stop database error spam GeekyDesigns vBulletin 4.x Add-ons 56 27 Jul 2016 20:49
Administrative and Maintenance Tools Suppress-o-Matic - Stop database error spam GeekyDesigns vBulletin 3.8 Add-ons 65 12 Sep 2013 20:01



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:39.

Layout Options | Width: Wide Color: