Carlo Rizzante

Hello Ipstenu and thanks for your reply.

This is the first time I start from scratch setting up a WP Multisite on a fresh install of WP 3.6. That’s why I was asking what others’ experience was.

Before, I had no issue what so ever in setting up a Multisite and I did on several occasions. Also in local if you remember an earlier post of mine on a similar topic. Indeed most of the sites I work on are multisite at this stage.

Anyway, Wildcard subdomains have been setup. The domain is https://blablablubla.com and on cPanel I setup the subdomain *.blablablubla.com. I am confused as you may imagine that in this case WPMU with sub-domains returns an error on the second site.

When setting up WPMU with sub-directories I tried all the solutions I could find on this Forum and on other websites. Including adding on the wp-config.php and .htaccess code for resetting cookies. I tried the boilerplate .htaccess code as well. No luck with anything.

So I am not stressing you at this point.

Now I’m contacting the web host (Hostgator) ‘cos I’m starting suspecting that something else may be wrong on that cPanel (and I can’t figure it out).

Anyway, I’ll keep you posted. Thanks so far.

ps. I also made sure to have wildcards enabled on the cPanel.

I noticed the error as well.

Strict Standards: Redefining already defined constructor for class WXR_Parser_Regex in .../wp-content/plugins/wordpress-importer/parsers.php on line 408

Strict Standards: Declaration of WP_Import::bump_request_timeout() should be compatible with WP_Importer::bump_request_timeout($val) in /...wp-content/plugins/wordpress-importer/wordpress-importer.php on line 38

Just as a reminder that the issue still persists at the date I’m writing this comment.

Beside that, the import proceeds smoothly but it fails to import Custom Post Types not enabled by the current theme, as well as Taxonomies and Media files attached to them.

Thanks, Ipstenu. I did appreciate your support, and let’s see if there is a solution to my trouble ??
Best, Ciao!

Found it.

First of all, I was searching for the wrong line of code, wpdb::escape.

The string to look for is $wpdb->escape.

It is a little bit everywhere, mainly plugins.

In my case, it was in the file sunrise.php. In fact, commenting the following line in wp-config.php, makes the error disappear.

// define('SUNRISE', 'on');

However, I suppose that the solution is to fix the file sunrise.php itself.

Unfortunately, esc_sql() can’t be used, since apparently sunrise.php is been included before the function esc_sql() is even registered.

So, I looked up into esc_sql().

function esc_sql( $data ) {
	global $wpdb;
	return $wpdb->_escape( $data );
}

Therefore, in sunrise.php, I commented the original line that causes the trouble, and duplicated it right below, modifying it as such:

// $dm_domain = $wpdb->escape( $_SERVER[ 'HTTP_HOST' ] );
$dm_domain = $wpdb->_escape( $_SERVER[ 'HTTP_HOST' ] );

So far, so good. Hopefully this will help others somehow.

Hello,
I have a very similar error message.

Notice: wpdb::escape is deprecated since version 3.6! Use wpdb::prepare() or esc_sql() instead. in /Users/carlorizzante/Dropbox/Development/vhosts/factory.dev/wp-includes/functions.php on line 2876

It appeared after the automatic update to WordPress 3.6. I am not sure about what version I had before, but usually I perform an update session on a daily base if available for all components.

I deactivated all plugins and themes, and I also tried to rename the two folders for themes and plugins as well in “theme-old” and “plugins-old”. However, the error persists.

I searched inside all the files for “wpdb::escape” and I not found any.

I also downloaded from www.remarpro.com the zip file of WordPress 3.6, and I copied all files (overwriting all). It did not fix the issue.

So I am now clueless. Any suggestions? ??

Thanks for your patience, Ipstenu. I’ll try to explain. Here what I do in order to setup my development environment in local.

1. Install MAMP, Apache port :80, MySQL port :3306
2. Create a folder “Development” inside the folder “Dropbox”
3. Inside “Development” I create few sub folders:
— conf
— db
— vhosts
4.a. “conf” contains the file I paste below, that setups few virtual servers.
4.b. “db” is linked (symlink) with “Applications/MAMP/db”.
4.c. “vhosts” contains the virtual servers.
5. I open the Terminal, digit “sudo pico /etc/hosts” and setup few locahosts (see below).
6. I create a folder “sandbox.dev” into “vhosts” and I copy into it WordPress (v3.6).
7. I follow the standard procedure for setting up a WP Multisite (sub-domains or sub-folders).

// Details

4.a. Configuring MAMP for virtual hosting (example for sandbox.dev):

