4.03: SQL Error when Posting

root · 2006-02-13 13:30:55

I get this error in admin whenever I post.

Fatal 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 ‘) order by Posted desc limit 1’ at line 1 select ID from `textpattern` where Posted < from_unixtime() order by Posted desc limit 1 in /root/txp/textpattern/lib/txplib_db.php on line 61

The thing posts, but having a “fatal error” can’t be good. Any ideas? :D

Sencer · 2006-02-13 14:24:15

1) Are you running any plugins? Please turn all of them off and try again

2) Which version of mysql, which version of textpattern are you using? Please, post your diagnostics infromation.

3) What are the exat steps to reproduce the error on a clean installation? If we get a ste by tep procedure of how the error can be triggered starting from a clean install, we can try to find out the source of the error and fix it.

root · 2006-02-13 20:15:58

I was reading back on past articles and while none of them seemed identical to my error, they all said to switch from “Debugging” to “Live” status. Now, my blog has been Live for some time now, but I’ve been editing my layout recently when the error’s come up. When I look at the site status, I find it in “debugging.” (I didn’t touch it, I promise!)

When I switch it back, the error goes away.

So is there an error here?

Thanks very much :D

Here’re my diagnostics:

(no plugins)

Textpattern version: 4.0.3 (r1188)
last_update: 2006-01-02 15:46:42/2006-01-02 15:42:53
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
open_basedir: /home/moonsha/:/usr/lib/php:/usr/local/lib/php:/tmp
Temp folder: /tmp
Site URL: beyond-sanity.org/root/txp
PHP version: 4.3.11
Register globals: 1
server_time: 2006-02-13 15:07:51
MySQL: 4.0.25-standard
Locale: en_US.UTF-8
Server: Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2634a mod_ssl/2.8.22 OpenSSL/0.9.7a
Apache version: Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2634a mod_ssl/2.8.22 OpenSSL/0.9.7a
php_sapi_mode: apache
os_version: Linux 2.4.26-ow3

Pre-flight check:
————————————
warn_register_globals_or_update
(my host doesn’t want to switch, and I don’t want to argue.)
————————————

.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

<Files root>
ForceType application/x-httpd-php
</Files>
————————————

Last edited by root (2006-02-13 20:18:17)

zem · 2006-02-14 05:58:19

Have you modified the admin write page at all? Running any plugins that affect that page?

root · 2006-02-14 10:30:37

Not at all. I’ve never tampered with anything but the .htaccess file, and I’ve reverted back to the original. No plugins or hacks of any kind.

Mary · 2006-03-17 21:27:14

Is this still a problem?

Textpattern CMS

Textpattern CMS support forum

#1 2006-02-13 13:30:55

4.03: SQL Error when Posting

#2 2006-02-13 14:24:15

Re: 4.03: SQL Error when Posting

#3 2006-02-13 20:15:58

Re: 4.03: SQL Error when Posting

#4 2006-02-14 05:58:19

Re: 4.03: SQL Error when Posting

#5 2006-02-14 10:30:37

Re: 4.03: SQL Error when Posting

#6 2006-03-17 21:27:14

Re: 4.03: SQL Error when Posting

Board footer