When performing the database update to the 6.x-2.x-dev version i get the following error for every location value being inseted in the database. It creates the table and columns ok but will not populate with data.

The format here just doesn't look right, seems to have the corrent data formatted incorrectly for an insert,

'a:10:{s:3:\"gmt\";i:9;s:3:\"dst\";i:0;s:5:\"s_mon\";i:0;s:5:\"s_nth\";i:0;s:5:\"s_dow\";i:0;s:6:\"s_time\";i:0;s:5:\"e_mon\";i:0;s:5:\"e_nth\";i:0;s:5:\"e_dow\";i:0;s:6:\"e_time\";i:0;}'

Any ideas?

user warning: Unknown column 'values' in 'field list' query: INSERT INTO worldclock_locations (`name`, `values`) VALUES ('Korea', 'a:10:{s:3:\"gmt\";i:9;s:3:\"dst\";i:0;s:5:\"s_mon\";i:0;s:5:\"s_nth\";i:0;s:5:\"s_dow\";i:0;s:6:\"s_time\";i:0;s:5:\"e_mon\";i:0;s:5:\"e_nth\";i:0;s:5:\"e_dow\";i:0;s:6:\"e_time\";i:0;}') in /media/media/webpagestuff/apache_htdocs/drupal/sites/all/modules/worldclock/worldclock.install on line 277.

Comments

flevour’s picture

flevour commented
Status: Active » Postponed

I am not providing an upgrade path for the moment, so you'll need to make a fresh install of the module. I wanted to try a new db schema with a more compact approach, we'll see if it eventually pays out.
Sorry for the bother,
Francesco