Error Running ChatterBotCorpusTrainer Using Postgres Database #2
Description
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.
ALTER TABLE statement ALTER COLUMN text TYPE varchar(1000);
ALTER TABLE 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': ''}]