Database Error

[tandiono]

Im getting a database error for :

http://www.friendsterforum.com/forum/index.php?action=shop

shop mods is installed to the latest version.

----

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


anyone please kindly assist me. Thanks

[Daniel15]

Try running this query in phpMyAdmin:

Code: [Select]

ALTER TABLE smf_shop_items ADD `category` SMALLINT NOT NULL

And see if this fixes the issue.

[tandiono]

i try to run this query in phpmyadmin.. But still fail. Is there anyway?

[Daniel15]

Are you still getting the same error, or is it a different error this time?

[tandiono]

it's still the same error. Is there anyway to fix this issue? THanks

[Daniel15]

Is your database prefix smf_? If not, edit the query so it has the correct prefix, and run it again.
If you PM me with cPanel login details, I'll try and see what's wrong with it.

[tandiono]

here's what it say :

Error

SQL query:

ALTER TABLE smf_shop_items ADD `category` SMALLINT NOT NULL

MySQL said: Documentation
#1146 - Table 'friend_shout.smf_shop_items' doesn't exist


Please kindly assist me. Thanks

[Daniel15]

#1146 - Table 'friend_shout.smf_shop_items' doesn't exist

Is friend_shout the SMF database? And is smf_ the prefix?

If friend_shout is not the correct database, choose the correct one via the list on the left-hand side of phpMyAdmin, and repeat the query.