[DragonByte Tech]

Originally Posted by ejbreeze

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   = 1 &&
                                        gi.approved             = 1 &&
                                        gi.deleted              = 0
                                MATCH
                                        (gi.title, gi.text, gi.tagging, gi.username)
                                AGAINST
                                        ('+clematis* ' IN BOOLEAN MODE);

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


Try opening dbtech/gallery/modules/gallery/functions/class_module.php

About line 1063 you might see

PHP Code:

                    gi.deleted        = 0 
                MATCH 
                    (gi.title, gi.text, gi.tagging, gi.username) 
                AGAINST 
                    " . $boolean_query
            );
        } elseif (($type == 'all_images_thumb') || ($type == 'all_images_full')) { 


With no && after the deleted = 0. If you do, change it to

PHP Code:

                    gi.deleted        = 0 && 
                MATCH 
                    (gi.title, gi.text, gi.tagging, gi.username) 
                AGAINST 
                    " . $boolean_query
            );
        } elseif (($type == 'all_images_thumb') || ($type == 'all_images_full')) { 


I think that's where it's coming from. If it's right then let me know and I'll keep checking.
Dylan