MyBB Community Forums

Is there a fix for this  or should I roll my own?

Thanks in advance!

Database: MariaDB 10.19
MyBB: 1.8.23
Merge: 1.8.23

Here is the offending query in users.php 
(Clearly  the comma in ''LIMIT , 1000" is not right)

Quote:

SELECT * FROM ibf_members m LEFT JOIN ibf_profile_portal pp ON (m.member_id=pp.pp_member_id) LEFT JOIN ibf_pfields_content pc ON (m.member_id=pc.member_id) LIMIT , 1000

 
In user.php, this is the   function generating the query:

function import()
        {
                global $import_session;

                // Get members
                $query = $this->old_db->query("
                        SELECT *
                        FROM ".OLD_TABLE_PREFIX."members m
                        LEFT JOIN ".OLD_TABLE_PREFIX."profile_portal pp ON (m.member_id=pp.pp_member_id)
                        LEFT JOIN ".OLD_TABLE_PREFIX."pfields_content pc ON (m.member_id=pc.member_id)
                        LIMIT ".$this->trackers['start_users'].", ".$import_session['users_per_screen']
                );
                while($user = $this->old_db->fetch_array($query))
                {
                        $this->insert($user);
                }
        }