Skip to content Skip to main navigation Skip to footer

WordPress database error Duplicate column name ‘quiz_author_id’ for…

Welcome to QSM Support Forum. › Forums › QSM Pro Support › WordPress database error Duplicate column name ‘quiz_author_id’ for…

Viewing 15 posts - 1 through 15 (of 16 total)
1 2
  • Author
    Posts
  • May 28, 2020 at 1:51 pm #4299
    Matt GaneMatt Gane
    Participant

    Hi

    My error log is being filled up with these database errors, I found a post here 4 weeks ago reporting the same issue but it doesn’t appear to be fixed yet – https://wordpress.org/support/topic/alter-tables-produced-duplicate-column-names/.

    These are the 2 errors I think…

    WordPress database error Duplicate column name ‘quiz_author_id’ for query ALTER TABLE wp_mlw_quizzes ADD quiz_author_id INT NOT NULL made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, qsm_add_author_column_in_db

    WordPress database error Duplicate column name ‘unique_id’ for query ALTER TABLE wp_mlw_results ADD unique_id varchar(255) NOT NULL made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, qsm_add_author_column_in_db

    Thanks

    Matt

    May 28, 2020 at 2:05 pm #4300
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Matt,

    Welcome to QSM Pro Support Forum. Hope you are having a great day.

    I request you to please share the website’s admin credentials so that our development team can look into the issue. Make sure to set the message as private before sharing the credentials.

    Regards,
    Kriti

    May 28, 2020 at 2:15 pm #4301
    Matt GaneMatt Gane
    Participant

    Hi

    My customers database contains private data so I can’t do that. As I’ve seen other.

    Looking at this error – “WordPress database error Duplicate column name ‘quiz_author_id’ for query ALTER TABLE wp_mlw_quizzes ADD quiz_author_id INT NOT NULL made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, qsm_add_author_column_in_db”

    Your plugin is trying to add the column quiz_author_id to the wp_mlw_quizzes table when it already exists, this is a plugin issue and access to the site will not make any difference anyway.

    Thanks

    Matt

    June 3, 2020 at 2:15 am #4421
    Matt GaneMatt Gane
    Participant

    Hi

    Is there any update on this?

    Thanks

    June 3, 2020 at 7:17 am #4423
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Matt,

    Our developers have recorded this as a bug and will fix this issue soon. I will keep you posted as soon as I hear back from them.

    Regards,
    Kriti

    June 21, 2020 at 2:30 pm #4704
    Matt GaneMatt Gane
    Participant

    Hi

    We are a few more weeks on, any update on this?

    Thanks

    June 21, 2020 at 6:27 pm #4705
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Matt,

    I will contact the development team and let you know regarding the update by tomorrow.

    Kind regards,
    Kriti

    June 24, 2020 at 5:46 am #4725
    Kriti SharmaKriti Sharma
    Keymaster

    Hi Matt,

    We have fixed this error in the latest version of the plugin. Please update the same and let me know.

    Kind regards,
    Kriti

    March 30, 2026 at 6:14 am #19989
    alex arafatalex arafat
    Participant

    I’ve been seeing similar database errors and it’s super frustrating. It reminds me of when I first took my dog to Vet in Sunnyridge—just like their team carefully diagnoses and fixes health issues, I hope the support team can pinpoint and resolve these database problems efficiently. At Vet in Sunnyridge, every purr and wag receives genuine care, and having that expert guidance makes a huge difference. Similarly, a careful, step-by-step approach should help clear these duplicate column errors without causing more issues.

    April 27, 2026 at 4:54 pm #20812
    alex arafatalex arafat
    Participant

    Hey Matt,

    I came across a similar issue with the database errors related to duplicate column names. It seems like the ALTER TABLE commands are trying to add columns that already exist in the database, which is causing these conflicts. It might be worth checking your database manually to see if these columns are already present, or you could try running a plugin update to ensure everything is synced properly.

    On a side note, I remember when my child was struggling with times tables. I found a great resource – a multiplication chart from 1 to 10 – that really helped them visualize the relationships between numbers. It made a huge difference in their understanding and confidence in math. You can check it out here: amultiplicationchart.com/multiplication-chart-1-10 It’s a simple, yet effective tool for early learners!

    Hope that helps!

    May 4, 2026 at 6:33 pm #21033
    alex arafatalex arafat
    Participant

    I ran into similar database errors on my WordPress site, and it got really frustrating managing backups while troubleshooting. To make things easier, I started using tera downloader mod apk alongside my workflow. With 2TB of secure, ad-free cloud storage, I could safely upload all my WordPress files, themes, and backups before attempting fixes. It made managing large files simple, and I didn’t have to worry about the “Storage Full” problem while experimenting with database changes. Having everything backed up gave me peace of mind and saved a lot of time.

    May 4, 2026 at 8:01 pm #21035
    alex arafatalex arafat
    Participant

    Hey Matt, I’ve been seeing the same database errors with duplicate columns in QSM—it’s super annoying having the error log fill up constantly. I ended up manually checking my tables to make sure the columns weren’t already added before any plugin update. Funny side note: while dealing with this, I also had a Dubai trip coming up, so I spent a few minutes checking my visa status UAE online. It was quick and stress-free, which gave me some peace of mind before diving back into fixing these WordPress database issues!

    May 4, 2026 at 11:46 pm #21038
    Sam GordenSam Gorden
    Participant

    Hi Matt,
    this usually means the columns already exist and the plugin is trying to add them again on every load.
    You can fix it by:
    Check in phpMyAdmin if quiz_author_id and unique_id are already there
    Update the plugin to the latest version
    Try deactivate/reactivate the plugin
    It’s mostly harmless, just causes headle online log spam.

    May 5, 2026 at 10:59 am #21052
    alex arafatalex arafat
    Participant

    Hey Matt, I’m seeing the same database errors popping up with duplicate columns—it’s really annoying having the log fill up nonstop. Feels a bit like keeping track of your car records in real life; I always use the evg check to make sure my UAE driving record is clean and up to date. Just like that system helps avoid surprises with fines or visa issues, it would be great if WordPress had a smoother way to prevent these duplicate column errors from clogging the database!

    May 5, 2026 at 6:04 pm #21058
    azan seoazan seo
    Participant

    Hi

    I had a similar issue before and while fixing it I also started focusing more on my skin care routine because stress was affecting it a lot. If you are dealing with skin texture or scars alongside stress, I’d suggest looking into Microneedling in Birmingham. I’ve seen people get really natural results from places like Ihya House Of Aesthetics. It’s not overhyped and actually helps improve skin gradually. Might not fix database errors, but definitely helps you feel better while dealing with them.

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 16 total)
1 2
  • You must be logged in to reply to this topic.