You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Getting the following value too long for type character varying(255) while training the bot using Postgres database. The tables are automatically created, is there a way to extend the column length? As a work around I execute the following script to increase the column length.
ALTERTABLE statement ALTER COLUMN text TYPE varchar(1000);
ALTERTABLE statement ALTER COLUMN search_text TYPE varchar(1000);
[SQL: INSERT INTO statement (text, search_text, conversation, created_at, in_response_to, search_in_response_to, persona) VALUES (%(text)s, %(search_text)s, %(conversation)s, %(created_at)s, %(in_response_to)s, %(search_in_response_to)s, %(persona)s) RETURNING statement.id]
[parameters: {'text': "Mahatma Gandhi, as you know, walked barefoot his whole life, which created an impressive set of calluses on his feet. He also ate very little, which ... (29 characters truncated) ... odd diet, he suffered from very bad breath. This made him ... what? (this is so bad it's good...) a super-callused fragile mystic hexed by halitosis.", 'search_text': 'PROPN:gandhi PROPN:know VERB:walk VERB:barefoot ADV:life NOUN:create VERB:impressive ADJ:set NOUN:callus NOUN:foot NOUN:eat VERB:little ADJ:frail VERB:odd ADJ:diet NOUN:suffer VERB:bad ADJ:breath NOUN:bad ADJ:good ADJ:super ADJ:callus VERB:fragile ADJ:mystic NOUN:hex VERB:halitosis', 'conversation': 'training', 'created_at': datetime.datetime(2023, 4, 16, 15, 39, 14, 819368, tzinfo=), 'in_response_to': 'Tell me a joke', 'search_in_response_to': 'VERB:joke', 'persona': ''}]
The text was updated successfully, but these errors were encountered:
Getting the following
value too long for type character varying(255)
while training the bot using Postgres database. The tables are automatically created, is there a way to extend the column length? As a work around I execute the following script to increase the column length.[SQL: INSERT INTO statement (text, search_text, conversation, created_at, in_response_to, search_in_response_to, persona) VALUES (%(text)s, %(search_text)s, %(conversation)s, %(created_at)s, %(in_response_to)s, %(search_in_response_to)s, %(persona)s) RETURNING statement.id]
[parameters: {'text': "Mahatma Gandhi, as you know, walked barefoot his whole life, which created an impressive set of calluses on his feet. He also ate very little, which ... (29 characters truncated) ... odd diet, he suffered from very bad breath. This made him ... what? (this is so bad it's good...) a super-callused fragile mystic hexed by halitosis.", 'search_text': 'PROPN:gandhi PROPN:know VERB:walk VERB:barefoot ADV:life NOUN:create VERB:impressive ADJ:set NOUN:callus NOUN:foot NOUN:eat VERB:little ADJ:frail VERB:odd ADJ:diet NOUN:suffer VERB:bad ADJ:breath NOUN:bad ADJ:good ADJ:super ADJ:callus VERB:fragile ADJ:mystic NOUN:hex VERB:halitosis', 'conversation': 'training', 'created_at': datetime.datetime(2023, 4, 16, 15, 39, 14, 819368, tzinfo=), 'in_response_to': 'Tell me a joke', 'search_in_response_to': 'VERB:joke', 'persona': ''}]
The text was updated successfully, but these errors were encountered: