We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 17673
    • 194 Posts
    I installed RC3 on a new machine (see php info page below) the manager seems to be working fine, but when I try to view any of the pages in the sample site I get:

    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Can’t create/write to file ’/var/lib/mysql/tmp/#sql_23dd_0.MYI’ (Errcode: 2) »
    SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type=’reference’,sc.content,’’) as content, sc.template, sc.link_attributes FROM `didatticadb`.`modx_site_content` sc LEFT JOIN `didatticadb`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (1,2,5,7,8,11,15,33,39,32,4,37,46,6,9,3,18,16,22,14,24,44,42,43) GROUP BY sc.id ORDER BY sc.menuindex ASC ;

    Looks like a server cache-config issue to me; but I’d like to have more infos from MODx gurus about this before contacting the sys admin, since she already frowned on me for installing MODx instead of using Plone ...

    PHP Logo
    PHP Version 5.1.2
    
    System 	Linux  2.6.16.13-4-smp #1 SMP Wed May 3 04:53:23 UTC 2006 x86_64
    Build Date 	May 2 2006 10:00:24
    Configure Command 	'../configure' '--prefix=/usr' '--datadir=/usr/share/php5' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--with-libdir=lib64' '--includedir=/usr/include' '--sysconfdir=/etc/php5/apache2' '--with-config-file-path=/etc/php5/apache2' '--with-config-file-scan-dir=/etc/php5/conf.d' '--with-exec-dir=/usr/lib64/php5/bin' '--enable-magic-quotes' '--enable-libxml' '--enable-session' '--with-mm' '--with-pcre-regex' '--enable-xml' '--enable-simplexml' '--enable-spl' '--enable-safe-mode' '--enable-sigchild' '--disable-debug' '--enable-memory-limit' '--enable-inline-optimization' '--enable-zend-multibyte' '--disable-rpath' '--with-apxs2=/usr/sbin/apxs2' '--disable-all' '--disable-cli'
    Server API 	Apache 2.0 Handler
    Virtual Directory Support 	disabled
    Configuration File (php.ini) Path 	/etc/php5/apache2/php.ini
    Scan this dir for additional .ini files 	/etc/php5/conf.d
    additional .ini files parsed 	/etc/php5/conf.d/mysql.ini, /etc/php5/conf.d/mysqli.ini
    PHP API 	20041225
    PHP Extension 	20050922
    Zend Extension 	220051025
    Debug Build 	no
    Thread Safety 	disabled
    Zend Memory Manager 	enabled
    IPv6 Support 	enabled
    Registered PHP Streams 	php, file, http, ftp
    Registered Stream Socket Transports 	tcp, udp, unix, udg
    Registered Stream Filters 	string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*
    
    Zend logo This program makes use of the Zend Scripting Language Engine:
    Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
    
    PHP Credits
    Configuration
    PHP Core
    Directive	Local Value	Master Value
    allow_call_time_pass_reference	Off	Off
    allow_url_fopen	On	On
    always_populate_raw_post_data	Off	Off
    arg_separator.input	&	&
    arg_separator.output	&	&
    asp_tags	Off	Off
    auto_append_file	no value	no value
    auto_globals_jit	On	On
    auto_prepend_file	no value	no value
    browscap	no value	no value
    default_charset	no value	no value
    default_mimetype	text/html	text/html
    define_syslog_variables	Off	Off
    detect_unicode	On	On
    disable_classes	no value	no value
    disable_functions	no value	no value
    display_errors	Off	Off
    display_startup_errors	Off	Off
    doc_root	no value	no value
    docref_ext	no value	no value
    docref_root	no value	no value
    enable_dl	On	On
    error_append_string	no value	no value
    error_log	no value	no value
    error_prepend_string	no value	no value
    error_reporting	2039	2047
    expose_php	On	On
    extension_dir	/usr/lib64/php5/extensions	/usr/lib64/php5/extensions
    file_uploads	On	On
    highlight.bg	#FFFFFF	#FFFFFF
    highlight.comment	#FF8000	#FF8000
    highlight.default	#0000BB	#0000BB
    highlight.html	#000000	#000000
    highlight.keyword	#007700	#007700
    highlight.string	#DD0000	#DD0000
    html_errors	On	On
    ignore_repeated_errors	Off	Off
    ignore_repeated_source	Off	Off
    ignore_user_abort	Off	Off
    implicit_flush	Off	Off
    include_path	/home/didattica/public_html/manager/includes/	.:/usr/share/php5:/usr/share/php5/PEAR
    log_errors	On	On
    log_errors_max_len	1024	1024
    magic_quotes_gpc	Off	Off
    magic_quotes_runtime	Off	Off
    magic_quotes_sybase	Off	Off
    mail.force_extra_parameters	no value	no value
    max_execution_time	30	30
    max_input_time	60	60
    memory_limit	8M	8M
    open_basedir	no value	no value
    output_buffering	4096	4096
    output_handler	no value	no value
    post_max_size	8M	8M
    precision	14	14
    realpath_cache_size	16K	16K
    realpath_cache_ttl	120	120
    register_argc_argv	Off	Off
    register_globals	Off	Off
    register_long_arrays	Off	Off
    report_memleaks	On	On
    report_zend_debug	On	On
    safe_mode	Off	Off
    safe_mode_exec_dir	no value	no value
    safe_mode_gid	Off	Off
    safe_mode_include_dir	no value	no value
    sendmail_from	no value	no value
    sendmail_path	/usr/sbin/sendmail -t -i 	/usr/sbin/sendmail -t -i 
    serialize_precision	100	100
    short_open_tag	On	On
    SMTP	localhost	localhost
    smtp_port	25	25
    sql.safe_mode	Off	Off
    track_errors	On	Off
    unserialize_callback_func	no value	no value
    upload_max_filesize	2M	2M
    upload_tmp_dir	no value	no value
    user_dir	no value	no value
    variables_order	GPCS	GPCS
    xmlrpc_error_number	0	0
    xmlrpc_errors	Off	Off
    y2k_compliance	On	On
    zend.ze1_compatibility_mode	Off	Off
    
    apache2handler
    Apache Version 	Apache/2.2.0 (Linux/SUSE)
    Apache API Version 	20051115
    Server Administrator 	xxx
    User/Group 	wwwrun(30)/1000
    Max Requests 	Per Child: 10000 - Keep Alive: off - Max Per Connection: 100
    Timeouts 	Connection: 300 - Keep-Alive: 15
    Virtual Server 	No
    Server Root 	/srv/www
    Loaded Modules 	core prefork http_core mod_so mod_actions mod_alias mod_autoindex mod_cgi mod_dir mod_env mod_expires mod_include mod_log_config mod_mime mod_negotiation mod_setenvif mod_ssl mod_suexec mod_userdir mod_php5 mod_auth_basic mod_authn_file mod_authz_groupfile mod_authz_default mod_authz_user mod_authz_host mod_authn_dbm
    
    Directive	Local Value	Master Value
    engine	1	1
    last_modified	0	0
    xbithack	0	0
    
    Apache Environment
    Variable	Value
    HTTP_HOST 	xxx
    HTTP_USER_AGENT 	Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
    HTTP_ACCEPT 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    HTTP_ACCEPT_LANGUAGE 	en-us,en;q=0.5
    HTTP_ACCEPT_ENCODING 	gzip,deflate
    HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    HTTP_KEEP_ALIVE 	300
    HTTP_REFERER 	xxx
    HTTP_COOKIE 	SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; PHPSESSID=6gcaa3h0k2kvfjktpmi4jirr95; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; webfxtab_documentPane=1; webfxtab_childPane=1; webfxtab_resourcesPane=5; webfxtab_settingsPane=2
    HTTP_CONNECTION 	keep-alive
    PATH 	/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
    SERVER_SIGNATURE 	<address>Apache/2.2.0 (Linux/SUSE) Server at xxx Port 80</address>
    SERVER_SOFTWARE 	Apache/2.2.0 (Linux/SUSE)
    SERVER_NAME 	xxx
    SERVER_ADDR 	193.206.122.227
    SERVER_PORT 	80
    REMOTE_ADDR 	193.204.89.132
    DOCUMENT_ROOT 	/srv/www/htdocs
    SERVER_ADMIN 	xxx
    SCRIPT_FILENAME 	/home/didattica/public_html/manager/index.php
    REMOTE_PORT 	40716
    GATEWAY_INTERFACE 	CGI/1.1
    SERVER_PROTOCOL 	HTTP/1.1
    REQUEST_METHOD 	GET
    QUERY_STRING 	a=200
    REQUEST_URI 	/didattica/manager/index.php?a=200
    SCRIPT_NAME 	/didattica/manager/index.php
    
    HTTP Headers Information
    HTTP Request Headers
    HTTP Request 	GET /didattica/manager/index.php?a=200 HTTP/1.1
    Host 	xxx
    User-Agent 	Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
    Accept 	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    Accept-Language 	en-us,en;q=0.5
    Accept-Encoding 	gzip,deflate
    Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    Keep-Alive 	300
    Referer 	xxx
    Cookie 	SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; PHPSESSID=6gcaa3h0k2kvfjktpmi4jirr95; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; webfxtab_documentPane=1; webfxtab_childPane=1; webfxtab_resourcesPane=5; webfxtab_settingsPane=2
    Connection 	keep-alive
    HTTP Response Headers
    X-Powered-By 	PHP/5.1.2
    Expires 	Thu, 19 Nov 1981 08:52:00 GMT
    Last-Modified 	Mon, 21 May 2007 17:43:50 GMT
    Cache-Control 	no-store, no-cache, must-revalidate, post-check=0, pre-check=0
    Pragma 	no-cache
    Set-Cookie 	SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5
    Connection 	close
    Transfer-Encoding 	chunked
    Content-Type 	text/html; charset=UTF-8
    
    date
    date/time support 	enabled
    Timezone Database Version 	2005.18
    Timezone Database 	internal
    Default timezone 	Europe/Berlin
    
    Directive	Local Value	Master Value
    date.default_latitude	31.7667	31.7667
    date.default_longitude	35.2333	35.2333
    date.sunrise_zenith	90.583333	90.583333
    date.sunset_zenith	90.583333	90.583333
    date.timezone	no value	no value
    
    libxml
    libXML support 	active
    libXML Version 	2.6.23
    libXML streams 	enabled
    
    mysql
    MySQL Support	enabled
    Active Persistent Links 	0
    Active Links 	1
    Client API version 	5.0.18
    MYSQL_MODULE_TYPE 	external
    MYSQL_SOCKET 	/var/lib/mysql/mysql.sock
    MYSQL_INCLUDE 	-I/usr/include/mysql
    MYSQL_LIBS 	-L/usr/lib64 -lmysqlclient
    
    Directive	Local Value	Master Value
    mysql.allow_persistent	Off	Off
    mysql.connect_timeout	60	60
    mysql.default_host	no value	no value
    mysql.default_password	no value	no value
    mysql.default_port	no value	no value
    mysql.default_socket	no value	no value
    mysql.default_user	no value	no value
    mysql.max_links	Unlimited	Unlimited
    mysql.max_persistent	Unlimited	Unlimited
    mysql.trace_mode	Off	Off
    
    mysqli
    MysqlI Support	enabled
    Client API version 	5.0.18
    MYSQLI_SOCKET 	/var/lib/mysql/mysql.sock
    
    Directive	Local Value	Master Value
    mysqli.default_host	no value	no value
    mysqli.default_port	3306	3306
    mysqli.default_pw	no value	no value
    mysqli.default_socket	no value	no value
    mysqli.default_user	no value	no value
    mysqli.max_links	Unlimited	Unlimited
    mysqli.reconnect	Off	Off
    
    pcre
    PCRE (Perl Compatible Regular Expressions) Support 	enabled
    PCRE Library Version 	6.2 01-Aug-2005
    
    Reflection
    Reflection	enabled
    Version 	$Id: php_reflection.c,v 1.164.2.17 2006/01/01 12:50:12 sniper Exp $
    
    session
    Session Support 	enabled
    Registered save handlers 	files user mm
    Registered serializer handlers 	php php_binary
    
    Directive	Local Value	Master Value
    session.auto_start	Off	Off
    session.bug_compat_42	Off	Off
    session.bug_compat_warn	On	On
    session.cache_expire	180	180
    session.cache_limiter	nocache	nocache
    session.cookie_domain	no value	no value
    session.cookie_lifetime	0	0
    session.cookie_path	/	/
    session.cookie_secure	Off	Off
    session.entropy_file	no value	no value
    session.entropy_length	0	0
    session.gc_divisor	1000	1000
    session.gc_maxlifetime	1440	1440
    session.gc_probability	1	1
    session.hash_bits_per_character	5	5
    session.hash_function	0	0
    session.name	SN465181ed7055a	PHPSESSID
    session.referer_check	no value	no value
    session.save_handler	files	files
    session.save_path	/var/lib/php5	/var/lib/php5
    session.serialize_handler	php	php
    session.use_cookies	On	On
    session.use_only_cookies	Off	Off
    session.use_trans_sid	0	0
    
    SimpleXML
    Simplexml support	enabled
    Revision 	$Revision: 1.151.2.11 $
    Schema support 	enabled
    
    SPL
    SPL support	enabled
    Interfaces 	Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
    Classes 	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException
    
    standard
    Regex Library 	Bundled library enabled
    Dynamic Library Support 	enabled
    Path to sendmail 	/usr/sbin/sendmail -t -i
    
    Directive	Local Value	Master Value
    assert.active	1	1
    assert.bail	0	0
    assert.callback	no value	no value
    assert.quiet_eval	0	0
    assert.warning	1	1
    auto_detect_line_endings	0	0
    default_socket_timeout	60	60
    safe_mode_allowed_env_vars	PHP_	PHP_
    safe_mode_protected_env_vars	LD_LIBRARY_PATH	LD_LIBRARY_PATH
    url_rewriter.tags	a=href,area=href,frame=src,input=src,form=fakeentry	a=href,area=href,frame=src,input=src,form=fakeentry
    user_agent	no value	no value
    
    xml
    XML Support 	active
    XML Namespace Support 	active
    libxml2 Version 	2.6.23
    
    Additional Modules
    Module Name
    
    Environment
    Variable	Value
    TERM 	xterm
    get_module_list_done 	true
    LC_ALL 	POSIX
    COLUMNS 	80
    get_includes_done 	true
    PATH 	/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
    PWD 	/etc/apache2
    LANG 	POSIX
    LINES 	24
    SHLVL 	2
    _ 	/sbin/startproc
    PREVLEVEL 	N
    RUNLEVEL 	5
    DAEMON 	/usr/sbin/httpd2-prefork
    
    PHP Variables
    Variable	Value
    _REQUEST["a"]	200
    _REQUEST["SN465181ed7055a"]	qui4m45gcrubje8iu0271uf7k5
    _REQUEST["PHPSESSID"]	6gcaa3h0k2kvfjktpmi4jirr95
    _REQUEST["webfxtab_documentPane"]	1
    _REQUEST["webfxtab_childPane"]	1
    _REQUEST["webfxtab_resourcesPane"]	5
    _REQUEST["webfxtab_settingsPane"]	2
    _GET["a"]	200
    _COOKIE["SN465181ed7055a"]	qui4m45gcrubje8iu0271uf7k5
    _COOKIE["PHPSESSID"]	6gcaa3h0k2kvfjktpmi4jirr95
    _COOKIE["webfxtab_documentPane"]	1
    _COOKIE["webfxtab_childPane"]	1
    _COOKIE["webfxtab_resourcesPane"]	5
    _COOKIE["webfxtab_settingsPane"]	2
    _SERVER["HTTP_HOST"]	
    _SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
    _SERVER["HTTP_ACCEPT"]	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    _SERVER["HTTP_ACCEPT_LANGUAGE"]	en-us,en;q=0.5
    _SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
    _SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
    _SERVER["HTTP_KEEP_ALIVE"]	300
    _SERVER["HTTP_REFERER"]	
    _SERVER["HTTP_COOKIE"]	SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; PHPSESSID=6gcaa3h0k2kvfjktpmi4jirr95; SN465181ed7055a=qui4m45gcrubje8iu0271uf7k5; webfxtab_documentPane=1; webfxtab_childPane=1; webfxtab_resourcesPane=5; webfxtab_settingsPane=2
    _SERVER["HTTP_CONNECTION"]	keep-alive
    _SERVER["PATH"]	/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
    _SERVER["SERVER_SIGNATURE"]	<address>Apache/2.2.0 (Linux/SUSE) Server at </address>
    _SERVER["SERVER_SOFTWARE"]	Apache/2.2.0 (Linux/SUSE)
    _SERVER["SERVER_NAME"]	
    _SERVER["SERVER_ADDR"]	
    _SERVER["SERVER_PORT"]	80
    _SERVER["REMOTE_ADDR"]	
    _SERVER["DOCUMENT_ROOT"]	/srv/www/htdocs
    _SERVER["SERVER_ADMIN"]	...
    _SERVER["SCRIPT_FILENAME"]	/home/didattica/public_html/manager/index.php
    _SERVER["REMOTE_PORT"]	40716
    _SERVER["GATEWAY_INTERFACE"]	CGI/1.1
    _SERVER["SERVER_PROTOCOL"]	HTTP/1.1
    _SERVER["REQUEST_METHOD"]	GET
    _SERVER["QUERY_STRING"]	a=200
    _SERVER["REQUEST_URI"]	/didattica/manager/index.php?a=200
    _SERVER["SCRIPT_NAME"]	/didattica/manager/index.php
    _SERVER["PHP_SELF"]	/didattica/manager/index.php
    _SERVER["REQUEST_TIME"]	1179769430
    
    
    
      ----------------------------------------------------------
      http://www.linkedin.com/in/lucapost/
      http://www.twitter.com/lukwe/
      ----------------------------------------------------------
      • 33372
      • 1,611 Posts
      Looks like the Site Content table file was not created properly, since that error seems to be saying that the file was not found. I suspect a server issue rather than a MODx issue, but you never know. Why don’t you try running the installer again as an Update?
        "Things are not what they appear to be; nor are they otherwise." - Buddha

        "Well, gee, Buddha - that wasn&#39;t very helpful..." - ZAP

        Useful MODx links: documentation | wiki | forum guidelines | bugs & requests | info you should include with your post | commercial support options
        • 22303 MODX Staff
        • 10,725 Posts
        Sounds like the MySQL server is not configured properly. Check to make sure a valid datadir is set in your MySQL configuration file (my.cnf).
          • 17673
          • 194 Posts
          ...re-installing from scratch gives the same error; I’ll have the admin review the mySQL configs and let you know!
            ----------------------------------------------------------
            http://www.linkedin.com/in/lucapost/
            http://www.twitter.com/lukwe/
            ----------------------------------------------------------