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 6009 Jun 30, 2021, 1:31 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5901 Jun 30, 2021, 10:56 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5906 Jun 30, 2021, 11:31 PM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5896 Jun 30, 2021, 11:49 PM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5892 Jul 1, 2021, 12:13 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5878 Jul 1, 2021, 1:33 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5888 Jul 1, 2021, 1:51 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5879 Jul 1, 2021, 2:13 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5875 Jul 1, 2021, 2:49 AM
Thread Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5870 Jul 1, 2021, 4:12 AM
Thread Re: [VishalT] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
Andy 5861 Jul 1, 2021, 5:24 AM
Post Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5851 Jul 1, 2021, 5:25 AM
Post Re: [Andy] [HELP] : Failed to execute query: 'ALTER TABLE glinks_Category CHANGE
VishalT 5880 Jul 1, 2021, 1:32 AM