Bug #623

Upgrade 1.1.18 -> 1.4.11

Added by Stefan T. about 2 years ago. Updated almost 2 years ago.

Status:Closed Start date:12/31/2009
Priority:Normal Due date:
Assignee:Ryan Gordon % Done:

100%
Category:Upgrade Procedure
Target version:1.4.12
Reproducibility:Always Database Type:
Reported In MyBB Version:1.4.10 Database Version:
PHP Version: SQA assignments:
Browser:

Description

You get this message when you try to upgrade:

Fatal error: [SQL] [1054] Unknown column 'unreadpms' in 'field list'
UPDATE mybb_users SET `unreadpms`='0' WHERE uid='1' in /***/inc/db_mysql.php on line 548

Associated revisions

Revision 4752
Added by Ryan Gordon about 2 years ago

Fixes Upgrade 1.1.18 -> 1.4.11 (fixes:623)

History

#1
Updated by Ryan Gordon about 2 years ago

  • Status changed from New to Rejected

Clearly you didn't upgrade properly:

It's there: upgrade5.php

if($db->field_exists('unreadpms', "users"))
{
    $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP unreadpms;");
}
$db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD unreadpms int(10) NOT NULL default '0' AFTER newpms;");

#2
Updated by Stefan T. about 2 years ago

But the error occurs before the table is updated...

#3
Updated by Ryan Gordon about 2 years ago

You've provided no repro instructions.

#4
Updated by Stefan T. about 2 years ago

Just start the upgrader. After you selected the version you see this error.

#5
Updated by Ryan Gordon about 2 years ago

Well I don't. You obviously didn't run the upgrade procedure properly. What version did you select exactly from the drop down? If you choose the right one, it would have added that field appropriately.

#6
Updated by Michael Malin about 2 years ago

Ryan, you don't get it.
Stefan is right.
If you go to the /install folder and select "Upgrade to MyBB 1.4.11" there is on the next page shown this error.

#7
Updated by Ryan Gordon about 2 years ago

That still doesn't help. As I stated before I need reproduction instructions and other details that are relevant to the problem like are you logged in, or logged out when you go to the installer? And if you're logged on, is the account an admin account or not?

#8
Updated by Stefan T. about 2 years ago

I am logged in as an admin.

#9
Updated by Michael Malin about 2 years ago

Ohm, whats about that bug, now?

#10
Updated by Ryan Gordon about 2 years ago

  • Status changed from Rejected to New

I'm very surprised this wasn't found before now as that has been in MyBB 1.4 for quite a while now

#11
Updated by Stefan T. about 2 years ago

I am sure the upgrader worked on MyBB 1.4.4 because I upgraded an very old forum there.

#12
Updated by Michael Malin about 2 years ago

Is there any "new" version of the upgrader? I tried it 2 minutes ago again and this bug was shown again.

#13
Updated by Stefan T. about 2 years ago

Nobody said, it is fixed... Please wait for a changeset.

#14
Updated by Ryan Gordon about 2 years ago

Stefan T. wrote:

I am sure the upgrader worked on MyBB 1.4.4 because I upgraded an very old forum there.

It was whenever the administration protection was added to the MyBB 1.4 upgrader.

#15
Updated by Ryan Gordon about 2 years ago

  • Status changed from New to Assigned
  • Assignee set to Ryan Gordon
  • Target version set to 1.4.12

#16
Updated by Ryan Gordon about 2 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Applied in changeset r4752.

#17
Updated by Stefan T. almost 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF