- Регистрация
- 15 Ноя 2009
- Сообщения
- 28
- Реакции
- 1
- Автор темы
- Заблокирован
- #1
Обновление вроде прошло успешно..... теперь как понимаю index.php это не главная форума, а главная CMS. Так вот, при преходе на форум (forum.php) выдает такое:
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT user.userid, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
albumpicture.dateline, picture.pictureid, picture.userid, picture.extension,
picture.idhash, picture.thumbnail_filesize, picture.caption AS caption,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
album.albumid AS albumid, album.title AS albumstitle, COUNT(comment.pictureid) AS comments
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 picturecomment AS comment ON (picture.pictureid = comment.pictureid)
LEFT JOIN user AS user ON(user.userid = album.userid)
LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '1' AND userlist.type = 'buddy')
GROUP BY picture.pictureid
ORDER BY albumpicture.dateline DESC
LIMIT 0, 10;
MySQL Error : Table 'novoro_forum.albumpicture' doesn't exist
Error Number : 1146
Request Date : Friday, November 20th 2009 @ 12:14:56 AM
Error Date : Friday, November 20th 2009 @ 12:14:56 AM
Script : Для просмотра ссылки Войдиили Зарегистрируйся
Referrer : Для просмотра ссылки Войдиили Зарегистрируйся
IP Address : 62.12.80.200
Username : Maxim
Classname : vB_Database
MySQL Version : 5.0.81-community
Помогите решить проблему.
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT user.userid, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
albumpicture.dateline, picture.pictureid, picture.userid, picture.extension,
picture.idhash, picture.thumbnail_filesize, picture.caption AS caption,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
album.albumid AS albumid, album.title AS albumstitle, COUNT(comment.pictureid) AS comments
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 picturecomment AS comment ON (picture.pictureid = comment.pictureid)
LEFT JOIN user AS user ON(user.userid = album.userid)
LEFT JOIN userlist AS userlist ON(userlist.userid = album.userid AND userlist.relationid = '1' AND userlist.type = 'buddy')
GROUP BY picture.pictureid
ORDER BY albumpicture.dateline DESC
LIMIT 0, 10;
MySQL Error : Table 'novoro_forum.albumpicture' doesn't exist
Error Number : 1146
Request Date : Friday, November 20th 2009 @ 12:14:56 AM
Error Date : Friday, November 20th 2009 @ 12:14:56 AM
Script : Для просмотра ссылки Войди
Referrer : Для просмотра ссылки Войди
IP Address : 62.12.80.200
Username : Maxim
Classname : vB_Database
MySQL Version : 5.0.81-community
Помогите решить проблему.