Title: Question Import Issue
Last modified: September 1, 2016

---

# Question Import Issue

 *  Resolved [PCWP](https://wordpress.org/support/users/toprasobh/)
 * (@toprasobh)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/)
 * Hi Alex,
 * Question Import is not happening on live server but its working on localhost.
   I tried to upload same csv file to live server, after uploading I am getting ‘
   question uploaded’ message but i am not able to see the pots or questions in 
   pot area and database. Rest everything is working fine on live server.
 * Is it due to server issue? Do we need to change any permission/configuration.
 * Thanks
 * [https://wordpress.org/plugins/quiz-tool-lite/](https://wordpress.org/plugins/quiz-tool-lite/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Alex Furr](https://wordpress.org/support/users/alexfurr/)
 * (@alexfurr)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484794)
 * 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
 *  Thread Starter [PCWP](https://wordpress.org/support/users/toprasobh/)
 * (@toprasobh)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484964)
 * None of the questions are uploading to live server and showing message ‘Questions
   Added’. But same thing is working on localhost.
 * [Sample csv fil](https://www.dropbox.com/s/6fzatq2lwy8aifw/Test.csv?dl=0)e : 
   [https://www.dropbox.com/s/6fzatq2lwy8aifw/Test.csv?dl=0](https://www.dropbox.com/s/6fzatq2lwy8aifw/Test.csv?dl=0)
 *  Plugin Author [Alex Furr](https://wordpress.org/support/users/alexfurr/)
 * (@alexfurr)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484977)
 * 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:
    [http://www-dev.efolio.soton.ac.uk/qtl-test.zip](http://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
 *  Thread Starter [PCWP](https://wordpress.org/support/users/toprasobh/)
 * (@toprasobh)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484985)
 * 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](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._
 *  Plugin Author [Alex Furr](https://wordpress.org/support/users/alexfurr/)
 * (@alexfurr)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484988)
 * 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 🙁
 *  Thread Starter [PCWP](https://wordpress.org/support/users/toprasobh/)
 * (@toprasobh)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7484991)
 * OK
    I tried with unused question id and pot id but still no luck.
 *  Thread Starter [PCWP](https://wordpress.org/support/users/toprasobh/)
 * (@toprasobh)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7485013)
 * 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]);
 *  Plugin Author [Alex Furr](https://wordpress.org/support/users/alexfurr/)
 * (@alexfurr)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7485039)
 * 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

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Question Import Issue’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/quiz-tool-lite_e3e3e5.svg)
 * [Quiz Tool Lite](https://wordpress.org/plugins/quiz-tool-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/quiz-tool-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/quiz-tool-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/quiz-tool-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/quiz-tool-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/quiz-tool-lite/reviews/)

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 8 replies
 * 2 participants
 * Last reply from: [Alex Furr](https://wordpress.org/support/users/alexfurr/)
 * Last activity: [9 years, 12 months ago](https://wordpress.org/support/topic/question-import-issue/#post-7485039)
 * Status: resolved