1 頁 (共 1 頁)

[問題]討論版 版面圖示 V1.0.5(已解決)

發表於 : 2004-03-24 15:30
jessie
問題外掛:討論版 版面圖示 V1.0.5
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... highlight=
使用版本:phpBB 2.0.7
網站位置:localhost
狀況描述:
錯誤

SQL 語法 :

ALTER TABLE `phpbb2_forums` ADD `forum_icon` VARCHAR( 255 ) default NULL

MySQL 傳回:


#1146 - Table 'phpbb2.phpbb2_forums' doesn't exist



請問fisubice風格的index_body.tpl要怎麼編改

發表於 : 2004-03-24 16:54
YOYOER
請你先檢查你的資料庫名稱是什麼\r
我剛剛裝好\r
那時也發生這個問題
我的資料庫名稱是PHPBB
所以我把他的PHPBB2_forums
改成PHPBB_forums
就可以拉

發表於 : 2004-03-24 17:02
jessie
YOYOER 寫:請你先檢查你的資料庫名稱是什麼\r
我剛剛裝好\r
那時也發生這個問題
我的資料庫名稱是PHPBB
所以我把他的PHPBB2_forums
改成PHPBB_forums
就可以拉
資料庫沒設錯\r
我的名稱phpbb2
自然也對應phpbb2_forums

發表於 : 2004-03-24 17:05
很明顯的就是沒有"phpbb2_forums"這個表格!phpbb2是資料庫而非表格!...請把它改成

ALTER TABLE `phpbb_forums` ADD `forum_icon` VARCHAR( 255 ) default NULL

發表於 : 2004-04-04 14:12
jessie
我的風格裡面只有一個colspan可不可以教我怎麼改下面這部分
#-----[ 打開 ]------------------------------------------
#
templates/subSilver/index_body.tpl

#
#-----[ 尋找 ]------------------------------------------
#
<th colspan="2" class="thCornerL" height="25" nowrap="nowrap"> {L_FORUM} </th>

#
#-----[ 之中, 尋找 ]------------------------------------------
#
colspan="2"

#
#-----[ 取代為 ]------------------------------------------
#
colspan="3"

#
#-----[ 尋找 ]------------------------------------------
#
<td class="catLeft" colspan="2" height="28"><span class="cattitle"><a href="{catrow.U_VIEWCAT}" class="cattitle">{catrow.CAT_DESC}</a></span></td>

#
#-----[ 之中, 尋找 ]------------------------------------------
#
colspan="2"

#
#-----[ 取代為 ]------------------------------------------
#
colspan="3"

#
我的index_body.tpl

代碼: 選擇全部

<!-- BEGIN switch_user_logged_out -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><img src="templates/jasidogdotcom/images/frametl.gif" width="12" height="13"></td>
    <td background="templates/jasidogdotcom/images/framet.gif"></td>
    <td align="right"><img src="templates/jasidogdotcom/images/frametr.gif" width="11" height="13"></td>
  </tr>
  <tr> 
    <td background="templates/jasidogdotcom/images/framel.gif"></td>
    <td width="100%" valign="top">
<form method="post" action="{S_LOGIN_ACTION}">
  <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
	<tr> 
	        <td class="catHead"><a name="login"></a><span class="cattitle">{L_LOGIN_LOGOUT}</span></td>
	</tr>
	<tr> 
	  <td class="row1" align="center" valign="middle" height="28"><span class="gensmall">{L_USERNAME}: 
		<input class="post" type="text" name="username" size="10" />
		   {L_PASSWORD}: 
		<input class="post" type="password" name="password" size="10" maxlength="32" />
		     {L_AUTO_LOGIN} 
		<input class="text" type="checkbox" name="autologin" />
		    
		<input type="submit" class="mainoption" name="login" value="{L_LOGIN}" />
		</span> </td>
	</tr>
  </table>
