Author Topic: Shop does not work for me on SMF 1.1.1  (Read 5059 times)

Offline jasonpeinko

Shop does not work for me on SMF 1.1.1
« on: February 08, 2007, 11:31:53 am »
I get this error:

Unknown column 'category' in 'field list'
File: /home/pinkofer/public_html/forum/Sources/shop/Shop-Subs.php
Line: 108

Offline Daniel15

Re: Shop does not work for me on SMF 1.1.1
« Reply #1 on: February 10, 2007, 01:46:11 pm »
Could you please try uninstalling and then reinstalling SMFShop? It sounds like one of the database tables wasn't created correctly.

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #2 on: March 01, 2007, 08:23:41 pm »
If I uninstall and re-install wont that delete the points and everything?

Offline Daniel15

Re: Shop does not work for me on SMF 1.1.1
« Reply #3 on: March 02, 2007, 05:20:34 pm »
Yes, it will. If you don't want to reinstall, please try running this query in phpMyAdmin:
Code: [Select]
ALTER TABLE smf_shop_items ADD `category` SMALLINT NOT NULL

This should solve this issue.

Where do you get this error?

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #4 on: March 02, 2007, 05:42:01 pm »
I did that, and the shop worked, and everyone had points and everything BUT!
The bank said 0 points in pocket and 0 points in bank!
and even when I posted the points in the bank didn't go up and even if I "saved" my points
(through the admin panel) it still said 0 and 0. Which part of the script keeps the points because I have a backup.

Offline Daniel15

Re: Shop does not work for me on SMF 1.1.1
« Reply #5 on: March 02, 2007, 05:57:46 pm »
The number of points a user has is stored in the database, in the smf_members table (the money and moneyBank fields). Are the values in the database correct?

Are you encountering this error (the 0 points in pocket and bank) everywhere, or just on the bank page?

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #6 on: March 02, 2007, 06:31:19 pm »
Thanks for your help.
Like I said. Just in the bank, but thats where it matters because users can't buy anything or earn points. they get points but you only see it under their names not in the bank, it still stays 0,0.
I'll have to check the value in the databases, what should they be (like what should they NOT be lol)

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #7 on: March 02, 2007, 07:28:59 pm »
this is what I see in the money bank
Rows    moneyBank
609    0.00
1    38.61
1    52.04
1    59.23
1    142.44
1    147.34
1    179.22
1    221.94
1    222.01
1    266.28
1    273.86
1    337.86
1    410.67
1    471.31
1    646.03
1    680.43
1    746.04
1    750.02
1    753.77
1    825.11
1    881.32
1    1346.14
1    1536.45
1    1814.29
1    1980.42
1    4210.61
1    5635.39
1    5732.28
1    21068.60
1    33647.18

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #8 on: March 03, 2007, 01:42:02 pm »
The money in the bank is still 0.
Isn't there a way to get the bank to get the points
back. It shows 0 and it won't go up.

as far as I can see the values in MoneyBank and Money are ok.
except for that
609    0.00
thing.
but the bank still doesnt work.


You see when I search my user using the admin panel i get this
Editing member id 4 (Nirkon)'s Inventory:


Money in Pocket:     757.00
Money in Bank:     21068.60

but!
The bank shows 0 and 0. and the Buy Stuff won't let me buy because I have 0 points. and when I post those numbers go up here^^ but not in the bank.


When I deposit money i get this:
Deposit processed! You now have 21188.6 DD points in the bank and 637 DD
points in your pocket.

but even then, 0, 0 and buy stuff won't let me buy... wtf <.<


if it helps, I know smf_shop_categories has 0 tables.
Any Idea? please help fast.
« Last Edit: March 03, 2007, 02:02:57 pm by Nirkon »

Offline Daniel15

Re: Shop does not work for me on SMF 1.1.1
« Reply #9 on: March 08, 2007, 03:43:09 pm »
It sounds like some SMFShop code is missing from Load.php. Open Sources/Load.php, and search for this line:
Code: (php) [Select]
'total_time_logged_in' => empty($user_settings['totalTimeLoggedIn']) ? 0 : $user_settings['totalTimeLoggedIn'],
Directly underneath it should be this:
Code: (php) [Select]
// Begin SMFShop MOD Version New Version
'money' => isset($user_settings['money']) ? $user_settings['money'] : '',
'moneyBank' => isset($user_settings['moneyBank']) ? $user_settings['moneyBank'] : '',
// End SMFShop MOD

If those lines aren't there, add them in. This should fix your problem.

If you have further problems, please feel free to PM me your cPanel username and password (you may change the password to a temporary one if you like), and I'll take a look at it.

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #10 on: March 08, 2007, 07:40:10 pm »
still this
You currently have 0 DD points in your pocket and 0 DD points in the bank. Would you like to deposit or withdraw money?

I wish it were that easy <.<

This all happened because of a failed update...  nvm i dont have an older load.php <.<
any ideas?

Offline feeble

Re: Shop does not work for me on SMF 1.1.1
« Reply #11 on: March 08, 2007, 08:57:20 pm »
you could try applying the large update from the smf site.

will wipe out all modifications, but will atleast give you a fresh start without clearing any important data like members and posts etc.

take this as a last options but lol

Offline Nirkon

Re: Shop does not work for me on SMF 1.1.1
« Reply #12 on: March 08, 2007, 09:45:07 pm »
Are you sure this will fix my problem without deleting anything (except the mods, as in points, posts etc..)?
and can you direct me to the update you are talking about?
« Last Edit: March 08, 2007, 09:49:07 pm by Nirkon »