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

Won't save cats or new products

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Won't save cats or new products

Tagged: category table, database, products, save

  • This topic has 30 replies, 8 voices, and was last updated 13 years, 4 months ago by peanuts.
Viewing 15 posts - 1 through 15 (of 31 total)
1 2 3 →
  • Author
    Posts
  • November 26, 2009 at 9:59 pm #489
    naderby
    Member

    Hi,

    Just installed the plugin, if I create a new product or category it tells me that they are created but then does not save them. If I go to view all the cats or products they are not listed.

    I’ve checked that the database tables have been created succesfully.

    Any ideas?

    November 27, 2009 at 7:46 am #16293
    amin007
    Participant

    This issue definitely points to database table not being created. Can you please confirm that you have 6 tables that was created for the eStore?

    November 27, 2009 at 8:58 am #16294
    naderby
    Member

    Thanks for the reply. Here are my tables:

    Code:
    table list deleted

    November 27, 2009 at 9:10 am #16295
    amin007
    Participant

    thanks for that.. I deleted the table name list (it’s not a good idea to expose them for security risk).

    Looks like one table didn’t get created (wp_eStore_cat_tbl).

    Not exactly why it didn’t create the category table on your server but I can take a look at it.

    November 27, 2009 at 4:04 pm #16296
    maisound
    Member

    I’m experiencing the same problem…

    November 27, 2009 at 4:19 pm #16297
    naderby
    Member

    Maybe it has something to do with the latest release of WP. The plugin was installed on a fresh install of WP.

    I’m waiting to hear back from support who have access to my wp set-up.

    November 27, 2009 at 4:32 pm #16298
    maisound
    Member

    Thanks, I hope this will be fixed soon.

    November 28, 2009 at 12:43 am #16299
    amin007
    Participant

    Nope, it has nothing to do with WordPress version. It’s something around the MySQL version on your server. The category table uses a default value for initialization and if your MySQL version is really old then it probably doesn’t have that functionality. I should be able to investigate this and give you more details once I can get a hold of the cPanel access on your test site (we will do this part via email :)

    November 28, 2009 at 10:02 am #16300
    naderby
    Member

    Hi Guys,

    Amin is correct, I was using an old MySQL4 database but I have now deleted that and re-installed using a MySQL5 database and all is now ok.

    Thanks for the support.

    November 29, 2009 at 11:42 am #16301
    maisound
    Member

    Hi

    amin, for several reasons I cannot upgrade to mySql5… how can I get in contact with you via email?

    thx

    November 29, 2009 at 10:03 pm #16302
    amin007
    Participant

    I sent you an email so now you can simply reply :)

    January 17, 2010 at 3:50 pm #16303
    miloman
    Member

    I just installed the plugin and have the same problem as naderby. Can’t save any category or new product. Get message “product saved” but database table is empty.

    My setup

    WP: 2.8.4

    MYSQL v5.0.67-community-nt

    Apache: 2.2

    I have 6 tables created by the eStore plugin in my database. All are empty. One thing I noticed is that the tables are prefixed twice with wp_ since I have setup my wordpress to prefix all tables with wp_.

    So the tables look like “wp_wp_estore_cat_prod_***”

    Thought this could be the problem so I tried renaming the tables to “wp_estore_cat_prod_***” but still doesn’t work.

    Any ideas? I have high hopes for this plugin and really want to get it working asap! Thanks.

    UPDATE: I removed the wp_ prefix from my wordpress setup, reinstalled plugin but still can’t save new products or categories.

    January 17, 2010 at 10:04 pm #16304
    amin007
    Participant

    You should never have to manually rename tables and stuff. This should work nicely after you activate the plugin. You may have some condition on your site… would be good if I could take a look at it. I will send you an email.

    January 21, 2010 at 6:36 am #16305
    DragonNote
    Member

    IIS7 – Windows Server 2008

    MySQL Version: 5.1.40-community

    PHP5 Version: 5.31

    WP: 2.9.1

    Theme: StudioBlue 1.0 by Elegant WordPress Theme

    URL: Not live, by email only.

    Just installed plugin..(retail version)

    Cannot add products or cats.

    Tables are present. Strange latin1_swedish_ci Collation…all other tables are utf8_general_ci

    wp_wp_ prefix as well.

    January 21, 2010 at 7:23 am #16306
    amin007
    Participant

    Windows server could be an issue here (previously whenever this type to error occured it was on a Windows server).

    Did you see any error or warning when activating the plugin?

    Did 6 tables get created for the eStore?

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 31 total)
1 2 3 →
  • 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