Database Error: “unknown column”

  • Resolved phst

    (@phst)


    3 years, 6 months ago

    Hi, I just installed QSM 8.0.6 on WP 6.1.1 PHP 8.0. Answers are not stored due to 2 missing columns in the DB. Here’s the entry in the server log file for one column:

    stderr: WordPress database error Unknown column ‘page_name’ in ‘field list’ for query INSERT INTO wp_mlw_results (quiz_id, quiz_name, quiz_system, point_score, correct_score, correct, total, name, business, email, phone, user, user_ip, time_taken, time_taken_real, quiz_results, deleted, unique_id, form_type, page_url, page_name) VALUES (1, …..

    After manually adding the text-fields “page_url” and “page_name” to wp_mlw_results for testing only, storing works as expected.

    Any thoughts? Thank you!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • sumitsanadhya

    (@sumitsanadhya)

    3 years, 6 months ago

    Hi @phst,

    I need to discuss this with my development team. Hopefully, I will get back to you with the solution.

    Regards,
    Sumit

    sumitsanadhya

    (@sumitsanadhya)

    3 years, 6 months ago

    Hi @phst

    It may happen if you upgrade from a very old version of QSM. It should not happen if the plugin is updated frequently.

    We are not able to generate this issue on our end. Can you please share step-by-step instructions to generate this issue?

    Regards,
    Sumit

    Thread Starter phst

    (@phst)

    3 years, 6 months ago

    Hi Sumit. Thanks for your reply. Here’s what I remember.

    1. I had a version which I last used somewhere in Feb/Mar-2021 and which was deactivated since. I now reactivated it and executed the upgrade.

    2.After the upgrade, the plugin required a DB-upgrade which I triggered.

    3. As quiz-results were not stored, I uninstalled the plugin, deleted the 7 mlw-tables from the DB and reinstalled it from scratch. But results were still not stored.

    4. The server-log showed the DB-Error with 2 missing columns. When I added them manually as text fields, all worked fine.

    5. I wrote you 🙂

    I now checked if there are an odd entries in wp-options, but it looks OK with “mlw_quiz_master_version 8.0.6”

    If you can confirm that the two columns are plain text fields, I can manage and you can close the ticket as resolved.

    Best regards, P

    sumitsanadhya

    (@sumitsanadhya)

    3 years, 6 months ago

    Hi @phst

    Both are varchar (255) please check below-given screenshot link for your reference.

    https://nimb.ws/sg3SIm

    Let me know if you need more help.

    Regards,
    Sumit

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

The topic ‘Database Error: “unknown column”’ is closed to new replies.