Effects Store 2.0.1 problem.

When I go to my effects store, and buy an effect, a custom color for example, I spend my points on it, and it says it's bought and everything.

But that's it. It doesn't actally insert it into the database. Atleast I don't think. It says I don't own that effect and it doesn't show up.

I would trace the problem myself but right now I am too tired to root through the php files you made.

I upgraded from Shop Mod 3 to the latest beta version, and upgraded from effects store 1.2.2.

EDIT:

BLAH. I uploaded install.php and uninstalled everthing, looking at the bottom of the log it said I had two queries that had errors executing. I originally added the SQL using the .sql file included.

So I ran the install again and everything reset. And it started working. You could buy things.

Then I sold what I bought and it all went back to not working again.

I've done some testing and I haven't been able to replicate the buying problem. It works like a charm in my tests. If you want to try to trace the problem yourself, items are bought and sold in mods/effects_store/exchange.php. The insertion of the item is done in class_base.php, in the give_item method. Once you've bought an effect, it should appear in your inventory like any normal item.

The only other thing I can think of that might cause the problem offhand is using the 1.x shop_effects.php, which handled buying and storage differently. Make sure that file has been overwritten with the newer one.

The queries error on the uninstall come from bad conversion of Add Index queries to Drop Index in my generator. The generator has been corrected for this and a fixed install.php will be in the next Effects Store release. Thanks for pointing that out.

I just changed the function give_item to a message_die() and made it display an error message.

But nothing happened. So I now know for a fact the give_item function isn't being called at all.

Okay, that's a great thing to know here. Go to the Shop's Item Editor in your admin panel. Choose one of the effect items there and click edit. Check the "Load Item on Buy" option. It should be set to Yes.

If that option is set to No, that would prevent give_item from being called on all of the effects (except for Title Stamp, which ignores this). The option should be on yes by default.

Wow, okay that worked. Haha. Thanks.

But this just leads me to the question, "Why weren't they on in the first place, especially since that's the default?"

But it doesn't matter now.

Thanks again.

Your shopitems table might have the default set to off. I didn't specify the default value in the install queries; the items just inherit the existing default from the table. On my Shop install, that default is "1"... I guess it's different on yours. I'll have to tweak the queries in the next version, just to be safe.

Thanks for bringing this issue to my attention.

I want to thank you, Thoul, because I had the same problem, but after reading your explanation here I was able to solve it.

So thanks!