while trying to upgrade [#43030]

Step 1

In a freshly copied 4.6.3 DB (working with 4.6.5)

On linking to 4.7.0 beta2

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column &#039;referer&#039; in &#039;field list&#039;\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, &#039;page not found&#039;, &#039;&lt;em&gt;node&lt;/em&gt; not found.&#039;, 1, &#039;&#039;, &#039;/interactive470-beta2/&#039;, &#039;&#039;, &#039;60.226.18.121&#039;, 1136205210) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/', '', '60.226.18.121', 1136205210) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108
 Home
Page not found
user warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', '<em>node</em> not found.', 1, '', '/interactive470-beta2/', '', '60.226.18.121', 1136205210) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108. 

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column &#039;cache&#039; in &#039;field list&#039;\nquery: UPDATE sessions SET uid = 0, cache = 0, hostname = &#039;60.226.18.121&#039;, session = &#039;messages|a:0:{}&#039;, timestamp = 1136205210 WHERE sid = &#039;c9777ccb740ed2ea9364f863d82b0b78&#039; in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/', '', '60.226.18.121', 1136205210) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108

What the!

Step 2

link to update.php

which returns

Access denied
Access denied. You are not authorized to access this page. Please log in as the admin user (the first user you created). If you cannot log in, you will have to edit update.php to bypass this access check. To do this:

With a text editor find the update.php file on your system. It should be in the main Drupal directory that you installed all the files into. 
There is a line near top of update.php that says $access_check = TRUE;. Change it to $access_check = FALSE;. 
As soon as the script is done, you must change the update.php script back to its original form to $access_check = TRUE;. 
To avoid having this problem in future, remember to log in to your website as the admin user (the user you first created) before you backup your database at the beginning of the update process. 

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column &#039;cache&#039; in &#039;field list&#039;\nquery: UPDATE sessions SET uid = 0, cache = 0, hostname = &#039;60.226.18.121&#039;, session = &#039;messages|a:0:{}&#039;, timestamp = 1136205422 WHERE sid = &#039;c9777ccb740ed2ea9364f863d82b0b78&#039; in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/update.php', '', '60.226.18.121', 1136205422) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108

So knowledgeable friends....where do I go next?

I'm off to check whether the DB is nuked or still usable for the 4.6.5 install....luckily I have spare.

Comments

Comment #1

wellsy commented 2 January 2006 at 12:56

So step 3

RTFM or in this case the message in front of you.

So I did as the message suggested.

uploaded the new update.php to the site refreshed and then....

Drupal database update
Use this script to upgrade an existing Drupal installation. You don't need this script when installing Drupal from scratch.
Before doing anything, backup your database. This process will change your database and its values, and some things might get lost. 
Update your Drupal sources, check the notes below and run the database upgrade script. Don't upgrade your database twice as it may cause problems. 
Go through the various administration pages to change the existing and new settings to your liking. 
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.


Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Unknown column &#039;cache&#039; in &#039;field list&#039;\nquery: UPDATE sessions SET uid = 0, cache = 0, hostname = &#039;60.226.18.121&#039;, session = &#039;messages|a:0:{}&#039;, timestamp = 1136206198 WHERE sid = &#039;c9777ccb740ed2ea9364f863d82b0b78&#039; in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/update.php', '', '60.226.18.121', 1136206198) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108

The result was the above

So I ran the script....

and after a long time was presented with

The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

I'll report back again soon.

Comment #2

wellsy commented 2 January 2006 at 13:01

step 4

I went to the base url of the 4.7.0 beta2 install.

Initially the page came out of cache.

Refreshed and

Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Unknown column &#039;referer&#039; in &#039;field list&#039;\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, &#039;page not found&#039;, &#039;&lt;em&gt;admin&lt;/em&gt; not found.&#039;, 1, &#039;&#039;, &#039;/interactive470-beta2/admin&#039;, &#039;http://www.orchidauction.biz/interactive470-beta2/&#039;, &#039;60.226.18.121&#039;, 1136206631) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/admin', 'http://www.orchidauction.biz/interactive470-beta2/', '60.226.18.121', 1136206631) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108
 Home
Page not found
Welcome to the administration section. Below are the most recent system events.

This lot in red
user warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'page not found', '<em>admin</em> not found.', 1, '', '/interactive470-beta2/admin', 'http://www.orchidauction.biz/interactive470-beta2/', '60.226.18.121', 1136206631) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.
End Red


