motherswhowork

Hi there,

Thanks for those tips – it’s still not working.

I’m not sure why – I revoked access, then started again using the instructions you set out and changed the access to read and write, but it is still not tweeting.

When I try to tweet from the post page, the clock comes up at the top and just keeps going even when the page has fully reloaded…but nothing happens.

Just wanted to say thank for all your help – in the end my host needed to make some server-side tweaks to get everything working again!

Thanks

You have PHPMyAdmin, right? You should be able to see what permissions you have on that database.

Hi,

Where can I find this?

No. Not your admin login. Your SQL database login. The account listed as username in your wp-config.php

They are saying that there is no SQL database login!!! 1and1 can be a real nightmare sometimes!

I’ve just spent more than an hour on the phone to them, and they don’t seem to know or understand what I’m talking about.

Ask your host if your SQL id has the rights to create new DB tables?

Tell them which ID you use to connect to the DB with (it’s listed in wp-config as your username).

Do you mean as them if my admin login has rights?

Can I quickly add that whenever I add a site it creates a user with the name of the site – so it I set one up called “test”, it creates a user with that name, and admin isn’t automatically listed…

Not sure if that makes a difference to this whole database tables thing..

Go look in the database – I suspect the tables for each new blog aren;t getting created. look under Super Admin -> Sites at the list and see the number in front of the /jatest/ blog. Now go look in the db for wp_THATNUMBER_posts.

If it’s not there, that’s your problem.

Oh good!

I checked, and no – no tables are being created…very odd.

Do you know why/how to fix this?

Error establishing a database connection

Same here – but I don’t know why this would happen if multisite uses one database…

No, not where the link goes. Give me the URL to a new blog you just created.

Ok – here is one: https://www.motherswhowork.co.uk/jatest/

Sorry! ??

It goes to: https://www.motherswhowork.co.uk/wp-admin/

Hi Andrea,

When it tries to create a new blog, what address does it give?

It gives the url of the blog, but when I click on it it takes me to the wp-admin of the main site…very strange.

Ok, so I’ve got some information from my web designer who did the initial move an database work:

Here’s what we’ve done with the DB so far:
When we moved the site, I did a search / replace on the database across the database on my local machine before re-uploading the database to the server via SSH – with an aim to remove all instances of /cms from the database. This was pretty tricky as the file when opened was around 100MB. As such I wouldn’t be able to say if I caught all of the instances, but I certainly covered all of the obvious angles (such as the multisite blog tables / options tables), along with all instances of /cms where site_url and home was set. It’s worth perhaps bearing in mind that when your site was broken into, we had to replace the post tables with an older backup, which contains links to /cms areas of the site still (for instance with images etc).

I have spotted some instances of the /folder in the database, though these are not in the core structural files… these are being replaced as we speak.

Also (sorry!) whenever I create a new site, WP automatically takes the sites name as the username – not admin, which I am permanently logged in as…I thought I’d mention that in case it gave any clues about what’s going on.

Hi Andrea,

deactivating the Redirection plugin doesn’t help…

When I deactivated, I also updated (Site Admin > Update), but the following error message came up:

Warning! Problem updating . Your server may not be able to connect to sites running on it. Error message: A valid URL was not provided.

This is probably why you’re having issues.

Really? Will deactivating/deleting the plugin fix the issue?

Either way, though, Andrea’s right about checking the whole DB. And the killer? Not all of it is easy to find when you’re doing that move. You’ll also need to search for ‘folder’ (i.e. the old folder name) and be VERY careful replacing.

Is there a simple find and replace plugin or script that can do this?

Hi Andrea,

My web designer did the change, but I think it did all of that. I can see in the wp-config file that the directory shows the domain.co.uk as it should be.

We installed the redirection plugin, which he configured to redirect old links from the /folder/ url to point to the new path on the yourdomain.co.uk path.