Forum Icon with ACP Control / SQL Error

[mixmax]

Forum_Icon_V1.0.4_en.txt , ohne extra

Couldn't update forum information

DEBUG MODE

SQL Error : 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 '1, prune_enable = 0 WHERE forum_id = 4' at line 2

UPDATE phpbb_forums SET forum_name = 'Test Forum', cat_id = 2, forum_desc = '', forum_status = 0, forum_icon = 'New.gif',show_quickreply = 1, 1, prune_enable = 0 WHERE forum_id = 4

Line : 457
File : admin_forums.php

Wo soll ich den Fehler suchen.?

[Markus67]

Hi ...

Der Fehler ist in der admin_forums.php

Wenn du den Fehler nicht findest verlinke einfach die komplette Datei als txt-Datei.
KB:datei

Markus

[mixmax]

Danke für die schnelle Hilfe.

[Markus67]

Hi ...

hast du einen QuickReply MOD installiert? Wenn ja welchen denn?

Markus

[mixmax]

Customizable Quick Reply

http://www.phpbbhacks.com/download/5196

[Markus67]

Hi ...

der Quick Reply wars ... da ist was doppelt drin ...

suche:

Code: Alles auswählen

			$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']) . ", forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "',show_quickreply = " . intval($HTTP_POST_VARS['show_quickreply']) . ", " . intval($HTTP_POST_VARS['show_quickreply']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "

ersetze mit:

Code: Alles auswählen

			$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']) . ", forum_icon = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', show_quickreply = " . intval($HTTP_POST_VARS['show_quickreply']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "

Markus

[mixmax]

Danke

Funzt jetzt

[Syrus76]

Bei mir gibt's diesbezüglich auch Probleme.

Couldn't update forum information

DEBUG MODE

SQL Error : 1054 Unknown column 'show_quickreply' in 'field list'

UPDATE phpbb_forums SET forum_name = 'Allgemein', cat_id = 1, forum_desc = 'Allgemeine Infos, Rennen und Strecken rund um den F1-Zirkus', forum_status = 0, forum_icon = '', show_quickreply = 0, prune_enable = 0 WHERE forum_id = 2

Line : 451
File : admin_forums.php

Was soll ich tun ??

[Markus67]

Hi ....

hast du die db_update.php ausgeführt?

Markus

[Syrus76]

war keiner dabei - habe folgenden Eintrag gem. Anweisung in der SQL vorgenommen:

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

den Prefix hab ich auf phpbb_forums abgeändert....

Habe keine Fehlermeldung erhalten von PHPmyadmin