vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Error Number : 1054 (https://vborg.vbsupport.ru/showthread.php?t=243136)

kkingg 05-23-2010 05:31 AM

Error Number : 1054
 
Database error in vBulletin 4.0.1:
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
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 IN (2689,4851,10698,10701,13006,13008,13013,13083,130 84,13101)
AND
a.contenttypeid = 1
ORDER BY a.contentid, a.displayorder;


MySQL Error : Unknown column 'a.displayorder' in 'field list'
Error Number : 1054
Request Date : Sunday, May 23rd 2010 @ 09:18:21 AM
Error Date : Sunday, May 23rd 2010 @ 09:18:21 AMScript : http://www.myforumtr.com/showthread.php?t=1691
Referrer : IP Address : 207.46.13.139
Username : Kayıtsız ?ye
Classname : vB_Database
MySQL Version :

Videx 05-24-2010 01:01 AM

You've done a good job of pasting an error, but you haven't told us much else. Like specifically, have you tried disabling all your mods? What else have you done to try to fix the problem? Have you searched for the error here and at vb.com? How often does the error happen and can you reproduce it?

kkingg 05-26-2010 08:32 PM

thanks


All times are GMT. The time now is 08:38 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.00952 seconds
  • Memory Usage 1,711KB
  • 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)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