Won't save cats or new products

[naderby]

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?

[amin007]

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?

[naderby]

Thanks for the reply. Here are my tables:

Code:

table list deleted

[amin007]

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.

[maisound]

I’m experiencing the same problem…

[naderby]

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.

[maisound]

Thanks, I hope this will be fixed soon.

[amin007]

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

[naderby]

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.

[maisound]

Hi

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

thx

[amin007]

I sent you an email so now you can simply reply

[miloman]

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.

[amin007]

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.

[DragonNote]

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.

[amin007]

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