2024-02-21, 08:46 PM
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)
In user.php, this is the function generating the query:
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);
}
}