[tom06]

http://tom.myfabforum.org

Hi when i try to access my shop using http://tom.myfabforum.org/index.php?component=SHOP
it gives me   General Error
SQL ERROR [ mysql4 ]

Unknown column 'pf_cash' in 'field list' [1054]

SQL

SELECT pf_cash FROM ph3bb12_profile_fields_data WHERE user_id = 2 LIMIT 1

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 157
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_profile_fields.php
LINE: 1090
CALL: dbal->sql_query_limit()

FILE: myffcms/com_shop.php
LINE: 239
CALL: get_profile_field()

FILE: myffcms/functions_cms.php
LINE: 123
CALL: com_shop()

FILE: includes/template.php(219) : eval()'d code
LINE: 21
CALL: cms_call()

FILE: includes/template.php
LINE: 2190
CALL: eval()

FILE: myffcms/portal.php
LINE: 96
CALL: template->pparse()

FILE: index.php
LINE: 25
CALL: include('myffcms/portal.php')


any ideas thanks Tom

[admin (no pm's please)]

Looks like you have set the shop to use "CASH" as the currency, but have not set up a "cash" custom profile field.

[tom06]

Thanks now fixed