ibf_core database error

[ntrivilino@alice.it]

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]

You would need to obtain the full error. Right now, you just have part of it.

[ntrivilino@alice.it]

OK I have requested the full error report

[DawPi]

I suggest you to truncate that table named ibf_core_sitemap, make the upgrade and rebuild sitemap at the end.

[ntrivilino@alice.it]

i can delete the table named ibf_core_sitemap without problem?

[Randy Calvert]

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]

in the phpmyadmin of my  site i have the "to empty" command, it's correct? thanks

[DawPi]

Yep. Anything that deletes the content of the table instead of deleting the table itself. 😉

[ntrivilino@alice.it]

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]

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]

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]

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]

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]

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. 

[Gary]

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