Avatare in Dateisystem verschieben MySQL Fehler

**savraot** · 31-07-2011, 19:07

Habe die Avatare ins Dateisystem verschoben, wenn ich das im vbtube acp einstelle (nach verschieben im vbacp) kommt folgender MySQL Datenbankfehler:

Datenbankfehler in vBulletin 4.1.5:

Invalid SQL:
SELECT vb4post.postid AS postid,
vb4post.threadid AS threadid,
vb4post.parentid AS parentid,
vb4post.username AS username,
vb4post.userid AS userid,
vb4post.title AS title,
vb4post.dateline AS dateline,
vb4post.pagetext AS pagetext,
customavatar.userid AS cavuserid,
customavatar.dateline AS cavdateline,
customavatar.width AS cavwidth,
customavatar.height AS cavheight,
avatar.avatarid AS favatarid,
avatar.avatarpath AS avatarpath,
user.userid AS puserid,
user.usergroupid AS groupid,
user.avatarid AS avatarid,
user.avatarrevision AS revision,
vbtube_tubes.tubeid AS tubeid,
vbtube_tubes.title AS ttitle,
vbtube_tubes.reviewid AS reviewid,
vbtube_tubes.active AS active
FROM vb4post
LEFT JOIN vb4user AS user ON(user.userid = vb4post.userid)
LEFT JOIN vb4customavatar AS customavatar ON(customavatar.userid = vb4post.userid)
LEFT JOIN vb4avatar AS avatar ON(avatar.avatarid = vb4user.avatarid)
LEFT JOIN vb4vbtube_tubes AS vbtube_tubes ON(reviewid = vb4post.threadid AND active=1 )
WHERE threadid = vbtube_tubes.reviewid AND parentid > 0 ORDER BY dateline DESC LIMIT 5;

MySQL-Fehler : Unknown column 'vb4user.avatarid' in 'on clause'
Fehler-Nr. : 1054
Fehler-Zeit : Sunday, 31.07.2011 @ 18:59:25
Datum : Sunday, 31.07.2011 @ 18:59:25
Skript : Savraots Cyber Talk
Referrer : Savraots Cyber Talk
IP-Adresse : 95.114.42.133
Benutzername : Savraot
Klassenname : vB_Database
MySQL-Version : 5.1.43-nmm4-log

**s7v7n** · 31-07-2011, 19:52

vbtube/includes/vbtube_commentsbit.php

PHP Code:


avatar.avatarid = " . TABLE_PREFIX . "user.avatarid)

Diesen Part löschen

PHP Code:


" . TABLE_PREFIX . "

**savraot** · 01-08-2011, 06:49

Problem ist gelöst, das funktioniert so!

Vielen Dank für den hilfreichen Tipp

**savraot** · 01-08-2011, 16:18

Doch nicht ganz gelöst. Wenn ich jetzt einen x-beliebigen Trailer in vbtube aufrufe habe ich folgenden Fehler:

LEFT JOIN vb4customavatar AS customavatar ON(customavatar.userid = vb4post.userid)
LEFT JOIN vb4avatar AS avatar ON(avatar.avatarid = vb4user.avatarid)
LEFT JOIN vb4usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
WHERE threadid = '35' AND parentid > '0' ORDER BY dateline DESC LIMIT 0,10;

MySQL-Fehler : Unknown column 'vb4user.avatarid' in 'on clause'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 01.08.2011 @ 16:17:29
Datum : Monday, 01.08.2011 @ 16:17:29
Skript : Savraots Cyber Talk
Referrer : Savraots Cyber Talk
IP-Adresse : 77.3.69.21
Benutzername : Savraot
Klassenname : vB_Database
MySQL-Version : 5.1.43-nmm4-log

Welche Datei muss ich bearbeiten?

**s7v7n** · 01-08-2011, 16:31

vbtube_show.php
vbtube/includes/vbtube_commentsbit.php

Finden:

PHP Code:


avatar.avatarid = " . TABLE_PREFIX . "user.avatarid

Löschen

PHP Code:


" . TABLE_PREFIX . "

**savraot** · 01-08-2011, 16:38

Super, passt wieder

**savraot** · 23-11-2011, 06:45

Mit dem Update auf vb 4.1.8 unf vbtube 2.5.2 wieder das gleiche Spiel wenn ich Avatare in das Dateisystem verschiebe????

Code:

Datenbankfehler in vBulletin 4.1.8:

