hi,
we’ve currently got cs-cart 1.3.5 running on a 1&1 Dedicated Server DC S Linux.
recently the site times out and was initially told by 1&1 support this was because of a possible ddos (distributed denial of service) attack. however i think this is not the case. i set up a firewall so our ip address was the only one able to access the server and the site still timed out.
there has been a few times after rebooting the server that i managed to get the site running again but eventually the following database error occured:
Database error: 145 : Table ‘./cscart/cscart_sessions’ is marked as crashed and should be repaired
Invalid query: SELECT session_id FROM cscart_sessions WHERE session_id=‘8c25f6aef9c47ff43ae0237eb5a83340’ AND expiry>‘1263840031’
so i repaired the the cscart_sessions table via phpmyadmin and then had the same problem with the stat_sessions table which i also repaired.
following this i deactivated statics from the site to see if it would make a difference but the site still times out. any light shed on this matter would be highly appreciated.
That’s 1&1 for you. No offence but I’ve seen so many people move it’s really not worth the time answering your question as it will re-occur.
Now the table “cscart_sessions” can be truncated since it only hold customer session data. The Statistics addon plays a heavy part on the database server so I suggest that you disable it (I know you have, but for a long while longer)
Lastly, Repair the entire database using PHPMyAdmin, if that still doesnt’ fix it, ask 1&1 to restore a backup for you.
[quote name=‘JesseLeeStringer’]That’s 1&1 for you. No offence but I’ve seen so many people move it’s really not worth the time answering your question as it will re-occur.
Now the table “cscart_sessions” can be truncated since it only hold customer session data. The Statistics addon plays a heavy part on the database server so I suggest that you disable it (I know you have, but for a long while longer)
Lastly, Repair the entire database using PHPMyAdmin, if that still doesnt’ fix it, ask 1&1 to restore a backup for you.[/QUOTE]
Have to agree with Jesse on this one. 1&1 was a horrible host for me. Good to see nothing has changed with them in the last 7 years.
the site is only accessible again once i reboot the server, still after a few minutes the table crashes again. also when i can access the site there is no log on panel at the back-end admin page, heard of this before?
if it is 1and1, which hosting company would be recommend, i’ve see cs-cart recommend siteground but am also finding a lot of bad reviews for them…
[quote name=‘choicenutrition@gmail.com’]the site is only accessible again once i reboot the server, still after a few minutes the table crashes again. also when i can access the site there is no log on panel at the back-end admin page, heard of this before?
if it is 1and1, which hosting company would be recommend, i’ve see cs-cart recommend siteground but am also finding a lot of bad reviews for them…[/QUOTE]
I can tell you I use Steadfast for the last 5 years and couldn’t be happier. They get back to you within 10 minutes on support issues and are on a very fast backbone. Their datacenter is located in Chicago which is great if you do most of your business in the US as it is pretty centrally located.
[quote name=‘choicenutrition@gmail.com’]we’ve currently got cs-cart 1.3.5 running on a 1&1 Dedicated Server DC S Linux. [/QUOTE]
Personally I would recommend a different host because your options are generally quite a bit limited there based on my own experiences there on behalf of quite a few clients. However, ignoring that entirely, you might be able to use SSH to run a full index rebuild against the database to help with that portion of your problem.
The repair and optimize functions in phpMyAdmin are just your standard functions built into the database but there are actually much more powerful functions available from the shell level that might be of use trying to fix deeper corruption issues that the general functions in phpMyAdmin might not be able to deal with.
I would give you a script to automate the deeper repairs but knowing that you are hosted with 1&1 tells me right off the top that the script probably wouldn’t be of much use to you since it is really written primarily for Cpanel servers first and foremost but since you did say that you are “dedicated”, I may be to modify the script to match your server if that is something you think might be of use to you.
[QUOTE]recently the site times out and was initially told by 1&1 support this was because of a possible ddos (distributed denial of service) attack. however i think this is not the case. i set up a firewall so our ip address was the only one able to access the server and the site still timed out.[/QUOTE]
Timeout and dDoS don’t generally go together like that and hearing about your database on top of that, I’m not really convinced that is your issue at all.
[QUOTE]there has been a few times after rebooting the server that i managed to get the site running again but eventually the following database error occured:
[/QUOTE]
That statement right there makes me think the server is doing a core dump and abruptly halting which will cause indirectly database corruption among other things but your underlying problem may actually be hardware related and if I were to take a guess without more information, I’d say memory most likely.
havent got a clue about ssh so i cant really go down that route. any help would be highly appreciated with this as i’m totally out of my jurisdiction with this issue. 1and1 support arent much help either, as its a root server they say we’re totally responsible for it. i will say that when this trouble started, i noticed that the server time had been changed, not sure why as i didnt edit anything, noticed this as order time/date didnt correspond to our local time/date like previous orders.
i dont think it is a ddos attack as well, there are too many other issues involved. is there any i way i can get a database backup without logging into the back end that i can install via cs-cart back end onto a new server with a decent hosting company.
[quote name=‘choicenutrition@gmail.com’]hi,
we’ve currently got cs-cart 1.3.5 running on a 1&1 Dedicated Server DC S Linux.
recently the site times out and was initially told by 1&1 support this was because of a possible ddos (distributed denial of service) attack. however i think this is not the case. i set up a firewall so our ip address was the only one able to access the server and the site still timed out.
there has been a few times after rebooting the server that i managed to get the site running again but eventually the following database error occured:
Database error: 145 : Table ‘./cscart/cscart_sessions’ is marked as crashed and should be repaired
Invalid query: SELECT session_id FROM cscart_sessions WHERE session_id=‘8c25f6aef9c47ff43ae0237eb5a83340’ AND expiry>‘1263840031’
so i repaired the the cscart_sessions table via phpmyadmin and then had the same problem with the stat_sessions table which i also repaired.
following this i deactivated statics from the site to see if it would make a difference but the site still times out. any light shed on this matter would be highly appreciated.[/QUOTE]
Hi
Just to let you i have this issue happen to me on one domain and the site was giving this error below
Table ‘./*********/cscart_users’ is marked as crashed and should be repaired (145)
When this happens cant login to back end of cart admin panel and all other site pages show this error.
what i did to fix this is the go to cpanel and click on db that has issue and will all tables on left and in middle of page
look in middle of page and go all the way down to page
select all tables options
then select the option at the bottom to repair the db
once done this will resolve this issue for you
avoid messing with the table data yourself and trying to repair each table one at a time.
also most hosting companies make daily backups also so if you dont have one you can request from them to help you restore the back up.
if you need further on this issue feel free to message me
thanks
Buta
Solutions Point Limited