Hi,

I am having an issue on uddeim pages.

When i try to send a message (same for my users) this message appears and we have to create the message from the star :

The page you are looking for can't be found
Error 1213 - Deadlock found when trying to get lock; try restarting transaction

It only appears on UDDEIM pages.

This is really disturbing and appearing more and more.

What caused this please? how can i make it not appearing anymore ?

Thank you for your help.

PS : I also have another error with "totrashoutbox"- I have added screencapture for this one.

Very strange. I have no idea why this error appears. How many users does your site have?

Hi,
thank you for your answer.

I have more thank 50 000 members using uddeim but not 50 000 a day.

What could cause this please? Uddeim is a huge part of my site and i can't do without it but with those errors, it became a real problem for me.

Thank you for your help.

Well, I googled for this error and found several entries related with the InnoDB engine.

stackoverflow.com/questions/2596005/working-around-mysql-error-deadlock-found-when-trying-to-get-lock-try-restarti

The solution to use try/catch statements is not practical since it requires to touch a lot of code. I recommend to switch the engine back to MyISAM.

The mysql manual gives some warnings about InnoDB:
dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
To switch the engine:
dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html