The database is currently RC4. The idea would be to compare the clean install database of RC4 (PM link) with the current server database (which is RC4) to see if the field tables are the same - not just in name but overall structure.Atul Khandekar said:
You don't have to mess with it if you don't have the tools. I looked here and I will have to install MySQL on my pc and load in the two database and compare them using a program I found which looks like it will do the job. I can do that next week or the week after. I did some testing here and several of the upgrade scrips fail - I do think several of the tables have 'incorrect' structures. To be honest, it would take too long to try to detail out everything I've looked at in a text message.
For example, in upgrade script 9 (RC2 to RC3), this appears to fail:
PHP:
// this one is for future use and is added now to maintain sync with the customavatar table since they share functions
$query[] = "ALTER TABLE " . TABLE_PREFIX . "customprofilepic ADD filesize INT UNSIGNED NOT NULL";
$explain[] = "Adding filesize field to " . TABLE_PREFIX . "customprofilepic table.";If I dump that one query from upgrade script 9, the rest of 9 runs.
I don't think there is an immediate consequence - the above and a couple other failures I have found don't seem to be hampering anything - what could I do if they were? - so I figure I can wait until next week to hop back on it.
If you do find a tool and have the time, I gave you a 'pruned' dump - messages and users were deleted - database from the server in a link in a PM - and the 'clean' database. Well, I gave you the dumps. Each tool I looked at you have to have the databases loaded - you can't just take the backups and derive the info from them.
Somethng I just thought of - maybe I could take a 'fresh' install as a template and empty all data from all tables - that would leaved the fields defined properly. Then I could import the records from the server database into it. Sound feasible?
