By Schamess on

I upgraded from 4.4 to 4.6 without much problem. In the 4.4 site I had many news feeds displayed in blocks on the front page. After upgrading, I set about categorizing the news feeds. I added some categories that weren't there before. Then, I went to the administration menu, clicked "blocks" - and got the following error message:

user error: Unknown column 'visibility' in 'field list'

query: INSERT INTO blocks (module, delta, status, weight, region, visibility, pages, custom, throttle, types) VALUES ('aggregator', 'category:6', 0, 0, 0, 0, '', 0, 0, '') in (my site)/includes/database.mysql.inc on line 66.

Now when I go to the home page, none of the blocks display - not even the login or navigation blocks. It won't let me access the admin pages via the url either (also none of the links work now). So, I don't think there's any way to go back and uncategorize the feeds.

Any suggestions on how to fix this, short of restoring the old database and doing the upgrade over again?

Happily, I did this all on a test site so the original is still up, running 4.4. But would appreciate any help! Hope to get the new site running soon.

Thanks!

Comments

Schamess’s picture

Schamess commented

I think I (maybe) fixed the problem - see here.

Andrew Schamess

rickrover’s picture

rickrover commented

I have the same problem. I updated from 4.5 to 4.6.0. I have all my files backed-up, but don't want to go back to 4.5 (really want 4.6.1) and am not sure how.

Do I have to have the host site install 4.6.1? I have shell access and MyPHP. I used Fantastico to install 4.5 (months ago) and to update to 4.6.0 (yesterday). When I had the "no blocks error" I deleted Durpal and reinstalled fresh, then restored my database, same problem.

I really don't know much at all about php and databases but I can get the job done if someone can point me to docs or info. Drupal has been working great for my site. It took a month to learn enough to do what I needed but I am just slow :) Drupal is the best and thanks to everyone who made it that way.

I really would be happy just reinstalling Drupal and some how just inserting the aggregtor and taxonomy data into the new data base if this can be done.

My site is "kinda" still up, clean 4.6.0 install with restored database and still no blocks :(

WhatonMars.com

Thanks for any help or info you can give with any of the above issuse.
Rick

Steven’s picture

Steven commented

There are updates in update.php to upgrade the blocks table as needed. Did you perform the updates correctly? If not, you'll have to run these SQL statements manually on your database (through PHPMyAdmin or someting similar, usually):

ALTER TABLE blocks DROP path;
ALTER TABLE blocks ADD visibility tinyint(1) NOT NULL;
ALTER TABLE blocks ADD pages text NOT NULL;

--
If you have a problem, please search before posting a question.

rickrover’s picture

rickrover commented

I guess not, I upgraded with fantastico with my hosting site control panel. Looked like it went ok. I will try the above and hope it works :)
Thanks for your help,
Rick

rickrover’s picture

rickrover commented

On MyPHP it was easy once I figured it out. If anyone needs more info on how to do this with MyPHP let me know.
THANKS,
Rick

cceallen’s picture

cceallen commented

I had the same problem after upgrading with Fantastico. Applying the mySql code given above fixed it for me.

bslade’s picture

bslade commented

I also upgraded from 4.5 to 4.6.2 using Fantastico, and I'm having this same problem. Maybe Fantastico has an old/bad copy of update.php? Here's the CVS id string from my update.php (from Fantastico):

$Id: update.php,v 1.147 2005/04/06 19:04:02 dries Exp $

Note, the visibility field is not in this update.php file

bslade’s picture

bslade commented

It looks like old some old updates where never applied when I upgraded to Drupal 4.6.2. An example of why I say this:

When I run the cron.php script, I get errors saying sid not found in search_index.

Looking at the database/updates.inc script, I see the sid column was added to the search_index table for update_110 which corresponds to update "2004-10-31" as disiplayed by /update.php

When I rerun update "2004-10-31", it does add the column (although it gives a bunch of other errors saying some columns have already been updated/added)

Does the Drupal upgrade to 4.6.2 not check to see if old updates have not been run?

This upgrade has been a complete meltdown for me. There are many tables that need updates and the upgrade process didn't say anything abou them (the upgrade did run, but apparently for the most recent update only)

Doesn't the upgrade script have some checks to make sure everything is update date?

I'm going to manually rerun all the old updates. Sort of messy.

Ben in DC

SimplyNoah’s picture

SimplyNoah commented

All of my blocks dissapeared and when I manage to get to admin I get like 20 error messages like this:

Unknown column 'visibility' in 'field list' query: INSERT INTO blocks (module, delta, status, weight, region, visibility, pages, custom, throttle, types) VALUES ('archive', '0', 0, 0, 0, 0, '', 0, 0, '') in /home/simplyno/public_html/main/includes/database.mysql.inc on line 66.

I tried the above sql statements and they had no problem but it still did not fix the blocks. I tried again and it gives me this error:

#1091 - Can't DROP 'path'. Check that column/key exists

I have back up and I've restored it like 5 times already, the only way I can aviod the blocks from disspearing again is to restore old backup before the problem occured and to never enter the blocks section in administer.

Help please. I Serch for topics before I posted. Sorry if I brought up an old topic.

radagast-1’s picture

radagast-1 commented

I had the same problem. This is what I did:

After running the SQL, go to:

http://yoursitename.org?q=admin/block

and add your blocks back.