ntrivilino@alice.it Posted May 13 Posted May 13 I want to upgrade MySQL version 5.7.34-cll-lve to version 8.0.13 and using the InnoDB storage engine, but when i try to upgrade the update and migration procedure on a new server crashes due to a database error: The MySQL server reported an error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<urlset xmlns=\"http://www.sitemaps' at line 1) in response to this request: INSERT INTO 'ibf_core_sitemap' ('data', 'updated', 'sitemap', 'last_id') VALUES (... How can I solve the problem to make the update work? Is there anyone who can help me with the database and the error?
Jim M Posted May 13 Posted May 13 You would need to obtain the full error. Right now, you just have part of it.
DawPi Posted May 14 Posted May 14 I suggest you to truncate that table named ibf_core_sitemap, make the upgrade and rebuild sitemap at the end.
ntrivilino@alice.it Posted May 15 Author Posted May 15 i can delete the table named ibf_core_sitemap without problem?
Randy Calvert Posted May 15 Posted May 15 There is a BIG difference between deleting and truncating a table. A deleted table no longer exists. Truncating means emptying it without removing the table structure. Think of it as throwing everything in a house away instead of burning the entire house down.
ntrivilino@alice.it Posted May 15 Author Posted May 15 in the phpmyadmin of my site i have the "to empty" command, it's correct? thanks
DawPi Posted May 15 Posted May 15 Yep. Anything that deletes the content of the table instead of deleting the table itself. 😉
ntrivilino@alice.it Posted May 20 Author Posted May 20 On 5/15/2024 at 9:50 AM, DawPi said: Yep. Anything that deletes the content of the table instead of deleting the table itself. 😉 ok i'm testing this solution today, tks
ntrivilino@alice.it Posted May 20 Author Posted May 20 not working 😞 or to be precise, a new error now appears my host proposes this: could a solution be to dump and restore the database on the same node? could someone from the Invision staff carry out the operation for a fee? The MySQL server reported an error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1) in response to this request: INSERT INTO 'ibf_core_spam_service_log' ('id', 'log_date', 'log_code', 'log_msg', 'email_address', 'ip_address') VALUES ... i can empty the table ibf_core_spam_service_log ?
Randy Calvert Posted May 20 Posted May 20 (edited) Yes, but if you are having this issue with all of the data in the tables, it sounds like a bigger underlying issue. I might suggest backing up the entire database, removing it, upgrading the server, and then reimporting the export. Otherwise I might suggest hiring a DB expert to perform your DB server upgrade. Edited May 20 by Randy Calvert
Jim M Posted May 20 Posted May 20 33 minutes ago, ntrivilino@alice.it said: could someone from the Invision staff carry out the operation for a fee? I'm afraid, this is not a service we currently offer. Generally, this would be the responsibility of your hosting provider assist with these kind of service.
ntrivilino@alice.it Posted May 20 Author Posted May 20 16 minutes ago, Randy Calvert said: Yes, but if you are having this issue with all of the data in the tables, it sounds like a bigger underlying issue. I might suggest backing up the entire database, removing it, upgrading the server, and then reimporting the export. Otherwise I might suggest hiring a DB expert to perform your DB server upgrade. here is some database expert who could help me and do the job (he gets paid of course)... You Randy?
Randy Calvert Posted May 20 Posted May 20 I’m unfortunately not a good database person. I generally can manage my own stuff, but I don’t work with other’s servers since I don’t want to risk unintended issues from not understanding their specific setup. You might try hitting up the third party resource directory. There are several great folks there who might be able to help. ntrivilino@alice.it 1
Gary Posted May 20 Posted May 20 (edited) Hi @ntrivilino@alice.it, I too cannot assist with the database issue you are getting, but here is a link to the Providers Directory where there may be someone who can assist you. Providers Directory - Invision Community Invision Community does have very knowledgeable individuals who don't mind getting their hands dirty with issues such as these. Send a few of them a private message with a link to this topic and you're bound to have the issue sorted promptly. Edit: I just read your topic in the Design and Customization forum. Best of luck! Edited May 20 by Gary ntrivilino@alice.it 1
Recommended Posts