Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error Running ChatterBotCorpusTrainer Using Postgres Database #2

Open
ramonmalcolm10 opened this issue Apr 16, 2023 · 0 comments
Open

Comments

@ramonmalcolm10
Copy link

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': ''}]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant