| Error log [message #23821] |
Wed, 30 March 2005 20:13  |
|
|
I have racked up 56 error messages in 24 hours! Is that normal?
I'm trying to track down my "Invalid STMP return code:" users see when they post new topics on 1/2 of my categories and not having much luck...
Thanks for any help...
Got Torque?
|
|
|
|
| Re: Error log [message #23828 is a reply to message #23821] |
Wed, 30 March 2005 23:05  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Does the forum's nntp SQL table have any values inside it?
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23836 is a reply to message #23828] |
Thu, 31 March 2005 03:45 |
|
|
In ...data/sql/fud_nntp.tbl.... I see this. If this is not the right file please point me to it...
DROP TABLE IF EXISTS {SQL_TABLE_PREFIX}nntp;
CREATE TABLE {SQL_TABLE_PREFIX}nntp
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
forum_id INT NOT NULL DEFAULT 0,
nntp_opt INT NOT NULL DEFAULT 44,
server VARCHAR(255) NOT NULL DEFAULT '',
newsgroup VARCHAR(255) NOT NULL DEFAULT '',
port INT NOT NULL DEFAULT 0,
timeout INT NOT NULL DEFAULT 0,
login VARCHAR(255),
pass VARCHAR(255),
imp_limit INT NOT NULL DEFAULT 0
);
CREATE INDEX {SQL_TABLE_PREFIX}nntp_i_f ON {SQL_TABLE_PREFIX}nntp (forum_id);
# 1 nntp_post_apr
# 2 allow_frm_post
# 4 frm_post_apr
# 8 allow_nntp_attch
# 16 complex_reply_match
# 32 create_users
# 64 auth NONE
# 128 auth (ORIGINAL/SIMPLE)
Got Torque?
|
|
|
|
| Re: Error log [message #23842 is a reply to message #23836] |
Thu, 31 March 2005 15:19 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I was asking for what is inside the database in this table...
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23844 is a reply to message #23842] |
Thu, 31 March 2005 19:42 |
|
|
Looks empty to me. snip of what I see when running a SQL-query on .... fud_nntp
SQL result
Host: localhost
Database: xxxxxxxxx
Generation Time: Mar 31, 2005 at 12:39 PM
Generated by: phpMyAdmin 2.6.1-pl3 / MySQL 4.1.10-ProHosting-SMP
SQL-query: EXPLAIN SELECT * FROM `fud_nntp` WHERE 1;
Rows: 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fud_nntp system NULL NULL NULL NULL 0 const row not found
Got Torque?
|
|
|
|
|
|
| Re: Error log [message #23874 is a reply to message #23857] |
Sun, 03 April 2005 17:20 |
|
|
Looking at the noted data base with the phpMyAdmin function of my hosting service I see where it says there are 0 records in this data base.
Got Torque?
|
|
|
|
| Re: Error log [message #23875 is a reply to message #23857] |
Sun, 03 April 2005 17:37 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Well, the problem is that given the information you've provided it would seem something impossible is hapenning.
The nntp_id value is not NULL, even though the join to fetch it is being done on an empty table (according to your sql information).
You can try to open post.php, and find a conditional expression that looks like this:
if (($mtf->nntp_id || $mtf->mlist_id) && !$mtf->mlist_msg_id) {
and if it get's into it (it seems that it does), make it output the value of $mtf->nntp_id and $id variables.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Error log [message #23894 is a reply to message #23892] |
Mon, 04 April 2005 15:59 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Uhm I didn't ask you for a snippet. I was asking that you add the debug code that would output the mentioned variables and run the page fethching those values and including them in your response.
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23895 is a reply to message #23894] |
Mon, 04 April 2005 17:21 |
|
|
Sounds easy enough if one knows php as well as you, and has access to the software required to run php scripts.
Got Torque?
|
|
|
|
| Re: Error log [message #23897 is a reply to message #23895] |
Mon, 04 April 2005 19:31 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Well, you have access the script too... it is your forum after all.
I can only do so much on my end... given all the information you've provided so far I am unable to replicate the problem, so my only recourse is to ask for more information.
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23899 is a reply to message #23897] |
Mon, 04 April 2005 21:15 |
|
|
I appreciate you trying to help, really it must be pretty frustrating trying to communicate with someone who knows very little php.
Looking at PHP.net, I need the three basic programs to run php scripts locally Apache, PHP and MySQL and it seems there is a package load called XAMPP that makes it “easy to load all 3”. I would think that these are also installed by my hosting service on there servers, or my forum just would not work.
I can go and get the …post.php file, save a master copy and up load an edited version to debug and then?? Run post.php from a browser and see what comes up and post my results.
So in post.php
I find a conditional expression that looks like this:
if (($mtf->nntp_id || $mtf->mlist_id) && !$mtf->mlist_msg_id) {
And? This is where I start to get lost, what do I need in the script to
” make it output the value of $mtf->nntp_id and $id variables.”
I’m sure there are some other php/fud gurus out there, jump in and help Ilia with some of these easy tasks so he can work on some more serious issues.
Got Torque?
|
|
|
|
| Re: Error log [message #23910 is a reply to message #23899] |
Tue, 05 April 2005 13:59 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
What you need to do is:
Download post.php via the forum's file manager, add debugging code and re-upload the file via the file manager. Then try posting a message.
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23969 is a reply to message #23910] |
Wed, 06 April 2005 14:15 |
|
|
I've spent hours trying to figure out what "debugging code" I need to add. Without knowing php I'm having a grand old time. Here is the debugging code I came up with
function var_dump_pre($mtf->nntp_id = null) {
echo '<pre>';
var_dump($mixed);
echo '</pre>';
return null;
}
function var_dump_pre($mtf->mlist_id = null) {
echo '<pre>';
var_dump($mixed);
echo '</pre>';
return null;
}
function var_dump_pre($mtf->mlist_msg_id = null) {
echo '<pre>';
var_dump($mixed);
echo '</pre>';
return null;
}
The above code didn't work, I got an error at the same line number where the code started.
Got Torque?
[Updated on: Wed, 06 April 2005 15:43] Report message to a moderator |
|
|
|
| Re: Error log [message #23971 is a reply to message #23969] |
Wed, 06 April 2005 14:27 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
var_dump(), just give all vars who's values you want to see as arguments to this function.
FUDforum Core Developer
|
|
|
|
| Re: Error log [message #23975 is a reply to message #23971] |
Wed, 06 April 2005 15:10 |
|
|
Ok I used this to debugg
var_dump ($mtf->nntp_id, $mtf->mlist_id, $mtf->mlist_msg_id);
and get the same thing
When creating new topics in some cats. I get
Invalid STMP return code:
Got Torque?
|
|
|
|
| Re: Error log [message #23982 is a reply to message #23975] |
Wed, 06 April 2005 23:17 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
So, no additional debug output other then that message?
Hmm... Dunno what to say...
It seems that the only option would be for you to provide me with admin access to the forum so that I can to try to debug the problem.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]