warnings galore upon publishing

root · 2006-10-26 14:20:40

Clicked publish, and this showed up across the top of the backend page. Article showed up correctly however.

Warning: 
Error: '' is not an integer
textpattern/include/txp_article.php:742 assert_int()
textpattern/include/txp_article.php:313 checkifneighbour()
textpattern/include/txp_article.php:131 article_edit()
textpattern/include/txp_article.php:49 article_post()
textpattern/index.php:104 include(/home/moonsha/public_html/beyond/root/txp/textpattern/include/txp_article.php)
in /home/moonsha/public_html/beyond/root/txp/textpattern/lib/txplib_misc.php on line 1843

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 ') order by Posted desc limit 1' at line 1 select ID from textpattern where Posted < from_unixtime() order by Posted desc limit 1 in /home/moonsha/public_html/beyond/root/txp/textpattern/lib/txplib_db.php on line 84

Warning: 
Error: '' is not an integer
textpattern/include/txp_article.php:742 assert_int()
textpattern/include/txp_article.php:316 checkifneighbour()
textpattern/include/txp_article.php:131 article_edit()
textpattern/include/txp_article.php:49 article_post()
textpattern/index.php:104 include(/home/moonsha/public_html/beyond/root/txp/textpattern/include/txp_article.php)
in /home/moonsha/public_html/beyond/root/txp/textpattern/lib/txplib_misc.php on line 1843

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 ') order by Posted asc limit 1' at line 1 select ID from textpattern where Posted > from_unixtime() order by Posted asc limit 1 in /home/moonsha/public_html/beyond/root/txp/textpattern/lib/txplib_db.php on line 84

Sencer · 2006-10-26 15:34:03

Can you post your diagnostics please. Do you get this everytime you publish a new article?

ruud · 2006-10-26 16:05:21

If the error occurs, what timestamp do you see on the right bottom side… is that empty or set to 1970?
If so, can you check your txp_textpattern table using PHPmyAdmin and check if all the fields in the Posted column have ‘normal’ dates?

root · 2006-10-27 11:07:30

Sencer, my diags:

Textpattern version: 4.0.4 (r1951)
Last Update: 2006-10-17 16:26:10/2006-10-17 16:25:37
Document root: /home/moonsha/public_html/beyond
$path_to_site: /home/moonsha/public_html/beyond/root/txp
Textpattern path: /home/moonsha/public_html/beyond/root/txp/textpattern
Permanent link mode: messy
Temporary directory path: /home/moonsha/public_html/beyond/root/txp/textpattern/tmp
Site URL: beyond-sanity.org/root/txp
PHP version: 4.4.2
Register globals: 1
Server Local Time: 2006-10-27 06:57:30
MySQL: 4.1.21-standard
Locale: en_US.UTF-8
Server: Apache/1.3.36 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.27 OpenSSL/0.9.7a PHP-CGI/0.1b
PHP Server API: cgi
RFC 2616 headers: 
Server OS: Linux 2.4.26-ow3
Active plugins: asy_dashboard-0.6m

Pre-flight check: 
------------------------
some_php_functions_disabled: wget
------------------------

.htaccess file contents: 
------------------------
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/

<IfModule mod_rewrite.c>
 RewriteEngine On
 RewriteCond %{REQUEST_FILENAME} -f [OR]
 RewriteCond %{REQUEST_FILENAME} -d
 RewriteRule ^(.+) - [PT,L]

 RewriteRule ^(.*) index.php
</IfModule>

#php_value register_globals 0

------------------------

and it doesn’t happen every time. It might have happened once before, but I just tested posting another similar article (same formatting, same elements in title, etc) and it didn’t occur.

ruud—I don’t get to check before I click publish, but the date turns out correct, I think because “set timestamp to now” is checked.

The-Exit · 2006-11-21 21:29:29

well, one of my authors is getting the same error, but I cannot say, if it is this error, or this one. but probably this has something to do with the preview tab and the back button in the browser, as described here

Textpattern CMS

Textpattern CMS support forum

#1 2006-10-26 14:20:40

warnings galore upon publishing

#2 2006-10-26 15:34:03

Re: warnings galore upon publishing

#3 2006-10-26 16:05:21

Re: warnings galore upon publishing

#4 2006-10-27 11:07:30

Re: warnings galore upon publishing

#5 2006-11-21 21:29:29

Re: warnings galore upon publishing

Board footer