my comments stopped working

skimes · 2008-02-13 16:52:44

Help!

I had a txp site up and running for a while then made changes that evidently broke my comments. I can click on comment, fill out the comment form and hit preview and it is ok, after clicking submit it gives me a 404 error and says unknown section.

I have the following forms: comments, comment_form and comments_display,

the url that comes along with the resulting 404 error is:

http://www.dsk4wva.com/article/27/complaint_cpreview_cpreview#cpreview

so what did I break? thanks

Mary · 2008-02-13 17:16:37

Off-topic: you’ve got two comments_error tags in your comments_form.

Try a tag trace.

skimes · 2008-02-13 17:46:25

Warning: MySQL server has gone away
select message,name from txp_discuss where name=‘DSK’ and message=’ hello\n\n’ and ip=‘75.108.32.209’
textpattern/lib/txplib_db.php:199 getRow() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84 
 
Warning: MySQL server has gone away
delete from txp_discuss_nonce where issue_time < date_sub(now(),interval 10 minute)
textpattern/publish/comment.php:473 safe_delete() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84

Warning: MySQL server has gone away
select * from txp_discuss_nonce where nonce=‘ccd73e83a5f8d8c6f71949b3baee3bac’ and used = 0
textpattern/lib/txplib_db.php:199 getRow() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84 
 
Warning: MySQL server has gone away
select host from txp_log where ip=‘75.108.32.209’ limit 1
textpattern/publish/log.php:39 safe_field() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84

Warning: MySQL server has gone away
insert into txp_log set `time`=now(),page=’/article/27/complaint’,ip=‘75.108.32.209’,host=‘75.108.32.209’,refer=’‘,status=‘200’,method=‘POST’
textpattern/publish/log.php:66 safe_insert() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84 
 
Warning: MySQL server has gone away
select user_html from txp_page where name=‘default’
textpattern/publish.php:443 safe_field() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84 
 
Warning: MySQL server has gone away
select user_html from txp_page where name=‘error_404’
textpattern/lib/txplib_misc.php:1536 safe_field() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84

Warning: MySQL server has gone away
select user_html from txp_page where name=‘error_default’
textpattern/lib/txplib_misc.php:1538 safe_field() in /home/dsk4wvac/public_html/textpattern/lib/txplib_db.php on line 84 
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=“http://www.w3.org/1999/xhtml” xml:lang=“en” lang=“en”>
<head> <meta http-equiv=“content-type” content=“text/html; charset=utf-8” /> <title>Textpattern Error: 404 Not Found</title>
</head>

<body>
Unknown section
</body>
</html>

Mary · 2008-02-13 18:11:45

Okay, are you able to examine your Txp database and see if any tables need repairing?

skimes · 2008-02-14 01:56:48

I checked and didn’t see anything that needs repairing, but who knows, maybe I will just disable commenting

Mary · 2008-02-14 20:42:27

It’s got nothing to do with comments. The error you’re getting is MySQL server has gone away. Something is happening to cause that, which is causing all the following database queries to fail.

Would you post your “high” diagnostics and try running this query manually:

SELECT message, name FROM txp_discuss WHERE name = 'DSK' AND message = '<p>hello</p>\n\n' AND ip = '75.108.32.209';

What result do you get?

skimes · 2008-02-14 21:37:01

Error

SQL-query :

SELECT `txp_discuss`.`message`

MySQL said:

Unknown table ‘txp_discuss’ in field list

Database dsk4wvac_textpattern – Table txp_discuss running on localhost Structure Browse SQL Select Insert Export Operations Options Empty Drop

Field Type Attributes Null Default Extra Action discussid int(6) UNSIGNED ZEROFILL No auto_increment Change Drop Primary Index Unique Fulltext parentid int(8) No 0 Change Drop Primary Index Unique Fulltext name varchar(255) No Change Drop Primary Index Unique Fulltext email varchar(50) No Change Drop Primary Index Unique Fulltext web varchar(255) No Change Drop Primary Index Unique Fulltext ip varchar(100) No Change Drop Primary Index Unique Fulltext posted datetime No 0000-00-00 00:00:00 Change Drop Primary Index Unique Fulltext message text No Change Drop Primary Index Unique Fulltext visible tinyint(4) No 1 Change Drop Primary Index Unique Fulltext

skimes · 2008-02-14 21:53:21

now i am getting this with no results, so the comment isn’t being inserted?:

Database dsk4wvac_textpattern – Table txp_discuss running on localhost Your SQL-query has been executed successfully SQL-query : [Edit] [Explain SQL] [Create PHP Code] SELECT message, name FROM txp_discuss WHERE name = ‘DSK’ AND message = ‘hello\n\n’ AND ip = ’75.108.32.209’ LIMIT 0 , 30

Mary · 2008-02-15 01:58:26

now i am getting this with no results, so the comment isn’t being inserted?

That’s not what the query is for. But that does tell us that it is something earlier where MySQL is failing. What we need is to be able to look at your MySQL logs. Contact your host, tell them about the “MySQL has gone away” message, and see if they can determine where and when it is happening.

skimes · 2008-02-18 16:48:32

contacting host is always a great waste of time and nothing more, I sent them a message but have not heard from them, i did look under admin-diagnostics-preflight check and it is giving me this:

Pre-flight check
mysql_table_errors: txp_log: error: Size of datafile is: 759708 Should be: 782320,
txp_log: error: Corrupt

does this tell me anything? how do i fix?

ruud · 2008-02-18 16:55:09

Fire up PHPmyAdmin and repair the txp_log table.

skimes · 2008-02-18 17:09:55

well i had tried that before but it wouldn’t let me because the table was in use but today it worked, but my mysql errors are still there, mysql has gone away when submitting comments,

Textpattern CMS

Textpattern CMS support forum

#1 2008-02-13 16:52:44

my comments stopped working

#2 2008-02-13 17:16:37

Re: my comments stopped working

#3 2008-02-13 17:46:25

Re: my comments stopped working

#4 2008-02-13 18:11:45

Re: my comments stopped working

#5 2008-02-14 01:56:48

Re: my comments stopped working

#6 2008-02-14 20:42:27

Re: my comments stopped working

#7 2008-02-14 21:37:01

Re: my comments stopped working

#8 2008-02-14 21:53:21

Re: my comments stopped working

#9 2008-02-15 01:58:26

Re: my comments stopped working

#10 2008-02-18 16:48:32

Re: my comments stopped working

#11 2008-02-18 16:55:09

Re: my comments stopped working

#12 2008-02-18 17:09:55

Re: my comments stopped working

Board footer