mysql problem

Kosimak · 2013-11-24 21:54:53

hello,

I'm started to get this error every time i try to negative through the site:

Query: SELECT COUNT(*) AS total_visitors FROM link_in WHERE link_id = 19 AND ip = 1795402848 AND DATE_FORMAT(click_date, '%y-%m-%d') = DATE_FORMAT(NOW(), '%y-%m-%d')
Error Message: Table './kosimak1_aspdata/link_in' is marked as crashed and last (automatic?) repair failed
Error Number: 144

but, If i past the url of the page I want to go to the site works fine?

Any Idea how to solve this problem?

thank you,

Kosimak.com

symtab · 2013-11-25 10:09:04

The way i implemented the link_in and link_out tables isnot so good, and it will be changed in the near future. You can clean those tables (unless you are using the link exchange and counting traffic). From a mysql console (mysql cli or phpmyadmin) run:

repair table link_in;
optimize table link_in;
delete from link_in;
repair table link_out;
optimize table link_out;
delete from link_out;

Kosimak · 2013-11-27 03:07:36

thanks that solved the problem.

But I do have another problem with the database dump tool.... it gives me this error when I run it:

Tip!Failed to execute the mysqldump cmd: /usr/bin/mysqldump -u kosimak1_aspadmi -p5;Z8Vb4#dB=@ kosimak1_aspdata > /home/kosimak1/public_html/tmp/downloads/23a26c4a26aa9a1ed2a1a41c613a5fa1.sql

symtab · 2013-11-27 15:42:01

i probably need to escape the password with escapeshellarg

symtab · 2013-11-27 15:42:12

Does that command work from shell?

Adult Script Pro Community Forums

#1 2013-11-24 21:54:53

mysql problem

#2 2013-11-25 10:09:04

Re: mysql problem

#3 2013-11-27 03:07:36

Re: mysql problem

#4 2013-11-27 15:42:01

Re: mysql problem

#5 2013-11-27 15:42:12

Re: mysql problem

Board footer