Upgrade from 2.0.16 to 2.0.21 - Database errors

[pinkpanther465]

So along time ago I ran a site that had about 6,000 users, I closed the site after it got to expensive to run. Now I once again have money to run the site and I would like to re-launch the forum from the backup I made. The old board version was 2.2.16, I inserted the old users into the database and than ran threw the normal steps to update to 2.2.22 and everything went threw ok. Every thing appears to be working except the fields don't match, the location field displays numbers, and the website field displays the users comments. How can I fix this and clear the comments & locations field.

See http://abouttp.com/forum/memberlist.php

[espicom]

Some confusion on version numbers... I assume you mean "2.0.16" and "2.0.22" (the latest).

When you restored the database, did you run the install/update_to_latest.php script that came with the 2.0.22 installation package?

[pinkpanther465]

Yes I did, and someone over IRC suggested replacing memberlist.php with a fresh copy and I did that as well to no avail.

[geocator]

Look in your database, browse the users table and see if that appears in the location filed there.

[pinkpanther465]

All the fields are off, it appears to be because of an additional table installed between .16 and .22.

[geocator]

All the fields are off, it appears to be because of an additional table installed between .16 and .22.

That makes no sense though as your backup should relate the data to specific fields.

[pinkpanther465]

I thought so to, this is the first issue Ive had with upgrading since forever.

I am going to create another database and dump it again.

[espicom]

What you are describing should not happen in phpBB, because all variables read from the tables are accessed by name - even if you add additional fields to the user record, for example, the variable "username" should point to the user's name field.

Mixing up the fields is something that will happen when accessing table fields by position, rather than name, which will be affected by adding fields to a table. The 14th column in the record does not necessarily point to the same column name, for example. I, unfortunately, have to deal with someone that codes that way, on other projects.