Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

[HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE

Quote Reply
[HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Hello,

I thought I was doing this right, however perhaps not. Can you please help me with this?

Ideally I am wanting to set 'index' as default condition for category-field-property 'seo-index' , as based on this value, I will dynamically add index and noindex tags in the page header.

However when I try to use ENUM property & set index as default, it is giving me following error:

Failed to execute query: 'ALTER TABLE glinks_Category CHANGE seo_index seo_index ENUM('index','noindex') DEFAULT 'index' NOT NULL': Data truncated for column 'seo_index' at row 1

I have attached screen-shot for reference purposes.

Thanks.

Vishal
-------------------------------------------------------

Last edited by:

VishalT: Jun 30, 2021, 1:32 AM
Subject Author Views Date
Thread [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE VishalT 5787 Jun 30, 2021, 1:31 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5679 Jun 30, 2021, 10:56 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5686 Jun 30, 2021, 11:31 PM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5676 Jun 30, 2021, 11:49 PM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5671 Jul 1, 2021, 12:13 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5657 Jul 1, 2021, 1:33 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5667 Jul 1, 2021, 1:51 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5657 Jul 1, 2021, 2:13 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5653 Jul 1, 2021, 2:49 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5648 Jul 1, 2021, 4:12 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5640 Jul 1, 2021, 5:24 AM
Post Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5629 Jul 1, 2021, 5:25 AM
Post Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5660 Jul 1, 2021, 1:32 AM