yourWBB | [WBB 2.3.x] Hacks und Addons | yourWBB Homeseite fuer 2.3.x

SQL-DATABASE ERROR Database error in WoltLab Burning Board (2.3.2): Invalid SQL: SELECT p.*, pc.cache, t.threadid, t.boardid, t.topic, t.closed, t.important, t.replycount, t.views FROM bb1_posts p LEFT JOIN bb1_threads t ON (p.threadid = t.threadid) LEFT JOIN bb1_postcache pc ON (p.postid=pc.postid) WHERE p.postid= mysql error: You have an error in your SQL syntax near '' at line 1 mysql error number: 1064 mysql version: 3.23.49-log php version: 4.3.10 Date: 02.07.2005 @ 18:10 Script: /xxx/home.php Referer: http://www.xxxxxx.de/xxx/index.php

suche in header.tpl: ------------------------------ <td class="logobackground" align="center"><if($style['logoimage']!="")><then><a href="index.php{$SID_ARG_1ST}"><img src="{$style['logoimage']}" border="0" alt="$master_board_name" title="$master_board_name" /></a></then></if></td> </tr> <tr> <td align="center"><span class="smallfont"> ------------------------------ füge hinter: ------------------------------ <td align="center"><span class="smallfont"> ------------------------------ folgendes ein: (Leerzeichem am Ende auch!!!!) ------------------------------ <a href="home.php{$SID_ARG_1ST}"><img src="{$style['imagefolder']}/top_home.gif" border="0" alt="{$lang->items['LANG_GLOBAL_HOME']}" title="{$lang->items['LANG_GLOBAL_HOME']}" /></a>

code:

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:

<table style="width:{$style['tableoutwidth']}" cellpadding="{$style['tableoutcellpadding']}" cellspacing="{$style['tableoutcellspacing']}" align="center" border="{$style['tableoutborder']}" class="tableoutborder">
  <tr>
    <td class="mainpage" align="center" style="background-image: url(images/green_vision/bg_endless_2.gif);">

<table style="width:100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td class="logobackground" align="center"><if($style['logoimage']!="")><then><a href="index.php{$SID_ARG_1ST}"><img src="{$style['logoimage']}" border="0" alt="$master_board_name" title="$master_board_name" /></a></then></if></td>
  </tr>
</table>

