vb.org Archive - How to fix this DB error?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - How to fix this DB error? (https://vborg.vbsupport.ru/showthread.php?t=304358)

katie hunter

11-10-2013 02:07 AM

How to fix this DB error?

I never seen this db error but all of a sudden i am seeing it reported in my email. Any idea how can i fix it?

Code:

Database error in vBulletin 4.2.1:



Invalid SQL:



                SELECT

                    gifts.gifttypeid, gifts.giftid, gifts.comment, gifts.message,

                    gifts.private, gifts.recipient, gifts.recipientid, gifts.sender,

                    gifts.senderid, gift_type.image

                FROM gifts AS gifts

                LEFT JOIN gift_type AS gift_type ON(gifts.gifttypeid = gift_type.gifttypeid)

                WHERE recipientid =

                ORDER BY dateline DESC

                LIMIT 5;



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 'ORDER BY dateline DESC

                LIMIT 5' at line 8

Error Number  : 1064

Request Date  : Saturday, November 9th 2013 @ 07:54:56 PM

Error Date    : Saturday, November 9th 2013 @ 07:54:56 PM

Script        : http://forum.nihonomaru.com/member.php?username=%20%E2%84%9DinReferrer      :

IP Address    : 

Username      :  ℝin

Classname     : vB_Database

MySQL Version :

ozzy47

11-10-2013 02:10 AM

Do you have a mod that deals with gifts?

nerbert

11-10-2013 02:53 AM

Looks like a mod that doesn't verify if a recipient is specified when submitted. The mod developer needs to fix that. In the mean time it probably isn't hurting anything, it just doesn't work when the form isn't fully filled out.

tbworld

11-10-2013 03:02 AM

Quote:

Originally Posted by nerbert (Post 2459594)

Not a bad take on it @Nerbert! :)

ozzy47

11-10-2013 03:04 AM

Looks like it is from this mod, https://vborg.vbsupport.ru/showthread.php?t=189788

katie hunter

11-10-2013 07:07 AM

Nop it is made from ground up for vb 4.x but the dev who made it logs in every day and doesn't reply >.> no matter how many times i poke him.

Still i need to figure out how to fix it. Do you want me to provide a specific php file ?

ozzy47

11-10-2013 10:23 AM

I don't know what the person told you who made the mod for you, but it is not built from the ground up, the query you are having issues with is the same exact query in the mod I linked you to.

katie hunter

11-10-2013 01:18 PM

Really? Do you know how i can fix it ?

ozzy47

11-10-2013 01:21 PM

Not really, without the full mod, it is impossible to tell what may be causing the issue. Even then it may be a pain to track down.

All times are GMT. The time now is 09:58 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01099 seconds Memory Usage 1,726KB 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_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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
Messages: