Foutmelding bij mod met plaatjes bij ieder forum.

[Pieter_1983]

Wat is het probleem?Bij het installeren van de "A picture to illustrate each one of your forums"mod krijg ik een foutmelding.
Wanneer ontstond het probleem? Bij het installeren
Adres van je forum: http://www.theohuiberts.nl/forum (het is een testforum om eerst mods te installeren voor ik mijn goede forum verpest)
Geïnstalleerde mods: A picture to illustrate each one of your forums
Huidige template: subsilver en FI Black 3D Blue
phpBB versie: 2.0.19
Host: pcextreme.nl
Heb je onlangs een mod of stijl geïnstalleerd? ja die ene dus.
Heb je gezocht naar een antwoord?Ja, en al aan mensen met php kennis gevraagd maar kan er niet op komen :S[/list]

hij moest erg makkelijk zijn maar ik blijf deze error krijgen :

Code: Selecteer alles

Could not query categories list

DEBUG MODE

SQL Error : 1054 Unknown column 'c.cat_icon' in 'field list'

SELECT c.cat_id, c.cat_title, c.cat_order, c.cat_icon FROM phpbb_categories c ORDER BY c.cat_order

Line : 118
File : index.php 
  

Bovenin het tekstbestandje van de mod staat dit :

Code: Selecteer alles

# 
#-----[ ACTION: EXECUTE]----------------------------------- 
# 
# 
SQL QUERY: 
ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);

Maar daar begrijp ik niks van, misschien dat het hier aan ligt en iemand mij kan helpen dit probleem op te lossen.
ps. Ik ben php/sql leek.

[XP-Rene]

Ga naar je phpMyAdmin en voer daar deze query uit.
Dus in phpMyAdmin klik je op "SQL" en daar zet je dit in:

Code: Selecteer alles

ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);

En klik vervolgens op "Start" of "Execute".

[Pieter_1983]

Dat phpMyAdmin, heb ik gedownload en geunzipt, maar moet ik dat uploaden naar mijn forum dir ?

edit :
Heb het onder de kennisbank gevonden, en volgens mij goed gevolgd maar ik krijg dit als ik ga naar http://www.theohuiberts.nl/phpmyadmin/

Code: Selecteer alles

