LearnPress 4.4.0 database/schema issue

  • dancenying

    (@dancenying)


    1 day, 5 hours ago

    I need help with a LearnPress 4.4.0 database/schema issue.

    Symptoms:

    • I cannot enroll a student in a course.
    • Manual Assign Course gives: Unknown column 'graduation' in 'field list'
    • Student self-enrollment creates an order, but the course is not attached.
    • Order page shows: Unknown column 'oi.item_id' in 'field list'
    • The LearnPress database upgrade banner remains.
    • I uninstalled and reinstalled LearnPress, selected delete data, but LearnPress courses/orders remained.
    • I tested with other plugins disabled and the issue remained.

    phpMyAdmin checks:

    • wp_learnpress_order_items does not have an item_id column.
    • wp_learnpress_user_items does not have a graduation column.
    • wp_learnpress_upgrade_db shows migration steps as completed.

    Can you please advise how to safely repair or reset the LearnPress database schema for LearnPress 4.4.0?

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support brianvu-tp

    (@briantp)

    16 hours, 41 minutes ago

    Hi dancenying,

    Thank you for reaching out to us.

    Based on the missing columns you mentioned (graduation and item_id), it highly indicates that this issue stemmed from a major upgrade directly from an older LearnPress version (such as 3.x.x) to version 4.4.0, which caused the database migration process to get interrupted or incomplete despite the status showing as “completed”.

    To help you further, we recommend that you create a free support ticket with the subject “dancenying – LearnPress 4.4.0 database/schema issue” through our official forum.

    Please visit and click on the “Support” to create the ticket. Our development team will take a closer look and provide the best possible solution.

    Thank you for your understanding!

    Best regards,
    Brianvu-tp

    Thread Starter dancenying

    (@dancenying)

    16 hours, 25 minutes ago

    Isn’t this what I did? Isn’t this a support ticket as you mention in your reply?

    Plugin Support brianvu-tp

    (@briantp)

    16 hours, 18 minutes ago

    Hi dancenying,

    Thank you for your reply.

    Please accept our apologies for any confusion caused by our previous message.

    For the record, the platform you are currently using to message us is a public community forum. As database schema issues like yours require in-depth technical analysis and potentially secure access to your site credentials or database details in order to safely run the repair scripts, we cannot handle them publicly here for security reasons.

    This is why we kindly ask you to submit a ticket via our official channel.

    Please visit and click on the “Support” to create the ticket.

    Please use the subject ‘dancenying – LearnPress 4.4.0 database/schema issue‘ so that our team can recognise your case immediately and fast-track it.

    Once the ticket has been created, our developers will log in safely, inspect the exact state of your database tables and run the necessary migration fixes for you.

    Thank you so much for your understanding and cooperation!

    Best regards,
    Brianvu-tp

    Thread Starter dancenying

    (@dancenying)

    16 hours, 14 minutes ago

    Done. Thanks.

    Plugin Support brianvu-tp

    (@briantp)

    16 hours, 1 minute ago

    Hi dancenying,

    Thank you for confirming and creating the ticket on our official forum.

    We have received your request and will reply to your ticket with the next steps and the best solution as soon as possible.

    Thank you again for your cooperation.

    We will continue to assist you on the official support forum!

    Best regards,
    Brianvu-tp

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

You must be logged in to reply to this topic.

Tags