Error upgrading?

[BGSWebDesign]

Hi,

Trying to upgrade to v. 1.87 from 1.86, got this:

Lost connection to MySQL server during query
MySQL server has gone away
MySQL server has gone away
MySQL server has gone away
database error, file error, or you already ran this script!

I CAN login using phpMyAdmin, try running again, get the same Upgrade message:

Upgrade detected!
Please wait while your database is updated
It is very important that you do not interrupt this process
DB Version: 1.86  New DB Version: 1.87
Testing MySQL permissions... Ok
Upgrading (Please Wait)...

After it finished go this message:

Upgrading (Please Wait)... Can't DROP 'email'. Check that column/key exists

Will this cause any problems with LMP?  Any ideas?

[DW]

This is rare (It's the first time, ever) and is likely to cause problems.  A manual database analysis and fix is probably required.  It seems that your server has a very low MySQL timeout setting...

Please submit your info and I'll manually repair your DB.  You can omit control panel access - I can upload a copy of PhpMyAdmin.

DW

[BGSWebDesign]

Hi DW,

This is rare (It's the first time, ever) and is likely to cause problems.

Of course, that usually happens to me - I'm always the 'FIRST'!

Regarding this...  it seems to be working fine, I waited for it to complete, and everything 'seems to be working', I saw this:

Can't DROP 'email'. Check that column/key exists

Can you please tell me what 'email' column this is speaking of?  I can look around myself in phpMyAdmin and see what's up here... you must know what/where this 'email' column was?

Other than that, I've sent out messages, and everything else looks good??   Do you still think there could be problems?  You said:

I'll manually repair your DB

 Let me know what this entails, as you know I prefer to do things on my own, as I do not allow FTP access to my server/list for security/privacy reasons.  

[DW]

Of course, that usually happens to me - I'm always the 'FIRST'!

Well, you're definitely not the first to have your MySQL server go down, but you are the first to have it happen within the mere seconds it takes for a ListMail update.  Was your host having some troubles?

Near the bottom of upgrade.php are all the MySQL commands for the update.

Anything after this is relevant:

Code: [Select]

// v1.87 update
if($cver=='1.86'){
It would appear that one of these lines is what it's having trouble with:

Code: [Select]

mysql_query("ALTER TABLE $utable DROP INDEX email");
mysql_query("ALTER TABLE $utable CHANGE email email VARCHAR(255) NOT NULL");
mysql_query("ALTER TABLE $utable ADD INDEX (email)");
Manually repairing the DB would entail going through the upgrade queries and comparing them to the existing database.  Any operation not already performed would need to be done manually.  Let me know if I can be of any help with this.

Regards

[BGSWebDesign]

Hi DW,

Manually repairing the DB would entail going through the upgrade queries and comparing them to the existing database. Any operation not already performed would need to be done manually. Let me know if I can be of any help with this.

Thanks, ok, I went through the last 10 commands or so and the databases/fields all seem to already be updated, everything else is working properly - so hats off - it seems even with a crash your upgrade.php can recover...

I suggest you also delete the file upgrade.php when you're done, right?  I wouldn't want that hanging around for hackers to play with...

Thanks, I'll let you know if anything else comes up.