I just came across this extension and am in the process of trying it out.
Is the xml structure for the update_users.xml the same as export_users.xml ?
As a test I exported the users from my development board that is running 3.1.2, renamed the export_users.xml to update_users.xml and removed the values of user_id, user_ip, and user_birthday. I changed the values of username, user_email and user_password. I save the file as update_users.xml. The update.xml looks like :
<?xml version="1.0" encoding="UTF-8"?>
<USERS>
<user>
<user_id></user_id>
<user_ip></user_ip>
<user_regdate>1456342565</user_regdate>
<username>Test.User</username>
<user_email>
Test.User@email.com</user_email>
<user_birthday></user_birthday>
<user_password>testing123</user_password>
</user>
</USERS>
I copied this xml file to FORUM_PATH\store\update_users.xml
I go to the ACP/Users and Groups/Ex-IMport Users, and get the following Error :
General Error
SQL ERROR [ mysqli ]
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 'OR (username_clean = "test.user" AND user_email = "
Test.User@email.com")' at line 2 [1064]
SQL
SELECT user_id, username, user_password, user_email FROM phpbb_users WHERE user_id = OR (username_clean = "test.user" AND user_email = "
Test.User@email.com")
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/exportimportusers/acp/exportimportusers_module.php
LINE: 378
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\exportimportusers\acp\exportimportusers_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
How to fix ?