YaBB SE 1.5.2

[shinsh]

ok I found the problem.
The problem is that the table log_errors uses the membername variable, and the script is asking for the ID

Code Select Expand

yabbse_log_errors
Champ Type Attributs Null Défaut Extra
ID_ERROR   bigint(20)   Non    auto_increment  
logTime   bigint(20)   Non  0    
memberName   tinytext   Non      
IP   tinytext   Non      
url   text   Non      
message   text   Non    


and Errors.php is asking for that:

Code Select Expand

SELECT le.ID_ERROR, le.IP, le.url, IFNULL(mem.memberName, 'Guest') AS memberName, le.logTime, le.message
      FROM {$db_prefix}log_errors AS le
         LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=le.ID_MEMBER)
      ORDER BY le.logTime;

le=log_errors table, and there is no ID_MEMBER column in log_errors

I replaced

Code Select Expand

(mem.ID_MEMBER=le.ID_MEMBER)
by

Code Select Expand

(mem.memberName=le.memberName)
and it worked properly.

Code Select Expand

[[Unknown]]

ok I found the problem.
The problem is that the table log_errors uses the membername variable, and the script is asking for the ID

Code Select Expand

yabbse_log_errors
Champ Type Attributs Null Défaut Extra
ID_ERROR   bigint(20)   Non    auto_increment  
logTime   bigint(20)   Non  0    
memberName   tinytext   Non      
IP   tinytext   Non      
url   text   Non      
message   text   Non    


and Errors.php is asking for that:

Code Select Expand

SELECT le.ID_ERROR, le.IP, le.url, IFNULL(mem.memberName, 'Guest') AS memberName, le.logTime, le.message
      FROM {$db_prefix}log_errors AS le
         LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=le.ID_MEMBER)
      ORDER BY le.logTime;

le=log_errors table, and there is no ID_MEMBER column in log_errors

I replaced

Code Select Expand

(mem.ID_MEMBER=le.ID_MEMBER)
by

Code Select Expand

(mem.memberName=le.memberName)
and it worked properly.

Code Select Expand

No.  The problem is that you didn't upgrade properly, not that the table structure is wrong.

-[Unknown]

[[Unknown]]

oilnum, please do not post here unless it's on the subject of YaBB SE 1.5.2.

Testing has it's own board:

http://www.yabbse.org/community/index.php?board=10;action=display;threadid=23020

-[Unknown]