vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   quick reply database error (https://vborg.vbsupport.ru/showthread.php?t=309890)

Mariner1 03-25-2014 08:14 PM

quick reply database error
 
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 03-25-2014 08:35 PM

Check error logs and post error here

Mariner1 03-25-2014 08:45 PM

where would i find them pls

--------------- Added [DATE]1395782060[/DATE] at [TIME]1395782060[/TIME] ---------------

ok found them,what am i looking for

RichieBoy67 03-25-2014 09:57 PM

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 03-26-2014 06:18 AM

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...ttttttttt&p=12
IP Address :
Username : Mariner
Classname : vB_Database
MySQL Version : 5.5.36-cll

ForceHSS 03-26-2014 06:49 AM

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
Code:

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


Mariner1 03-26-2014 09:36 AM

Cant do that,i get this message

You are not authorized to execute SQL queries

I'll just keep blogs disabled

ForceHSS 03-26-2014 02:58 PM

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

ozzy47 03-26-2014 11:56 PM

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


All times are GMT. The time now is 02:09 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01012 seconds
  • Memory Usage 1,727KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete