www.boards.ie/photopost

Naos · 13-10-2004 1:51pm #1

Dunno if thats the right addy but ya get the gist.

anyway in the Know ur nerds section, the following comes up when i click on a pic(to enhance size...)

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=585 LEFT JOIN session s ON s.userid=585 WHERE u.userid=585 LIMIT 1

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

Database handle: Resource id #7

Any ideas?

amp · 13-10-2004 2:33pm

I think it's been like that since the coming of vB3. I imagine it will be sorted once an admin has a chance.

My guess would be that Photopost was integrated into vB2's way of handling records and vB3 handles signatures as different things now.

So when photopost tries to read signature records, vB3 goes WTF?!!!one and dumps an error.

Either that or it's leaves on the line.

seamus · 13-10-2004 2:43pm

Working fine for me now

[Edit: Curiouser and curiouser.

I can view photos posted by some users and not by others. I can also view some photos posted by smiles, and not others...

Very strange.