Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2006-01-06 11:06:01
- wmike1503
- Member
- Registered: 2006-01-03
- Posts: 11
MySQL problems
Have been setting up textpattern site successfully – I changed my logon password and entered smtp settings into PHP.ini.
Now when I try to preview my site I get the following:
tag_error <txp:article/> -> Warning: mysql_query() [function.mysql-query]: Unable to save result set on line 56
tag_error <txp:article/> -> Warning: mysql_query() [function.mysql-query]: Unable to save result set on line 56
PHP.ini mail setting:
[mail function]- For Win32 only.
SMTP = mail.outitgoes.com
smtp_port = 25
- For Win32 only.
sendmail_from = wmike@wrightplace.co.uk
Any ideas, please?
I have been working on a site design and content for the past fours days and, obviously, do not wish to start again.
Any advice gratefully received!
Mike
Offline
#2 2006-01-06 11:10:41
- wmike1503
- Member
- Registered: 2006-01-03
- Posts: 11
Re: MySQL problems
Further to last.
Diagnostics:
Textpattern version: 4.0.3 (r1188)
last_update: 2006-01-04 15:33:29/2005-12-26 18:49:56
Document root: C:/Program Files/xampp/htdocs (C:\Program Files\xampp\htdocs)
$path_to_site: C:\Program Files\xampp\htdocs\wpcms
Textpattern path: C:\Program Files\xampp\htdocs\wpcms\textpattern
Permanent link mode: title_only
upload_tmp_dir: C:\Program Files\xampp\tmp
Temp folder: C:\Program Files\xampp\htdocs\wpcms\textpattern\tmp
Site URL: localhost/wpcms
PHP version: 5.0.5
Register globals: 1
server_time: 2006-01-06 11:09:47
MySQL: 5.0.15-nt
Locale: English_United Kingdom.1252
Server: Apache/2.0.55 (Win32) mod_autoindex_color mod_ssl/2.0.55 OpenSSL/0.9.8a PHP/5.0.5
Apache version: Apache/2.0.55 (Win32) mod_autoindex_color mod_ssl/2.0.55 OpenSSL/0.9.8a PHP/5.0.5
php_sapi_mode: apache2handler
os_version: Windows NT 5.1
Pre-flight check:
————————————
C:\Program Files\xampp\htdocs\wpcms\textpattern\setup\ still exists
Your version of PHP has security related risks. Please turn register_globals off or update to a newer PHP version.
————————————
.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
————————————
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: C:\Program Files\xampp\mysql\share\charsets/
18 Tables: textpattern: Size of indexfile is: 55296 Should be: 56320, txp_log: Wrong bytesec: 0-0-0 at linkstart: 57284
PHP extensions: bcmath, calendar, com_dotnet/0.1, ctype, ftp, iconv, odbc/1.0, pcre, session, SPL, SQLite, standard/5.0.5, tokenizer/0.1, zlib/1.1, libxml, dom/20031129, SimpleXML, wddx, xml, apache2handler, dbase, dbx, dio/0.1, filepro, gd, mbstring, exif/1.4 $Id: exif.c,v 1.162.2.9 2005/08/05 14:00:47 hyanantha Exp $, mime_magic/0.1, ming, msql, mssql, mysql, mysqli/0.1, openssl, pdf/2.0.3, shmop, soap, sockets, zip, Zend Optimizer
Apache modules: core, mod_win32, mpm_winnt, http_core, mod_so, mod_access, mod_actions, mod_alias, mod_asis, mod_auth, mod_autoindex_color, mod_cgi, mod_dir, mod_env, mod_imap, mod_include, mod_info, mod_isapi, mod_log_config, mod_mime, mod_negotiation, mod_rewrite, mod_setenvif, mod_ssl, mod_status, mod_php5
/include/txp_category.php: r1154 (dffd7979531373149c74e3eedfbb50e2)
/include/txp_plugin.php: r1167 (c2c7d7fc1e4918c79cd3658c62e4fbda)
/include/txp_auth.php: r1166 (3e2eaca7b151e14561125ab68e722203)
/include/txp_form.php: r947 (c0e4393328985742bd81cda61d10d5ed)
/include/txp_section.php: r1154 (d85c1ce405fccd9dac364c8ef4eb72eb)
/include/txp_tag.php: r1134 (3e2dfbd6fdccf0693c147ba22a9705e7)
/include/txp_list.php: r1042 (e85d2de1c63b41f0e5bdcf268e3c487b)
/include/txp_page.php: r876 (e22dc37b465b87757722732a225b25f3)
/include/txp_discuss.php: r1170 (1e56e08cc95c255783410076db12529f)
/include/txp_prefs.php: r1170 (c806be1b1f238e75a5ff6b7cf8432d17)
/include/txp_log.php: r906 (68c4f32b70ce41a349f197b6bba6c200)
/include/txp_preview.php: r628 (a16f84b6610fc66db0bce51e25b7af34)
/include/txp_image.php: r1168 (e8ec79ff9b3a21c356ee23da7973b1f0)
/include/txp_article.php: r1170 (88689d7469d16c13d51bd4adff03ebd7)
/include/txp_css.php: r922 (0c596d9968052b89581d1ca65a77c5de)
/include/txp_admin.php: r1074 (7e87ff0e29101593fb170b1a2de9fd59)
/include/txp_link.php: r1154 (7c0c55ff6580793dff0626f169e64ad6)
/include/txp_diag.php: r1154 (5d66b90f7e7720dd0e3526ca1b24cf89)
/lib/admin_config.php: r877 (9aea12193cc76eea1964eb0383ec6513)
/lib/txplib_misc.php: r1170 (7000a1b27aa40c90978211e6cff358ec)
/lib/taglib.php: r628 (493878f922262157601c26a999a1c478)
/lib/txplib_head.php: r1183 (fb85b66b4e379476935233f844844bef)
/lib/classTextile.php: r1141 (b066c2bfa94a26ae3d70b245dcf81369)
/lib/txplib_html.php: r1166 (bd11de6e6daa3391eab75a46db55ae36)
/lib/txplib_db.php: r1170 (5a2c3a1e328cd343a067cbb8fd25cd79)
/lib/IXRClass.php: r765 (2efb0fb05b55c634072b0bae9af38bdd)
/lib/txplib_forms.php: r950 (74da2c67abe4786c353ea416c13656eb)
/publish/taghandlers.php: r1188 (4e8eaeb0543d8fde09d6e423af4253b9)
/publish/atom.php: r1117 (14c1aa23c708898d7723b3d6b9c89050)
/publish/log.php: r864 (c3d16d3dfe375819a19fcd62398e4b86)
/publish/comment.php: r1187 (d55dde574418d2eaf6a394d703056d9a)
/publish/search.php: r884 (80f942f1dc301857c2fa9dcb16aa1246)
/publish/rss.php: r1099 (ce0d82b9435d8f1de01c8e2b6c585f93)
/publish.php: r1186 (d5c20bf2298e87969575f9e622bf2797)
/index.php: r1172 (52f753ebb51c1f7d5312485d9dbad7e4)
/css.php: r944 (df1c754417bdfb4e97a2c83ae5b454ee)
Offline
#3 2006-01-06 23:16:30
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Offline
Pages: 1