[Solved] Error on registration page

[ZacFields]

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: Yes
Your knowledge: Basic Knowledge
Board URL: [url]xxxxx[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
Upgraded to IM 1.4.1


What was done to try to solve the problem?
nothing thus far



De.scription and Message

When someone tries to register for my forums, when they click on "Register" it takes them to an error page containing this error message:

[code]Couldn't load Visual Confirmation Code from database! If you have a phpBB Plus you have to install the phpBB internat modules for the Visual Confirmation. Please read the references to phpBB Plus in the "add_ons" folder of CrackerTracker Mod Package!  DEBUG MODE  SQL Error ]

My apologies if this has been posted already but I couldn't find anything so here it is. And FYI my phpbb_confirm table is missing... is this right?

Zac

[Teelk]

I'm assuming that you do have a confirm table, as it's part of all IM builds. Therefore, the problem may lie in the includes/constants.php file, although it's strange that it would be missing this information.

Open includes/constants.php and look for...

Code: Select all

define('CONFIRM_TABLE', $table_prefix.'confirm');

If that doesn't exist then add it after...

Code: Select all

define('CONFIG_TABLE', $table_prefix.'config');

But, if it doesn't exist then I'd be worried that your constants.php file wasn't updated and I'd compare it to one from the IM 1.4.1 package.

[ZacFields]

For some reason I actually am missing the table titled phpbb_confirm.

Got a .script I can add it back?

Zac

[IntegraMOD]

Try this

Code: Select all

## Table structure for table `phpbb_confirm`#  CREATE TABLE phpbb_confirm (   confirm_id char(32) NOT NULL default '',   session_id char(32) NOT NULL default '',   code char(10) NOT NULL default '',   PRIMARY KEY  (session_id,confirm_id)) TYPE=MyISAM;  # --------------------------------------------------------  

Or Import the one from your 1.40 database
MAKE SURE YOU HAVE A BACKUP

[ZacFields]

Creating the backup now. I'll get back with you when I get a chance to test this.

Zac

[ZacFields]

That did the trick, gffb. I can't imagine how that table would be missing as I have never deleted any tables via phpmyadmin.

Oh well, all is well now. I am a little dissapointed to find out that's probably why I haven't gotten any spammers on my site since the upgrade. We'll see if any spammers show up now. <img>

Zac

[IntegraMOD]

Great news please edit topic title to reflect now solved