</form>
    </td>
    <td background="templates/jasidogdotcom/images/framer.gif"></td>
  </tr>
  <tr> 
    <td><img src="templates/jasidogdotcom/images/framebl.gif" width="12" height="11"></td>
    <td background="templates/jasidogdotcom/images/frameb.gif"></td>
    <td><img src="templates/jasidogdotcom/images/framebr.gif" width="11" height="11"></td>
  </tr>
</table>
<!-- END switch_user_logged_out -->
<br>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><img src="templates/jasidogdotcom/images/frametl.gif" width="12" height="13"></td>
    <td background="templates/jasidogdotcom/images/framet.gif"></td>
    <td align="right" background="templates/jasidogdotcom/images/framet.gif"><img src="templates/jasidogdotcom/images/frametr.gif" width="11" height="13"></td>
  </tr>
  <tr> 
    <td background="templates/jasidogdotcom/images/framel.gif"></td>
    <td width="100%">
	 <table width="100%" cellspacing="0" cellpadding="2" border="0" align="center">
  <tr> 
	<td align="left" valign="bottom"><span class="gensmall">
	<!-- BEGIN switch_user_logged_in -->
	{LAST_VISIT_DATE}<br />
	<!-- END switch_user_logged_in -->
	{CURRENT_TIME}<br /></span><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
	<td align="right" valign="bottom" class="gensmall">
		<!-- BEGIN switch_user_logged_in -->
		<a href="{U_SEARCH_NEW}" class="gensmall">{L_SEARCH_NEW}</a><br /><a href="{U_SEARCH_SELF}" class="gensmall">{L_SEARCH_SELF}</a><br />
		<!-- END switch_user_logged_in -->
		<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a><br /><a href="{U_RECENT}" class="gensmall">{L_RECENT}</a></td>
  </tr>
</table>
  <!-- BEGIN catrow -->
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
        <tr> 
          <th class="thCornerL" nowrap> </th>
          <th align="left" class="thCornerL" nowrap> {L_FORUM}</th>
          <th width="50" class="thTop" nowrap> {L_TOPICS} </th>
          <th width="50" class="thTop" nowrap> {L_POSTS} </th>
          <th class="thCornerR" nowrap> {L_LASTPOST} </th>
        </tr>
      
        <tr> 
          <td class="catLeft"><span class="cattitle"></span></td>
          <td class="catLeft" colspan="4"><span class="cattitle"><a href="{catrow.U_VIEWCAT}" class="cattitle">{catrow.CAT_DESC}</a></span></td>
        </tr>
        <!-- BEGIN forumrow -->
        <tr> 
          <td class="row1" align="center" valign="middle" height="50"><img src="{catrow.forumrow.FORUM_FOLDER_IMG}" width="26" height="25" alt="{catrow.forumrow.L_FORUM_FOLDER_ALT}" title="{catrow.forumrow.L_FORUM_FOLDER_ALT}" /></td><td class="row1" align="center" valign="middle" height="50">{catrow.forumrow.FORUM_ICON_IMG}</td>
          <td class="row1" width="100%" height="50"><span class="forumlink"> <a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><br />
            </span> <span class="genmed">{catrow.forumrow.FORUM_DESC}<br />
            </span><span class="gensmall">{catrow.forumrow.L_MODERATOR} {catrow.forumrow.MODERATORS}</span></td>
          <td class="row2" align="center" valign="middle" height="50"><span class="gensmall">{catrow.forumrow.TOPICS}</span></td>
          <td class="row2" align="center" valign="middle" height="50"><span class="gensmall">{catrow.forumrow.POSTS}</span></td>
          <td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"> <span class="gensmall"><a href="{catrow.forumrow.U_LAST_TOPIC}">{catrow.forumrow.LAST_TOPIC}</a><br />{catrow.forumrow.LAST_POST}</span></td>
        </tr>
        <!-- END forumrow -->
        
      </table><br/><br/>
<!-- END catrow -->
	  <table width="100%" cellspacing="0" border="0" align="center" cellpadding="0">
  <tr> 
	<td align="left"><span class="gensmall"><a href="{U_MARK_READ}" class="gensmall">{L_MARK_FORUMS_READ}</a></span></td>
	<td align="right"><span class="gensmall">{S_TIMEZONE}</span></td>
  </tr>
