PDA

View Full Version : Mysql error!


pattox2k1
24 Apr 2002, 00:07
hi....my board is giving me this

Database error in vBulletin 2.2.5:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,580)
ORDER BY dateline

mysql error: Unknown column 'attachment.counter' in 'field list'

mysql error number: 1054

Date: Wednesday 24th of April 2002 12:02:18 AM
Script: http://www.thugnature.net/forums/forums/showthread.php?s=&threadid=77
Referer: http://www.thugnature.net/forums/online.php?

when you go to a thread

then -

when you try to acces an attachment there was a dif 1

can you please help!
thanks!

Steve Machol
24 Apr 2002, 05:45
For some reason the 'counter' field is missing from your attachment table. Is this happening with all attchments or just this one?

pattox2k1
24 Apr 2002, 05:48
oh.....i previously had a problem with the attachments....so i told my fellow admin and he changed it....he may have removed it,

just to be sure....what should i add to attachments.php in phpmyadmin

if you could contact me on AIM = tsnoopcom
MSN = tupacsnop@hotmail.com

thanks!

Steve Machol
24 Apr 2002, 05:58
Sorry, I'm not good enogh with mySQL to know how to put a missing field back in. Hopefully someone else will have an idea.

pattox2k1
24 Apr 2002, 05:59
ok then....thanks...

i hope some1 can help!

FWC
24 Apr 2002, 06:19
That field should be:

counter smallint(5) unsigned NOT NULL default '0'

I can't imagine why the other admin would have dropped that field.

Chen
24 Apr 2002, 10:52
Run this query to add the field:
ALTER TABLE attachment ADD counter smallint(5) unsigned NOT NULL default '0';

Teach your admins not to drop any fields, lol.

pattox2k1
24 Apr 2002, 12:46
thanks fellas!

but i do have 1 other - its when u go to open an attachment

Database error in vBulletin 2.2.5:

Invalid SQL: SELECT downloads FROM user WHERE userid = 2
mysql error: Unknown column 'downloads' in 'field list'

mysql error number: 1054

Date: Wednesday 24th of April 2002 12:42:27 PM
Script: http://www.thugnature.net/forums/forums/attachment.php?postid=568
Referer: http://www.thugnature.net/forums/showthread.php?threadid=74

hope yall can help again!

pattox2k1
24 Apr 2002, 13:19
BTW chen....yall know im new....
was wondering why your who downloaded this hack isnt working here - http://www.thugnature.net/forums/showthread.php?threadid=74

thanks!