Database ERror

[Hon3Y]

hey am having databse error .. plz tell me wt to do here is error's

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM subscription ORDER BY displayorder;

MySQL Error : Unknown column \'displayorder\' in \'order clause\'
Error Number : 1054


second error is :-
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 = 16
AND album.state IN (\'public\', \'private\', \'profile\')
AND (album.visible > 0 OR album.moderation > 0)

ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column \'album.moderation\' in \'field list\'
Error Number : 1054


plz tell me
Edit/Delete Message

 

[Hon3Y]

anyone care to answer

 

[DOPE]

whoever userid16 is, is the one causing the problem...
check through their pictures and what not....
if that doesnt help you may need to repair your database....
go into your cpanel...
go to mysql... theres an option to repair database...see if that works

 

[Hon3Y]

i did that repairing the sql

no that user is not problem ..whenever i clicked my own name ..dis give me error

 

[DOPE]

hey am having databse error .. plz tell me wt to do here is error's

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM subscription ORDER BY displayorder;

MySQL Error : Unknown column \'displayorder\' in \'order clause\'
Error Number : 1054


second error is :-
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 = 16
AND album.state IN (\'public\', \'private\', \'profile\')
AND (album.visible > 0 OR album.moderation > 0)

ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column \'album.moderation\' in \'field list\'
Error Number : 1054


plz tell me
Edit/Delete Message

it says an album of user 16....

 

[Hon3Y]

nah if u reg on my site username :test pass :desirootz

DesirootZ - Connecting Punjabi'z N Non Punjabi'z Powered By DesirootZ

noow when i click it come databse error means little problem is solved

now wt to do

 

[Hon3Y]

nah if u reg on my site username :test pass :desirootz

DesirootZ - Connecting Punjabi'z N Non Punjabi'z Powered By DesirootZ

noow when i click it come databse error means little problem is solved

now wt to do