Can anyone help me in my SQL database problematic lines

  • Resolved coolshri

    (@coolshri)


    3 months ago

     “Can you help me rewrite or remove the SQL commands that require advanced privileges, so I can import this database on shared hosting?”

    i am providing you the chatgpt link where chatgpt resolved the issue but i dont know how to fix that issue in my database file 🥺

    if someone will help me i will be very grateful for you.

    my mail id is [redacted – please all replies should be in the forum.]

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator threadi

    (@threadi)

    3 months ago

    If you need personal assistance with your issue, I would recommend looking here: https://jobs.wordpress.net

    If you want help here in the forum, we would need to know:

    • What kind of file is it?
    • Where did you get it? Who or which plugin created it for you?
    • What exactly is the problem when using it? What error message do you see when you do exactly what?
    Thread Starter coolshri

    (@coolshri)

    3 months ago

    wordpress database backup file which i have to import on phpMyAdmin but while importing it shows some error in sql.

    it shows following error while importing – “/*!50001 CREATE ALGORITHM=UNDEFINED *//*!50013 DEFINER=u542790455_65bcd8b97f633@localhost SQL SECURITY DEFINER *//*!50001 VIEW wper_wsm_bounceVisits ASselect wper_wsm_pageViews.visitId AS visitId, wper_wsm_pageViews.visitLastActionTime AS visitLastActionTimefrom wper_wsm_pageViewsgroup by wper_wsm_pageViews.visitIdhaving count(wper_wsm_pageViews.URLId) = 1 */;”

    i just want to replace this wordpress database with correct lines which chatgpt suggest are – “CREATE VIEW wper_wsm_bounceVisits ASSELECT wper_wsm_pageViews.visitId AS visitId, wper_wsm_pageViews.visitLastActionTime AS visitLastActionTimeFROM wper_wsm_pageViewsGROUP BY wper_wsm_pageViews.visitIdHAVING COUNT(wper_wsm_pageViews.URLId) = 1;”

    but I don’t know how to replace this code in my .sql.gz file. If anyone can help me i will be very grateful for you 🙏🏻

    • This reply was modified 3 months ago by coolshri.
    Moderator threadi

    (@threadi)

    3 months ago

    How did you create this “WordPress database backup”?

    To execute “CREATE VIEW” in SQL, you need the appropriate rights for the SQL user. These are usually always available for views. You should contact your host’s support team to obtain the missing permissions. This means you won’t have to make any adjustments to the file.

    Thread Starter coolshri

    (@coolshri)

    3 months ago

    i got that backup from my hosting provider. They tried but they’re unable to fix this they said contact on wordpress for this issue. They said some plugin are causing these problems so contact wordpress they were tried from their side but they’re unable to fix.

    Please help me because due to this issue my website is offline since 2 days.

    Moderator threadi

    (@threadi)

    3 months ago

    The message regarding the import of a SQL-file has nothing to do with WordPress plugins. An SQL file is a backup of your database. You have to import it into your hosting to set up or restore the database there. I’m not entirely sure what the problem is in your case – I don’t think it’s the SQL file. To import it, your host would have to grant you the above permissions. No one here in the forum can help you with that.

    If you urgently need personal assistance, try the following link, as mentioned above: https://jobs.wordpress.net

    Thread Starter coolshri

    (@coolshri)

    3 months ago

    how to share the error screenshot here?

    after viewing the screenshot you will be able to understand the problem.

    Thread Starter coolshri

    (@coolshri)

    3 months ago

    thank you soo much for your advice

    i asked for the older backup file to the hosting provider and that worked 🤞🏻😊

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Tags