Welcome, Guest. Please Login or Register.
March 28, 2024, 12:01:10 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  YaBB SE Info  |  News From the YaBB SE Team  |  YaBB SE 1.5.2 « previous next »
Pages: 1 ... 11 12 [13] Reply Ignore Print
Author Topic: YaBB SE 1.5.2  (Read 99222 times)
shinsh
Noobie
*
Posts: 2


:D

Re:YaBB SE 1.5.2
« Reply #180 on: May 15, 2003, 09:50:34 PM »
Reply with quote

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
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:
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 (mem.ID_MEMBER=le.ID_MEMBER)
by
(mem.memberName=le.memberName)
and it worked properly.
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:YaBB SE 1.5.2
« Reply #181 on: May 15, 2003, 11:18:14 PM »
Reply with quote

Quote from: shinsh on May 15, 2003, 09:50:34 PM
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
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:
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 (mem.ID_MEMBER=le.ID_MEMBER)
by
(mem.memberName=le.memberName)
and it worked properly.

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

-[Unknown]
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:YaBB SE 1.5.2
« Reply #182 on: May 19, 2003, 06:26:38 AM »
Reply with quote

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]
Logged
Pages: 1 ... 11 12 [13] Reply Ignore Print 
YaBB SE Community  |  YaBB SE Info  |  News From the YaBB SE Team  |  YaBB SE 1.5.2 « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.013 seconds with 19 queries.