PAYONE-GmbH/oxid-6

ADD COLUMN `OXTIMESTAMP` missing from migrations for fcpocheckedaddresses

Closed this issue · 2 comments

Found another issue with the migrations in 1.6.2:

self::copyDataFromOldColumnIfExists('fcpocheckedaddresses', 'fcpo_checkdate', 'OXTIMESTAMP', self::$sQueryFcpocheckedaddressesCopyTimestampData);

In this line the data from fcpo_checkdate gets copied to OXTIMESTAMP for the fcpocheckedaddresses table. But earlier in the migration this OXTIMESTAMP column never gets added. It's only in the CREATE TABLE, but if you migrate from an earlier version where the table already exists without OXTIMESTAMP it gets not created and therefore the copying e.t.c. does not work.

I had to create the column manually and deactivate and activate the module again for this to work.

But there are many other differences between the tables for version 1.3.2 to 1.6.2. Is there a migration script?

stale commented

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.