Drupal 5 to 6 upgrade many errors
Hello,
I am in the midst of attempting an upgrade of a drupal 5 site to drupal 6. I have disabled all contributed modules and I am just attempting to update core alone right now... when run the upgrade script I am getting a number of errors and I have been searching the drupal.org site for other people's experiences with the same errors and I am not finding any.
I am hoping someone out there might be able to take a quick look at the errors and let me know if they are in fact a problem.
Also, I am curious to know if there is any documentation on how to troubleshoot this type of errors, I have searched drupal.org for some kind of documentation on what to do when they come up and have been able to find very little direction, any help in pointing me where I could learn more about this would be really appreciated.
I have attached a .txt file of the errors I received (screen cap was too large).
Thanks,
:) Andy
| Attachment | Size |
|---|---|
| update-first-attempt.txt | 77.73 KB |
Ical feed
Overall not too bad, but I'd check my tables to be sure.
Not too concerning:
- table ... already exists: it tried to create a table that is already in your database. you should be fine, but perhaps check that the field definitions are the same in those tables.
- duplicate entry ... for key ...: it tried to create a row that already exists, and the attempt ran afoul of a primary key. you should be fine if the field values are the same for that entry.
- duplicate column name ...: it tried to create a field that already exists. you should be fine but check the column definition.
- duplicate key name: it tried to create a key that already exists. you should be fine but check the key definition.
- multiple primary key defined: it tried to create a second primary key. you should be fine but check the primary key definitions.
A bit more concerning:
- you have an error in your mysql syntax: This is odd. Did you have some module that has to do with watching people's posts? Because one of the permissions from that module has a single quote in it which is somehow messing up the system.module's installation routine. I'm not really sure what to do about that. It might not break anything either.
thanks for the input david, I
thanks for the input david,
I did have the watcher module installed, I see where you are talking about ...access others' lists of watched posts.
would it be advisable to uninstall that module and redo the upgrade process?
also, is there an easy way to see which errors in the first list caused the failures in the list below? or is that even how it works, I am very new to this process so any explanation of this would be greatly appreciated...
thanks,
Andy
I had some of these messages
I had some of these messages when I upgraded from 5 to 6, and I haven't really dug deeply enough to figure out why they happen. What I did was just use phpmyadmin to manually check that all the tables for which there were errors were defined in the way that the erroneous queries wanted them to be. Does that make any sense? -It seems hackish, but for me it was faster than trying to figure everything out and re-update. However, since you've got a bunch of errors, and especially with that watcher.module weirdness, you might indeed want to uninstall that and re-update - however, you would definitely lose whatever data the watcher module was keeping track of for you. If that data is important, you might be better off just leaving it. Check to see if the watcher module has a drupal 6 update, Google around for this issue, etc.
thanks, that makes sense, I
thanks, that makes sense, I will give that a try...
:) Andy
ok. so I am going through the
ok. so I am going through the errors as you suggested, and I am finding some that are related to items that are missing in the database...
for example: * Failed: ALTER TABLE {cache_filter} CHANGE
serializedserializedSMALLINT NOT NULL DEFAULT 0in looking at the database the table cache_filter has no field for serialized. So I was going to add serialized as specified above.
so is it okay for me to add the missing items as the script was trying to?
I think so - it's what I
I think so - it's what I would do, though I'm not absolutely sure it's right. But it seems entirely logical.
Actually I found...
I found that in re-doing the same upgrade, that I had a much easier time upgrading with all of the modules turned on. As long as I was logged in as user 1 - then things went well with a lot fewer errors. My initial errors were similar to yours. One caveat - I was using Internationalization- and that one really needs to be OFF in the D5 - D6 upgrade. Also -- you should switch to one of the standard themes otherwise viewing your page is 'interesting' post upgrade - but I'm sure you've found that already.
I've manually updated tables too...with a good deal of success, but I always become unnaturally superstitious while I'm doing it.