I just installed smileys into drupal v6.2 and am seeing this:

"user warning: Unknown column 'promote_to_box' in 'where clause' query: SELECT * FROM smileys WHERE promote_to_box='1' in /usr/local/drupal-6.2/sites/all/modules/smileys/smileys.module on line 42."

Comments

Gurpartap Singh’s picture

Gurpartap Singh commented

Did you upgrade from 5.x?

NewToDruballer’s picture

NewToDruballer commented

Same thing here.
According to the schema, adding

$ret[] = update_sql("ALTER TABLE {smileys} ADD `promote_to_box` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `standalone`;");
$ret[] = update_sql("ALTER TABLE {smileys} CHANGE `package` `package` VARCHAR( 64 ) NOT NULL DEFAULT 'Miscellaneous';");

to smileys_update_6000()-function and updateing the module worked for me. (Or just paste the sql into your pma, remove the brackets and submit)

Gurpartap Singh’s picture

Gurpartap Singh commented
Status: Active » Fixed

Please run the appropriate update (6000) in update.php to fix the problem if you still have it.

Gurpartap Singh’s picture

Gurpartap Singh commented
Version: 6.x-1.x-dev » 6.x-1.0-alpha1
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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