By johlin on

Hello.

I have an error on the Status Report page. It reads as follows:

Database schema Out of date
Some modules have database schema updates to install. You should run the database update script immediately.

"database update script" is a clickable link, but when I click it, it goes to a "Page Not Found" message. It appears to stem from update.php, which doesn't seem to exist. Is update.php something I have to install???

Any advice is appreciated.

⋅ Categories: Drupal 5.x

Comments

newms’s picture

newms commented

Update.php *should* come with your drupal install. It should be located in your main drupal installation directory. If some how its not there, maybe you should get a fresh copy of drupal and put the upload.php on your server.

newms

Dan DG’s picture

Dan DG commented

I just had this same issue. I'm assuming my update.php was not present as my initial installation was courtesy of Fantastico.

As I'm using 5.1 I downloaded a fresh copy from http://ftp.osuosl.org/pub/drupal/files/projects/drupal-5.1.tar.gz and extracted update.php

Edit the following line (line 18?):
$access_check = TRUE;
So that it reads:
$access_check = FALSE;

(Found this out at http://drupal.org/upgrade/running-update-php)

Upload to your site and then visit www.yoursite.com/update.php
Remember to edit update.php back again to prevent anyone else from running it.

Following this through worked a treat for me.

johlin’s picture

johlin commented

Thanks so much for your help. Everything seems A-O-Kay now!

JohnForsythe’s picture

JohnForsythe commented

If you used Fantastico to install Drupal, you will not have an update.php script. They leave it out for some reason. Download a real copy of Drupal, and copy the update.php file over to your site.

edit: Looks like Dan beat me to it.

--
John Forsythe
Blamcast - Custom theme design and more...

sacxtra’s picture

sacxtra commented

You'd think the cPanel/Fantastico folks would design some kind of semaphore switch (remember semaphore's from back in the BBS days?), to remove Drupal from cPanel if the file update.php exists, instead of giving bad advice to update your Drupal 4.7.3 to a 5.1 when in REALITY your currently running Drupal 4.7.6

They screwed up.

In a perfect world, if exist /update.php or "cat fantversion.php | grep whatever" then
It's should say NO DRUPAL INSTALLS er.... NO FANTASTICO INSTALLS OF DRUPAL ON THIS SYSTEM.
instead of UPDATE NOW! in RED!

And they should have update path fork. 4.x vs. 5.x
fantastico is really retarded in this alone. Seriously wtf..

It could mean DEATH to a website.

Of course everyone does subscribe to security from drupal via email RIGHT?! And manually patch. Always Backup first.

And if your like me, where you trusted fantastico three years ago, you've been editing your fantversion.php to the current version, after you manually install. I feel like just setting the sucker on 9.9.9 but then when I update, I don't remember what version is/was installed. Oh well.

anyway, I am just brainstorming.

One day I will get off my ass and create a few new databases and grab control away from fantastico by removing my sites one at a time. (with the paths renamed of course) I don't see any other solution to wrestle the control away from cPanel/fantastico. Someone had some good advise on upgrading in another thread. But that information is subject to potentially a lot of unforseen problems in my opinion. Themes are not the only thing that can get screwed up. Any new thing that changes can. Who knows what mods someone may have made. Although, I agree, it's likely only page.tpl or whatever and a few /modules . Why take a chance? What if some poor dude has some module that ain't supported and they have other TRUSTED users that can access fantastico? LOL

I'll leave that to the experts. I used my own expert opinion on how to fix my individual problem. That's what this post was about. Plus I hope it generates some keywords so someone can find it.

Almost didn't post this ;o)

liminalspace’s picture

liminalspace commented

I am having similar trouble, as is my coworker (both using 5.1).

We have update.php and when we 'run' it (aka - either by hitting the link provided by the Drupal Status area or manually typing in www.mysitehere.com/update.php) we get sent to a polite screen of blank white, which (to me at least) means it has run.

However I continue to get Drupal bitching at me that my database schema is out of date. I have downloaded a clean copy of 5.1 and taken the update.php file and replaced mine with it, as well as changing the access from TRUE to FALSE just to check if it made any difference - which unsuprisingly it did not.

I have just uploaded and sucessfully installed about 10 new modules for a site I'm working on (which is already live and i'm working without a net on this one - no development server, hehe), and it has been since those modules were installed that Drupal has begun complaining my database schema is out of date - again, no suprise there.

Can anyone give me any ideas on what else to try? Obviously I need to update to keep everything happy, I don't want angry modules coming to eat my children ;-)

Anyone?

damonish’s picture

damonish commented

Ditto on all mentioned; no test server, etc.

And the blank white screen is very polite; everything seems to be in working order, just it keeps making sure I'm aware that the schema is out of date.

Has anyone made any relevant discoveries regarding this?

LeoB-1’s picture

LeoB-1 commented

In my case as soon as I enable the Notify module (for mail notification) I get that

Database schema Out of date
Some modules have database schema updates to install. You should run the database update script immediately."

But isn't there a warning on the update.php page that you should not run it twice? I have already ran it.

mindyblock’s picture

mindyblock commented

I had to upgrade to a new version of Members, though its still under dvpt.

Thank You Dan DG - for pointing out where to find the file - update.php. I got 5.1 from siteground and it wasn't there! It worked well! I didn't edit or change any code though.

He said, As I'm using 5.1 I downloaded a fresh copy from http://ftp.osuosl.org/pub/drupal/files/projects/drupal-5.1.tar.gz and extracted update.php

mdowsett’s picture

mdowsett commented

I have a similar problem - my database schema is out of date as well.

I did have my update.php status to FALSE and that didn't help. I also disabled all conributed modules (there was hardly any anyways) and that didn't help.

The latest error the update give me reads:
"An HTTP error 404 occured. update.php?op=do_update"

I've posted my problems here:
http://drupal.org/node/188477
as well with some screen shots, but no luck yet.

I'm in dire need of help!

newms’s picture

newms commented

Maybe this helps?

http://drupal.org/node/122114

cgjohnson’s picture

cgjohnson commented

In case this helps someone using site5 to host a Drupal site, just wanted to note that it also seems to strip update.php from the main directory. No surprise, since they use fantastico. When I add the file manually, it works fine. (that's the only site5 quirk I've had thus far).