PDA

View Full Version : DATABASE error


Kiran-E-Sehar
02-17-2012, 06:29 AM
Hi

since i reinstall my forum on my own new server and uploade database its works fine for me on the spot
but after a few hours when i visited the forum i saw there is database error

then i go to phpmyadmin and tried to repair table
and there was this error "note : The storage engine for the table doesn't support check" on almost 12 tables

please guide me how to fix this error

thanks in advance

Lynne
02-17-2012, 04:38 PM
What is the exact database error you are getting?

Kiran-E-Sehar
02-18-2012, 11:50 PM
when i tried to repair database i found this
apipost
note : The storage engine for the table doesn't support repair

autosave
note : The storage engine for the table doesn't support repair

cpsession
note : The storage engine for the table doesn't support repair

this error is coming on almost 12 tables

and

1)

When some one reply in a post the post showed as empty then he must have to edit and after edit and entering the data its shows normaly

2) When user login id its not redirecting correctly . it show invalid redirect

3) chek the attachment

Kiran-E-Sehar
02-18-2012, 11:52 PM
and now getting one more problem

when i login to forum its done and page shows you have successfully login but after this its shows main page but id not signed in :(

ForceHSS
02-19-2012, 12:55 AM
check url settings in options and make a htaccess file to stop members going to the wrong one

--------------- Added 1329616842 at 1329616842 ---------------

as to your screenshot go to admincp/options/Message Posting and Editing Options/Minimum Characters Per Post make sure it is not blank

--------------- Added 1329616991 at 1329616991 ---------------

Maximum Characters Per Thread/Post Title = 85

Lynne
02-19-2012, 03:48 AM
What tables are getting that error? Most tables should be repairable, and the others are usually memory tables which you may just truncate.

Kiran-E-Sehar
02-19-2012, 07:22 AM
these tables

apipost
autosave
cpsession
dbtech_status_category
dbtech_status_mood
iwt_chat_updatestream
iwt_chatroom_chatting
mysmiliesvb
quotedatanew
session
tag_proposition
vsa_birthdaythread

and i cant login to admin panel its redirects as unsigned

Kiran-E-Sehar
02-20-2012, 01:57 PM
any one here?

ForceHSS
02-21-2012, 04:16 AM
disable custom plugins from config see if that helps as most of them tables are from custom plugins

Kiran-E-Sehar
02-21-2012, 07:06 AM
i already disabled hooks


but still getting many errors :(

when some one reply to a post it shows this page which i attached
but when its redirects post shows empty

socialteenz
02-21-2012, 07:54 AM
Then try disabling all the products from the admincp too!!

Kiran-E-Sehar
02-21-2012, 08:18 AM
stillllll sameeeee problemmmmmmmmmm

gsmlover4u
02-21-2012, 08:57 AM
dear what is your forum link

Kiran-E-Sehar
02-21-2012, 09:30 AM
<a href="http://www.forum.kiran-e-sehar.com" target="_blank">www.forum.kiran-e-sehar.com</a>

Lautaro
02-21-2012, 10:19 AM
Okay,

I got your server IP and got here http://184.107.180.3/
You have a "mysql" folder there with a mysqldumper connected to your forum's database with NO PROTECTION.

I secured that folder for you so nobody else has access, also I sent you the user and pass to access that folder by PM so you can change it to whatever you want. Someone with bad intentions could've stole your database and deleted it. You need to be more careful with security.

As far as I can tell, you have your own vps/dedicated server with cpanel installed or a shared hosting with cpanel and dedicated ip. If you have a vps/dedicated server the problems you have could be because of a bad configuration of apache/php.

If you need help with this I can help you, but not with cpanel. I would be able to help you do a fresh install in your server and using WEBMIN, installing apache/php/mysql and everything you need to have your forum working and SECURE. Let me know if you need help with this.

gsmlover4u
02-21-2012, 10:50 AM
also redirect your domain to forum

Lynne
02-21-2012, 06:49 PM
i already disabled hooks


but still getting many errors :(

when some one reply to a post it shows this page which i attached
but when its redirects post shows empty
posts showing up empty? This sounds like you are running PCRE 8.21 which has a bug - http://bugs.exim.org/show_bug.cgi?id=1187. You will need to contact your host and have them downgrade to PCRE version 8.20. Or, alternately, if you have server access, you may see this thread about steps to take - http://forums.cpanel.net/f5/need-downgrade-pcre-8-21-8-20-a-257991.html