Can't do new registrations in my forum!!!

[mariokaz]

Hi there!!

After installed the great Ctracker Ver. 5.0.1a in my Plus 1.53a 2.0.21, my new users can't register in my forum. ¦4

www.all-reefs.com

This one is the error that appears when I want to do the new registration:

Code: Alles auswählen

phpBB : Critical Error 

Could not perform Database operation

DEBUG MODE

SQL Error : 1146 Table 'mariocaz_foro.CTRACK' doesn't exist

UPDATE CTRACK SET value = '148.241.26.133' WHERE name = 'lastreg_ip'

Line : 1048
File : usercp_register.php

And I don't know what is happen, I think is missin some table because the error says, but all my tables are fine and there are the ctracker tables in my DB, please help me. ¢¦

These ones are the ctracker tables that I see in my DB:

phpbb_ctracker_backup
phpbb_ctracker_config
phpbb_ctracker_filechk
phpbb_ctracker_filescanner
phpbb_ctracker_ipblocker
phpbb_ctracker_loginhistory

I put here my file ant the installation file of the mos, if you have to take a look or tell me if you need any other file ok.

Cheers and thank you in advance!

Mario

[ Attachment gelöscht am Sa 21.Okt, 2006 11:01 von oxpus ]

[ Attachment gelöscht am Sa 21.Okt, 2006 11:01 von oxpus ]

[oxpus]

Look on your includes/constants.php
There are some table definition missing

[mariokaz]

Hello oxpus,

First thank you a lot for always helping me my friend.

Ok I saw in my constants.php file and everything is fine.

Here are the instructions of the Mod for that file:

Code: Alles auswählen

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND AND DELETE ]------------------------------------------
#
// CBACK CrackerTracker Professional
define('CTRACK', $table_prefix.'ctrack');
define('CTFILTER', $table_prefix.'ct_filter');
define('CTVISKEY', $table_prefix.'ct_viskey');
// CBACK CrackerTracker Professional

#
#-----[ FIND ]------------------------------------------
#
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

#
#-----[ AFTER, ADD ]------------------------------------------
#
// BEGIN CrackerTracker v5.x
define('CTRACKER_CONFIG', $table_prefix . 'ctracker_config');
define('CTRACKER_IPBLOCKER', $table_prefix . 'ctracker_ipblocker');
define('CTRACKER_LOGINHISTORY', $table_prefix . 'ctracker_loginhistory');
define('CTRACKER_FILECHK', $table_prefix . 'ctracker_filechk');
define('CTRACKER_FILESCANNER', $table_prefix . 'ctracker_filescanner');
define('CTRACKER_BACKUP', $table_prefix . 'ctracker_backup');
// END CrackerTracker v5.x

And yes I see and I don't have the first part in my file (I deleted it) and also I have the part of the code that I have to add.

Here is that part in my file.

Code: Alles auswählen

...............
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

// BEGIN CrackerTracker v5.x
define('CTRACKER_CONFIG', $table_prefix . 'ctracker_config');
define('CTRACKER_IPBLOCKER', $table_prefix . 'ctracker_ipblocker');
define('CTRACKER_LOGINHISTORY', $table_prefix . 'ctracker_loginhistory');
define('CTRACKER_FILECHK', $table_prefix . 'ctracker_filechk');
define('CTRACKER_FILESCANNER', $table_prefix . 'ctracker_filescanner');
define('CTRACKER_BACKUP', $table_prefix . 'ctracker_backup');
// END CrackerTracker v5.x

//<!-- BEGIN Unread Post Information to Database Mod --> 
define('UPI2DB_ALWAYS_READ_TABLE', $table_prefix.'upi2db_always_read'); 
define('UPI2DB_LAST_POSTS_TABLE', $table_prefix.'upi2db_last_posts'); 
define('UPI2DB_UNREAD_POSTS_TABLE', $table_prefix.'upi2db_unread_posts');
define('UPI2DB_VERSION', 'Plus');
//<!-- END Unread Post Information to Database Mod -->
.............................

So I don't know what is happen I am a little desparete because I can't have new users in my forum and it is very important for me. ¢¦

I attach here my constants.php if you want to take a look into there, also tell me if you need any other file ok.

Mario[/code]

[oxpus]

Hm, do you have uninstalled the old cracker tracker?

[mariokaz]

Yes oxpus, completelly!!

The only thing is that I installed a version special for the Plus 1.53a (Ctracker Version 5.0.1a), because the normal version don't works in the Plus boards, so I did all this install instructions (you can take a look):

[oxpus]

The 5.0.x will NOT use the table "phpbb_ctrack", so this code will be remained from CT 4!

[mariokaz]

Uffff so what can I do ¦4

Because the normal version of the Ctracker don't works in the Plus boards.

I have to uninstall that tables and install new ones ? or do something in the code ? ¢¦

[oxpus]

Check the uninstallation of the old one on usercp_register before line 1048.
There you have an old sql statement from the old mod!

[mariokaz]

Wow really you are awesome oxpus!!!

Without hesitate you are the best in this.

Thank you I see the problem, because that code was twice and I didn't see it, but with your nice help like always everything is possible.

Now yes I can have more new users in my forum.

Thank you again my friend.

Mario