• Resolved satishkotgire

    (@satishkotgire)


    Is there an option to delete all questions at once? Each page shows just 20 questions and deleting questions page by page is time consuming.

Viewing 13 replies - 16 through 28 (of 28 total)
  • Thread Starter satishkotgire

    (@satishkotgire)

    I have admin privilege but I don’t know how to modify hosting php.ini file as I am not the expert. Therefore I would prefer to wait until you provide me alternate solution. If nothing works then I will have to delete plugin and install it again, but I will lose all my quiz setup data.

    Plugin Author ays-pro

    (@ays-pro)

    Do you have access to your website database/PHPMyAdmin ?
    We found the solution, but you need to change a row in your database.
    Is it possible for you?

    Plugin Author ays-pro

    (@ays-pro)

    Please do not uninstall the plugin, cause it will not help you and you may lose all data.
    Do you have access to your website database/PHPMyAdmin ?

    Thread Starter satishkotgire

    (@satishkotgire)

    Technically I should have access to everything as I have admin login account. I will explore and find out database/PHPMyAdmin. Can you please let me know which row I need to modify? Thanks in advance.

    Plugin Author ays-pro

    (@ays-pro)

    You need to find “usermeta” (prefix_usermeta) table, there must be a row with meta_key “questions_per_page” and meta_value 500.
    You need to change this 500 by double-clicking to the field and press enter.
    Hope it will help.
    We are ready to do it for you, if you need our help please contact us with this form.

    Thread Starter satishkotgire

    (@satishkotgire)

    In PHPMyAdmin I tried to increase connection timeout from 60 to 180 secs, but it is not allowing me it is saying “You need SUPER Admin access”

    Plugin Author ays-pro

    (@ays-pro)

    You need to change questions_per_page usermeta only.

    Thread Starter satishkotgire

    (@satishkotgire)

    I have checked all tables related to Quiz Maker but did not find it. I found following tables in the database,
    wp_aysquiz_answers
    wp_aysquiz_attributes
    wp_aysquiz_categories
    ……
    wp_aysquiz_settings

    In settings table, there is no such row available. There are just 5-6 entries in settings table, also I did not find any other relevant table. Sorry to bother you again.

    Plugin Author ays-pro

    (@ays-pro)

    You need to find wp_usermeta table.
    Then questions_per_page row.

    Thread Starter satishkotgire

    (@satishkotgire)

    I could not find it, however I could do my job. I deleted all questions from backend through SQL query. I have my CSV file through which I can easily upload all the questions again.

    Thank you very much for your quick support. I really appreciate it.

    Plugin Author ays-pro

    (@ays-pro)

    Please wait.
    It will not help you.
    You need to change my mentioned row.
    It is WordPress default table and it will still there.
    There must be wp_usermeta table, could you find wp_users table?

    Plugin Author ays-pro

    (@ays-pro)

    There might be pagination in your Database.
    Please check all the pages.
    Here is the screenshot https://prnt.sc/pxhtzk

    Thread Starter satishkotgire

    (@satishkotgire)

    Thank you very much, finally got it, changed value to 50. Now it is working fine. Yes, I could not find due to pagination.

Viewing 13 replies - 16 through 28 (of 28 total)
  • The topic ‘Option to delete all questions at once’ is closed to new replies.