MySQL Column Info Error

[simone-frontdev]

Hi, when i try to do columnInfo() for a table its throw a errror like this:

const result = await inspector.columnInfo('posts') console.log(result)

(node:19210) UnhandledPromiseRejectionWarning: Error: ER_BAD_FIELD_ERROR: Unknown column 'c.GENERATION_EXPRESSION' in 'field list'
    at Query.Sequence._packetToError (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/Users/simonedellefave/Personal/react-express-crud-generator/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (events.js:400:28)
    at Socket.emit (domain.js:475:12)

I'm using a MySQL 5.5.62 What can i do?

[rijkvanzanten]

@simonedellefave-dev Generated columns where introduced in MySQL 5.7, which means the inspector doesn't currently support MySQL versions older than 5.7.

MySQL 5.5 came out 12 years ago (!!). I would highly recommend updating to a more modern version regardless of schema inspector support

[simone-frontdev]

😄 Thank you very much! I'll upgrade to a modern version