Error Number : 1052 (attachment)

S

snoopdo2g

New Member
Hi there !

im gettin' this error when im done uploading an attachment to a post,
i just submit the post and that's when im gettin this.
I've added a small hack for showing NFO's as PNG's and even
if i remove it i will still have this problem, it might have to do
with thumbnail as it says in the error...

anyways, i need help if someone can tell me exactly, what to do,
because i've read several posts on the net but it can' help...
im a kind of n00b in those things lol, i tried repair database,
nothing happend...

Thanks !


Code: 
Database error in vBulletin 3.8.2:

Invalid SQL:

			SELECT  filename,filedata, filesize, visible, attachmentid, counter, postid, IF(thumbnail = '', 0, 1) AS hasthumbnail, LENGTH(thumbnail) AS thumbnailsize,
				attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
			FROM attachment
			LEFT JOIN attachmenttype AS attachmenttype USING (extension)
			WHERE postid IN (-1,3550)
			ORDER BY attachmentid;

MySQL Error   : Column 'thumbnail' in field list is ambiguous
Error Number  : 1052




Update:

i now tried to change that text up there with same text of showthread.php (the original untouched one from the install)
and it gives me another kind of error:

Fatal error: Call to a member function fetch_array() on a non-object in /home/mysite/public_html/myforum/showthread.php on line 973

and at that line, there is that:


while ($attachment = $db->fetch_array($attachments))




EDIT: RESOLVED read last post ;)
 
If you uninstall the hack, this will go away, I reccomend that you find a better one.

Make sure you remove all files and template edits along with the hack
 
mmmxiv said:
If you uninstall the hack, this will go away, I reccomend that you find a better one.

Make sure you remove all files and template edits along with the hack
Click to expand...



thanks but as i said i already done that........
"if i remove it i will still have this problem, it might have to do
with thumbnail as it says in the error..."

also removed all templates edits etc..... all but nuthin' changed.

and still now if i try to upload any kind of attachment i can't read the thread
and i get that error...

Heeeeeeelpppppp please..
 
Also i just disabled the ncode image resizer to see if it has anything to do
and re enabled after but now it's not workin' anymore...


I tried sumfin else, see first post Updated
and it's givin' me another kind of error...

Thanks for reading,
any help is appreciated thanks :(






EDIT: Nevermind, i found a way around :D
i just reinstalled the whole vBulletin :D
saved my db and everything worked perfect ;)

Peace !
and thanks for the peopz who tried to help ;)
 
You must log in or register to reply here.
Back
Top