Warning: Unknown column 'referer' in 'field list' query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Unknown column &#039;cache&#039; in &#039;field list&#039;\nquery: UPDATE sessions SET uid = 1, cache = 0, hostname = &#039;60.226.18.121&#039;, session = &#039;messages|a:0:{}watchdog_overview_filter|s:3:\\&quot;all\\&quot;;&#039;, timestamp = 1136206631 WHERE sid = &#039;eac721340b287fa474ca5f9ec8cb7697&#039; in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108.', 2, '', '/interactive470-beta2/admin', 'http://www.orchidauction.biz/interactive470-beta2/', '60.226.18.121', 1136206631) in /mounted-storage/home8/sub001/sc14839-HDBP/www/interactive470-beta2/includes/database.mysql.inc on line 108

So where to next gents?

I'll have a further look and see if DB is changed...will report soon.

Comment #3

wellsy commented 2 January 2006 at 13:22

ughh!

I took a screen shot of the db prior to upgrade but the page was not a the bottom of the screen when I took it so no totals are visible.

No way I can tell if it's changed or not now.

Anyway the 4.6.5 install can still use the database so I guess it must have failed to update eh?

Anyone here know how to proceed?

Comment #4

wellsy commented 2 January 2006 at 14:59

Oh yeah...using IE6

Comment #5

wellsy commented 2 January 2006 at 23:35

Does anyone know what proceedure to use get some 4.6.3 data into 4.7.0 beta2?

Comment #6

wellsy commented 6 January 2006 at 01:23

Duh- I take it there is no proceedure?

So how do I move my 14mb of data to 4.7.0 stable release when that arrives?

Cmon there must be a way guys.

Comment #7

drumm

he/him

NY, US

commented 12 January 2006 at 23:50

Duh- I take it there is no proceedure?

So how do I move my 14mb of data to 4.7.0 stable release when that arrives?

Cmon there must be a way guys.

This is not the way to encourage people to provide help.

Can you paste the output of the following SQL query run on your old database before allowing 4.7's update.php to touch it?

SELECT * FROM variable WHERE name LIKE 'update_%';

And tell me which columns are in your system table:

DESCRIBE system;

Comment #8

wellsy commented 13 January 2006 at 13:05

From the way this bug report had been ignored I was under the belief that no-one had even read it.
You were the first to follow up since it was posted on the 2nd January.
I have spent many many hours trying to update 4.6.3 database to 4.7.0 beta 1 and 2 and have still not gained anything useful from the experience.

Frankly I have abandoned any further time wasting in this area.
I now await a stable release and confirmation of an update proceedure that works.

I will however do as you request when possible....I am struggling with very limited internet connectivity here at present.

I will report back with answers to your questions as soon as I am able.

Comment #9

wellsy commented 13 January 2006 at 13:15

As requested:
*****************************************************
SELECT *
FROM variable
WHERE name LIKE 'update_%';

no results reported
*****************************************************
DESCRIBE system;

filename varchar(255) PRI
name varchar(255)
type varchar(255)
description varchar(255)
status int(2) 0
throttle tinyint(1) 0
bootstrap int(2) 0
schema_version smallint(2) unsigned 0
*****************************************************

Comment #10

Bèr Kessels commented 2 February 2006 at 08:43

Priority:	Critical	» Normal
Status:	Active	» Closed (duplicate)

dupe of http://drupal.org/node/46934

The tone in this issue is way too grim

Comment #11

wellsy commented 2 February 2006 at 12:34

yep....it's grim when a detailed issue gets a grand total of two responces from the community and neither of those is of any assistance.
Both merely chastise me for my negative attitude. What do you expect my attitude to be when a valid issue report is ignored by all?

As mentioned I no longer waste my time with trying to get data into 4.7 beta. It simply does not work!

Oh, by the way, is there any possibility that data will be easily migrated to 4.7 release candidate?
No answer ever came to that question.

Comment #12

Bèr Kessels commented 2 February 2006 at 14:16

please post any constructive posts to the new thread. Thanks.

while trying to upgrade