Thread: Major Additions - [DBTech] Dragonbyte Gallery v1 (vB4)
View Single Post
  #376  
Old 11-12-2012, 02:42 PM
ejbreeze ejbreeze is offline
 
Join Date: Nov 2008
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

After importing the albums I am getting this error emailed to me.

PHP Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                                
SELECT
                                        COUNT
(imageid) AS thiscount
                                FROM dbtech_gallery_images gi
                                LEFT JOIN dbtech_gallery_albums ga ON gi
.albumid ga.albumid
                                WHERE
                                        
((gi.albumid 0) || ((ga.hidden        0) && (ga.password '')) || (gi.userid 0)) &&
                                        
gi.instanceid   &&
                                        
gi.approved             &&
                                        
gi.deleted              0
                                MATCH
                                        
(gi.titlegi.textgi.tagginggi.username)
                                
AGAINST
                                        
('+clematis* ' IN BOOLEAN MODE);

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH
                                        (gi.title, gi.text, gi.tagging, gi.username)
                                AGAINST
                                        ('
+c' at line 10
Error Number  : 1064
Request Date  : Monday, November 12th 2012 @ 07:55:52 AM
Error Date    : Monday, November 12th 2012 @ 07:55:52 AM
Script        : http://www.xxx.com/forums/dbtgallery.php?do=search
Referrer      : http://www.xxx/forums/dbtgallery.php?catid=13&gal=gallery
IP Address    : 114.152.214.35
Username      : Mal
Classname     : vB_Database
MySQL Version : 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01304 seconds
  • Memory Usage 1,793KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete