Too long post_checksum 1 550 000 chars - unable to import DB

[Kamahl19]

I am working on one board and I need to move the DB to my localhost. However I cant import DB using my phpmyadmin or bigdump, it gives me an error because post_checksum has abotut 1 550 000 chars. How is this possible?

[AmigoJack]

post_checksum has abotut 1 550 000 chars

Of course this makes no sense, sounds like your import data is corrupt.

Since you wouldn't have created a topic if you'd be able to check the data yourself to locate the issued query and correct it: what do you want now?

(I suspect you have one big .sql file)

[Kamahl19]

Moreover, many posts have post_checksum like this. I have really no idea how could this happen. Well, now I need a solution because I am unable to do anything with the DB. Could I somehow iterate through all posts and generate their new checksum?

[Oyabun1]

Compare your /posting.php file with a standard one, particularly the lines following:

Code: Select all

    // Grab md5 'checksum' of new message 

[Kamahl19]

I already checked that, also functions_posting.php . Both are fine, from version 3.0.11 with some standard MODs like Stargate Portal, NV Gallery and few more.

[Kamahl19]

Any ideas? Do you think I can generate new post_checksum for all posts ?

[AmigoJack]

1. Is it an .sql file? Why not search and replacing all "too long" values with empty ones?
2. How does the source look like? Does the *_posts table really contain the very same values or could it be an improper export?
3. The "checksum" only exists for detecting post edit race conditions. Reconstructing it only means to hash the message text with MD5.

[Kamahl19]

Yes I already find out. I dont know why but exported did that. Thanks