Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.