Problem mit Galerie (The Table is full)

[Bin]

Hi Leute,

ich habe die 4Images Galerie installiert. Ich weis nicht, ob ihr sie kennt.

Aber ich habe ein Problem mit den "Top Bildern".

Hier ist mal die URL zu der Galerie:

http://www.vw-freaks.net/galerie/4images/

Hier ist mal die URL zu den "Top Bildern":

http://www.vw-freaks.net/galerie/4im...fd8fe01c6c8bd0

Hier ist ein Ausschnitt aus dem Code:

// Comments
if ($mode == "comments") {
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_comments, i.image_hits, i.image_rating, i.image_votes, i.image_thumb_file, c.cat_name".get_user_table_field(", u.", "user_name")."
FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id
$cat_match_sql
ORDER BY i.image_comments DESC, i.image_hits DESC, i.image_rating DESC, image_votes DESC
LIMIT 20";
$result = $site_db->query($sql);
$top_list = array();
$i = 1;
while ($row = $site_db->fetch_array($result)) {
$top_list[$i] = $row;
$i++;
}
$site_db->free_result();
$register_array['lang_top'] = "Most commented";

for ($i = 1; $i <= 20; $i++) {
if (isset($top_list[$i])) {
$register_array['image_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);
$register_array['image_openwindow_'.$i] = (check_permission("auth_viewimage", $top_list[$i]['cat_id'])) ? "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\" onclick=\"opendetailwindow()\" target=\"detailwindow\">".htmlspecialchars($top_list[$i]['image_name'])."</a>" : htmlspecialchars($top_list[$i]['image_name']);
if (isset($top_list[$i][$user_table_fields['user_name']]) && $top_list[$i]['user_id'] != GUEST) {
$user_profile_link = (!empty($url_show_profile)) ? preg_replace("/{user_id}/", $top_list[$i]['user_id'], $url_show_profile) : ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$top_list[$i]['user_id'];
$register_array['image_user_'.$i] = "<a href=\"".$site_sess->url($user_profile_link)."\">".htmlspecialchars($top_list[$i][$user_table_fields['user_name']])."</a>";
}
else {
$register_array['image_user_'.$i] = $lang['userlevel_guest'];
}
$register_array['image_cat_'.$i] = "<a href=\"".$site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$top_list[$i]['cat_id'])."\">".htmlspecialchars($top_list[$i]['cat_name'])."</a>";
$register_array['image_number_'.$i] = "<b>".$top_list[$i]['image_comments']."</b> Comments";
$register_array['image_thumb_'.$i] = "<a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$top_list[$i]['image_id'])."\"><img src=\"data/thumbnails/".$top_list[$i]['cat_id']."/".$top_list[$i]['image_thumb_file']."\" border=\"0\" alt=\"\" />";
}
else {
$register_array['image_'.$i] = "--";
$register_array['image_user_'.$i] = "--";
$register_array['image_cat_'.$i] = "--";
$register_array['image_number_'.$i] = "--";
$register_array['image_thumb_'.$i] = "--";
}
}}

Und wenn man nun auf die "Top Bilder" schaut, dann kommt folgender Fehler:

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_comments, i.image_hits, i.image_rating, i.image_votes, i.image_thumb_file, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id ORDER BY i.image_comments DESC, i.image_hits DESC, i.image_rating DESC, image_votes DESC LIMIT 20
The table 'SQL15694e17_0' is full

Als wir noch ca 20 Bilder in der Galerie hatten, funktionierten die Top Bilder ohne Probleme.
Doch jetzt haben wir 1561 Bilder in der Galerie und auf einmal funktionieren die Top Bilder nicht mehr...

An was könnte das liegen?

Ich hoffe ihr könnt mir weiterhelfen!
Ich weis wirklich nicht mehr was ich machen soll...

[Abraxax]

The table 'SQL15694e17_0' is full .....

[goth]

http://dev.mysql.com/doc/mysql/en/Full_table.html