#Some SQL is using a hardcoded defined user

1 messages · Page 1 of 1 (latest)

fervent jolt
#

[ script:oxmysql] SELECT `id` FROM `phone_instagram_posts` WHERE `id` = ? ["15d91"] [ script:lb-phone] SCRIPT ERROR: Callback 'instagram:createPost' failed: lb-phone was unable to execute a query! [ script:lb-phone] Query: INSERT INTO phone_instagram_posts (id, username, media, caption, location) VALUES (?, ?, ?, ?, ?) [ script:lb-phone] ["15d91","tjmiller","[\"https://r2.fivemanage.com/image/f73ovVFP6DOX.webp\"]","",null] [ script:lb-phone] The user specified as a definer ('admin'@'%') does not exist [ script:lb-phone] > handler (@lb-phone/lib/server/callbacks.lua:49) [ script:lb-phone] > logError (@oxmysql/dist/build.js:25870) [ script:lb-phone] > rawQuery (@oxmysql/dist/build.js:26053) [ script:lb-phone] > processTicksAndRejections (node:internal/process/task_queues:96) [ script:lb-phone]
As you can see here this sql query is trying to use the user admin when our server is setup to use a different user
It appears you have hardcoded this.

#

steps to reproduce

  1. Upgrade to version 2.1.19
  2. make sure your sql server isnt using admin as a definer
  3. try to post to instapic and check server logs
    If i add a user of admin with no password it works but this is not a good workaround as it should use the defined user in the server.cfg
uneven mulch
#

i'm guessing you switched your database from another host or something, and exporeted it

#

that's why you're getting this