Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By brenda003 on
I followed all the steps involved in upgrading but seem to be having a problem with not all tables being updated properly. I get a "Page not found" at my website currently.
Why would it not be updating all the tables correctly?
Is there a method to figuring out which database updates I need to run so I can do it manually? I'm not sure on my current version of Drupal, I believe it's 4.6.5 but a lot of core files have been altered. Is this causing the problems, perhaps?
Any help would be appreciated, thanks.
Comments
If you hack your Drupal
If you hack your Drupal install then you cannot expect our update script to work. It still might, but this depends on the nature of your changes.
In any case, more information is needed to find out what went wrong.
--
Drupal services
My Drupal services
--
Drupal services
My Drupal services
Keep records to make a smoother upgrade
After so many failed upgrades in the past, I have become more careful and this is what I would recommend
- Copy your database and codebase just incase things go wrong and upgrade the copy and after it works, switch
- As you make updates to code, make noted somewhere so that before you upgrade you can use a clean copy of the old version's codebase, run the upgrade and when done, you can edit the core for the new setup to get any tweaks that you had done on the old version if necessary
-----
Web Development, Production & Marketing Advice - http://www.cmsproducer.com/click/26/3
Empty cache table
I had some problems, too. Don't know if it works for you but I deleted the cache table in the database and it worked.
THanks for the comments. I'm
THanks for the comments. I'm mostly trying to understand how I would go about updating the database itself, since it isn't doing it properly using the update script... not sure if I'm making sense. I mean knowing which updates need to be done - all of them?
Most of the changes have just been various patches, tweaks to work with PHP 5, and many modules have been hacked, but I don't understand why that would really affect things.
Maybe there's some handbook I've been unable to find about this somewhere!
Well obviously I was
Well obviously I was thinking about this wrong... if I'm deleting all old drupal files and replacing them, modifying them shouldn't affect anything. So, now I don't know what the problem could be.
I installed a new version of drupal 4.6.6 and imported my current database into it. Everything worked fine. Tried to update again to 4.7RC1 and first I get this error:
Page not found
user warning: Unknown column 'theme' in 'where clause' query: SELECT * FROM blogger_blocks WHERE theme = 'bluemarine' AND status = 1 ORDER BY region, weight, module in /xxx/includes/database.mysql.inc on line 120.
Hm. Maybe my database prefixes are messing it up? Not sure. Testing that one now.
It is unclear to me why this
It is unclear to me why this query should be executed when you access update.php.
--
Drupal services
My Drupal services
--
Drupal services
My Drupal services
I get this after I've run
I get this after I've run update.php and go to any page on the site. Update.php shows no errors and finishes within a second or two, making me feel like it isn't working properly.
Looking at the tables, they aren't updating correctly.
I'm now trying a different approach of a clean install of 4.7rc1 and modifying the tables of my 4.6.3 database to merge them into the clean install.
Will report my progress if anyone is interested, but at this point I don't know what else to do.
Hmm
It seems to me like your update started on the wrong update function.
--
Drupal services
My Drupal services
--
Drupal services
My Drupal services
Smooth Upgrade from Drupal 4.66 to Drupal 4.7 - How to
It makes a difference to begin with an installation that's the least tweaked and patched in order to succeed in upgrading to Drupal 4.7. If you modified some of the core database table with module SQL such as 'Similar Entried - http://drupal.org/node/25974' which even warns you about problems in u[grade, you will need to go into your database and undo the changes made (this means that you will loose any information stored in added columns).
I have been able to upgrade from Drupal 4.66 to Drupal 4.7 with minimal issues by keeping in mind all the changes that I previously made to my Drupal 4.66 installtion. Here is a detailed description on procedure for upgrading Drupal 4.66 to Drupal 4.7.
-----
iDonny - Web CMS Development, Design, and Web Marketing Advice
Manually updating your Drupal 4.6 database to Drupal 4.7
If you really want to manually update the database tables to be Drupal 4.7 compatible, you will have to pick and run the SQL commands in your favourite tool (PHPmyAdmin or mySQL command prompt). Look in the update.php file in the 4.7 codebase root folder or the updates.inc file in the databse folder and you will see the 100s or ALTER commands that are used to add new columns, change data-types or even remove some Drupal 4.6 columns.
Assuming that you made a backup of your live database before you started to upgrade, I would go back and make a new copy of the database, make sure that I clear the cache tables and other manual table tweaks that you may have made, and try the upgrade again. it's much easier than attempting to manually ALTER tables (in my opinion at least)
-----
iDonny - Web CMS Development, Design, and Web Marketing Advice