You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Got the following error when importing our IPB 3.1.4:
Private Message
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 'AND map_user_id!=1456 AND map_user_active=1' at line 1
Query:
SELECT * FROM TAG_message_topic_user_map WHERE map_topic_id= AND map_user_id!=1456 AND map_user_active=1
Checking the mybb_privatemessages table a single PM was imported 3 times.
Looking in the merge\boards\ipb3\privatemessages.php it appears to be line 102:
$rec_query = $this->old_db->simple_select('message_topic_user_map', '*', "map_topic_id={$data['mt_id']} AND map_user_id!={$data['msg_author_id']} AND map_user_active=1");
specifically {$data['mt_id']} has not returned any data
SELECT *
FROM TAG_message_topic_user_map WHERE map_topic_id= AND map_user_id!=1456 AND map_user_active=1
Looking at the original query and what it returns
SELECT *
FROM ".OLD_TABLE_PREFIX."message_posts m
LEFT JOIN ".OLD_TABLE_PREFIX."message_topics mt ON(m.msg_topic_id=mt.mt_id)
LEFT JOIN ".OLD_TABLE_PREFIX."message_topic_user_map mp ON(mp.map_topic_id=mt.mt_id AND mp.map_user_id=mt.mt_starter_id)
LIMIT ".$this->trackers['start_privatemessages'].", ".$import_session['privatemessages_per_screen']
mt_id AND map_topic_id can be NULL according to my data (attached exported JSON from phpMyAdmin). TAG_message_posts.zip
I guess this would then mean that you need to check if {$data['mt_id']} IS NULL before running that section?
The text was updated successfully, but these errors were encountered:
Got the following error when importing our IPB 3.1.4:
Private Message
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 'AND map_user_id!=1456 AND map_user_active=1' at line 1
Query:
SELECT * FROM TAG_message_topic_user_map WHERE map_topic_id= AND map_user_id!=1456 AND map_user_active=1
Checking the mybb_privatemessages table a single PM was imported 3 times.
Looking in the merge\boards\ipb3\privatemessages.php it appears to be line 102:
$rec_query = $this->old_db->simple_select('message_topic_user_map', '*', "map_topic_id={$data['mt_id']} AND map_user_id!={$data['msg_author_id']} AND map_user_active=1");
specifically {$data['mt_id']} has not returned any data
SELECT *
FROM TAG_message_topic_user_map
WHERE map_topic_id= AND map_user_id!=1456 AND map_user_active=1
Looking at the original query and what it returns
SELECT *
FROM ".OLD_TABLE_PREFIX."message_posts m
LEFT JOIN ".OLD_TABLE_PREFIX."message_topics mt ON(m.msg_topic_id=mt.mt_id)
LEFT JOIN ".OLD_TABLE_PREFIX."message_topic_user_map mp ON(mp.map_topic_id=mt.mt_id AND mp.map_user_id=mt.mt_starter_id)
LIMIT ".$this->trackers['start_privatemessages'].", ".$import_session['privatemessages_per_screen']
mt_id AND map_topic_id can be NULL according to my data (attached exported JSON from phpMyAdmin).
TAG_message_posts.zip
I guess this would then mean that you need to check if {$data['mt_id']} IS NULL before running that section?
The text was updated successfully, but these errors were encountered: