[ForceHSS]

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 


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

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

DROP TABLE IF EXISTS `userregcode`;

This will fix your problem