[Ary Braga]

Originally Posted by crazyboy1661

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.

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.