Welcome, Guest. Please Login or Register.
November 24, 2017, 11:50:29 AM
Home Help Search Login Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

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


:D


Re:YaBB SE 1.5.2
« Reply #180 on: May 15, 2003, 04: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
Code: [Select]
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]
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]
(mem.ID_MEMBER=le.ID_MEMBER)by
Code: [Select]
(mem.memberName=le.memberName)and it worked properly.
Code: [Select]
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830



WWW
Re:YaBB SE 1.5.2
« Reply #181 on: May 15, 2003, 06:18:14 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
Code: [Select]
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]
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]
(mem.ID_MEMBER=le.ID_MEMBER)by
Code: [Select]
(mem.memberName=le.memberName)and it worked properly.
Code: [Select]

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



WWW
Re:YaBB SE 1.5.2
« Reply #182 on: May 19, 2003, 01: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  |  Topic: 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.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.295 seconds with 19 queries.