|
Page 1 of 2
|
 Kangura 
Joined: August 2006
Posts: 75
Location:  Melbourne
|
 New Cracker Tracker
Hi All,
I was slow to read MG's advice in http://www.phpBBXS.eu/viewtopic.php?t=243&highlight=cback and have "installed" the new Cracker Tracker. I ran the install and it seemed OK, I modified each file meticulously but now when trying to open any message the following error appears:
General Error Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.ct_miserable_user' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.ct_miserable_user, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos, u.ct_miserable_user FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 491 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 742
File : viewtopic.php
Instructions on what to change in viewtopic.php:
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
# the original line is longer!
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts,
#
#-----[ IN-LINE FIND ]------------------------------------------
#
u.user_allowsmile
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, u.ct_miserable_user
#
#-----[ FIND ]------------------------------------------
#
$message = $postrow[$i]['post_text'];
#
#-----[ REPLACE WITH ]------------------------------------------
#
// CrackerTracker v5.x
if ( $postrow[$i]['ct_miserable_user'] == 1 && $postrow[$i]['user_id'] != $userdata['user_id'] && $userdata['user_level'] == 0)
{
$message = $lang['ctracker_message_dialog_title'] . '<br /><br />' . $lang['ctracker_ipb_deleted'];
}
else
{
$message = $postrow[$i]['post_text'];
if ( $postrow[$i]['ct_miserable_user'] == 1 && $userdata['user_level'] == ADMIN )
{
$message .= '<br /><br />' . $lang['ctracker_mu_success'];
}
}
(the whole file doesn't fit in here sorry)
I made 2 backups of the forum prior to starting this job but neither of them will restore! Plus I saved a copy of each individual file before I modified it.
I don't know what to do now. Try to fix the new errors or delete this version and just keep the old one?
Thanks in advance for responses.
Cheers,
Julie
|
#1 Thu 05 Oct, 2006 05:30 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
difus 
Joined: August 2006
Posts: 763
Location: 
|
Re: New Cracker Tracker
send me this file or all you changed files[e-mail]. I'll take look
do you update database succesfully ?
do you did old ctracker full uninstall [including database tables] ?
|
#2 Thu 05 Oct, 2006 08:22 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
ctracker 5.0.2 tables [phpmyadmin]
|
| Description: |
|
| Filesize: |
12.94 KB |
| Viewed: |
7283 Time(s) |
|
|
#3 Thu 05 Oct, 2006 08:32 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
|
| Description: |
|
Download |
| Filename: |
cback_ctracker_unin.4.rar |
| Filesize: |
6.9 KB |
| Downloaded: |
177 Time(s) |
|
#5 Thu 05 Oct, 2006 11:45 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
second step
|
| Description: |
|
Download |
| Filename: |
cback_ctracker_v502.zip |
| Filesize: |
317 KB |
| Downloaded: |
240 Time(s) |
|
#6 Thu 05 Oct, 2006 11:51 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
your's viewtopic changed
|
| Description: |
|
Download |
| Filename: |
viewtopic.rar |
| Filesize: |
20.84 KB |
| Downloaded: |
218 Time(s) |
|
#7 Thu 05 Oct, 2006 12:02 |
|
Kangura
Joined: August 2006
Posts: 75
Location: Melbourne
|
Re: New Cracker Tracker
Hi Difus and thank you very much  that's one error gone
Now this comes out:
Warning: include(./language/lang_italian/lang_cback_ctracker.php) [function.include]: failed to open stream: No such file or directory in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php on line 523
Warning: include(./language/lang_italian/lang_cback_ctracker.php) [function.include]: failed to open stream: No such file or directory in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php on line 523
Warning: include() [function.include]: Failed opening './language/lang_italian/lang_cback_ctracker.php' for inclusion (include_path='.:/imports/php5/lib/php/') in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php on line 523
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php:523) in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/sessions.php on line 315
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php:523) in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/sessions.php on line 316
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php:523) in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/functions.php on line 1500
I'll put includes/functions.php and includes/sessions.php in http://europeclubitalia.net/pictures/cartella now
|
#8 Thu 05 Oct, 2006 13:44 |
|
Kangura
Joined: August 2006
Posts: 75
Location: Melbourne
|
Re: New Cracker Tracker
both those files are loaded now
if "lang_cback_ctracker.php" has to be translated into italian to work, I can do that tomorrow otherwise maybe the english version might work,,,i'll try that now (i can't stuff it up more...)
|
#9 Thu 05 Oct, 2006 13:51 |
|
Kangura
Joined: August 2006
Posts: 75
Location: Melbourne
|
Re: New Cracker Tracker
Here's my database 
Here's the error when I try to open any forum:
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.ct_miserable_user' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.ct_miserable_user, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 437 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 742
File : viewtopic.php
|
#10 Thu 05 Oct, 2006 14:32 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
first you are missing /language/lang_italian/lang_cback_ctracker.php
if you don't have it copy from lang_english
|
#11 Thu 05 Oct, 2006 16:31 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
phpbb_ctracker_config
phpbb_ctracker_filechk
phpbb_ctracker_filescanner
phpbb_ctracker_ipblocker
phpbb_ctracker_loginhistory
these tables are new and right, but you have old tables
first run db_uninstall_4x.php I added from your phpBBXS root.delete after run
then run install.php I added ctracker 5.0.2 from your root.after delete.no attention to errors 
now your database is OK
and your files
|
| Description: |
|
Download |
| Filename: |
func_sesion_files.rar |
| Filesize: |
20.56 KB |
| Downloaded: |
212 Time(s) |
|
#12 Thu 05 Oct, 2006 16:47 |
|
Kangura
Joined: August 2006
Posts: 75
Location: Melbourne
|
Re: New Cracker Tracker
Hi again,
 here's my database after following your instructions
Some questions please:
I have added the copy as suggested to /language/lang_italian/lang_cback_ctracker.php (is this file necessary in each of the language folders??
Is there meant to be the table: phpbb_ctracker_backup?
This error appears down the bottom of the forum page:
Parse error: syntax error, unexpected ')' in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/includes/page_tail.php on line 64
(I've added this file to: http://europeclubitalia.net/pictures/cartella/ )
Link to ACP at the bottom of the page has gone  Can it come back?
In ACP - CrackerTracker/IP&Agent Blocker brings up this error: Fatal error: Call to undefined method stdClass::load_blocklist() in /mounted-storage/home26a/sub001/sc19248-PWJK/www/xs/ctracker/admin/acp_module_ipblocker.php on line 51
Apart from all this, the site is working again. I'd love to complete this task now,but am falling asleep. I'll come back to it tomorrow.
Thank you very much for all your help and persistance Difus (most of all for your patience)
Ciao 
Last edited by Kangura on Thu 05 Oct, 2006 18:14; edited 3 times in total |
#13 Thu 05 Oct, 2006 17:19 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
yes for all languages.
originaly ctracker includes only english and german languages
|
#14 Thu 05 Oct, 2006 17:39 |
|
difus
Joined: August 2006
Posts: 763
Location:
|
Re: New Cracker Tracker
Quote: Is there meant to be the table: phpbb_ctracker_backup?
leave it 
and your page_tail.php
|
| Description: |
|
Download |
| Filename: |
page_tail.rar |
| Filesize: |
2.04 KB |
| Downloaded: |
175 Time(s) |
|
#15 Thu 05 Oct, 2006 23:47 |
|
|
|
Page 1 of 2
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
|
|
|
|