<table style="width:100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="{$style['imagefolder']}/menue_l_r.gif" border="0" alt="" title="" /></td>
    <td align="center" class="menuebg"><span class="smallfont"><if($wbbuserdata['userid'])><then><a href="usercp.php{$SID_ARG_1ST}" onmouseover="topbutton1.src='{$style['imagefolder']}/top_hover_usercp.gif';" onmouseout="topbutton1.src='{$style['imagefolder']}/top_usercp.gif';"><img name="topbutton1" src="{$style['imagefolder']}/top_usercp.gif" border="0" alt="{$lang->items['LANG_GLOBAL_USERCP']}" title="{$lang->items['LANG_GLOBAL_USERCP']}" /></a><a href="pms.php{$SID_ARG_1ST}" onmouseover="topbutton2.src='{$style['imagefolder']}/top_hover_pms.gif';" onmouseout="topbutton2.src='{$style['imagefolder']}/top_pms.gif';"><img name="topbutton2" src="{$style['imagefolder']}/top_pms.gif" border="0" alt="{$lang->items['LANG_GLOBAL_PMS']}" title="{$lang->items['LANG_GLOBAL_PMS']}" /></a></then><else><a href="register.php{$SID_ARG_1ST}" onmouseover="topbutton3.src='{$style['imagefolder']}/top_hover_register.gif';" onmouseout="topbutton3.src='{$style['imagefolder']}/top_register.gif';"><img name="topbutton3" src="{$style['imagefolder']}/top_register.gif" border="0" alt="{$lang->items['LANG_GLOBAL_REGISTER']}" title="{$lang->items['LANG_GLOBAL_REGISTER']}" /></a></else></if><a href="calendar.php{$SID_ARG_1ST}" onmouseover="topbutton4.src='{$style['imagefolder']}/top_hover_calendar.gif';" onmouseout="topbutton4.src='{$style['imagefolder']}/top_calendar.gif';"><img name="topbutton4" src="{$style['imagefolder']}/top_calendar.gif" border="0" alt="{$lang->items['LANG_GLOBAL_CALENDAR']}" title="{$lang->items['LANG_GLOBAL_CALENDAR']}" /></a><a href="memberslist.php{$SID_ARG_1ST}" onmouseover="topbutton5.src='{$style['imagefolder']}/top_hover_members.gif';" onmouseout="topbutton5.src='{$style['imagefolder']}/top_members.gif';"><img name="topbutton5" src="{$style['imagefolder']}/top_members.gif" border="0" alt="{$lang->items['LANG_GLOBAL_MEMBERSLIST']}" title="{$lang->items['LANG_GLOBAL_MEMBERSLIST']}" /></a><a href="team.php{$SID_ARG_1ST}" onmouseover="topbutton6.src='{$style['imagefolder']}/top_hover_team.gif';" onmouseout="topbutton6.src='{$style['imagefolder']}/top_team.gif';"><img name="topbutton6" src="{$style['imagefolder']}/top_team.gif" border="0" alt="{$lang->items['LANG_GLOBAL_TEAM']}" title="{$lang->items['LANG_GLOBAL_TEAM']}" /></a><a href="search.php{$SID_ARG_1ST}" onmouseover="topbutton7.src='{$style['imagefolder']}/top_hover_search.gif';" onmouseout="topbutton7.src='{$style['imagefolder']}/top_search.gif';"><img name="topbutton7" src="{$style['imagefolder']}/top_search.gif" border="0" alt="{$lang->items['LANG_GLOBAL_SEARCH']}" title="{$lang->items['LANG_GLOBAL_SEARCH']}" /></a><a href="misc.php?action=faq{$SID_ARG_2ND}" onmouseover="topbutton8.src='{$style['imagefolder']}/top_hover_faq.gif';" onmouseout="topbutton8.src='{$style['imagefolder']}/top_faq.gif';"><img name="topbutton8" src="{$style['imagefolder']}/top_faq.gif" border="0" alt="{$lang->items['LANG_GLOBAL_FAQ']}" title="{$lang->items['LANG_GLOBAL_FAQ']}" /></a><if($wbbuserdata['a_can_use_acp']==1 && $wbbuserdata['a_acp_or_mcp']==1)><then><a href="acp/index.php" target="_blank" onmouseover="topbutton9.src='{$style['imagefolder']}/top_hover_acp.gif';" onmouseout="topbutton9.src='{$style['imagefolder']}/top_acp.gif';"><img name="topbutton9" src="{$style['imagefolder']}/top_acp.gif" border="0" alt="{$lang->items['LANG_GLOBAL_ACP']}" title="{$lang->items['LANG_GLOBAL_ACP']}" /></a></then></if><if($wbbuserdata['a_can_use_acp']==1 && $wbbuserdata['a_acp_or_mcp']==0)><then><a href="acp/index.php" target="_blank" onmouseover="topbutton10.src='{$style['imagefolder']}/top_hover_modcp.gif';" onmouseout="topbutton10.src='{$style['imagefolder']}/top_modcp.gif';"><img name="topbutton10" src="{$style['imagefolder']}/top_modcp.gif" border="0" alt="{$lang->items['LANG_GLOBAL_MODCP']}" title="{$lang->items['LANG_GLOBAL_MODCP']}" /></a></then></if><a href="index.php{$SID_ARG_1ST}" onmouseover="topbutton11.src='{$style['imagefolder']}/top_hover_start.gif';" onmouseout="topbutton11.src='{$style['imagefolder']}/top_start.gif';"><img name="topbutton11" src="{$style['imagefolder']}/top_start.gif" border="0" alt="{$lang->items['LANG_GLOBAL_TOINDEX']}" title="{$lang->items['LANG_GLOBAL_TOINDEX']}" /></a></span></td>
  </tr> 
  <tr>
    <td><img src="{$style['imagefolder']}/bottom_l_r.gif" border="0" alt="" title="" /></td>
    <td class="butbottom"></td>
    <td><img src="{$style['imagefolder']}/bottom_l_r.gif" border="0" alt="" title="" /></td>
  </tr>