</table>
    </td>
    <td background="templates/jasidogdotcom/images/framer.gif"></td>
  </tr>
  <tr> 
    <td><img src="templates/jasidogdotcom/images/framebl.gif" width="12" height="11"></td>
    <td background="templates/jasidogdotcom/images/frameb.gif"></td>
    <td><img src="templates/jasidogdotcom/images/framebr.gif" width="11" height="11"></td>
  </tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td><img src="templates/jasidogdotcom/images/frametl.gif" width="12" height="13"></td>
    <td background="templates/jasidogdotcom/images/framet.gif"></td>
    <td align="right"><img src="templates/jasidogdotcom/images/frametr.gif" width="11" height="13"></td>
  </tr>
  <tr> 
    <td background="templates/jasidogdotcom/images/framel.gif"></td>
    <td width="100%"> 
      <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
        <tr> 
          <td class="catHead"> </td>
          <td class="catHead"><span class="cattitle"><a href="{U_VIEWONLINE}" class="cattitle">{L_WHO_IS_ONLINE}</a></span></td>
        </tr>

        <tr> 
          <td class="row1" align="center" valign="middle" rowspan="3"><img src="templates/jasidogdotcom/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" /></td>
          <td class="row1" align="left" width="100%"><span class="gensmall">{TOTAL_POSTS}<br />
            {TOTAL_USERS}<br />
            {NEWEST_USER}</span> </td>
        </tr>
        <tr> 
          <td class="row1" align="left"><span class="gensmall">{TOTAL_USERS_ONLINE} 
              [ {L_WHOSONLINE_ADMIN} ]   [ {L_WHOSONLINE_MOD} ]<br />
            {RECORD_USERS}<br />
            {LOGGED_IN_USER_LIST}</span></td>
        </tr>
        <tr> 
          <td class="row1" align="left"><span class="gensmall">{L_ONLINE_EXPLAIN}</span></td>
        </tr>
      </table>
      
    </td>
    <td background="templates/jasidogdotcom/images/framer.gif"></td>
  </tr>
  <tr> 
    <td><img src="templates/jasidogdotcom/images/framebl.gif" width="12" height="11"></td>
    <td background="templates/jasidogdotcom/images/frameb.gif"></td>
    <td><img src="templates/jasidogdotcom/images/framebr.gif" width="11" height="11"></td>
  </tr>
</table>
<br>

<br clear="all" />
<table cellspacing="3" border="0" align="center" cellpadding="0">
  <tr> 
    <td width="20" align="center"><img src="templates/jasidogdotcom/images/folder_new.gif" alt="{L_NEW_POSTS}"/></td>
    <td><span class="gensmall">{L_NEW_POSTS}</span></td>
    <td>  </td>
    <td width="20" align="center"><img src="templates/jasidogdotcom/images/folder.gif" alt="{L_NO_NEW_POSTS}" /></td>
    <td><span class="gensmall">{L_NO_NEW_POSTS}</span></td>
    <td>  </td>
    <td width="20" align="center"><img src="templates/jasidogdotcom/images/folder_lock.gif" alt="{L_FORUM_LOCKED}" /></td>
    <td><span class="gensmall">{L_FORUM_LOCKED}</span></td>
  </tr>
</table>
圖檔
這個問題不知道是不是上面沒設好

發表於 : 2004-04-04 17:51
Mac
試試看吧:

尋找\r

代碼: 選擇全部

          <th align="left" class="thCornerL" nowrap> {L_FORUM}</th> 
替換成

代碼: 選擇全部

          <th align="left" class="thCornerL" colspan="2" nowrap> {L_FORUM}</th> 
尋找\r

代碼: 選擇全部

          <td class="catLeft" colspan="4">
替換成

代碼: 選擇全部

          <td class="catLeft" colspan="5">
~Mac

發表於 : 2004-04-04 17:57
jessie
Mac 寫:試試看吧:
可以了...謝謝 Mac