SMF Shop

SMFShop => Items => Topic started by: CRONUS on January 19, 2007, 04:13:39 pm

Title: Random money or Shop bug ?
Post by: CRONUS on January 19, 2007, 04:13:39 pm
When i try to use "Random Money" item I get:
Quote
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

By the way it's in this site :)
Title: Re: Random money or Shop bug ?
Post by: Daniel15 on January 19, 2007, 04:20:06 pm
Quote
Unknown column 'it.delete_after_use' in 'field list'
Oops, my fault for not reading my own changelog properly :P
I'll fix this now, as well as upgrade this site to the latest SMFShop version :D

EDIT: It should be fixed now :)
Title: Re: Random money or Shop bug ?
Post by: backend on April 06, 2007, 02:58:34 am
i am getting this error too. any clue on how to fix it?
Title: Re: Random money or Shop bug ?
Post by: Daniel15 on April 07, 2007, 07:43:38 pm
backend, the error CRONUS was talking about was on this site.
If you're getting the database error, please check your forum's error log for the exact message. Post the message here, and I'll try to see what's wrong ;).
Title: Re: Random money or Shop bug ?
Post by: backend on April 08, 2007, 01:13:46 am
thanks for replying Dan.

here is the error:

Database Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
WHERE ID_MEMBER = 2
LIMIT 1' at line 3
File: /home/content/a/s/h/Thomas/html/forum/Sources/shop/Shop-Bank.php
Line: 84
Title: Re: Random money or Shop bug ?
Post by: backend on April 08, 2007, 01:14:22 am
and a few more like this:

8: Undefined index: shopFeeDeposit
File: /home/content/a/s/h/Thomas/html/forum/Sources/shop/Shop-Bank.php
Line: 67
Title: Re: Random money or Shop bug ?
Post by: backend on April 08, 2007, 01:15:55 am
8: Undefined index: shopFeeWithdraw
File: /home/content/a/s/h/ashoor/html/Thomas/Themes/default/Shop.template.php (eval?)
Line: 515
Title: Re: Random money or Shop bug ?
Post by: Daniel15 on April 08, 2007, 01:31:09 pm
Those errors are related to the bank withdrawl and deposit fees. Go to Admin Panel  → Shop Administration → General Settings, and make sure values are set for Deposit fee and Withdrawal fee (set them to 0 if you like).
Title: Re: Random money or Shop bug ?
Post by: backend on April 08, 2007, 02:00:09 pm
Perfect that did it, thanks a lot.

For those who will ask this question in the future:  make sure you have some value in the desposit and withdrawl boxes, even if it is just ZERO. Just don't leave them blank.

Title: Re: Random money or Shop bug ?
Post by: Daniel15 on April 08, 2007, 03:39:13 pm
Quote
For those who will ask this question in the future:  make sure you have some value in the desposit and withdrawl boxes, even if it is just ZERO. Just don't leave them blank.
My code should be checking if they are set (and set them to 0 if they're not), but I must have missed it...