vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   attachments : DB Error (https://vborg.vbsupport.ru/showthread.php?t=129573)

dsa411 10-20-2006 08:06 PM
attachments : DB Error
 
Hi i have vb 3.6.1 installed and when i am in admincp trying to manage my attachments i get database errors for pretty much every option except the maanger. All parts of the attachment section start out good (i can see the page for the function) until i try to perform the actual function(hit save, go, search etc..) like move attacments from database to file system or search for attacments
here is the error i get

Code:
Database error in vBulletin 3.6.1:

Invalid SQL:

                SELECT attachmentid, attachment.dateline, attachment.postid, filename, counter,
                user.userid, IF(user.userid<>0, user.username, post.username) AS username
                FROM vb_attachment AS attachment
                LEFT JOIN vb_user AS user ON (attachment.userid=user.userid)
                LEFT JOIN vb_post AS post ON (attachment.postid=post.postid)
                ORDER BY counter DESC
                LIMIT 5;

MySQL Error  : Column: 'counter' in field list is ambiguous
Error Number : 1052
Date        : Friday, October 20th 2006 @ 05:59:42 PM
Script      : http://****/****/admincp/attachment.php?do=stats
Referrer    : http://****/****/admincp/index.php?do=nav
IP Address  : *.*.*.*
Username    : ****
Classname    : vb_database
This error is i get from clickin attachment statistics.

i have only v3arcade related hacks installed and i am positive the error happend before installation of the hacks. for what ever reason(im a moron) i decided to wait til now to get to it.

Paul M 10-20-2006 08:28 PM
In default vb, only the attachment table has a field called counter - you seem to have one in either your post or user table. It's not added by the arcade so an old modification must have added in the past. You should check which of those two table has the extra column and drop/rename it.

dsa411 10-21-2006 03:54 AM
Thank you so much! just dropped the table and it worked out fine:cool:

seems like the only other problem i have is moving the attachments from the database to filesystem here is the error
Code:
atabase error in vBulletin 3.6.1:

Invalid SQL:

                SELECT attachmentid, filename, filedata, filesize, userid, thumbnail
                FROM vb_attachment
                WHERE attachmentid >= 2 AND attachmentid < 302
                ORDER BY attachmentid ASC;

MySQL Error  : MySQL client run out of memory
Error Number : 2008
Date        : Saturday, October 21st 2006 @ 01:59:19 AM
Script      : http://****/*****/admincp/attachment.php?do=domoveattachment
Referrer    : http://****/*****/admincp/attachment.php?do=doswitchtype
IP Address  : *.*.*.*
Username    : *****
Classname    : vb_database
FIXED!
seems i just turned "Number of attachments to process per cycle" down and worked fine. guess my server cant handle 300 :)


All times are GMT. The time now is 10:54 PM.

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.01429 seconds
  • Memory Usage 1,714KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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