update error

[umiya]

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 'ORDER BY smf_shop_inventory.id' at line 8
File: /home/hiya/public_html/forum/Sources/shop/ShopAdmin.php
Line: 85

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.1, whereas your database is at version SMF 1.0. It is recommended that you execute the latest version of upgrade.php.

and i thought it upgraded from 1.0 to 1.0.1 when i did it via package manager.


edit:

nevermind, it seems you need teh user name and not the display name which I dont see why it couldnt take both. And I still dont know why it gave me the above error