got an error after upgrade to pp481

[Radgul]

in upgrade 47.php I got
Preparing to reorganize admin options...
ALTER TABLE categories DROP INDEX lastphoto failed with error: Can't DROP 'lastphoto'. Check that column/key exists
ALTER TABLE categories DROP INDEX thumbnail failed with error: Can't DROP 'thumbnail'. Check that column/key exists
ALTER TABLE iponline DROP INDEX userid failed with error: Can't DROP 'userid'. Check that column/key exists
ALTER TABLE photos DROP INDEX approved failed with error: Can't DROP 'approved'. Check that column/key exists
ALTER TABLE photos DROP INDEX date failed with error: Can't DROP 'date'. Check that column/key exists


Done! You can now remove this file and check out your new Admin Options layout!
_______________________________
and then this error when trying to whow a photo

MySQL error reported!

Script: showphoto

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,u.signature FROM user u LEFT JOIN userfield uf ON uf.userid=1102 LEFT JOIN session s ON s.userid=1102 WHERE u.userid=1102 LIMIT 1

Result: Unknown column 'u.signature' in 'field list'

Database handle: Resource id #8
__
how can I solve this problem?

[Chuck S]

sounds to me like you are trying to integrate with VB3 and selected VB2 as the install type instead as that is the way this would happen

of course if you are integrating with VB2 then you have a hacked forum table because that field should be present in VB2

[Radgul]

Thank you, I changed in my settings table vbversion vrom vb2 to vb3
and now everything works