HELP! Big problems Site is down

[PetrolheadsNW]

As above

 

My index.php file got corrupted last night, I put a thread up here but no-one came to my rescue. As our website is our primary source of income, this morning I took drastic measures. Via the /admin panel I attempted to restore a backup from wednesday by choosing /backup/restore menu. I selected the date of the file I wanted to restore the clicked restore. whilst restore was in progress, I was greeted with a message about one of my products and some SQL data which is corrupt. The restore completed but when I tried to access our site it was still down and when I tried to go back into the /admin control panel this no longer worked either. I still have access to cpanel but what can I do to get our site back on line.

 

The message when attempting to enter /admin module reads:

1146 - Table 'head_osc1.sessions' doesn't exist

 

select value from sessions where sesskey = 'e9469c2a650ca8a21f0b068cd9cd041c' and expiry > '1122630801'

 

[TEP STOP]

 

The message when attempting to enter our site now reads:

1146 - Table 'head_osc1.sessions' doesn't exist

 

select value from sessions where sesskey = '2fc32bd942493afe811ab273ecf656b0' and expiry > '1122630897'

 

[TEP STOP]

 

Please could someone HELP!

 

Our site name is "WWW.PETROLHEADSNW.COM"

 

Would i of lost all our products and customer info by attempting restore?

[boxtel]

As above

 

My index.php file got corrupted last night, I put a thread up here but no-one came to my rescue. As our website is our primary source of income, this morning I took drastic measures. Via the /admin panel I attempted to restore a backup from wednesday by choosing /backup/restore menu. I selected the date of the file I wanted to restore the clicked restore. whilst restore was in progress, I was greeted with a message about one of my products and some SQL data which is corrupt. The restore completed but when I tried to access our site it was still down and when I tried to go back into the /admin control panel this no longer worked either. I still have access to cpanel but what can I do to get our site back on line.

 

The message when attempting to enter /admin module reads:

1146 - Table 'head_osc1.sessions' doesn't exist

 

select value from sessions where sesskey = 'e9469c2a650ca8a21f0b068cd9cd041c' and expiry > '1122630801'

 

[TEP STOP]

 

The message when attempting to enter our site now reads:

1146 - Table 'head_osc1.sessions' doesn't exist

 

select value from sessions where sesskey = '2fc32bd942493afe811ab273ecf656b0' and expiry > '1122630897'

 

[TEP STOP]

 

Please could someone HELP!

 

Our site name is "WWW.PETROLHEADSNW.COM"

 

Would i of lost all our products and customer info by attempting restore?

<{POST_SNAPBACK}>

 

well, the restore did not go well as you seem to be missing several tables.

[PetrolheadsNW]

well, the restore did not go well as you seem to be missing several tables.

<{POST_SNAPBACK}>

 

I can i restore it now that I cannot access the/Admin module?. I only have access to the Cpanel atm

[boxtel]

I can i restore it now that I cannot access the/Admin module?. I only have access to the Cpanel atm

<{POST_SNAPBACK}>

 

you use PhpMyAdmin to recreate / import your backup file.

[PetrolheadsNW]

you use PhpMyAdmin to recreate / import your backup file.

<{POST_SNAPBACK}>

 

As iam a complete novice with this subject could you please advise me to where the PHP Admin module can be found

 

Thanks

[KIEDIS]

As iam a complete novice with this subject could you please advise me to where the PHP Admin module can be found

 

Thanks

<{POST_SNAPBACK}>

 

you can also try to check using phpmyadmin...you can do the backup and the restore from there

 

sometimes databases can crash because of lack of space in the server, i dont think its the case but try checking with your webhosting for the phpmyadmin address...its pretty useful

[PetrolheadsNW]

you can also try to check using phpmyadmin...you can do the backup and the restore from there

 

sometimes databases can crash because of lack of space in the server, i dont think its the case but try checking with your webhosting for the phpmyadmin address...its pretty useful

<{POST_SNAPBACK}>

 

Thanks

 

I can access all our files via the cpanel file manager, is this of any use "can I perform a restore this way?"

