[fabiocesar]

Originally Posted by iBaker

Ok, I have been working on this a fair bit and are overcoming many of the problems that it has, both within Impex and this mod.

I have been doing this on my local PC using xampps and once it is all going properly will try on a web server and then if all goes well I will post here the little things that I have had to do to make it work...for example Attachments should use database not file system as that will cause an error etc.

The final error that I have come up with is in the very last process of changing the in-line attachments (step 11).

The error I get is:

ImpEx Database error

mysql error: Invalid SQL: 
            SELECT attachmentid
            FROM attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT , 1000
        

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 ' 1000' at line 5

mysql error number: 1064

Date: Saturday 01st 2012f September 2012 12:24:14 PM
Database: recflynew_forum
MySQL error:

This is the code in the php file that causes the error (011.php):

        // Get an array data
        $attachments = $Db_target->query("
            SELECT attachmentid
            FROM {$t_tb_prefix}attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT $start_at, $per_page
        ");

MySQL Error 1064 seems to fire up if the delimiter is incorrect...it also interesting that there seems to be no value inserted for $start_at

Can anyone help with this final error...thanks!

still no solution for this bug??