I'm on OST 1.9.8.We try to import users of mass quantity.In our trial, our CSV contains over 5000 user records.Tried 3 times, it always fail at the same point, only 2467 users are imported, the rest will not be.And the browser stops and returns an error.We try check the database and seems only 2 tables are involved in Users,ost_user, ost_user_emailHave anyone got experience to directly insert into these 2 tables please?Will it corrupt the data?
You haven't really provided us with any information with which to assist you. Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.The error you get?
I do the test once again on OST v1.9.14.The error wasn't anything informative.In my CSV file, we make up to 5000 users for testing, running from mu99001001 until mu99006000 sequentially in the single CSV file.But after running about 2 minutes of uploading, the IE browser just keep running and then will end up the the below browser error.Appreciate any ideas.
Check your PHP error log.
Error log shows:PHP Warning: require(client.inc.php): failed to open stream: No such file or directory in /home/public_html/ost1914/index.php on line 16PHP Warning: require(client.inc.php): failed to open stream: No such file or directory in /home/public_html/ost1914/index.php on line 16PHP Fatal error: require(): Failed opening required 'client.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/ost1914/index.php on line 16
I was expecting a maximum execution time error... I'm not sure what that is about.I would delete the first 2479 lines of your insert and re-run it with the remaining.
@[deleted], yes. you got it right.PHP Fatal error: Maximum execution time of 30 seconds exceeded in /xxx/include/mysqli.php on line 0is there a solution to this within OST script, somewhere to set the time limit just for User Import, if not to change "php_value max_execution_time"?
I would change the php.ini setting (max_execution_time), restart the webserver software, and then run the import. Then change the setting back, and restart the webserver software again.
Thanks @ntozier . It works. Can close this thread.
Very welcome. :)