The PHPAdmin module which people speak off, I have not yet come across. The only 2 admin modules Iam aware of are:

 

"CPanel" and "oursite/Admin" is there another module that I have missed

 

Thanks in advance

[FalseDawn]

If this is that important, I suggest you stop faffing around with stuff you don't understand and get your host to restore a backup themselves. You might have to pay them a few dollars for it.

 

Any decent host does daily backups.

[PetrolheadsNW]

If this is that important, I suggest you stop faffing around with stuff you don't understand and get your host to restore a backup themselves. You might have to pay them a few dollars for it.

 

Any decent host does daily backups.

<{POST_SNAPBACK}>

 

I totaly agree, Iam not doing it because I enjoy it. Iam trying to repair damage done by one of our employees, this code I can understand a small amount. What screwed it up first of all was by using the in built editor, I have since installed dreamweaver to avoid any more hiccups. Please be patient with me as I do need your help and once its backup and running, I shall not have the need to "mess around with it" any longer

 

I will first contact our host and see if they can perform a restore

 

Thanks

[KIEDIS]

I totaly agree, Iam not doing it because I enjoy it. Iam trying to repair damage done by one of our employees, this code I can understand a small amount. What screwed it up first of all was by using the in built editor, I have since installed dreamweaver to avoid any more hiccups. Please be patient with me as I do need your help and once its backup and running, I shall not have the need to "mess around with it" any longer

 

I will first contact our host and see if they can perform a restore

 

Thanks

<{POST_SNAPBACK}>

 

well dreamweaver is nice but i dont use the 'site manager thingy' from it

 

i actually preffer notepad...but of course it wont show me code in different colours as dreamweaver do...and well after many hours of coding i really need those to realize some stuff...

 

phpmyadmin is not in the file manager, its the database manager.

 

the hosting should give you some kind of address to it and you should be able to login with your usual login and password.

 

I also advice you to read 'php and mysql for dummies' i know it sounds funny but it explains in a simple way many things after that you can check out o'reilly's books that are pretty good too

[Jair]

If this is that important, I suggest you stop faffing around with stuff you don't understand

 

What a faffing stupid comment to make. I suggest you take your elitist attitude and shove it up your "false dawn".

 

For many of us it is that important and we don't have the resources to hire some condescending social idiot like you, so we try our best. This forum is designed for helping people use this product and all I see is put downs like this.

 

Hope you read this before it gets removed because you make me sick. If you don't want to help people then my suggestion would be this....

 

SHUT THE FAFF UP!! We don't need your scoldings, just your help, and if your incapable of helping then don't post.

 

Probably my last post before I am banned... Oh well(It was worth it!) besides, getting answers here is nearly impossible.

 

Jair

[bbelau]

What a faffing stupid comment to make.  I suggest you take your elitist attitude and shove it up your "false dawn". 

 

For many of us it is that important and we don't have the resources to hire some condescending social idiot like you, so we try our best.  This forum is designed for helping people use this product and all I see is put downs like this. 

 

Hope you read this before it gets removed because you make me sick.  If you don't want to help people then my suggestion would be this....

 

SHUT THE FAFF UP!!  We don't need your scoldings, just your help, and if your incapable of helping then don't post.

 

Probably my last post before I am banned... Oh well(It was worth it!) besides, getting answers here is nearly impossible.

 

Jair

<{POST_SNAPBACK}>

 

I agree with Jair....nice work :thumbsup: These forums are supposed to be a global resource for people who have real questions about real problems. Start a blog if you want to complain. We don't have time for your opinions here.

[PetrolheadsNW]

I agree with Jair....nice work? :thumbsup:? ? These forums are supposed to be a global resource for people who have real questions about real problems.? Start a blog if you want to complain.? We don't have time for your opinions here.

<{POST_SNAPBACK}>

 

Well thanks peeps, the comments in question did not help at all, as you state, members do not post for the fun of it and every post on here usually requires your help.

 

I did as requested and had my ISP reinstate from a recent backup, the site is now 99% recovered, we still have the extra checkout charges issue which we have posted in another post.

 

Thanks again and keep up the excellent work :thumbsup: