Hello all,

I ran into a 404 error when trying to upgrade my site from 4.7.4 to 5.0 beta 2. The exact error message was:

An HTTP error 404 occured. update.php?op=do_update

It is quite obscure and I found no clue searching on the forum. Could some one point me a direction to look for information on this?
FYI, I followed the upgrading instructions, i.e. login as user 1, delete old files, upload new files, run update.php -> 404 error. And before the starting the database upgrade, I received this warning message:

user warning: Table 'vnsoton_drupal.node_type' doesn't exist query: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC in /home/vnsoton/public_html/includes/database.mysql.inc on line 167.

and after the upgrade (but this might be just because of the corrupted DB after a failed upgrade)

user warning: Table 'vnsoton_drupal.blocks_roles' doesn't exist query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'fancy' AND b.status = 1 AND (r.rid IN (2,3) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/vnsoton/public_html/includes/database.mysql.inc on line 167.

Comments

trungdong’s picture

I just retried the whole process, but this time I disabled all the 3rd party modules and themes. I didn't get the warning message before the update, but still get the 404 error. The update summary says:

The update process was aborted prematurely while running update #1000 in system.module.

Two warning messages AFTER the upgrade:

* user warning: Table 'vnsoton_drupal.node_type' doesn't exist query: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC in /home/vnsoton/public_html/includes/database.mysql.inc on line 167.
* user warning: Table 'vnsoton_drupal.blocks_roles' doesn't exist query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'bluemarine' AND b.status = 1 AND (r.rid IN (2,3) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/vnsoton/public_html/includes/database.mysql.inc on line 167.

pobster’s picture

I believe it's an issue with mozilla browsers (obviously including Firefox in case you didn't know!)

Try using IE.

Pobster

trungdong’s picture

Thanks for the advice! I just tried the same process again using IE7. Still the same problem :(

The frustrating thing here is that there is no clue where the error is from.

@baudolino: It's a 404.

baudolino’s picture

Are you sure it's not error 406?

Try adding this line to your .htaccess file: SecFilterEngine Off

pobster’s picture

Oops! Yeah I read that as a 406 error, sorry about that! I'd just stick a fresh .htaccess file in your root directory to fix a 404.

Pobster

trungdong’s picture

Thank you for the suggestion! I disabled clean url before upgrading and removed the .htaccess file and it works without a hitch.

Anyway, I'm still not sure what the real problem is. I think this, what ever it is, should make it to the upgrade instructions.

taherk’s picture

I am still struggling to make it work. Can you explain what you mean by disabling clean URL...

I am using 4.7. cck and views mods and trying to upgrade to 5

______________________________________
Drupal Tips, how-to, Themes @ http://mydrupal.com

taherk’s picture

I am bumping here again, as I tried again with Drupal 5.0 and still getting same error.

I think my database is not getting updated. I ran the update.php 2nd time and I was still seeing the pending update for modules ( Numbers in dropdown)... I saw that there is an open issue for this...but just in case some has found a fix please post here.

Till then, my drupal 5 site is not usable

______________________________________
Drupal Tips, how-to, Themes @ http://mydrupal.com

fool2’s picture

It was a 404 But SecFilterEngine Off worked.

Note: I already had SecFilterScanPOST Off in htaccess for other errors I was getting

vinayras’s picture

Thanks for the help.

adding
SecFilterEngine Off
in .htaccess

Vinay Yadav
PHP Specialist
http://www.vinayras.com

thaipeace’s picture

Hi all one, this is the first time i post an entry here. I always read your posts and it is so helpful for me to resolve my project. So now, I have a misunderstanding problem. When I try to make an autocomplete property for my textfield. First time it ran well but later it can't run anyway. Every time I type a letter to call this autocomplete fuction, there is a pop up like that "An Http 404 error occured" and then I cilck ok, it end my work.
This is my textfield (very simple):
$form['items'] = array (
'#type' => 'textfield',
'#title' => 'Block\'s items',
'#default_value' => '',
'#autocomplete_path' => 'dvbanner/inc/autocomplete',
'#description' => 'Enter banner items name that you would like adding this to this block, seprate by comma (,).'
)

This is my autocomplete function:
$regexp = '%(?:^|,\ *)("(?>[^"]*)(?>""[^"]* )*"|(?: [^",]*))%x';
preg_match_all($regexp, $string, $matches);
$array = $matches[1];

// Fetch last tag
$last_string = trim(array_pop($array));
if ($last_string != '') {
$result = db_query (
"SELECT bid, title FROM {dvbanner_item} WHERE LOWER(title) LIKE LOWER('%%%s%%')",
$last_string
);

$prefix = count($array) ? implode(', ', $array) .', ' : '';
$matches = array();

while ($v = db_fetch_object($result)) {
$n = $v->title;
// Commas and quotes in terms are special cases, so encode 'em.
if (strpos($v->title, ',') !== FALSE || strpos($v->title, '"') !== FALSE) {
$n = '"'. str_replace('"', '""', $v->title) .'"';
}

$matches[$prefix . $n] = check_plain($v->title);
}

print drupal_to_js($matches);

Thanks for all your remark and returning your solutions if you want !!!