</table>

<table style="width:{$style['tableoutwidth']}" cellpadding="{$style['tableoutcellpadding']}" cellspacing="{$style['tableoutcellspacing']}" align="center" border="{$style['tableoutborder']}" class="tableoutborder"> <tr> <td class="mainpage" align="center"> <table style="width:100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="logobackground" align="center"><if($style['logoimage']!="")><then><a href="index.php{$SID_ARG_1ST}"><img src="{$style['logoimage']}" border="0" alt="$master_board_name" title="$master_board_name" /></a></then></if></td> </tr> <a href="home.php{$SID_ARG_1ST}"><img src="{$style['imagefolder']}/top_home.gif" border="0" alt="{$lang->items['LANG_GLOBAL_HOME']}" title="{$lang->items['LANG_GLOBAL_HOME']}" /></a> <tr> <td class="mainpage"><table style="width:590px" cellspacing="0" cellpadding="0" border="0"> <tr> <td align="left" style="background-image: url({$style['imagefolder']}/top_bg.gif);"><img src="{$style['imagefolder']}/header_left.gif" border="0" alt="" title="" /></td> <td align="left" style="background-image: url({$style['imagefolder']}/top_bg.gif);"><span class="headerfont"> <a href="index.php{$SID_ARG_1ST}">Forum</a>   <a href="memberslist.php{$SID_ARG_1ST}">Mitglieder</a>   <a href="search.php{$SID_ARG_1ST}">Suche</a>   <a href="team.php{$SID_ARG_1ST}" >Team</a>   <a href="misc.php?action=faq{$SID_ARG_2ND}">Faq</a><if($wbbuserdata['userid'])><then>   <a href="usercp.php{$SID_ARG_1ST}">Profil</a>   <a href="pms.php{$SID_ARG_1ST}">Nachrichten</a></then><else>   <a href="register.php{$SID_ARG_1ST}">Registrieren</a></else></if><if($wbbuserdata['a_can_use_acp']==1 && $wbbuserdata['a_acp_or_mcp']==1)><then>   <a href="acp/index.php" target="_blank">Admin CP</a></then></if><if($wbbuserdata['a_can_use_acp']==1 && $wbbuserdata['a_acp_or_mcp']==0)><then>   <a href="acp/index.php" target="_blank">Mod CP</a></then></if></span></td> <td align="right" style="background-image: url({$style['imagefolder']}/top_bg.gif);"><img src="{$style['imagefolder']}/header_right.gif" border="0" alt="" title="" /></td> </tr> </table> </td> </tr> </table><br />

SQL-DATABASE ERROR Database error in WoltLab Burning Board (2.3.2): Invalid SQL: SELECT p.*, pc.cache, t.threadid, t.boardid, t.topic, t.closed, t.important, t.replycount, t.views FROM bb1_posts p LEFT JOIN bb1_threads t ON (p.threadid = t.threadid) LEFT JOIN bb1_postcache pc ON (p.postid=pc.postid) WHERE p.postid= mysql error: You have an error in your SQL syntax near '' at line 1 mysql error number: 1064 mysql version: 3.23.49-log php version: 4.3.12-dev Date: 11.07.2005 @ 11:19 Script: /forum/home.php Referer: http://seelzeforen.de/forum/index.php