quick reply database error

[Mariner1]

When using the quick reply it says The following errors occurred with your submission

Database Error

The reply posts even though the screen doesnt change and it looks like the reply doesnt post.If you click post quick reply again it says

The following errors occurred with your submission

This post is a duplicate of a post that you have posted in the last five minutes.

If you come out of the screen altogether it shows your reply

How do i fix this pls

[ForceHSS]

Check error logs and post error here

[Mariner1]

where would i find them pls

--------------- Added 1395782060 at 1395782060 ---------------

ok found them,what am i looking for

[RichieBoy67]

Well it is hard to help you without the exact database error you are getting so lets start with that.

Normally you would have an admin email set in your config where database errors would get sent to. This would help too.

[Mariner1]

This os the error.I dont get error if i disable blogs

Invalid SQL:


SELECT
fd.thumbnail_dateline, fd.filesize, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fd.thumbnail_filesize,
a.dateline, a.state, a.attachmentid, a.counter, a.contentid, a.filename, a.userid, a.settings, a.displayorder,
at.contenttypes
,blog_user.entries, fd.filedata, a.info_hash, a.size, a.ul_x, a.dl_x, a.flags, a.comment, a.created_by, a.announce_list, a.completed.
FROM attachment AS a
INNER JOIN filedata AS fd ON (fd.filedataid = a.filedataid)
LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)


WHERE
a.contentid = 13
AND
a.contenttypeid = 1


ORDER BY a.contentid, a.displayorder;

MySQL Error : Unknown column 'blog_user.entries' in 'field list'
Error Number : 1054
Request Date : Wednesday, March 26th 2014 @ 06:14:06 AM
Error Date : Wednesday, March 26th 2014 @ 06:14:06 AM
Script : http://184.107.137.18/newreply.php?do=postreply&t=7
Referrer : http://184.107.137.18/showthread.php?7-tttttttttttttttttttttttt&p=12
IP Address :
Username : Mariner
Classname : vB_Database
MySQL Version : 5.5.36-cll

[ForceHSS]

What vb version are you running?
You are missing a table for blogs. Download vb files again upload them and run the upgrade.php should reinstall the missing table. But first if you have a backup would be better to try that first.

If 4.2.2 run this admincp/Maintenance/Execute SQL Query

ALTER TABLE `blog_user`
ADD COLUMN `entries` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `lastblogtextid`;

[Mariner1]

Cant do that,i get this message

You are not authorized to execute SQL queries

I'll just keep blogs disabled

[ForceHSS]

You need to add your userid in the config.php file

[ozzy47]

Have you tried on a unmodified default style?
Have you tried with all mods disabled?
What vB version and PHP version are you running?