Question Import Issue

Hi,
Are any questions being uploaded at all? Or does it fail on all of them?
I assume the rest of the functionality is working OK.

You can send me a copy if you like and I’ll try at our end.

Alex

None of the questions are uploading to live server and showing message ‘Questions Added’. But same thing is working on localhost.

Sample csv file : https://www.dropbox.com/s/6fzatq2lwy8aifw/Test.csv?dl=0

Hi,

OK sounds like a permissions issue with your live DB. I tried the import and it worked fine for both our installs here.

I’ve written a simple database permissions checker plugin. You can download it here:
https://www-dev.efolio.soton.ac.uk/qtl-test.zip

Activate it on your test and live site and see if you get any error messages.

Alex

Hi,

Both cases (localhost and live server) I am getting the below attached message. https://www.dropbox.com/s/fs45av2vzzfn0ab/Test%20result.png?dl=0. I think there is no permission issue, Right?
I can manually create Pots and questions on live server. Only the actual import is not happening on live server.

Yes that looks as it should do.

OK on the live server are there existing questions? The only thing I can think is that some of your existing questions may be conflicting with the question IDs, although I’m pretty sure we were checking for that issue.
Unfortunately its incredibly hard to troubleshoot issues where we don’t have access to the box for debugging ??

OK
I tried with unused question id and pot id but still no luck.

Hi,

Finally I rectified the issue.
Just modified the import code (plugins/quiz-tool-lite/scripts/export-functions.php : line number 122).

Replaced line 122 with this code

$con = new mysqli(“localhost”, “root”, “password”, “Dbname”);
$thisData = mysqli_real_escape_string($con, $data[0]);

Thank you so much for posting this solution! I’ve just got back from work so will look at how you solved the issue and add it to the latest version. Many many thanks, and glad you got it sorted.

Alex