Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: SQL Errors when posting an article.
One of the authors in my weblog is getting the same error, but I could not reproduce the error.
But then we stumbled on one thing: she is in the article form and writing an article, then she clicks on preview and goes back with the browser back, and not by clicking on the text tab.
Offline
Re: SQL Errors when posting an article.
I have been experiencing the same problem – although it is intermittent and not every time a user presses the publish button on a new article.
Here is my diagnostics (high)
Textpattern version: 4.0.4 (r1951)
last_update: 2006-10-17 14:38:31/2006-08-31 16:47:58
Document root: G:/htdocs/intranet (G:\htdocs\intranet)
$path_to_site: G:\htdocs\intranet
Textpattern path: G:\htdocs\intranet\textpattern
Permanent link mode: section_title
Temp folder: G:\htdocs\intranet\textpattern\tmp
Site URL: intranet2.internal.xxx.xxx
PHP version: 5.2.0
Server time: 2006-11-22 13:45:12
MySQL: 5.0.27-community-nt
Locale: English_United Kingdom.1252
Server: Apache/2.2.3 (Win32) PHP/5.2.0
Apache version: Apache/2.2.3 (Win32) PHP/5.2.0
PHP mode: apache2handler
rfc2616_headers:
Operating System: Windows NT 5.0
active_plugins: upm_file-0.1
Pre-flight check:
————————————
.htaccess file is missing
————————————
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: F:\MySQL\MySQL Server 5.0\share\charsets\
18 Tables: OK
PHP extensions: bcmath, calendar, com_dotnet/0.1, ctype, session, filter/0.9.5-dev, ftp, hash/1.0, iconv, json/1.2.1, odbc/1.0, pcre, Reflection, date/5.2.0, libxml, standard/5.2.0, tokenizer/0.1, zlib/1.1, SimpleXML, dom/20031129, SPL, wddx, xml, xmlreader/0.1, xmlwriter/0.1, apache2handler, mbstring, gd, mysql/1.0
Apache modules: core, mod_win32, mpm_winnt, http_core, mod_so, mod_actions, mod_alias, mod_asis, mod_auth_basic, mod_authn_default, mod_authn_file, mod_authz_default, mod_authz_groupfile, mod_authz_host, mod_authz_user, mod_autoindex, mod_cgi, mod_dir, mod_env, mod_imagemap, mod_include, mod_isapi, mod_log_config, mod_mime, mod_negotiation, mod_rewrite, mod_setenvif, mod_userdir, mod_php5
pretext_data: array (
‘id’ => ‘’,
‘s’ => ‘’,
‘c’ => ‘’,
‘q’ => ‘’,
‘pg’ => ‘’,
‘p’ => ‘’,
‘month’ => ‘’,
‘author’ => ‘’,
‘request_uri’ => ‘/11f061231e59fc84639caa211edcba1f/?txpcleantest=1’,
‘qs’ => ‘txpcleantest=1’,
‘subpath’ => ‘\\/’,
‘req’ => ‘/11f061231e59fc84639caa211edcba1f/?txpcleantest=1’,
)
/include/txp_category.php: r1879 (aa84dc76082b0227a2b84cb5028c5ff2)
/include/txp_plugin.php: r1917 (def1c6926df4dd5ef4fa607655bef350)
/include/txp_auth.php: r1879 (f84d0af5836156c5f10e503e19eea592)
/include/txp_form.php: r1913 (b41e377f44b03b7127d9c83b4cf08559)
/include/txp_section.php: r1891 (8085ac2980f510c1edb8023c059a4f2d)
/include/txp_tag.php: r1915 (434b53e6d7d7edeffb6c3386117c8382)
/include/txp_list.php: r1892 (8dcd73ec065ae5f0646a4e7e6d3da4d4)
/include/txp_page.php: r1913 (0b454b359aa189e066c22ffa5db49422)
/include/txp_discuss.php: r1909 (e3e8b3033c04ee02d5a2fab5a918fc3d)
/include/txp_prefs.php: r1946 (9b9a5df2ea126e157495bebcb4673fb1)
/include/txp_log.php: r1919 (0d8990043f8b8d3d6f144eb8aa7ece1f)
/include/txp_preview.php: r1238 (5d3f54eeb736dc7cde1ae8d269d7ed37)
/include/txp_image.php: r1922 (a47c37636b7a2bedc4b15208af7a6dfd)
/include/txp_article.php: r1889 (f6d150d49ccbf5c2676892271ebd97e4)
/include/txp_css.php: r1897 (62a795fc0bde840125fc5222252c974d)
/include/txp_admin.php: r1879 (2877d7d092f0812c7956313408d79834)
/include/txp_link.php: r1879 (c1ea6a187e4f314e108cef85e6fe3157)
/include/txp_diag.php: r1902 (c8185f20380666dba2e261cf1e026bf1)
/include/txp_file.php: r1895 (35faafb0d5eb0fb5e3ee0fa436eeef27)
/include/txp_import.php: r1238 (e5e41b797bc26018755828fe7b2f5f11)
/lib/admin_config.php: r1747 (f9c6ea27f665cd037d31c06ed54b3514)
/lib/txplib_misc.php: r1932 (111499e2c5788e2f94d868bf22ae933f)
/lib/taglib.php: r1535 (5efb10c2638b6671ec3a47099cc428cd)
/lib/txplib_head.php: r1887 (c6e2241f040e0616595f8262cd61a098)
/lib/classTextile.php: r1943 (0464f2ea4fce419a90e9db6fe72376b2)
/lib/txplib_html.php: r1937 (e4e0c59111bd245f47f4678e8981f74a)
/lib/txplib_db.php: r1879 (142f3d8eaf1e6e4aa120622925c1c8df)
/lib/IXRClass.php: r765 (2efb0fb05b55c634072b0bae9af38bdd)
/lib/txplib_forms.php: r1887 (1c7e8d0e03b1033b5b660129d2b71725)
/lib/class.thumb.php: r1879 (78e4339bb1d65978b1c57698d1bf3f49)
/lib/constants.php: unknown (0e40251c717c52b2b7fe992b62a3e97a)
/lib/txplib_update.php: r1239 (813b996fd418da19242d7bc07d66bdf5)
/lib/txplib_wrapper.php: unknown (584448787b4a3488200722672c0eee0d)
/publish/taghandlers.php: r1949 (84480d420e13ca1860e7af9dcbdc4946)
/publish/atom.php: r1864 (8b51c019578514c6e0765cb11024b689)
/publish/log.php: r1637 (91f4ca2e4a9bd0a5a90e319646620a8e)
/publish/comment.php: r1951 (6d9994735584048031c4d834129c53af)
/publish/search.php: r1748 (1f3b5b2dffa90ccf597959b1b0e975ff)
/publish/rss.php: r1864 (c48e432b1e7ccfe06de06842249f125d)
/publish.php: r1945 (516bb917dbf2d388dd08016acf61b3c3)
/index.php: r1948 (5f9d0798381aacb14671f2dba3832e5c)
/css.php: r944 (df1c754417bdfb4e97a2c83ae5b454ee)
Last edited by douglgm (2006-11-22 13:46:06)
Offline
#18 2006-11-26 02:43:31
- root
- Member
- From: Manila, Philippines
- Registered: 2004-05-31
- Posts: 48
Re: SQL Errors when posting an article.
The-Exit: It happened to me again too, and I think you’re on to something—I previewed before publishing also.
Last edited by root (2006-11-26 02:43:50)
Offline
Re: SQL Errors when posting an article.
Yep – that seems to be it! repeated use of the back button while previewing/editing an article can leave things in a real mess! One of my ‘users’ managed to get multiple articles too!
Either I need Txp to be a little more robust about things – or I need better user education! ;-)
Doug.
Offline
#20 2006-12-02 23:55:24
- Cap'n Refsmmat
- New Member
- Registered: 2006-10-21
- Posts: 9
Re: SQL Errors when posting an article.
I have this problem as well.
I’ve traced down the problem to when I use Preview while writing a new article, then hit backspace instead of using the Text button.
Offline
#21 2006-12-13 18:18:50
- jessbaby
- New Member
- Registered: 2006-12-13
- Posts: 4
Re: SQL Errors when posting an article.
Ditto what Cap’n Refsmmat said. I was doing the same thing when I got that error.
Offline
Re: SQL Errors when posting an article.
I think the following patch will fix this problem:
Index: 4.0/textpattern/include/txp_article.php
===================================================================
--- 4.0/textpattern/include/txp_article.php (revision 2250)
+++ 4.0/textpattern/include/txp_article.php (working copy)
@@ -678,10 +678,12 @@
//-- publish button --------------
+ $onclick = "if (typeof(cur_view)=='string') document.article.view.value=cur_view;";
+
echo
(has_privs('article.publish')) ?
- fInput('submit','publish',gTxt('publish'),"publish", '', '', '', 4) :
- fInput('submit','publish',gTxt('save'),"publish", '', '', '', 4);
+ fInput('submit','publish',gTxt('publish'),"publish", '', $onclick, '', 4) :
+ fInput('submit','publish',gTxt('save'),"publish", '', $onclick, '', 4);
}
else
@@ -859,7 +861,7 @@
$state = ($view==$tabevent) ? 'up' : 'down';
$img = 'txp_img/'.$tabevent.$state.'.gif';
$out = '<img src="'.$img.'"';
- $out.=($tabevent!=$view) ? ' onclick="document.article.view.value=\''.$tabevent.'\'; document.article.submit(); return false;"' : "";
+ $out.=($tabevent!=$view) ? ' onclick="cur_view=document.article.view.value; document.article.view.value=\''.$tabevent.'\'; document.article.submit(); return false;"' : "";
$out.= ' height="100" width="19" alt="" />';
return $out;
}Last edited by ruud (2007-03-10 02:30:11)
Offline
#23 2007-03-10 08:05:52
- root
- Member
- From: Manila, Philippines
- Registered: 2004-05-31
- Posts: 48
Re: SQL Errors when posting an article.
Hey, that’s cool :) I’d love to try it out but unfortunately, I’m not on svn :s
Offline
Re: SQL Errors when posting an article.
This was fixed in revision 2267
Offline
Re: SQL Errors when posting an article.
Sorry to open an old thread, but I have the same error again now – only in IE(!) – on 4.0.5.
- Happens Only when saving newly posted articles
- Happens only in IE(!)
- Happens with all admin plugins off
- Happens with javascript off
Any clues?
Offline
Re: SQL Errors when posting an article.
Please open a new topic and post the exact steps to reproduce and the error message you get.
Offline