Cannot update users info

[Craig A]

[quote]
User ids:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
[/quote]

[quote]
Database error in vBulletin Control Panel: Invalid SQL: SELECT dateline FROM post WHERE userid=999
ORDER BY lastpost DESC LIMIT 1
mysql error: Unknown column 'lastpost' in 'order clause'
mysql error number: 1054
Date: Saturday 10th of June 2000 04:58:25 PM
Script: /forum/admin/misc.php
Referer: [url]http://www.ten-tenths.com/forum/admin/misc.php[/url]

[/quote]

What's happening ? Worked a few days ago...

[Craig A]

Hello ?

Come on guys - are you all down the pub ?

[Freddie Bingham]

Well I can see there is no 'lastpost' field in the post table and that is what is causing the error...

[Craig A]

Good. Now what to do about it ?

[Freddie Bingham]

Well can you tell me what you were trying to do when the error occurred?

[Craig A]

Update the users info... ie on the control panel.

[Jake]

Ya, Ive been getting the same error as well when trying to update the user profile after changing the status levels.

[Craig A]

Blimey - looks like it's not something [i]i've[/i] done wrong this time ;)

[Joe]

this may help...
[url]http://www.vbulletin.com/forum/showthread.php?threadid=907[/url]

Look at the seccond to last post by john... let me know if this works on your site...

[Craig A]

Thanks for the tip, but that code is already in the latest version... Where is John when you need him ?

[Freddie Bingham]

It doesn't always occur when you are updating user info so I was wanting to know *exactly* what you changed.

[Craig A]

It /always/ occurs here. I added the user stars thingy and then tried updating (couldn't say if it was broken before this as I don't know)

[Freddie Bingham]

Ok I can reproduce the bug when I hit update user's info after modifying a user's title.

Database error in vBulletin Control Panel: Invalid SQL: SELECT dateline FROM post WHERE userid=34 ORDER BY lastpost DESC LIMIT 1
mysql error: Unknown column 'lastpost' in 'order clause'
mysql error number: 1054
Date: Sunday 11th of June 2000 01:19:57 AM
Script: /forums/admin/misc.php
Referer: [url]http://www.hedgehogwheels.com/forums/admin/misc.php[/url]

[Edited by rangersfan on 06-11-2000 at 01:26 AM]

[Joe]

[QUOTE][i]Originally posted by Craig Antill [/i]
[B]Thanks for the tip, but that code is already in the latest version... Where is John when you need him ? [/B][/QUOTE]

Lates Version? I have 1.1.2 ... how many versions of 1.1.2 are there? Why dosent John or James update the version number? This is going to get confusing! :)

I mean, if its a minor version, move it to 1.1.3, if its a bigger update, make it 1.2.0 ... if its huge, make it 2.0.0 or somthing... please? ;)

[werehere]

Great rangersfan,

I will alert John to this post for further investigation.:)