Hallo Julian,
was mir gerade aufgefallen ist:
Die Moduleinstellungen dafür sind im ACP in den "vBCMS Einstellungen" unter "Allgemeine-Einstellungen" und nicht unter "Modul-Einstellungen" zu finden. Liegt das an mir, oder hat das noch jemand ?
Gruss,Micha
__________________
Das Forum für Opel Omega/Senator Freunde : www.omega-senator.de
SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, albumpicture.dateline, album.public, picture.thumbnail_filesize, album.albumid AS albumid, picture.caption AS caption, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM albumpicture AS albumpicture
INNER JOIN picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '1' AND userlist.type = 'buddy')
ORDER BY albumpicture.dateline
LIMIT 5;
MySQL Error : Unknown column 'album.public' in 'field list'
Error Number : 1054
Date : Friday, January 25th 2008 @ 12:40:06 PM
Script : Startseite - *******
Referrer : ********
IP Address :
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.26
Hallo,
seit dem Update auf Beta 4 habe ich auch die Fehlermeldung:
Code:
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, albumpicture.dateline, album.public, picture.thumbnail_filesize, album.albumid AS albumid, picture.caption AS caption, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM albumpicture AS albumpicture
INNER JOIN picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '1' AND userlist.type = 'buddy')
ORDER BY albumpicture.dateline
LIMIT 2;
MySQL Error : Unbekanntes Tabellenfeld 'album.public' in field list
Error Number : 1054
Date : Sunday, January 27th 2008 @ 07:58:00 PM
Script : http://www.xxxxxx.de/forum/index.php?area=vbcmsarea_home
Referrer : http://www.xxxxxx.de/forum/forum.php
IP Address : xxxxxxxxxxx
Username : Merlin
Classname : vB_Database
MySQL Version : 5.0.45-Dotdeb_0.dotdeb.1-log
Hat sich anscheinend mit der Beta 4 was geändert
Gruss,Micha
__________________
Das Forum für Opel Omega/Senator Freunde : www.omega-senator.de
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the Startseite - ***** home page, then try to open another page.
Click the Back button to try another link.
The Startseite - ***** forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Das kommt aber nur bei Mitgliedern wenn Sie auf Satrtseite klicken "index.php war mal vbcms"!
Als Admin kommt das nicht!
ich weiß das daher weil wenn ich das Modul deaktiviere ist der Fehler weg.
Ich übernehme das mal
Als Admin, bzw. Mod usw läuft das ganze, bei unregistrierten kommt leider diese Fehlermeldung. Wäre schön wenn man das zum laufen bekommt, empfinde das als ein sehr interessantes Modul.
Quote:
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, albumpicture.dateline, IF(album.state = 'public', 1, 0) AS public, picture.thumbnail_filesize, album.albumid AS albumid, picture.caption AS caption, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM vb_albumpicture AS albumpicture
INNER JOIN vb_picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vb_album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN vb_userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '0' AND userlist.type = 'buddy')
WHERE (public > 0 OR NOT ISNULL(userlist.relationid))
ORDER BY albumpicture.dateline
LIMIT 4;
MySQL Error : Unknown column 'public' in 'where clause'
Error Number : 1054
Date : Wednesday, January 30th 2008 @ 06:06:30 AM
Script : Startseite - Obscurus Forums
Referrer : Obscurus Forums
IP Address : 84.141.77.131
Username : Unregistered
Classname : vb_database
MySQL Version :
-->
sql fehler sieht man im quelltext die obere Meldung bringt nicht viel
Hier der Quell Text
Quote:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>***********Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.************.de/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The ***********database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.**************.de</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The Startseite - ********* forum technical staff have been notified of the error, though you may <a href="mailto:************.de">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, albumpicture.dateline, IF(album.state = 'public', 1, 0) AS public, picture.thumbnail_filesize, album.albumid AS albumid, picture.caption AS caption, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM albumpicture AS albumpicture
INNER JOIN picture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN album AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '4' AND userlist.type = 'buddy')
WHERE (public > 0 OR NOT ISNULL(userlist.relationid))
ORDER BY albumpicture.dateline
LIMIT 4;
MySQL Error : Unknown column 'public' in 'where clause'
Error Number : 1054
Date : Wednesday, January 30th 2008 @ 01:32:40 PM
Script : Startseite - *******
Referrer : *******
IP Address : **.**.**.***
Username : ******
Classname : vB_Database
MySQL Version :
-->
20.12.2007, 21:19
.
Linear Mode
Similar Threads