Hi,

When I update as described in title field, this error occurs:

user warning: Duplicate column name 'page_info' query: ALTER TABLE contact ADD `page_info` LONGTEXT DEFAULT NULL in /<my_path>/includes/database.mysql-common.inc on line 298.

Comments

behindthepage’s picture

behindthepage CreditAttribution: behindthepage commented

Hi Alex72RM,

Thanks for this bug report. You will have no problems with your installation from now on. The problem occurred because 1.9 added the extra column and 1.12 tried to do the same in it's update. I will have to correct that.

regards
Geoff

Alex72RM’s picture

Alex72RM CreditAttribution: Alex72RM commented

Yes, I noticed that I need only to alter the dimension of page_info column: from 'text' to 'longtext'

behindthepage’s picture

behindthepage CreditAttribution: behindthepage commented
Status: Active » Closed (fixed)
Summit’s picture

Summit CreditAttribution: Summit commented
Version: 6.x-1.12 » 6.x-1.13
Status: Closed (fixed) » Active

Hi,
Sorry but I think I have to set this to active again and to 6.13.
The same occured with my update to 6.13 I think. Is it because it is friday the 13th:)

Update error:

Failed: ALTER TABLE {contact} ADD `page_info` LONGTEXT DEFAULT NULL

Do I have to go into my database and change dimension of page_info column: from 'text' to 'longtext' manually?

Greetings, Martijn

behindthepage’s picture

behindthepage CreditAttribution: behindthepage commented

Hi Martijn,

The reason this has failed is because it has already been done when the module was installed.
I will add an if column exists do nothing in the update script.

Regards
Geoff

behindthepage’s picture

behindthepage CreditAttribution: behindthepage commented
Status: Active » Closed (fixed)

This is fixed in Vers 6.x-1.14