Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

WP 3.1 update database error

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › WP 3.1 update database error

Tagged: database error

  • This topic has 5 replies, 2 voices, and was last updated 14 years, 2 months ago by amin007.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • March 21, 2011 at 12:24 am #2999
    iinet
    Member

    Hello,

    I updated to WP 3.1 today and based on recommendations in the forums, then upgraded wp-estore using the automatic update request:

    https://support.tipsandtricks-hq.com/automatic-update-request

    Now, when I try to change a price on one of my products it does not change and I get this php error:

    WordPress database error Unknown column ‘old_price’ in ‘field list’ for query UPDATE 22_wp_eStore_tbl SET name = ‘Get Engaged DVD set’, price = ‘.50’, pr…..

    Please advice how to fix. I’m guessing your wp-estore database has been changed. How do I correct the DB structure without loosing all my data?

    March 21, 2011 at 2:17 am #30454
    amin007
    Participant

    Please follow the instruction for upgrading. It tells you to do a deactivate and reactivate the plugin when upgrading. Please do that and let me know how you go after that.

    March 21, 2011 at 4:08 am #30455
    iinet
    Member

    Hello, I followed the instructions exactly, including deactivating and reactivating the plugin. I still have the problem.

    Because there are only CREATE table calls in your plugin and no ALTER table calls, it looks like there is no way this plugin will update a database when you guys alter a table. Am I incorrect? Please let me know what the next step is.

    Thanks,

    David

    March 21, 2011 at 4:54 am #30456
    amin007
    Participant

    WordPress handles database updates slightly differently.

    Are you using a Windows server?

    March 21, 2011 at 11:57 am #30457
    iinet
    Member

    No, I’m using FreeBSD, MySQL and the latest version of PHP.

    March 22, 2011 at 12:01 am #30458
    amin007
    Participant

    Not sure why your site is having an upgrade issue but I have sent you an email to get site access so I can check it out.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