vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Stop the Registration Bots (https://vborg.vbsupport.ru/showthread.php?t=244746)

pbforum 08-08-2012 09:50 AM

i have aa problem to install

Database error in vBulletin 4.2.0:

Invalid SQL:

CREATE TABLE IF NOT EXISTS stopbotsregistry (
`hash` varchar(100) NOT NULL default '',
`regtime` int(10) unsigned NOT NULL default '0',
`uf_name` varchar(10) NOT NULL default '',
`uf_value` varchar(10) NOT NULL default '',
PRIMARY KEY (`hash`),
KEY `regtime` (`regtime`)
) 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 8
Error Number : 1064
Request Date : Wednesday, August 8th 2012 @ 06:51:46 AM
Error Date : Wednesday, August 8th 2012 @ 06:51:46 AM
Script : http://punjabiforum.in/forum/admincp...=productimport
Referrer : https://punjabiforum.in/forum/adminc...?do=productadd
IP Address : 94.59.232.82
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll

Videx 08-08-2012 12:07 PM

The 'Type =' part of the query is obsolete and no longer supported by newer MySQL installations.

Either delete that part of the query to use the default storage engine or replace it with 'Engine ='

(from https://vborg.vbsupport.ru/showpost....67&postcount=2)

pbforum 08-08-2012 03:57 PM

can u tell me how ?

Videx 08-08-2012 04:34 PM

Quote:

Originally Posted by pbforum (Post 2355571)
can u tell me how ?

Until the author fixes it, just edit the .xml file with any text editor prior to installing.

pbforum 08-08-2012 05:07 PM

i did but same problem

Videx 08-08-2012 11:51 PM

Quote:

Originally Posted by pbforum (Post 2355597)
i did but same problem

Then I can't help you. If you've changed line 8 I can't imagine why it would still say you have " 'TYPE=MyISAM' at line 8" if you really don't.

Maybe you tried to upload the original file? Maybe you forgot to save it after editing it?

nyenius 08-19-2012 02:11 PM

:(

Really this kind of mod... (im using 4.2)

Toorak Times 10-21-2012 06:03 PM

This has been working fine on my 4.2pl2 till last week now the shifty ones have found away around:eek:

hyperspin 10-22-2012 03:01 AM

1 Attachment(s)
I'm getting the attached error upon importing this mod.

Max Taxable 10-25-2012 09:31 PM

Better job of this:

https://vborg.vbsupport.ru/showthread.php?t=289463


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01052 seconds
  • Memory Usage 1,734KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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