Go to main content

Navigation menu

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » Archives
  3. » rev 1866 posting comment fails

Pages: 1

#1 2006-10-01 01:44:24

phiw13
Plugin Author
From: South-Western Japan
Registered: 2004-02-27
Posts: 3,595
Website

rev 1866 posting comment fails

Posting a simple comment to an existing article fails. Errors below. The preview works fine. Absolute default everything.

Errors

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1 select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'') textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), ) in /Library/WebServer/Documents/txptest/textpattern/lib/txplib_db.php on line 84

Notice: Undefined index: nonce in /Library/WebServer/Documents/txptest/textpattern/publish/comment.php on line 278

Notice: Undefined index: secret in /Library/WebServer/Documents/txptest/textpattern/publish/comment.php on line 279

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1 select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'') textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), ) in /Library/WebServer/Documents/txptest/textpattern/lib/txplib_db.php on line 84

Notice: Undefined index: nonce in /Library/WebServer/Documents/txptest/textpattern/publish/comment.php on line 278

Notice: Undefined index: secret in /Library/WebServer/Documents/txptest/textpattern/publish/comment.php on line 279

tag_error <txp:comments_form/> ->  Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1
select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'')
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )  on line 84

textpattern/lib/txplib_db.php:84 trigger_error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1
select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'')
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), ), 512)
textpattern/lib/txplib_db.php:258 safe_query(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )
textpattern/publish/comment.php:277 safe_row(nonce, secret, txp_discuss_nonce, nonce in (''2a93c2968be52637637221c90f8af422''))
textpattern/publish/taghandlers.php:1561 getComment()
textpattern/publish/taghandlers.php:1419 comments_preview(Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)

tag_error <txp:comments_form/> ->  Notice: Undefined index:  nonce  on line 278

textpattern/publish/taghandlers.php:1561 getComment()
textpattern/publish/taghandlers.php:1419 comments_preview(Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)
textpattern/publish.php:956 if_comments_allowed(Array, 
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
, <txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, <txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
textpattern/publish.php:779 parse(<txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)

tag_error <txp:comments_form/> ->  Notice: Undefined index:  secret  on line 279

textpattern/publish/taghandlers.php:1561 getComment()
textpattern/publish/taghandlers.php:1419 comments_preview(Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)
textpattern/publish.php:956 if_comments_allowed(Array, 
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
, <txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, <txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
textpattern/publish.php:779 parse(<txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)

tag_error <txp:comments_form/> ->  Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1
select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'')
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )  on line 84

textpattern/lib/txplib_db.php:84 trigger_error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2a93c2968be52637637221c90f8af422'')' at line 1
select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422'')
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), ), 512)
textpattern/lib/txplib_db.php:258 safe_query(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )
textpattern/lib/txplib_db.php:199 getRow(select nonce, secret from txp_discuss_nonce where nonce in (''2a93c2968be52637637221c90f8af422''), )
textpattern/publish/comment.php:277 safe_row(nonce, secret, txp_discuss_nonce, nonce in (''2a93c2968be52637637221c90f8af422''))
textpattern/publish/comment.php:88 getComment()
textpattern/publish/taghandlers.php:1420 commentForm(5, Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)

tag_error <txp:comments_form/> ->  Notice: Undefined index:  nonce  on line 278

textpattern/publish/comment.php:88 getComment()
textpattern/publish/taghandlers.php:1420 commentForm(5, Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)
textpattern/publish.php:956 if_comments_allowed(Array, 
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
, <txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, <txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
textpattern/publish.php:779 parse(<txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)

tag_error <txp:comments_form/> ->  Notice: Undefined index:  secret  on line 279

textpattern/publish/comment.php:88 getComment()
textpattern/publish/taghandlers.php:1420 commentForm(5, Array)
textpattern/publish.php:956 comments_form(Array, , <txp:comments_form />)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, 
<txp:comments_form />
)
textpattern/publish/taghandlers.php:2255 parse(
<txp:comments_form />
)
textpattern/publish.php:956 if_comments_allowed(Array, 
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
, <txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
processTags(Array)
textpattern/publish.php:915 preg_replace_callback(/<txp:(\S+)\b(.*)(?:(?<!br )(\/))?>(?(3)|(.+)<\/txp:\1>)/sU, processTags, <txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)
textpattern/publish.php:779 parse(<txp:comments />
<txp:if_comments_allowed>
<txp:comments_form />
<txp:else />
<p><txp:text item="comments_closed" /></p>
</txp:if_comments_allowed>)

Diagnostics

MySQL: 4.1.18-standard
Locale: en_GB.UTF-8
Server: Apache/1.3.33 (Darwin) PHP/5.1.2
Apache version: Apache/1.3.33 (Darwin) PHP/5.1.2
PHP Server API: apache

Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg

Offline

#2 2006-10-01 01:53:55

phiw13
Plugin Author
From: South-Western Japan
Registered: 2004-02-27
Posts: 3,595
Website

Re: rev 1866 posting comment fails

Update: Previewing once works fine. But preview, then edit your comment and preview again, and I get the errors above.

Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg

Offline

#3 2006-10-01 03:10:38

hcgtv
Archived Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: rev 1866 posting comment fails

I can confirm, I also get errors on second preview.

We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make

Offline

#4 2006-10-01 05:07:46

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: rev 1866 posting comment fails

Thanks guys. Try r1867.

Offline

#5 2006-10-01 05:20:25

phiw13
Plugin Author
From: South-Western Japan
Registered: 2004-02-27
Posts: 3,595
Website

Re: rev 1866 posting comment fails

Mary wrote:

Thanks guys. Try r1867.

OK :-).

Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern
phiw13 on Codeberg

Offline

#6 2006-10-01 16:37:35

hcgtv
Archived Plugin Author
From: Key Largo, Florida
Registered: 2005-11-29
Posts: 2,722
Website

Re: rev 1866 posting comment fails

Working fine on 1867.

Quick question on comments – I know the default templates were updated to take advantage of new commenting features, I went ahead and updated all my site’s forms. Will this affect existing users when they update their sites to 4.0.4?

We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make

Offline

#7 2006-10-01 21:34:40

zem
Developer Emeritus
From: Melbourne, Australia
Registered: 2004-04-08
Posts: 2,579

Re: rev 1866 posting comment fails

Will this affect existing users when they update their sites to 4.0.4?

It shouldn’t. The changes were intended to be backwards compatibile. But that’s what testing is for.

Alex

Offline

Pages: 1

  1. Index
  2. » Archives
  3. » rev 1866 posting comment fails

Board footer

Powered by FluxBB