By Gunnar Langemark@www.langemark.com on

I'm working on an upgrade for my troubled langemarks cafe. It runs on 4.3 code,and I'm testing an upgrade on my windoze machine. I have added a couple of changes to the db as stated in upgrade script, but when I try to upgrade the db via the link in the update.php script, I get the following error:

Fatal error: Table 'langemark2.users_roles' doesn't exist query: SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1 in C:\FoxServ\www\drupal431\includes\database.mysql.inc on line 125

I have a db with a role table and a user table. There is no users_roles table. Should I have one?

Comments

dries’s picture

dries commented

Yes, you have to create this table manually as per update.php's instructions.

marky’s picture

marky commented

"There is no users_roles table. Should I have one?"

Yes, you should. In reality, your upgrade path is 4.3 > 4.4 > CVS, so you need to create *all* the tables listed on the first page of update.php. Just run it again... ;)

/marky

Gunnar Langemark@www.langemark.com’s picture

Gunnar Langemark@www.langemark.com commented

OK - it said that if I upgrade from 4.4 I should create them. Guess I misunderstood.

Now it says:
Fatal error: Unknown column 'headers' in 'field list' query: SELECT data, created, headers FROM cache WHERE cid = 'variables' in C:\FoxServ\www\drupal431\includes\database.mysql.inc on line 125

So I should have a "headers" column in the "cache" table??
Since it was the unimportant table "cache", I just dropped it and created a 4.5 cache with headers, and tried again.
Now I got:

Fatal error: Class theme_marvin: Cannot inherit from undefined class basetheme in C:\FoxServ\www\drupal431\themes\marvin\marvin.theme on line 4

This of course has todo with the theming system which is new too. OK.
What to do? The class is not defined? How do I fix that?

Dropping in from Langemarks Cafe.

hrkaspar’s picture

hrkaspar commented

Delete themes not working in CVS (seems to be all those that used to work in 4.3) Upload some themes that work (or use one of the included ones...) It seems CVS degrades quite nicely if no theme is available, but does not work if a broken (old) theme is. There should be better warnings in this matter, I have a vague memory that it is part of the 4.3->4.4 upgrade warning.

Brgds
Kaspar

Drupal på dansk : DrupalDanmark

Gunnar Langemark@www.langemark.com’s picture

Gunnar Langemark@www.langemark.com commented

Worked - thanx

I also had a few db errors - which were fixed by hand. It turned out to be simple errors.

Dropping in from Langemarks Cafe.

Gabriel R.’s picture

Gabriel R. commented

Hello all,

I'm having the same *Unknown column 'headers'* problem as described above. The old instalation is 4.3.x and the new one is 4.5 final. Deleting all the old themes and keeping only what comes with 4.5 final doesn't help.

Fatal error: Unknown column 'headers' in 'field list' query: SELECT data, created, headers FROM cache WHERE cid = 'variables' in /home/httpd/vhosts/franta-romania.com/httpdocs/includes/database.mysql.inc on line 125

From what the error looks like (and I'm not a SQL enabled) it seems the trouble comes from a mess in the cache table.

Thanks for your help.

-- NO, don't read this signature!

Gabriel R.’s picture

Gabriel R. commented

I added the tables manually, using code from database.mysql.

-- NO, don't read this signature!

ekes’s picture

ekes commented

Catch 22 this one. The update 2004-01-13 creates the column headers in cache table, however the includes update is using require it in a query.

Solution...

ALTER TABLE cache ADD headers text;

Then when update.php barfs at 2004-01-13 just go back and restart it after that.

I also found it barfed on a few others on a similarly huge upgrade, it required going into database/update.inc and looking up the queries and seeing why they weren't working. Suspect most were individual oddities to my database.

It would however be helpful to change the 2005-03-21 update from:

ALTER TABLE term_node ADD PRIMARY KEY (tid, nid);

to:

ALTER IGNORE TABLE term_node ADD PRIMARY KEY (tid, nid);

as this automates removal of the duplicate keys - which in a two column table isn't loosing any data.

----
kester :: http://www.iskra-it.com/