can't find username/email...

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Mick
Support Team Member
Support Team Member
Posts: 23055
Joined: Fri Aug 29, 2008 9:49 am

Re: can't find username/email...

Post by Mick »

runehints wrote:Forums got pruned, and as I was looking through to restore the database, I deleted the backup. The next oldest backup is 2 years old.
You're saying the latest db backup you have is two years old :?:
"The more connected we get the more alone we become" - Kyle Broflovski©
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

Yes.

I therefore merged 2 databases together...

I merged just the posts and topics tables. making sure that nothing overlapped. Which has successfully worked, however, this has also not worked due the recent posts not showing up on the main index page. We are missing about 25 topics, but thats nothing.
User avatar
Lumpy Burgertushie
Registered User
Posts: 68551
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: can't find username/email...

Post by Lumpy Burgertushie »

there ya go. you can't just merge only those tables.

all of the tables are interconnected.

you have forums, topics, posts, all with IDs etc. etc.

you then have the users that posted the posts and what authorizations they have and what groups they belong to , etc. etc. etc.


I think your attempt at merging has caused all these problems.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

we have, same users who post posting, so that dosen't matter.

We have same forums although they are parented, should that matter?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51883
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: can't find username/email...

Post by stevemaury »

It all matters. Either the poster in your previous topic misunderstood what you were trying to do, or you got bad advice.

IF the forum arrangement was exactly the same in the two databases it may be possible to salvage this. The problem is going to be that you may have users who posted in the past but are no longer users.

Anyway, if you still have both backups, you may be able to salvage this. Tell me EXACTLY what you did in your merge attempt and tell me the size of the 2 .sql files.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

Hello

MY sql files are still backed up... Not that stupid...

However....

I know this sounds strange, 1 forum has partents and sub forums. The other dose not.
Our new user count has not increast by much, those who did, did not post, those who did posted 1 or 2 posts.
Our Backup sql had 55,000 posts.
Our pruned sql has 18,000 posts - only 2,000 posts new
Since we upgraded to phpbb3, our users have left. Not sure why...

1 sql has 16.9MB
other sql has 23.2MB.
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

What I should of said,

Total merged topics 6423
total merged posts 57388

I moved the newer topics to the older database. Would this matter?
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

What should I do?

If i post, the recent posts show on the index...
runehints
Registered User
Posts: 328
Joined: Tue Dec 14, 2004 9:00 pm

Re: can't find username/email...

Post by runehints »

any ideas?
Locked

Return to “[3.0.x] Support Forum”