PDA

View Full Version : Required Tables


Kiran-E-Sehar
11-24-2013, 08:50 PM
Hello,
I am so tired of fixing the issues my forum have,
so i backed up the database table wise and save them and then just deleted my forum's database and re upload the original files from upload folder and then installed new forum.
now i don't want to restore my entire database i want only necessery tables like users, posts, threads
so could anyone tell me which tables i must have to restore so my previous data will work fine, i don't want to restore old settings i will manage settings again now with new installation

pityocamptes
11-24-2013, 10:06 PM
Whats wrong with the other tables?

--------------- Added 1385334461 at 1385334461 ---------------

I wonder if the IMPEX installer would just pull what is needed? I merged over from phpbb and used the impex importer and did not seem to have too many issues...

Kiran-E-Sehar
11-24-2013, 11:15 PM
i really don't know what is the main issue,
i reinstalled forum more than 10 times tried to upgrade , disabled all of my plugins but still there were too many issues, like problem with login, problem with password recovery problem with redirect,
i checked the settings tried to change settings with many options but still i am getting many database errors

tbworld
11-25-2013, 01:41 AM
My recommendations:

You need to rollback to the backup of your database before you started altering it. Hopefully, you have a backup of your entire system from that point in time.

Tables are interlinked in the database via indexes, IDs and fields. What you have now is a database, with no known state, and most likely is not repairable. Yes, you can alter tables, but you must know the interaction of that table before you alter it.

If your forum data is valuable and you need to put your board back online, then I recommend you hire someone. Unless your database was damaged on a key table, your original problems were probably minor.

Kiran-E-Sehar
11-27-2013, 08:17 PM
well i have done,
but after upgrading i have 1 issue my Remember me option is not working, if i dont use forum 900 seconds i must have to re login even i always selecting remember me

Lynne
11-27-2013, 09:14 PM
Then your cookies are being set correctly.

Kiran-E-Sehar
11-29-2013, 09:45 PM
Lynne i tried to fix cookies, but i could not find the solution,

actually there are 2 problems,
if i open my forum with www user can not login , when they login to forum and click on submit its redirects to home as logged off.

and if i use forum without www login works fine, but its cant keep users logged in, after inactive session ids get logged off :/
please help me to solve this

Lynne
11-29-2013, 09:47 PM
Since you allow users to login to your site via both http://www.yoursite.com and just yoursite.com, then you MUST have your cookie domain (AdminCP > Settings > Options > Cookies and HTTP Header Options > Cookie Domain) set to ".yoursite.com" (no quotes, but note the period at the beginning) or your users will have problems.