upgrade fails - step 16

[cyc]

Hi

Trying to upgrade to v3 from 2.2.9 and it fails on step 16, the error message is as follows:

Database error in vBulletin :

Invalid SQL:
ALTER TABLE post
ADD parentid INT UNSIGNED NOT NULL,
ADD attach SMALLINT UNSIGNED NOT NULL,
DROP edituserid,
DROP editdate

mysql error: Can't DROP 'edituserid'. Check that column/key exists

edituserid and editdate did exist at step 15. If anyone knows of a fix please tell me

cheers

[Zachery]

Step 16 of what upgrade script?

There is usualy more to that error message.

[cyc]

Step 16 of what upgrade script?

There is usualy more to that error message.

The script is upgrade1.php?step=16

I left out the error number in my orig post, I dont know whatelse on the error page would be useful.

<!--
Database error in vBulletin :

Invalid SQL:
ALTER TABLE post
ADD parentid INT UNSIGNED NOT NULL,
ADD attach SMALLINT UNSIGNED NOT NULL,
DROP edituserid,
DROP editdate

mysql error: Can't DROP 'edituserid'. Check that column/key exists

mysql error number: 1091

Date: Wednesday 04th of August 2004 04:28:03 PM
Script: http://www.SOMEDOMAIN/install/upgrade1.php?step=16
Referer:
IP Address: some IP
-->

I also tried upgrading to 2.3.5 which worked fine, but the upgrade to v3 still failed.

[Steve Machol]

Try going to step 17:

http://www.somedomain/install/upgrade1.php?step=17

[cyc]

Try going to step 17:

http://www.somedomain/install/upgrade1.php?step=17

I've tried that several times, it completes the upgrade to 3.0.3 without any problems (posting/edit/admincp/usercp etc.). Everything within the forum works except the forumdisplay pages which give an sql error. I'll post that sql error later today.

[cyc]

I'll post that sql error later today.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
IF(votenum >= 2, votenum, 0) AS votenum,
IF(votenum >= 2 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0,92096)
ORDER BY sticky DESC, lastpost DESC

mysql error: Unknown column 'thread.firstpostid' in 'on clause'

mysql error number: 1054

Date: Thursday 05th of August 2004 09:43:21 PM
Script: http://www.somedomain/forumdisplay.php?f=7
Referer: http://www.somedomain/index.php?
Username: ME
IP Address: MY IP

ideas?

[Floris]

Note that you can run the upgrade script only once - running it twice will most likely result into an error.

Make sure you have all the version 2 files removed and replaced with the 3.0.3 files.

Make sure you run the upgrade from upgrade.php only.

If you have any hacks installed in version 2, undo those to avoid these problems. Sometimes mysql database table changes are conflicting.

[cyc]

Note that you can run the upgrade script only once - running it twice will most likely result into an error.

Yep, whenever i've re-run the upgrade its been on a different database

Make sure you have all the version 2 files removed and replaced with the 3.0.3 files.

I've been using a sub directory, there is no chance of file mix ups etc.. The way I'm doing it worked without any problems on a forum with 1.5 million posts and 70,000 users.

Make sure you run the upgrade from upgrade.php only.

I've always done this except when it was suggested to skip a step.

If you have any hacks installed in version 2, undo those to avoid these problems. Sometimes mysql database table changes are conflicting.

I'm 99% sure any hacks i have arnt causing the problems, but i'll remove them to be sure.

regards,

[cyc]

When I run the conflicts script I get this:


Table Conflicts
No Table Conflicts

Column Conflicts
No Column conflicts

[Steve Machol]

One or more of the upgrade steps were skipped or did not complete. Try adding this field manually to the thread table with phpMyAdmin:

Field: firstpostid
Type: int(10)
Attributes: UNSIGNED
Null: No
Default: 0

[JimF]

Figured I'd update this in case anyone was actually looking for a solution...

I just commented out the first query in step 16 and re-ran it, and everything is working fine now.

I had the same exact problem as cyc.

-jim