03-30-2010, 08:05 PM
|
|
|
|
Join Date: Jul 2006
Posts: 1,131
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Installing VB 4 with SQL Errors in 3.8.5. Can I install it anyways?
I've been having a lot of DB errors on VB 3.5.8. Also when attempting to reinstall VB 3.5 I get an "unable to find site" after clicking on "Upgrade" - step 3. I thought that one solution might be to install VB 4.0. Are these errors going to interfere with an upgrade?
In the ACP Index:
Quote:
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Tuesday, March 30th 2010 @ 03:42:38 PM
Error Date : Tuesday, March 30th 2010 @ 03:42:38 PM
Script : http://www.XXXXXXXXXXXXforum/admincp/index.php?do=home
Referrer : http://www.XXXXXXXXXX.com/forum/admi...dex.php?do=nav
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community
|
This happens when clicking on a username:
Quote:
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.userid = 17
AND album.state IN ('public', 'private', 'profile')
ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Table 'XXXXXXXXXXXX.picture' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 30th 2010 @ 03:52:20 PM
Error Date : Tuesday, March 30th 2010 @ 03:52:21 PM
Script : http://www.XXXXXXXX.com/forum/member.php?u=17
Referrer : http://www.XXXXXXXXXXXXXX.com/forum/...e&pp=50&page=1
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community
|
This happens when clicking on one particular post:
Quote:
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,9129,9131,9137,9148,9149,9150,9151,9174,9354,936 3,9401,9404,9485,9490,9495)
ORDER BY attachmentid;
MySQL Error : Unknown column 'extension' in 'from clause'
Error Number : 1054
Request Date : Tuesday, March 30th 2010 @ 03:55:47 PM
Error Date : Tuesday, March 30th 2010 @ 03:55:47 PM
Script : http://www.XXXXXXXXXX.com/forum/showthread.php?t=798
Referrer : http://www.XXXXXXXXXXXX.com/forum/forumdisplay.php?f=53
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community
|
There are most likely more but they would be taking up board space. TIA.
|