Warning: Cannot modify header information - headers already sent by (output started at /home/theohuiberts.nl/www/phpmyadmin/libraries/common.lib.php(100) : eval()'d code:814) in /home/theohuiberts.nl/www/phpmyadmin/libraries/select_theme.lib.php on line 92

Warning: Cannot modify header information - headers already sent by (output started at /home/theohuiberts.nl/www/phpmyadmin/libraries/common.lib.php(100) : eval()'d code:814) in /home/theohuiberts.nl/www/phpmyadmin/index.php on line 121

Kan iemand mij alsjeblieft vertellen wat ik fout doe ?

[XP-Rene]

Heb je geen toegang tot phpMyAdmin gekregen van je host?

[Pieter_1983]

ik was net een bericht aan het typen toen ik je bericht zag,

ik kwam er dus achter dat ik via pcextreme er gewoon toegang toe had
ben ff aan het zoeken gegaan en ben hierop uitgekomen :

Fout
SQL-query:

ALTER TABLE prefix_forums ADD forum_icon VARCHAR( 100 )
MySQL retourneerde:

#1146 - Table '5999test.prefix_forums' doesn't exist

[ Terug ]

[Paul]

prefix_ veranderen in jouw prefix

[XP-Rene]

Oke,
tabel 5999test.prefix_forums bestaat dus niet.

Stond er in die Mod nog meer over SQL uitvoeren.
Normaal gesproken zou er in die mod moeten staan dat er tabellen aangemaakt moeten worden, of je hebt het zelf niet goed gedaan/gelezen.

[Pieter_1983]

waar moet ik dat veranderen en wat is prefix ? :p

[Pieter_1983]

Zo heb ik het gedownload

Code: Selecteer alles

###############################################
## 
## MOD Title:   Categories & Forum Icon 
## MOD Version: 1.0.0
## Author: Anh Le Minh < netanh@zapo.net > 
## Website: http://www.netanh.com
## Forum: http://forum.netanh.com
## Description: This Mod gives 1 images beside your categories name, forum name on
## index page
##
## Files To Edit: 7
##                language/lang_xxx/lang_main.php 
##                language/lang_xxx/lang_admin.php 
##                admin/admin_forums.php
##                templates/YOUR_TEMPLATE/admin/forum_edit_body.tpl
##                templates/YOUR_TEMPLATE/admin/category_edit_body.tpl
##                templates/YOUR_TEMPLATE/index_body.tpl
##                index.php 
## Installation Time:   10-15 Minutes 
## Included Files:      none 
## 
################################################################################### 
## 
## Installation/Author Notes: 
## First always make a back-up from the files that 
## you're going to edit.
## 
## This add-on MOD adds a few field to your 'forums' & 'categories' table. 
################################################################################### 

# 
#-----[ ACTION: EXECUTE]----------------------------------- 
# 
# 
SQL QUERY: 
ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);

# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: language/lang_xxx/lang_main.php 

[FIND]: 
// 
// That's all Folks! 

[ADD AFTER]: 

// Categories & Forum icon MOD
$lang['Icon'] = "Icon"; 

####### SAVE & CLOSE: language/lang_xxx/lang_main.php ####### 
#############################################################


# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: language/lang_xxx/lang_admin.php 

[FIND]: 
// 
// That's all Folks! 

[ADD AFTER]: 

// Categories & Forum icon MOD
$lang['Icon'] = "Icon"; 

####### SAVE & CLOSE: language/lang_xxx/lang_admin.php ####### 
#############################################################


# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: admin\admin_forums.php

[FIND]: 
case 'editforum':
			//
			// Show form to create/modify a forum
			//
			if ($mode == 'editforum')
			{
				// $newmode determines if we are going to INSERT or UPDATE after posting?

				$l_title = $lang['Edit_forum'];
				$newmode = 'modforum';
				$buttonvalue = $lang['Update'];

				$forum_id = intval($HTTP_GET_VARS[POST_FORUM_URL]);

				$row = get_info('forum', $forum_id);

				$cat_id = $row['cat_id'];
				$forumname = $row['forum_name'];
				$forumdesc = $row['forum_desc'];
				$forumstatus = $row['forum_status'];
[ADD AFTER]: 
$forumicon = $row['forum_icon'];

------------------------------
[FIND]: 
$forumdesc = '';

[ADD AFTER]: 
$forumicon = '';

------------------------------
[FIND]: 
'L_FORUM_DESCRIPTION' => $lang['Forum_desc'],

[ADD AFTER]: 
'L_ICON' => $lang['Icon'],

------------------------------
[FIND]: 
'DESCRIPTION' => $forumdesc)

[REPLACE WITH]:
'DESCRIPTION' => $forumdesc,
'F_ICON' => $forumicon)

------------------------------
[FIND]:
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";

[REPLACE]:
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, forum_icon, cat_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
				VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";


------------------------------
[FIND]:
$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
				WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);


[REPLACE]:
$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
				WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);


------------------------------
[FIND]:
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order)
				VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order)";


[REPLACE]:
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order, cat_icon) 
            VALUES ('" . $HTTP_POST_VARS['categoryname'] . "', $next_order, $caticon)";

------------------------------
[FIND]:
$cat_title = $row['cat_title'];

[ADD AFTER]:
$caticon = $row['cat_icon'];


------------------------------
[FIND]:
'CAT_TITLE' => $cat_title,

[ADD AFTER]:
'CAT_ICON' => $caticon,
'L_ICON' => $lang['Icon'],


