Problem after transfering forum to new server

[rulaman]

Hello!

My smf 1.1.4 forum was transfered from a Linux Confixx 3 system to a Linux Plesk 8.2 system.

Now I have the problem, that i cannot delete any messages in forum. I always get an empty page after deleting, and after reloading forum, the "deleted" message is still there...

Can anyone help me please?

Thanks....

[Kindred]

sounds like you should check your database information.

Please run repair_settings.php and make sure everything is pointing to your NEW server.

[rulaman]

Thanks for your help, but i get
"Not Found
The requested document was not found on this server. "

when trying this.....

??

[H]

Double check that you uploaded repair_settings.php to the right location and that you're typing the right location in your browser

[rulaman]

Hi !

Thank you very much for your help !

Ok, now i have "repair_settings.php" installed, but when i start this tool, i get this message:

"Some settings are not being shown because the MySQL connection information is incorrect."

I really don't know why the MySQL information should be incorrect...?

I put all neccesary information (paths etc...)  into the tool, and started it, but all is same after that.

Everything works fine: I can read all messages, i can watch my gallery, but: i can't delete any thread in my forum. I always get an empty page when deleting a thread. And when i reload my forum, the thread is still there.
But deleting a single message in a thread, works fine...

Well... i am no database specialist, but all other MySQL databases work fine after that server transfer...

What am i doing wrong?

Thank you very much for your help!!!

greetings
rulaman

[Kindred]

it is not connecting to you smf database...   

at this point, it has nothing to do with paths, and everything to do with the mySQL connection.

[rulaman]

it is not connecting to you smf database...   

So what can i do yet....


Could you please give me some help with my forum, i am really frustated now.


Is it a server or a Plesk Problem???
You can watch my forum here: http://quake3.spiralnebula.net/forum/index.php [nofollow]


thanks

[Kindred]

unfortunately I am at the office right now and can not connect directly to your system to confirm settings.

Either one of the other staff can help you, or you can PM me login information for your site and I will help you when I get home this evening (about 10 hours)

[rulaman]

Hi again !

Many thanks to your support forum, i found the problem here and solved it!

Reason was this:

http://www.simplemachines.org/community/index.php?topic=63232.0

Simon,

I've fixed it, but I think this *may* actually be a bug with the MySQL you are running. I basically worked around it. It was actually an attachments query which was failing. Whenever using WHERE attachmentType = in the query, it lost connection to the server. I fixed it by changing these lines in RemoveTopic.php:

Code Select Expand


removeAttachments('a.attachmentType = '0' AND m.ID_TOPIC ' . $condition, 'messages');


To:

Code Select Expand


removeAttachments('a.attachmentType = \'0\' AND m.ID_TOPIC ' . $condition, 'messages');


However, that should NOT be needed, it's effectively casting the 0 as a string, although attachmentType is an integer - very, very odd.

Grudge

EDIT:  You need to make these changes to Post.php file.
Find a.attachmentType = 0
Replace a.attachmentType = \'0\'

greetings
rulaman