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

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

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

Post by Kamahl19 » Tue Nov 05, 2013 9:14 pm

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?

User avatar
AmigoJack
Registered User
Posts: 5570
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by AmigoJack » Wed Nov 06, 2013 9:21 am

Kamahl19 wrote: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)
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by Kamahl19 » Wed Nov 06, 2013 10:30 am

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?

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by Oyabun1 » Wed Nov 06, 2013 10:50 am

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

Code: Select all

    // Grab md5 'checksum' of new message 
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by Kamahl19 » Wed Nov 06, 2013 1:15 pm

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.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by Kamahl19 » Fri Nov 08, 2013 8:10 pm

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

User avatar
AmigoJack
Registered User
Posts: 5570
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by AmigoJack » Fri Nov 08, 2013 9:56 pm

  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.
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
Kamahl19
Registered User
Posts: 1598
Joined: Tue Nov 06, 2007 3:33 pm
Location: Slovakia
Name: Martin
Contact:

Re: Too long post_checksum 1 550 000 chars - unable to impor

Post by Kamahl19 » Fri Nov 08, 2013 11:34 pm

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

Locked

Return to “[3.0.x] Support Forum”