Thread: Anti-Spam Options - Verify Email Before Registration
View Single Post
  #81  
Old 07-25-2013, 12:08 PM
crazyboy1661 crazyboy1661 is offline
 
Join Date: Jan 2011
Location: India
Posts: 135
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello there, This mod is fantastic and was working fine before to restore my sql database. But now I am facing some problem with my DBase. While I am trying to upload this mod, i am getting the following error. Kindly guide me to rectify this error.

Other plugins are working fine.

I have very less technical knowledge to handle this.

Thanks in advance.


Error Showing:

Database Error Database error
The mysite database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the mysite.com home page, then try to open another page.
Click the Back button to try another link.

The mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

PHP Code:
Database error in vBulletin 4.2.1:

Invalid SQL:
CREATE TABLE vb4_userregcode (
`
userregidINT10 NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`
userregemailVARCHAR100 NOT NULL ,
`
userregcodeVARCHAR100 NOT NULL,
`
countedINT10 NOT NULL,
`
dayscounterINT100 NOT NULL,
`
wheretoapplyBOOL NOT NULL
ENGINE MYISAM ;;

MySQL Error   Table 'vb4_userregcode' already exists
Error Number  
1050
Request Date  
ThursdayJuly 25th 2013 06:52:23 AM
Error Date    
ThursdayJuly 25th 2013 06:52:23 AM
Script        
http://mysite.com/admincp/plugin.php?do=productimport
Referrer      http://mysite.com/admincp/plugin.php?do=productadd
IP Address    0.0.0.0
Username      
admin
Classname     
vB_Database
MySQL Version 
5.5.32-log 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01177 seconds
  • Memory Usage 1,781KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete