Error starting Ghost

Developer help
1

I’ve this error when installing ghost:

]: {
Aug 19 02:05:12 instance-1 node[10480]: message: {
Aug 19 02:05:12 instance-1 node[10480]: statusCode: 500,
Aug 19 02:05:12 instance-1 node[10480]: errorType: ‘MigrationScriptError’,
Aug 19 02:05:12 instance-1 node[10480]: level: ‘normal’,
Aug 19 02:05:12 instance-1 node[10480]: message: ‘Field length of customer_id in members_stripe_customers is too long!’,
Aug 19 02:05:12 instance-1 node[10480]: id: 300,
Aug 19 02:05:12 instance-1 node[10480]: context: ‘This usually happens if your database encoding is utf8mb4.\n’ +
Aug 19 02:05:12 instance-1 node[10480]: ‘All unique fields and indexes must be lower than 191 characters.\n’ +
Aug 19 02:05:12 instance-1 node[10480]: ‘Please correct your field length and reset your database with knex-migrator reset.\n’,

how to fix this please?

OS: debian 10, Ver 15.1 Distrib 10.1.45-MariaDB

Thanks

2

It is solved. Just need to change the table column to varchar (191)

3

Hey @proson1 could you please add more details about how you got into this state? The designed field length for members_stripe_customers.member_id field is varchar (255), so fair warning it’s not recommended to change it’s length.

I’m assuming the reason for the error is not officially supported 10.1.45-MariaDB. Don’t know all the quirks of that version but would suggest looking into changing default encoding to same as MySQL 5.7 as the error message suggests above.