db problem

[MApI]

Hi, since RC2 i've this prob:
- when an user try to edit his profile
- when an user try to send a private message
- when a new user try to register
they've the following error:

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.

The real prob, is that I can't receive any e-mail, so can't know the real db problem ...

HELP ! Thanks

[George L]

right click and view the source code of the error page and paste the contents in a post here

[MApI]

Here I'm and here it's:

<!-- Database error in vBulletin: Invalid SQL: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='4'
mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
Date: Saturday 26th of May 2001 11:03:34 AM
Script: /member.php?action=getinfo&userid=4
Referer: http://www.kuibus.f2s.com/forumdisplay.php?forumid=3
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

Thaks in adv.

[George L]

have a look into this thread http://vbulletin.com/forum/showthrea...t=customavatar and http://vbulletin.com/forum/showthrea...t=customavatar

[MApI]

Ok, might be that I'd forgotten some upradex.php; I din't understand the way to fix problem:[list=a][*]Can I run all upgradex.php ?[*]Do I reinstall vbb ? If so, do I backup & load my db ? (.. and how merge it ? (No telnet))[/list=a]

Thank you for helping.

[tubedogg]

No do not rerun any upgrade scripts.

Run this query via phpMyAdmin (instructions in my sig)

ALTER customavatar ADD dateline int(10) unsigned DEFAULT '0' NOT NULL

[MApI]

Done and ... everything's working !!!!


Thanx a lot