XF 2.2 Server error

[Yunus88]

Why is this server error happening?

 

[Mike]

Whats the full stack trace?

 

[Yunus88]

Whats the full stack trace?

I don't know where it is looked at.

 

[Paul B]

Click on the blue error title to see the full stack trace.

 

[Yunus88]

 

[Mike]

I'm not really sure why this would be happening. Haven't you changed anything on the server recently or restored from a backup? If you've upgraded XF (based on other threads), I'd run a file health check to ensure all files are in the correct state. Beyond that, if you did a DB restore, I could see something not being done correctly with that which has corrupted some binary data in the DB. If that's the case, you may want to check the process you're taking.

Regardless, Issuect the only workaround would be to empty the contents of the xf_mail_queue table.

 

[Yunus88]

I'm not really sure why this would be happening. Haven't you changed anything on the server recently or restored from a backup? If you've upgraded XF (based on other threads), I'd run a file health check to ensure all files are in the correct state. Beyond that, if you did a DB restore, I could see something not being done correctly with that which has corrupted some binary data in the DB. If that's the case, you may want to check the process you're taking.

Regardless, Issuect the only workaround would be to empty the contents of the xf_mail_queue table.

Yes I changed it. I switched to utf8mb4_general_ci.

 

[Yunus88]

Regardless, Issuect the only workaround would be to empty the contents of the xf_mail_queue table.

How do I do this?

 

[Masetrix]

How do I do this?

SQL Truncate Table

Discover the SQL TRUNCATE TABLE command to quickly remove all data from a table without affecting its schema.

www.tutorialspoint.com

PhpMyAdmin -> console

truncate table xf_mail_queue;

 

[Yunus88]

SQL Truncate Table

Discover the SQL TRUNCATE TABLE command to quickly remove all data from a table without affecting its schema.

www.tutorialspoint.com

PhpMyAdmin -> console

truncate table xf_mail_queue;

Is there any harm in doing this?

 

[Yunus88]

Regardless, Issuect the only workaround would be to empty the contents of the xf_mail_queue table.

PhpMyAdmin -> console

truncate table xf_mail_queue;

Do I need to write this to SQL?

 

[Masetrix]

Do I need to write this to SQL?

Yes

 

[Yunus88]

Yes

This code will empty the xf_mail_queue table, right? I hope there is no problem.

 

[Masetrix]

This code will empty the xf_mail_queue table, right? I hope there is no problem.

This command clears the whole table.
This is also not a problem. You should always create a backup of the database beforehand so that you can restore the database with this table later in the event of problems or errors.

 

[Yunus88]

Solved. Thank you.

 

[Deleted member 184953]

same problem here, resolved by the same way.