Invalid SQL:
SELECT 	vb4post.postid AS postid, 
				vb4post.threadid AS threadid, 
				vb4post.parentid AS parentid, 
				vb4post.username AS username, 
				vb4post.userid AS userid, 
				vb4post.title AS title, 
				vb4post.dateline AS dateline, 
				vb4post.pagetext AS pagetext,
				customavatar.userid AS cavuserid,
				customavatar.dateline AS cavdateline,
				customavatar.width AS cavwidth,
				customavatar.height AS cavheight,
				avatar.avatarid AS favatarid,
				avatar.avatarpath AS avatarpath,
				user.userid AS puserid,
				user.usergroupid AS groupid,
				user.avatarid AS avatarid,
				user.avatarrevision AS revision,
				vbtube_tubes.tubeid AS tubeid,
				vbtube_tubes.title AS ttitle,
				vbtube_tubes.reviewid AS reviewid,
				vbtube_tubes.active AS active										
		FROM vb4post
		LEFT JOIN vb4user AS user ON(user.userid = vb4post.userid)
		LEFT JOIN vb4customavatar AS customavatar ON(customavatar.userid = vb4post.userid)
		LEFT JOIN vb4avatar AS avatar ON(avatar.avatarid = vb4user.avatarid)
		LEFT JOIN vb4vbtube_tubes AS vbtube_tubes ON(reviewid = vb4post.threadid AND active=1 )
		WHERE threadid = vbtube_tubes.reviewid AND parentid > 0 ORDER BY dateline DESC LIMIT 5;

MySQL-Fehler  : Unknown column 'vb4user.avatarid' in 'on clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Wednesday, 23.11.2011 @ 06:33:08
Datum         : Wednesday, 23.11.2011 @ 06:33:09
Skript        : http://www.XXX/videogalerie
Referrer      : http://www.XXX/sony-ps3-11/
IP-Adresse    : 95.113.231.139
Benutzername  : XXX
Klassenname   : vB_Database
MySQL-Version : 5.1.43-nmm4-log

Code:

Datenbankfehler in vBulletin 4.1.8:

Invalid SQL:
SELECT 	vb4post.postid AS postid, 
				vb4post.threadid AS threadid, 
				vb4post.parentid AS parentid, 
				vb4post.username AS username, 
				vb4post.userid AS userid, 
				vb4post.title AS title, 
				vb4post.dateline AS dateline, 
				vb4post.pagetext AS pagetext,
				usergroup.usergroupid AS usergroupid,
				usergroup.usertitle AS utitle,
				usergroup.opentag AS opentag,
				usergroup.closetag AS closetag,
				customavatar.userid AS cavuserid,
				customavatar.dateline AS cavdateline,
				customavatar.width AS cavwidth,
				customavatar.height AS cavheight,
				avatar.avatarid AS favatarid,
				avatar.avatarpath AS avatarpath,
				user.userid AS puserid,
				user.usergroupid AS groupid,
				user.avatarid AS avatarid,
				user.avatarrevision AS revision						
		FROM vb4post
		LEFT JOIN vb4user AS user ON(user.userid = vb4post.userid)
		LEFT JOIN vb4customavatar AS customavatar ON(customavatar.userid = vb4post.userid)
		LEFT JOIN vb4avatar AS avatar ON(avatar.avatarid = vb4user.avatarid)
		LEFT JOIN vb4usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
		WHERE threadid = '698' AND parentid > '0' ORDER BY dateline DESC LIMIT 0,10;

MySQL-Fehler  : Unknown column 'vb4user.avatarid' in 'on clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Wednesday, 23.11.2011 @ 06:34:14
Datum         : Wednesday, 23.11.2011 @ 06:34:14
Skript        : http://www.XXX/videos/138/wo-kommen-viren-her.html
Referrer      : 
IP-Adresse    : 85.13.146.147
Benutzername  : Unregistriert
Klassenname   : vB_Database
MySQL-Version :

Das nervt so ziemlich!

**savraot** · 25-11-2011, 08:03

Gibt es da keine Lösung für das Problem?

**s7v7n** · 25-11-2011, 11:04

Das hängt leider von der mysql Version und mysql Einstellungen ab.
Da es nicht möglich ist diese vorher abzufragen musst du 2 kleine edits machen.

File: vbtube_show.php
vbtube/includes/vbtube_commentsbit.php

Finde 2 mal:

PHP Code:


ON(avatar.avatarid = " . TABLE_PREFIX . "user.avatarid)

Ersetze es mit:

PHP Code:


ON(avatar.avatarid = user.avatarid)

Lade die editierte vbtube_show.php und vbtube_commentsbit.php Datei hoch und es müsste dann gehen.

Ich habe gerade gemerkt, daß ich das oben im Thread schon erklärt habe wie es zu reparieren ist.
Jetzt ists doppelt.

**savraot** · 25-11-2011, 18:58

Code:

ON(avatar.avatarid = user.avatarid)

Diese Zeilen hast du schon in der 2.5.2 so eingebaut

(commentbit und vbtube_show.php) und das funktioniert jetzt nicht mehr, deshalb habe ich nochmals in dieses Thema geposted.

Thread: Avatare in Dateisystem verschieben MySQL Fehler

LinkBack

Thread Tools

Display

Avatare in Dateisystem verschieben MySQL Fehler

Posting Permissions