<virtualHost *:80>
	ServerName sandbox.dev
	ServerAlias sandbox.dev *.sandbox.dev
	DocumentRoot "/Users/carlorizzante/Dropbox/Development/vhosts/sandbox.dev/"
	<directory "/Users/carlorizzante/Dropbox/Development/vhosts/sandbox.dev/">
		Options Indexes FollowSymLinks Includes
		AllowOverride All
		Order allow,deny
		Allow from all
	</directory>
	CustomLog "/Users/carlorizzante/Dropbox/Development/logs/sandbox.dev-access.log" common
	ErrorLog "/Users/carlorizzante/Dropbox/Development/logs/sandbox.dev-errors.log"
</Virtualhost>

5. Terminal, localhosts:

# ## Sandbox WP Multisite
127.0.0.1 sandbox.dev
127.0.0.1 *.sandbox.dev
## END

As a note, sandbox.dev is one of the virtual host I’ve setup. Also, I am aware of the difference between a multisite with sub-domains and sub-directories. In production I have no problem, it is only in local that WP Multisite works with sub-domains, but not with sub-directories, and at this point I am lost.

Ok, so help me getting it.

I’m developing a WordPress Multisite with sub-directories (that it has to be online soon), and in order to work on it I would like to replicate the structure on my local machine.

How would you proceed? What kind of solution would you have in local to develop a WPMU with sub-directories? And how would you later convert one in an other?

Hello Ipstenu, and thanks for your reply.

Should it make any difference the reason why? In order to replicate what has to go live, I need a multisite with sub-directories.

And the default procedure to create a Multisite with sub-directories simply fails in local. At least for me.

Something else funny happens, indeed.

I’ve uploaded a file (a zip) and the file name changed, at the end, just before the extension, it has been added a _ somehow.

Example, original file name “file.zip”

File name after upload “file_.zip”

I can see that from the Media/Edit and when I try to download it. Then, the download goes smooth. But the _ at the end of the file name, I’ve never seen that before.

Hello Ipstenu,
sorry, I did not understand your question before. I’ve never used lesstools.com on that nameservers before.

But first, I resolved the permalink and redirection issues re-saving the permalink structure a couple of time, and using the WordPress MU Domain Mapping plugin (that’s the plugin I’m using).

Before mapping the second domain with the plugin, I tried a redirect via cpanel. It did not work that well.

I would like to understand more about it, specially after I’ve read that’s basically just an interface for something WordPress has already built in.

The problem related to permalinks was more tricky to figure it out for me. After I enabled the network all permalinks had been reset with the additional “blog/” path. I did not realize that I had to update the .htaccess. Once done, it worked just fine.

Thanks for your comments!
Carlo

Thanks, Patrick.

May I ask you one more question? I assume so and thanks in advance if you get the time to answer.

When, if I visit the Domain Mapping page of a site in the network (Dashboard > Tools > Domain Mapping), and I watch at the domains mapped with that site, I don’t have anymore site.primarysite.com but just a duplicated entry.

I expected to have something like

Primary Domain Delete
[x] https://site.com
[ ] https://site.primarysite.com

Instead I’ve a duplicated entry

Primary Domain Delete
[x] https://site.com
[ ] https://site.com

Is this correct? It happens for all the sites mapped to a parked domain.

By the way, I’ve mapped the domain I want to redirect with the relative site. So now I’ve this setup

Primary Domain Delete
[ ] https://site.com del
[x] https://site.org
[ ] https://site.org

And it works fine. Thanks for having clarified this!

Kindly,
Carlo

I indeed realize I’ve probably an other issue. Perhaps is not properly a problem, but just to stay on the safe side.

I mapped lesstools.org as primary domain for that site. When I created it it was lesstools.carlorizzante.com – Now, if I try to open lesstools.carlorizzante.com I’m actually redirected to https://carlorizzante.com/wp-signup.php?new=lesstools

There is a way to be redirected to lesstools.org, avoiding the signup template? Thanks, again! ??

Well, my intention is to use lesstools.org and have visitors redirected to lesstools.org when they hit lesstools.com – I’ve messed up with permalinks and such, but now I resolved that issue. It was enough to re-save the permalink structure a couple of times (which always puzzles me).

Now, my big doubt is how should I manage the redirection of a domain to an other domain inside a network. Should I map both .com and .org and set one of the two as primary? Or should I avoid the mapping of the one I’m not using except for redirection and set instead the redirection via cpanel?

Thanks for your support,
Carlo

Just to let you know, I noticed an invisible super admin as well in my network. So it might be something that happens quite regularly, possibly when an user has been deleted or its privileges modified.