Have installed all modules according to your Readme doc and everything seemed to be ok until I tried to set up my first page and then I got the following error when I tried to add blocks and each time I clicked on save my changes.

The listed error is:

" Unknown column 'status' in 'field list' query: SELECT status FROM homebox_default WHERE bid = 3821 AND pid = 1 in /home/garp/public_html/sites/all/modules/homebox/homebox.admin.inc on line 217."

Thanking you in advance for your help in this matter. GarP

Comments

jchatard’s picture

jchatard commented
Title: Error when trying to add blocks to page » Unknown column 'status' in 'field list' query
Assigned: Unassigned » jchatard

Hi GarP,

I think I made something wrong (maybe in the commit or code), I'll have to check.

I can suggest you 2 things try to run update.php.

Or, completely uninstall alpha2, then install alpha1, and after update to alpha2.

What is important is that in the 'system' table, you need to have homebox 'schema' field to be in version 6002.

I'll check this very soon.

Sorry for inconvinience.
Jérémy

DeFr’s picture

DeFr commented

@jchatard: You've added the fields status and open to the homebox_default table via homebox_update_6002, but didn't update the default schema provided in homebox schema with those two colums. On fresh install, Drupal just take whatever is in the hook_schema as the latest and greatest, and doesn't apply any update, that's why new installs don't work.

jchatard’s picture

jchatard commented

Thanks Franck!

Fixed in ALPHA3, everyone is encouraged to upgrade.
Jérémy

jchatard’s picture

jchatard commented
Status: Active » Fixed

Change issue status I always forgot!

GarP’s picture

GarP commented

Thanks for this GREAT module and your fast response ! ! Upgrading to ALPHA3 solved the problem. GarP

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.