Attachment Mod fehler

[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

[Pansen]

kann mia in diesem Forum niemand helfen?!Schade eig aber naja was will man machen...

[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

[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