Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2006-12-13 17:42:34
- jessbaby
- New Member
- Registered: 2006-12-13
- Posts: 4
SQL syntax error
Hi, I ran a search so I hope this isn’t a repeat question. I did come across one post that looked similar, but it was in German. :/
I recently upgraded to 4.0.4 (r1956). I had a database problem with logging earlier today that my web host fixed. This error was happening prior to the database problem, so fixing that didn’t cause this.
Any help on this would be MUCH appreciated. It doesn’t actually interfere with how things run that I can see, but I don’t imagine errors are a good thing to ignore.
When I post a new article, I get the following errors/warnings:
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/jessbaby/public_html/TXP/textpattern/include/txp_article.php)
in /home/jessbaby/public_html/TXP/textpattern/lib/txplib_misc.php on line 1842
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/jessbaby/public_html/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/jessbaby/public_html/TXP/textpattern/include/txp_article.php)
in /home/jessbaby/public_html/TXP/textpattern/lib/txplib_misc.php on line 1842
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/jessbaby/public_html/TXP/textpattern/lib/txplib_db.php on line 84
Offline
#2 2006-12-13 17:47:23
- jessbaby
- New Member
- Registered: 2006-12-13
- Posts: 4
Re: SQL syntax error
Oops, so sorry for misplacing this post. I should have put it in Troubleshooting.
Offline
Re: SQL syntax error
Known problem, unknown cause ( see other topic ). Can you reproduce this error and if so, what steps do you take to get this error?
Offline
#4 2006-12-13 18:15:42
- jessbaby
- New Member
- Registered: 2006-12-13
- Posts: 4
Re: SQL syntax error
Thanks so much.
Similar to what the other poster (root) said, it doesn’t happen every time.
It doesn’t seem to have rhyme or reason. It’s apparently got nothing to do with content posted (images, links, text only, etc). I had it happen twice in a row today, but 3 test posts since then have gone through without error.
Sorry I couldn’t be more helpful on that one.
EDIT: A-ha. I think it’s the preview/backspace issue for me as well.
Last edited by jessbaby (2006-12-13 18:17:43)
Offline
Pages: 1