ptrumpis / snap-camera-server

An alternative, self-hosted solution that allows you to continue using Snap Camera with all Snapchat filters after its shutdown on January 25, 2023.
https://github.com/snapcamera
MIT License
351 stars 44 forks source link

Adding migration for missing 'custom_import' column. #160

Open ygabo opened 4 months ago

ygabo commented 4 months ago

Getting some errors when starting up the mysql server.

Error: Unknown column 'custom_import' in 'field list' webapp-1 | at Packet.asError (/usr/src/app/node_modules/mysql2/lib/packets/packet.js:738:17) webapp-1 | at Query.execute (/usr/src/app/node_modules/mysql2/lib/commands/command.js:29:26) webapp-1 | at PoolConnection.handlePacket (/usr/src/app/node_modules/mysql2/lib/connection.js:481:34) webapp-1 | at PacketParser.onPacket (/usr/src/app/node_modules/mysql2/lib/connection.js:97:12) webapp-1 | at PacketParser.executeStart (/usr/src/app/node_modules/mysql2/lib/packet_parser.js:75:16) webapp-1 | at Socket. (/usr/src/app/node_modules/mysql2/lib/connection.js:104:25) webapp-1 | at Socket.emit (node:events:513:28) webapp-1 | at addChunk (node:internal/streams/readable:315:12) webapp-1 | at readableAddChunk (node:internal/streams/readable:289:9) webapp-1 | at Socket.Readable.push (node:internal/streams/readable:228:10) webapp-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { webapp-1 | code: 'ER_BAD_FIELD_ERROR', webapp-1 | errno: 1054, webapp-1 | sqlState: '42S22', webapp-1 | sqlMessage: "Unknown column 'custom_import' in 'field list'", webapp-1 | sql: "INSERT INTO lenses SET unlockable_id = '36899040876', uuid = '6ea585588cd04078ab59058dbf64580b', ... , obfuscated_user_slug = 'zNY45R4zBSahj3Iqg3u8aA', image_sequence = '{}', web_import = 0, custom_import = 0"

Added the migration files to create the column into the 'lenses' and 'unlocks' tables.