Author Topic: Random money or Shop bug ?  (Read 5518 times)

Offline CRONUS

Random money or Shop bug ?
« 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 :)

Offline Daniel15

Re: Random money or Shop bug ?
« Reply #1 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 :)
« Last Edit: January 19, 2007, 04:31:54 pm by Daniel15 »

Offline backend

Re: Random money or Shop bug ?
« Reply #2 on: April 06, 2007, 02:58:34 am »
i am getting this error too. any clue on how to fix it?

Offline Daniel15

Re: Random money or Shop bug ?
« Reply #3 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 ;).

Offline backend

Re: Random money or Shop bug ?
« Reply #4 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

Offline backend

Re: Random money or Shop bug ?
« Reply #5 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

Offline backend

Re: Random money or Shop bug ?
« Reply #6 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

Offline Daniel15

Re: Random money or Shop bug ?
« Reply #7 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).

Offline backend

Re: Random money or Shop bug ?
« Reply #8 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.


Offline Daniel15

Re: Random money or Shop bug ?
« Reply #9 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...