PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : Help: 2 Datenbank fehler ?


Gipskopf
26.02.2008, 22:30
Hi

Habe gerade einen benutzer verwarnt.
Dann wird bei und ein Thema ertellt was versteckt ist und nur S-mods sehen können.

Wenn ich dann auf das Thema klicke bekomme ich eine Fehler meldung.

Könnt ihr mir da bitte helfen ?

Warnung: mysql_query() [function.mysql-query (http://diy-community.de/function.mysql-query)]: Unable to save result set in /includes/class_core.php (Zeile 371)

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,250776,250778)
ORDER BY post.dateline;

MySQL-Fehler : Got error 134 from table handler
Fehler-Nr. : 1030
Datum : Tuesday, February 26th 2008 @ 10:26:43 PM
Skript : http://diy-community.de/showthread.php?t=19739
Referrer : http://diy-community.de/forumdisplay.php?f=81
IP-Adresse : 81.173.187.182
Benutzername : Storm
Klassenname : vb_database

Gipskopf
26.02.2008, 22:33
Und noch ein fehler ?
wenn man auf Ungelesene beiträge klickt kommt das ??


Wir haben seit wochen nix am forum gemacht ?


Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO search (userid, showposts, ipaddress, personal, forumchoice, sortby, sortorder, searchtime, orderedids, announceids, dateline, displayterms, searchhash, completed)
VALUES (1043, 0, '81.173.187.182', 1, '', 'lastpost', 'DESC', 0.01144, '19739,19670,19738,19737,19734,19736,19730,19735,19732,19709,19209,17643,19702,19708,19733,19283,196 05,18796,18651,19273,19727,19466,19690,18968,18273,17623,19688,19367,19710,19476,18992,19267,19728,1 8731,19374,19406,19658,19657,19729,14445,18407,19627,19725,14658,19671,19722,18417,19689,19723,19714 ,19683,19594,19726,18851,19720', '', 1204061485, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:0:{}s:6:\"forums\";N;s:7:\"options\";a:3:{s:11:\"starteronly\";b:0;s:11:\"childforums\";b:1;s:6:\"action\";s:6:\"getnew\";}}', 'a7e07db934360c3898e0dcaec55f73d1', 1);

MySQL-Fehler : Duplicate entry '909615' for key 1
Fehler-Nr. : 1062
Datum : Tuesday, February 26th 2008 @ 10:31:25 PM
Skript : http://diy-community.de/search.php?do=getnew
Referrer : http://diy-community.de/private.php
IP-Adresse : 81.173.187.182
Benutzername : Storm
Klassenname : vb_database

Pathor
27.02.2008, 00:01
Repariere mal alle Tabellen.

eNflamed
27.02.2008, 11:23
moin,

wollte nicht gleich wieder einen neunen faden eröffnen...aber ich bekomme auch einen datenbankfehler gemeldet. :confused:

Datenbankfehler in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User d005b5a1 has already more than 'max_user_connections' active connections
/www/htdocs/w008d1e5/forum/includes/class_core.php on line 274

MySQL-Fehler :
Fehler-Nr. :
Datum : Wednesday, February 27th 2008 @ (http://service.gmx.net/de/cgi/g.fcgi/mail/new?CUSTOMERNO=38073147&t=de1079230818.1204107636.57db5b3d&to=) 08:33:46 AM
Skript : http://www.panik-hilfe.de/forum/index.php (http://service.gmx.net/de/cgi/derefer?TYPE=3&DEST=http%3A%2F%2Fwww.panik-hilfe.de%2Fforum%2Findex.php)
Referrer : http://www.panik-hilfe.de/forum/forumdisplay.php?f=26 (http://service.gmx.net/de/cgi/derefer?TYPE=3&DEST=http%3A%2F%2Fwww.panik-hilfe.de%2Fforum%2Fforumdisplay.php%3Ff%3D26)



weiss einer was ich machen muss?

hcmagix
28.02.2008, 06:05
Wenn Du die php.ini nicht selbst bearbeiten kannst dann deinen Provider fragen ob er die Anzahl der max_user_connections erhöht.