vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Database error in vBulletin 4.1.1 (https://vborg.vbsupport.ru/showthread.php?t=293256)

hallianonline 12-24-2012 02:02 PM

Database error in vBulletin 4.1.1
 
Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT a.attachmentid
FROM attachment AS a
WHERE
(filedataid = AND userid = 3);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND userid = 3)' at line 4
Error Number : 1064
Request Date : Monday, December 24th 2012 @ 02:18:27 AM
Error Date : Monday, December 24th 2012 @ 02:18:27 AM

Kindly Provide solution how to correct it. due to this error i could not upload attachments

Lynne 12-24-2012 03:50 PM

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS'true); 


hallianonline 12-25-2012 04:18 PM

i m using following plugins do u suggest which of them could cause problem

Display Unread Posts and Reputation 4.1.7.0

Forum Category Icons (Advanced) 2.0.0

Inferno vBShout 2.5.2

Limited Guest Viewing 2.1.0
Members who have Visited 4.1.7.0
Top Posters 4.1.7.0

Usergroup Color Bar 2.0.0

vBSEO :: Sitemap Generator 3.0

VSa - ChatBox 3.1.8 VSa - ChatBox

VSa - Sub-Forum Manager 3.1.4

Who Has Read a Thread 4.1.7.0

Lynne 12-26-2012 03:31 AM

I have no idea. Try disabling them all, see if the problem goes away, then add them back one-by-one to see which one makes the problem come back.


All times are GMT. The time now is 08:24 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.01028 seconds
  • Memory Usage 1,715KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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