SQL Query

I'm not versed enough in MySQL and Dolphin... with that said.

Can someone tell me if this will work with 7.1.x?

$sqlQuery = "SELECT `bx_events_main`.`ID` FROM `bx_events_main` WHERE `bx_events_main`.`ResponsibleID` = '{$iProfileId}' ORDER BY `bx_events_main`.`Date` DESC LIMIT 1";

Has any of this changed? This is taken from a module written for 7.0.x, I'm getting an error.

Found error in the file '/home/public_html/modules/*/*/classes/the_file_in_question.php' at line 1286.

Called 'db_res' function with erroneous argument #0.

Debug backtrace:

Array

(

    [1] => Array

        (

            [file] => /home/public_html/inc/classes/BxDolDb.php

            [line] => 237

            [function] => error

            [class] => BxDolDb

            [object] => BxDolDb Object

                (

                    [error_checking] => 1

                    [error_message] => 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 '

        943952400, 

        1, 

        '', 

        'Event, Party', 

        '' at line 46

try:

$sSQL = mysql_query("SELECT `ID` FROM `bx_events_main` WHERE `ResponsibleID` = '$iProfileId' ORDER BY `Date` DESC LIMIT 1");

Thanks for the attempt, I was going to delete this but I think others may want to know this...

Actually I found what was causing this, for those still wanting to use "Beckmedia Facebook Ultimate Module."

I have fixed this module to work with 7.1.x (on a limited bases) and for 7.0.9.

Something recently with Facebook I guess and was getting all kinds of errors when using the FB event import part of the module, this is the only thing I use if for, so I worked for two months trying to find the problems.

The one throwing this error was this code, what it exactly does I don't know. I know it's about the date though.

list($date, $time) = explode('T', $EventStart);        list($year, $month, $day) = explode('-', $date);        list($hour, $minute, $second) = explode(':', $time);        $timestamp2 = mktime($hour + 4, $minute, $second, $month, $day, (int) $year);        return $timestamp2;

I had to add the "2" after $timestamp that was the original way it was; I had forgot the last one on the return $timestamp2;

Now all my Facebook events imported, the module can be seen working here, only for events though.

This is also the site where the spammers have attacked all the modules except the events.

http://duvallocals.com/m/events/home/