Menu

#14 I cannot update the forum

open
nobody
5
2005-03-01
2005-03-01
Spider
No

I have Core Version: 0.10.0 up and running. . I am
upgrading from 0.6.2 phpwsbb to phpwsbb-1.0.1 When I
click update I get the following error.

I am a noob as far as tables go. I can export, sql query,
thats about it. Can someone please help me out here.

DB Error: unknown error
ALTER TABLE mod_phpwsbb_threads ADD lastpost int
NOT NULL default 0 [nativecode=1060 ** Duplicate
column name 'lastpost']

Discussion

  • Shaun Murray

    Shaun Murray - 2005-03-02

    Logged In: YES
    user_id=722742

    I had the same problem a few days ago doing exactly the same. The
    upgrade direct from 0.62 to 1.0 doesn't work.

    With phpMyAdmin, drop the columns that have been added by the install
    which are extra to those originally in v0.62 so that you're back where you
    started or reinstate that backup you made.

    Then you need to go through multiple installs.

    0.62 -> 0.72
    0.72 -> 0.81
    0.81 -> 0.97
    0.97 -> 1.01

    Or something similar to that.

    You'll also need to remove the version checking from the pre-1.0.1 boost/
    update.php files, the core version check and remove old update code for
    previous versions eg. the 0.40 update code.

     
  • Spider

    Spider - 2005-03-02

    Logged In: YES
    user_id=1181569

    Thank you for your reply. Could you please expand on this
    please. I donot know what files I have to edit.

    You'll also need to remove the version checking from the pre-
    1.0.1 boost/
    update.php files, the core version check and remove old
    update code for
    previous versions eg. the 0.40 update code.

     
  • Spider

    Spider - 2005-03-03

    Logged In: YES
    user_id=1181569

    It's ok I did it, Thank you very much for helping me out. It all
    works fine now thanx to you.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.