aizik

Tobias, thanks,

You were right. I increased the memory in wp_settings and now everything is working. The larger tables take a bit to load, but they don’t break anymore. I had changed it in php.ini but WP_MEMORY_LIMIT was missing.

Thanks again!

You are right… in WP System Health it shows only 64MB in memory.

How can I increase it?

System:

Server Setup: show detailed ?
OS Type Linux srv-linux01 2.6.33.3-85.fc13.x86_64 #1 SMP Thu May 6 18:09:49 UTC 2010 x86_64
Server Software Apache/2.2.15 (Fedora)
PHP Version 5.3.3
MySQL Server 5.1.45
Memory Limit 64 MB
Server Quota’s: access not permitted or quota not configured.
Server Locale: show detailed ?
date/time
(LC_TIME) C
Load Average: show detailed ?
last 1 minute 0,15
Checkpoints: show detailed ?
Rendering Dashboard
(callback:dashboard)
73,09 %
46,78 MB | Will be passed during generation of this Dashboard Overview.

PHP:

PHP Version 5.3.3
Runtime Configuration: show detailed ?
Maximum Execution Time
(max_execution_time) 30 seconds
This sets the maximum time in seconds a script is allowed to run before it is terminated by the parser.
File Upload Settings: ? collapse
HTTP File Upload
(file_uploads) On
Whether or not to allow HTTP file uploads.
Temporary Directory
(upload_tmp_dir)
The temporary directory used for storing files when doing file upload.
Maximum File Size
(upload_max_filesize) 200 MB
The maximum size of an uploaded file.
Data handling: show detailed ?
Language Options: show detailed ?
Short Open Tags
(short_open_tag) Off
Tells whether the short form (<? ?>) of PHP’s open tag should be allowed.
Security and Safe Mode: show detailed ?
Remote open Files
(allow_url_fopen) On
This option enables the URL-aware fopen wrappers that enable accessing URL object like files. Should be disabled for security reasons, to prevent remote file inclusion attacks.
PHP Safe Mode
(safe_mode) Off
Whether to enable PHP’s safe mode.
Open Basedir
(open_basedir)
Limit the files that can be opened by PHP to the specified directory-tree, including the file itself. This directive is NOT affected by whether Safe Mode is turned On or Off.

WP:

Core Information: show detailed ?
Version 3.1
Installation Type Multi Site Installation
Automatic Updates: show detailed ?
Language
(WPLANG) es_ES
Language
(get_locale) es_ES
Update Method
(evaluated) direct
Describes the layer been used to performs automatic updates at your WordPress installation.
System Constants: show detailed ?
Post Revision Handling
(WP_POST_REVISIONS) no limit
Whether to skip, enable or limit post revisions.
Automatic Save Interval
(AUTOSAVE_INTERVAL) 60 seconds
Post/Page Editor time interval for sending an automatic draft save.
Empty Trash Interval
(EMPTY_TRASH_DAYS) 30 days
Constant controls the number of days before WordPress permanently deletes posts, pages, attachments, and comments, from the trash bin.
HTTP Transport: ? collapse
PHP libcurl
(curl) Yes
Allows you to connect and communicate to many different types of servers with many different types of protocols.
PHP Streams API
(streams) No
Streams were introduced with PHP 4.3.0 as a way of generalizing file, network, data compression, and other operations which share a common set of functions and uses.
function fopen
(fopen) No
Opens file or URL.
function fsockopen
(fsockopen) No
Open Internet or Unix domain socket connection
Built-in HTTP
(exthttp) No
It eases handling of HTTP URLs, dates, redirects, headers and messages and more.

It partially worked.

With all the plugins deactivated all the tables worked except 1. I will try increasing the execution time limit.

After activating the plugins I found a conflict with:
Exec-PHP
TDO Miniforms
WP-Polls

I think that it is a bit odd, since I’m don’t have any polls and the TDO forms and Tables are not on the same post. Could they conflict even if not loaded on the same post?

Is anyone else experiencing conflicts with these plugins?

Reading other posts I found that php memory might be an issue… our limit is set to 128MB…

It worked!

I feel bad to admit that the problem was something simpler. The Hyper Cache plugin was breaking the links. I had purged the Cache and the plugin was only active for 1 of the sites but it still affected all of them.

Thanks for all the help!

Bingo!

I don’t see a wp_1_options table. There is a wp_options table that has the information for the main site.

What should I do now?

These are the tables I have:
`help_desk
help_desk_knowledgebase
help_desk_ticket
wp_3_commentmeta
wp_3_comments
wp_3_links
wp_3_options
wp_3_postmeta
wp_3_posts
wp_3_terms
wp_3_term_relationships
wp_3_term_taxonomy
wp_3_ue1_cache
wp_4_commentmeta
wp_4_comments
wp_4_links
wp_4_options
wp_4_postmeta
wp_4_posts
wp_4_terms
wp_4_term_relationships
wp_4_term_taxonomy
wp_blogs
wp_blog_versions
wp_bp_activity
wp_bp_activity_meta
wp_bp_friends
wp_bp_groups
wp_bp_groups_groupmeta
wp_bp_groups_members
wp_bp_messages_messages
wp_bp_messages_notices
wp_bp_messages_recipients
wp_bp_notifications
wp_bp_xprofile_data
wp_bp_xprofile_fields
wp_bp_xprofile_groups
wp_calendar
wp_calendar_categories
wp_calendar_config
wp_commentmeta
wp_comments
wp_connections
wp_connections_terms
wp_connections_term_relationships
wp_connections_term_taxonomy
wp_eg_attachments_clicks
wp_eventscalendar_main
wp_faqtastic_groups
wp_faqtastic_questions
wp_faqtastic_related
wp_links
wp_options
wp_pollsa
wp_pollsip
wp_pollsq
wp_postmeta
wp_posts
wp_registration_log
wp_signups
wp_site
wp_sitemeta
wp_statpress
wp_tdomf_table_edits
wp_tdomf_table_forms
wp_tdomf_table_sessions
wp_tdomf_table_widgets
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_ue1_cache
wp_usermeta
wp_users `

