I installed CPN recently on my site, it has been working like a charm until i tried to configure a block (all blocks send out the same error when i try to configure them) I am currently using Omega theme and i have delta blocks enabled. the issue dissapears when i disable CPN.
the output on the error page is as following:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'js' in 'field list': SELECT css, js FROM {block} WHERE module = :module AND delta = :delta; Array ( [:module] => system [:delta] => main ) in cpn_form_alter() (line 293 of /home/site1/www/sites/all/modules/cpn/cpn.module).

i also tried to disable delta blocks since it seems to be part of the problem but i still got the same error, also, if i disable CPN, configure the blocks the way i want and enable CPN again the blocks remain configured, it is just nagging to have to configure without seeing the added CSS to the blocks, since most of the changes are mostly visual.

Comments

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Category: Bug report » Support request
Issue summary: View changes
Status: Active » Fixed

This would happen if the installation failed, for some reason.

When CPN Is installed it is supposed to add the 'css' and 'js' fields to the schema and to the {block} table.

What you might try doing is running the following code from your terminal (it assumes that drush is installed):
drush ev "module_load_include('install', 'cpn');cpn_alter_block();"

That should cause the two missing fields to be loaded.

Status: Fixed » Closed (fixed)

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