vb.org Archive
Page 9 of 34 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - Verify Email Before Registration (https://vborg.vbsupport.ru/showthread.php?t=294164)

crazyboy1661 07-26-2013 05:48 AM
Hello da_judge, can you please help me!

Quote:
Originally Posted by crazyboy1661 (Post 2435310)
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.

I have no 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 (
`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userregemail` VARCHAR( 100 ) NOT NULL ,
`userregcode` VARCHAR( 100 ) NOT NULL,
`counted` INT( 10 ) NOT NULL,
`dayscounter` INT( 100 ) NOT NULL,
`wheretoapply` BOOL NOT NULL
) ENGINE = MYISAM ;;

MySQL Error   : Table 'vb4_userregcode' already exists
Error Number  : 1050
Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM
Error Date    : Thursday, July 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 

Light Peak 07-29-2013 06:28 AM
any idea to put a note below "Make sure to write the correct email email to receive the verification code"? because hotmail rejects email sent from my mail server so i'd like to put a note so users will be informed

EDIT: got it already. Btw, hope recaptcha verification can be added in

fxdigi-cash 08-01-2013 07:07 AM
does this mod use Keycaptcha by any chance???

smirkley 08-04-2013 04:59 AM
No, it doesnt use any human verification options.

The one reason I dont use it unfortunatly, as I like it.

Ary Braga 08-07-2013 11:37 PM
Quote:
Originally Posted by crazyboy1661 (Post 2435310)
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 (
`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userregemail` VARCHAR( 100 ) NOT NULL ,
`userregcode` VARCHAR( 100 ) NOT NULL,
`counted` INT( 10 ) NOT NULL,
`dayscounter` INT( 100 ) NOT NULL,
`wheretoapply` BOOL NOT NULL
) ENGINE = MYISAM ;;

MySQL Error   : Table 'vb4_userregcode' already exists
Error Number  : 1050
Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM
Error Date    : Thursday, July 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 
Bro. make this.

Open notepad and

Copy and paste this code below.

Code:
DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.

tommythejoat 08-15-2013 12:20 AM
Quote:
Originally Posted by Ary Braga (Post 2437741)
Bro. make this.

Open notepad and

Copy and paste this code below.

Code:
DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.
So, clicking the allow overwrite option does not work? :confused:

ForceHSS 08-15-2013 01:16 AM
Quote:
Originally Posted by crazyboy1661 (Post 2435310)
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 (
`userregid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userregemail` VARCHAR( 100 ) NOT NULL ,
`userregcode` VARCHAR( 100 ) NOT NULL,
`counted` INT( 10 ) NOT NULL,
`dayscounter` INT( 100 ) NOT NULL,
`wheretoapply` BOOL NOT NULL
) ENGINE = MYISAM ;;

MySQL Error   : Table 'vb4_userregcode' already exists
Error Number  : 1050
Request Date  : Thursday, July 25th 2013 @ 06:52:23 AM
Error Date    : Thursday, July 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 
go to your forum admin panel scroll down to Maintenance/Execute SQL Query/Manual Query put the code below into the box then click continue
Code:
CREATE TABLE `userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) NOT NULL,
  `userregcode` varchar(100) NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM AUTO_INCREMENT=661 DEFAULT CHARSET=utf8;
If the above does not work run this code first
Code:
DROP TABLE IF EXISTS `userregcode`;
This will fix your problem

crazyboy1661 08-15-2013 06:59 AM
First of all I am very thankful for your reply. I did it but no use. Still I am getting the same reply/message.

Also when I tried to Execute SQL query, the following message is shown.
PHP Code:
You are not authorized to execute SQL queries 


Quote:
Originally Posted by Ary Braga (Post 2437741)
Bro. make this.

Open notepad and

Copy and paste this code below.

Code:
DROP TABLE IF EXISTS `vb_userregcode`;
CREATE TABLE IF NOT EXISTS `vb_userregcode` (
  `userregid` int(10) NOT NULL auto_increment,
  `userregemail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `userregcode` varchar(100) collate utf8_unicode_ci NOT NULL,
  `counted` int(10) NOT NULL,
  `dayscounter` int(100) NOT NULL,
  `wheretoapply` tinyint(1) NOT NULL,
  PRIMARY KEY  (`userregid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;



Save your file in utf-8 format and rename to userregid.sql

After goto Php MyAdmin and choose your database.

click IMPORT and select your userregid.sql file on PC and click EXECUTE.

Done.

ForceHSS 08-15-2013 11:31 AM
Quote:
Originally Posted by crazyboy1661 (Post 2438977)
First of all I am very thankful for your reply. I did it but no use. Still I am getting the same reply/message.

Also when I tried to Execute SQL query, the following message is shown.
PHP Code:
You are not authorized to execute SQL queries 
You need to add your userid into the config file then you can run them. If you are still having a problem after you run this pm me will have a look

da_judge 09-01-2013 07:20 PM
Correct edit you config.php and add your member id to following line, i have put userid 1 so change to what yours is and save...

$config['SpecialUsers']['canrunqueries'] = '1';


or you could do it via phpmyadmin :)


All times are GMT. The time now is 12:00 PM.
Page 9 of 34 « First 78 9 101119 Last »
Show 40 post(s) from this thread on one page

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.01490 seconds
  • Memory Usage 1,813KB
  • 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
  • (5)bbcode_code_printable
  • (5)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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