خطأ بقاعدة البيانات ظهر لي بعد الترقية مالحل له؟

[خالد الحربي]

هذي الرساله :

+++++++++++++++++++++++++++

<tr>
    <td class="bodytext" colspan="2">
        Please try the following:
        <ul>
            <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
            <li>Open the <a href="/">www.name.com</a> home page, then try to open another page.</li>
            <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
        </ul>
    </td>
</tr>
<tr>
    <td class="bodytext" colspan="2">The www.name.com forum technical staff have been notified of the error, though you may <a href="mailto:dbmaster@example.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.6.4:

Invalid SQL:

            SELECT subscribeforumid, forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid
                
            FROM forum AS forum
            LEFT JOIN subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 3);

MySQL Error  : Unknown column 'lastpostid' in 'field list'
Error Number : 1054
Date         : Sunday, February 11th 2007 @ 09:26:56 AM
Script       : http://www.name.com/vbk/usercp.php?
Referrer     : 
IP Address   : 212.00000000
Username     : اداره المنتييديات
Classname    : vb_database</textarea></form> 

مالحل بارك الله فيكم ؟

[Sc®iPt]

ازرع هذا الأمر :

ALTER TABLE user ADD `lastpostid` int(10) unsigned NOT NULL default '0'; 

[خالد الحربي]

هلا اخويسيكربت للأسف لم ينجح

وهذي نتائجه

Error
SQL query:

ALTER TABLE user ADD `lastpostid` int( 10 ) unsigned NOT NULL default '0'

MySQL said:

#1060 - Duplicate column name 'lastpostid'


ننتظر الاجابة

[محمود حسين]

السلام عليكم

الحقل lastpostid في الجدول forum غير موجود

نفذ الاستعلام التالي

ALTER TABLE forum ADD `lastpostid` int(10) unsigned NOT NULL default '0';