SMF Shop
SMFShop => Items => Topic started by: CRONUS on January 19, 2007, 04:13:39 pm
-
When i try to use "Random Money" item I get:
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 :)
-
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 :)
-
i am getting this error too. any clue on how to fix it?
-
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 ;).
-
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
-
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
-
8: Undefined index: shopFeeWithdraw
File: /home/content/a/s/h/ashoor/html/Thomas/Themes/default/Shop.template.php (eval?)
Line: 515
-
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).
-
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.
-
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...