#14 I cannot update the forum

[Spider]

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']

[Shaun Murray]

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]

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]

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.