PDA


View Full Version : Geting the following error, the CMPS works onse and stops


Skaterscafe.com
07-31-2005, 06:30 PM
I installed the CMPS and after install it works...once. After that I get the error below. I uninstalled and re-installed the CMPS and again, it worked once and stopped. I get the following, any ideas?

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT attachmentid, filename, filesize, visible, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize FROM attachment WHERE postid IN(118069,118064,116351,115797,115696,115371,11537 0,115367) ORDER BY attachmentid
mysql error: Unknown column 'thumbnail_filesize' in 'field list'

mysql error number: 1054

Date: Sunday 31st of July 2005 07:39:49 AM
Script: http://www.lawncafe.com/cmps_index.php
Referer:
Username: ***********
IP Address: *************

Skaterscafe.com
08-02-2005, 03:46 PM
Anyone?

Brian
08-03-2005, 06:04 PM
Have you added any hacks to your forum that have anything to do with attachments? That is a valid column and you should have it on your attachment column.

Skaterscafe.com
08-05-2005, 12:15 AM
Thanks Brian,

No, the forum is lightly hacked, it has v3arcade, no double post, FlashChat, online last 24 hours, and a few small ones...nothing to do with images. I uninstalled again and reinstalled and the same, worked once and then gone.

Brian
08-05-2005, 12:21 PM
Actually, I see the problem now - you're running vB 3.0.1. There have been several releases since then (quite a few security related), so I would seriously suggest upgrading.