Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
SQL error/warning and undefined index notices
Hi,
I have a problem when saving an article with a date in the future. This is likely to be caused be caused by a plugin but since I don’t know which one I hope someone has a clue or can give me a hint in the right direction.
The Website:
Gouwzee
Hosting company:
Intention Internet
This is the message:
Notice: Undefined index: Status in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 147
Notice: Undefined index: Status in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 148
Notice: Undefined index: Status in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 149
Warning:
Error: '' is not an integer
assert_int()
textpattern/include/txp_article.php:161 array_map(assert_int, Array)
textpattern/include/txp_article.php:51 article_save()
textpattern/index.php:104 include(/home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php)
in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/lib/txplib_misc.php on line 1842
Notice: Undefined index: Status in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 176
Notice: Undefined index: url_title in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 177
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 '' at line 30 update textpattern set Title = 'Open huis', Body = 'Op woensdag 14 maart organiseren we een open huis. Klik \"hier\":http://www.obsdegouwzee.nl/article/78/open-huis voor meer informatie', Body_html = '
Op woensdag 14 maart organiseren we een open huis. Klik hier voor meer informatie
', Excerpt = '', Excerpt_html = '', Keywords = '', Image = '', Status = 4, LastMod = now(), LastModID = 'admin', Section = 'article', Category1 = 'agenda', Category2 = '', Annotate = 0, textile_body = 1, textile_excerpt = 1, override_form = '', url_title = 'open-huis', AnnotateInvite = 'reageer', custom_1 = '', custom_2 = ' in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/lib/txplib_db.php on line 84
Notice: Undefined index: Status in /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/include/txp_article.php on line 222
My diagnostics:
Textpattern versie: 4.0.4 (r1956)
Laatste update: 2006-12-30 10:01:08/2007-01-31 17:14:36
Document root: /home/Sites/Customers/www.obsdegouwzee.nl/web
$path_to_site: /home/Sites/Customers/www.obsdegouwzee.nl/web
Pad naar textpattern: /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern
Permanente link modus: section_id_title
open_basedir: /home/Sites/Customers/www.obsdegouwzee.nl:/tmp
Tijdelijke bestanden map: /home/Sites/Customers/www.obsdegouwzee.nl/web/textpattern/tmp
Site URL: www.obsdegouwzee.nl
PHP versie: 5.2.1
Register globals: 1
Lokale server tijd: 2007-03-06 07:43:35
MySQL: 4.0.23a
Localisatie: nl_NL.UTF-8
Server: Apache
Apache versie: Apache
PHP server API: apache2handler
RFC 2616 headers:
Besturingssysteem van de server: Linux 2.4.29
Actieve plugins: ajw_comment_alt-0.3, ajw_comment_num-0.2, bas_img_selector-0.71, cbs_category_list-0.9, kgr_safe_excerpt-1.0, rss_suparchive-0.18, sed_comment_pack-0.4, smf_eventarticle-0.1, upm_insert_tab-0.2.2, zem_article_info-0.1, zem_contact_lang-4.0.3.03m, pap_contact_cleaner-0.1, Newsletter Manager-4.0.3.0.3m, fpx_image_import-0.3, zem_contact_reborn-4.0.3.17, ajw_admin_workflow-0.3.1m, smd_slimbox-0.21
- htaccess bestand:*
#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
Offline
#2 2007-03-06 21:43:07
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: SQL error/warning and undefined index notices
Likely the problem: http://forum.textpattern.com/viewtopic.php?id=19531
Offline
Re: SQL error/warning and undefined index notices
Mary wrote:
Likely the problem: http://forum.textpattern.com/viewtopic.php?id=19531
I tried to reproduce the problem and it might indeed have something to do with the back button / article preview. I’ll see if the error returns if I don’t use the back button anymore.
thank you.
Offline