Seite 1 von 1

Attachment Mod fehler

Verfasst: 13.12.2005 22:02
von Pansen
Moin erstmal,

Ich habe ein problem mit dem Attachment Mod er funktioniert nicht so ganz...

immer wenn ich im Adminpanel Manage Extensions auswähle kommt erstmal eine Reihe von Fehlern
Warning: mysql_free_result(): 44 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 46 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 47 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 48 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 49 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 50 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 51 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 52 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 53 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 54 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 55 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 56 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 57 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 58 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 59 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 60 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 61 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 62 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 63 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 64 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 65 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 66 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 67 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 68 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 69 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 70 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 71 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 72 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

Warning: mysql_free_result(): 73 is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/b11b1/Forum/phpBB2/db/mysql4.php on line 318

der fehler stört mich eig nit das einzige prob daran wenn ich eine neue extension hinzufügen oder eine alte ändern will kommt der Fehler:
Couldn't update Extension Informations

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 'UPDATE WHERE ext_id = 16' at line 1

UPDATE phpbb_extensions SET UPDATE WHERE ext_id = 16

Line : 133
File : admin_extensions.php

schnelle Hilfe wäre Super

MFG

Pansen

Verfasst: 14.12.2005 18:43
von Pansen
kann mia in diesem Forum niemand helfen?!Schade eig aber naja was will man machen...

Verfasst: 25.12.2005 21:12
von EliteGurke
hey da,

hab das gleiche problem...

zu den warnings gibts nen bugreport mit lösung:
http://sourceforge.net/tracker/index.ph ... tid=536151

OPEN
attach_mod/includes/functions_selects.php

FIND

Code: Alles auswählen

function group_select($select_name,
$default_group = 0)
{
global $db, $lang;

$sql = 'SELECT group_id, group_name
FROM ' . EXTENSION_GROUPS_TABLE . '
ORDER BY group_name';

if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, "Couldn't query Extension
Groups Table", "", __LINE__, __FILE__, $sql);
}

$group_select = '<select name="' . $select_name . '">';

$group_name = $db->sql_fetchrowset($result);
$num_rows = $db->sql_numrows($result);
$db->sql_freeresult($result);

if ($num_rows > 0)
{
$group_name[$num_rows]['group_id'] = 0;
$group_name[$num_rows]['group_name'] =
$lang['Not_assigned'];

for ($i = 0; $i < sizeof($group_name); $i++)
{
if (!$default_group)
{
$selected = ($i == 0) ? ' selected="selected"' : '';
}
else
{
$selected = ($group_name[$i]['group_id'] ==
$default_group) ? ' selected="selected"' : '';
}

$group_select .= '<option value="' .
$group_name[$i]['group_id'] . '"' . $selected . '>' .
$group_name[$i]['group_name'] . '</option>';
}
}
$db->sql_freeresult($result);

$group_select .= '</select>';

return $group_select;
}
REPLACE WITH

Code: Alles auswählen

function group_select($select_name,
$default_group = 0)
{
global $db, $lang;

$sql = 'SELECT group_id, group_name
FROM ' . EXTENSION_GROUPS_TABLE . '
ORDER BY group_name';

if (!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, "Couldn't query Extension
Groups Table", "", __LINE__, __FILE__, $sql);
}

$group_select = '<select name="' . $select_name . '">';

$group_name = $db->sql_fetchrowset($result);
$num_rows = $db->sql_numrows($result);
$db->sql_freeresult($result);

if ($num_rows > 0)
{
$group_name[$num_rows]['group_id'] = 0;
$group_name[$num_rows]['group_name'] =
$lang['Not_assigned'];

for ($i = 0; $i < sizeof($group_name); $i++)
{
if (!$default_group)
{
$selected = ($i == 0) ? ' selected="selected"' : '';
}
else
{
$selected = ($group_name[$i]['group_id'] ==
$default_group) ? ' selected="selected"' : '';
}

$group_select .= '<option value="' .
$group_name[$i]['group_id'] . '"' . $selected . '>' .
$group_name[$i]['group_name'] . '</option>';
}
}

$group_select .= '</select>';

return $group_select;
}
zum dem fehler gibts leider noch nichts offizielles, aber ich empfehle dir auf http://www.opentools.de nachzuschaun. das is die heimat vom attachement mod.

so far
mfg EliteGurke

Verfasst: 25.12.2005 21:27
von EliteGurke
ok, selbst dem fehler bin ich jetzt auf den grund gegangen:
in Datei admin/admin_extensions.php
in Zeile 128 folgendes ändern:

aus:
$sql = 'UPDATE ' . EXTENSIONS_TABLE . ' SET ' . attach_mod_sql_escape('UPDATE', $sql_ary) . '
mache:
$sql = 'UPDATE ' . EXTENSIONS_TABLE . ' SET ' . attach_mod_sql_build_array('UPDATE', $sql_ary) . '

so far
mfg EliteGurke