Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
Hi,
Currently Postgres users get an error running update.php when upgrading to imagecache 2.x
Here's the Postgres SQL for imagecache_update_4() to make it work.
Simply remove the mysql-specific 'after weight' from the SQL. i.e:
<?php
// code for imagecache.install > imagecache_update_4()
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
$ret[] = update_sql("ALTER TABLE {imagecache_action} ADD COLUMN action varchar(255) not null default '' after weight");
case 'pgsql':
// @todo: pgsql updates. DONE
$ret[] = update_sql("ALTER TABLE {imagecache_action} ADD COLUMN action varchar(255) not null default ''");
break;
}
?>
tested and works for me :-)
thanks for the great module by the way, absolutely essential stuff. nicely done!
Comment | File | Size | Author |
---|---|---|---|
#4 | imagecache_294538.patch | 743 bytes | drewish |
Comments
Comment #1
davidwhthomas CreditAttribution: davidwhthomas commentedFor the search engines ;-)
Postgres fix for error:
See above post for solution.
Comment #2
Gompho CreditAttribution: Gompho commentedHas this patch been implemented into the CVS releases of imagecache?
Comment #3
drewish CreditAttribution: drewish commentedGompho, if you see an issue marked fixed you can assume it's been committed.
As this stands it's needs to be converted to a proper patch for review. See http://drupal.org/patch for help on creating one.
Comment #4
drewish CreditAttribution: drewish commentedcommitted the attached to HEAD and DRUPAL-5--2.
Comment #5
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.