------------------------------
[FIND]:
// Modify a category in the DB
$sql = "UPDATE " . CATEGORIES_TABLE . "
	SET cat_title = '" . str_replace("\'", "''", $HTTP_POST_VARS['cat_title']) . "' 
	WHERE cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]);

[REPLACE]:
$sql = "UPDATE " . CATEGORIES_TABLE . "
	SET cat_title = '" . str_replace("\'", "''", $HTTP_POST_VARS['cat_title']) . "', cat_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['cat_icon']) . "' 
	WHERE cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]);


------------------------------
[FIND]:
$name = $catinfo['cat_title'];

[ADD AFTER]:
$caticon = $catinfo['cat_icon'];

####### SAVE & CLOSE: admin\admin_forums.php ####### 
#############################################################

# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: index.php

[FIND]: 
//
// Start page proper
//
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
	FROM " . CATEGORIES_TABLE . " c 

[REPLACE]: 
//
// Start page proper
//
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order, c.cat_icon
	FROM " . CATEGORIES_TABLE . " c 

------------------------------
[FIND]: 
if ( $display_forums )
		{
			$template->assign_block_vars('catrow', array(
				'CAT_ID' => $cat_id,
				'CAT_DESC' => $category_rows[$i]['cat_title'],
				'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id"))
			);

[REPLACE]: 
if ( $display_forums )
		{
				if ($category_rows[$i]['cat_icon'] != '')
				{$c_icon = '&nbsp;<img src="'.$category_rows[$i]['cat_icon'].'"/>&nbsp;';}
                                else {$c_icon = '';}
			$template->assign_block_vars('catrow', array(
				'CAT_ID' => $cat_id,
				'CAT_DESC' => $category_rows[$i]['cat_title'],
				'CAT_ICON' => $c_icon,
				'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id"))
			);


------------------------------
[FIND]: 
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
							
$template->assign_block_vars('catrow.forumrow',	array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'FORUM_FOLDER_IMG' => $folder_image, 
'FORUM_ID' => $forum_data[$j]['forum_id'], 
'FORUM_NAME' => $forum_data[$j]['forum_name'],
'FORUM_DESC' => $forum_data[$j]['forum_desc'],
'POSTS' => $forum_data[$j]['forum_posts'],
'TOPICS' => $forum_data[$j]['forum_topics'],


[REPLACE]: 
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
if ($forum_data[$j]['forum_icon'] != '')
{$f_icon = '&nbsp;<img src="'.$forum_data[$j]['forum_icon'].'">&nbsp;';}
else {$f_icon = '';}

$template->assign_block_vars('catrow.forumrow',	array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'FORUM_FOLDER_IMG' => $folder_image, 
'FORUM_ID' => $forum_data[$j]['forum_id'], 
'FORUM_NAME' => $forum_data[$j]['forum_name'],
'FORUM_DESC' => $forum_data[$j]['forum_desc'],
'FORUM_ICON' => $f_icon,
'POSTS' => $forum_data[$j]['forum_posts'],
'TOPICS' => $forum_data[$j]['forum_topics'],

####### SAVE & CLOSE: index.php ####### 
#############################################################


# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: templates\subSilver\admin\forum_edit_body.tpl

[FIND]: 
	<tr> 
	  <td class="row1">{L_FORUM_DESCRIPTION}</td>
	  <td class="row2"><textarea rows="5" cols="45" wrap="virtual" name="forumdesc" class="post">{DESCRIPTION}</textarea></td>
	</tr>

[ADD AFTER]: 
<tr> 
   <td class="row1">{L_ICON}</td>
   <td class="row2"><input type="text" size="25" name="forumicon" value="{F_ICON}" class="post" /></td>
</tr>

####### SAVE & CLOSE: templates\subSilver\admin\forum_edit_body.tpl ####### 
###########################################################################


# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: templates\subSilver\admin\category_edit_body.tpl

[FIND]: 
	<tr> 
	  <td class="row1">{L_CATEGORY}</td>
	  <td class="row2"><input type="text" size="25" name="cat_title" value="{CAT_TITLE}" /></td>
	</tr>

[ADD AFTER]: 
<tr> 
   <td class="row1">{L_ICON}</td>
   <td class="row2"><input type="text" size="25" name="cat_icon" value="{CAT_ICON}" class="post" /></td>
</tr>


####### SAVE & CLOSE: templates\subSilver\admin\category_edit_body.tpl ####### 
##############################################################################


# 
#-----[ ACTION: ]------------------------------------------ 
# OPEN: templates\subSilver\index_body.tpl

[FIND]: 
<span class="cattitle"><a href="{catrow.U_VIEWCAT}" class="cattitle">{catrow.CAT_DESC}</a></span>

[ADD BEFORE]: 
{catrow.CAT_ICON}


------------------------------
[FIND]: 
<span class="forumlink"> <a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a>

[ADD BEFORE]: 
{catrow.forumrow.FORUM_ICON}


####### SAVE & CLOSE: templates\subSilver\index_body.tpl ####### 
################################################################

[XP-Rene]

waar moet ik dat veranderen en wat is prefix ? :p

Huh?

[Pieter_1983]

waar moet ik dat veranderen en wat is prefix ? :p

Huh?

paulus Geplaatst: Ma Jan 30, 2006 2:31 pm Onderwerp:

--------------------------------------------------------------------------------

prefix_ veranderen in jouw prefix

[XP-Rene]

De standaard prefix is phpbb_ en deze staat opgeslagen in config.php
Dus

Code: Selecteer alles

ALTER TABLE prefix_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE prefix_categories ADD cat_icon VARCHAR(100);

wordt

Code: Selecteer alles

ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE phpbb_categories ADD cat_icon VARCHAR(100);

[Pieter_1983]

als ik kijk in de config.php is die helemaal leeg.

[XP-Rene]

als ik kijk in de config.php is die helemaal leeg.

1. Als je config.php leeg is, kun je niet eens in je forum inloggen.
2. Je moet dit ook niet wijzigen in config.php
3. Deze query moet je uitvoeren in phpMyAdmin.

Dit is wat er in mijn config.php staat:

Code: Selecteer alles

<?php


// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'localhost';
$dbname = 'wasedierenbescherming_com_-_forum';
$dbuser = '********';
$dbpasswd = '********';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

Dus de jouewe kan nooit leeg zijn.

[Pieter_1983]

Dus de jouewe kan nooit leeg zijn.

Nee klopt, ik zat lokaal te kijken want had de config niet teruggehaald in deze dir.

maar ja het werkt nog niet :S

Code: Selecteer alles

SQL-query: 

SELECT * 
FROM `phpbb_config` 
WHERE 1 
ALTER TABLE phpbb_forums ADD forum_icon VARCHAR( 100 ) 
MySQL retourneerde:  

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(100)' at line 2 

[XP-Rene]

Heb je je config.php nagekeken op de prefix?

[Pieter_1983]

config.php via phpmyadmin :

SELECT * FROM `phpbb_config` WHERE 1


config.php via kladblok :

<?php


// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'db.pcextreme.nl';
$dbname = '5999test';
$dbuser = '****';
$dbpasswd = '****';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

[Pieter_1983]

Weet iemand hoe ik deze fout kan herstellen en wil hij mij daar mee helpen ?

[Paul]

je moet wat in het vak sql stond wel eerst weghalen

[XP-Rene]

Dus, als je phpMyAdmin start en op SQL klikt, haal je dit weg:

Code: Selecteer alles

SELECT * FROM `phpbb_config` WHERE 1

en vervang je door

Code: Selecteer alles

ALTER TABLE phpbb_forums ADD forum_icon VARCHAR(100); 
ALTER TABLE phpbb_categories ADD cat_icon VARCHAR(100);

en ram je op "Start".