This is stranger than I thought. Now I’m convinced that the redirect is working in Chrome but nothing else. In Chrome I can download uploaded files, see images, etc. and the same url does not work in Safari, Firefox or IE.

What is going on?!

andrea, what do you mean?

The actual location is:

/home/mayore99/public_html/intranet

I added the <ifmodule> nothing changed.

The htaccess is eaxctly the same as in Network page.

wp-config I’m not sure if everything is ok. It is as follows:

<?php
/**
 * The base configurations of the WordPress.
 *
 * This file has the following configurations: MySQL settings, Table Prefix,
 * Secret Keys, WordPress Language, and ABSPATH. You can find more information by
 * visiting {@link https://codex.www.ads-software.com/Editing_wp-config.php Editing
 * wp-config.php} Codex page. You can get the MySQL settings from your web host.
 *
 * This file is used by the wp-config.php creation script during the
 * installation. You don't have to use the web site, you can just copy this file
 * to "wp-config.php" and fill in the values.
 *
 * @package WordPress
 */

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'mayore99_wp');

/** MySQL database username */
define('DB_USER', 'XXXXXX');

/** MySQL database password */
define('DB_PASSWORD', 'XXXXXX');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

/** Activar Hyper Cache plugin */

define('WP_CACHE', true);

/** Activar MultiSite */

//define('WP_ALLOW_MULTISITE', true);
define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', false );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'intranet.mayoreoelectrico.com' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

define( 'AUTH_SALT', '~t+x0O+;<code>e;z37Mj49s</code>@a-T%HPbj}~T9Jz[PqT*pP(la)+HgG_nei~-N<w-88vh' );
define( 'SECURE_AUTH_SALT', 'b}2<{J([email protected]+i.n<@K]AuIP}bvT+s~8a}@.M) gI4H+A|<{pK!:2A9Q,9I' );
define( 'LOGGED_IN_SALT', 'pdKWCuGk/d~[njgrx4HK,d!x?mihs7z|

Gyx|Sqih0U:BF8pXPr|{+WKV[WWi8Cs' );
define( 'NONCE_SALT', 'ofa$N

KkC%,EDSZ>e{wTxV^{e@>0NnVZn#3]q]kzZgI.uW{/w#!dPD-F8yf~(HW<' );

/**#@+
 * Authentication Unique Keys.
 *
 * Change these to different unique phrases!
 * You can generate these using the {@link https://api.www.ads-software.com/secret-key/1.1/ www.ads-software.com secret-key service}
 *
 * @since 2.6.0
 */
define('AUTH_KEY', 'XXXXX');
define('SECURE_AUTH_KEY', 'XXXXXX');
define('LOGGED_IN_KEY', 'XXXXX');
define('NONCE_KEY', 'XXXXX');
/**#@-*/

/**
 * WordPress Database Table prefix.
 *
 * You can have multiple installations in one database if you give each a unique
 * prefix. Only numbers, letters, and underscores please!
 */
$table_prefix  = 'wp_';

/**
 * WordPress Localized Language, defaults to English.
 *
 * Change this to localize WordPress.  A corresponding MO file for the chosen
 * language must be installed to wp-content/languages. For example, install
 * de.mo to wp-content/languages and set WPLANG to 'de' to enable German
 * language support.
 */
define ('WPLANG', 'es_ES');

/* That's all, stop editing! Happy blogging. */

/** WordPress absolute path to the WordPress directory. */
if ( !defined('ABSPATH') )
	define('ABSPATH', dirname(__FILE__) . '/');

/** Sets up WordPress vars and included files. */
require_once(ABSPATH . 'wp-settings.php');
?>

Not sure if the Abspath would have anything to do with it.

On one of the sites I do have many plugins active, but on the other 2 sites there are no plugins and the same happens.

Thanks again…

I don’t think so… this is the full htaccess file:

# BEGIN WordPress
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# uploaded files
RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule  ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule  ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]

# END WordPress

AuthUserFile 	/dev/null
AuthGroupFile 	/dev/null
AuthType 	Basic
AuthName 	"AllowFrom"

<Limit GET POST>
order deny,allow
deny from all
allow from xx.xx.xx.xx
</Limit>

Yes, the site is blocked by IP, I posted the link for reference only as an example…

Why could it be that the file path with wp-content is working but not without it?

I’ve gone through the htaccess and it seems ok, also the Upload Path site option and the files are uploading correctly.

Changed the upload path to wp-content/blogs.dir/1/files

The files are uploaded to the right directory

Still do not display (actually they display ok in Chrome, the browser I used to upload them, but not in any other browser).

https://intranet.mayoreoelectrico.com/files/2010/05/mem_small.png does not display
https://intranet.mayoreoelectrico.com/wp-content/files/2010/05/mem_small.png works

My htaccess file seems fine, so my problem should be something else. Here is my htaccess

RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]

# uploaded files
RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ – [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]

My guess is that it could be something in the site option. I was thinking that the upload path (although the files are being uploaded to the correct directory, just not displaying)
My Upload Path is:/public_html/intranet/files/ (intranet is where wordpress is installed)

Same problem, how can I fix it?

I do have <?php wp_head(); ?>