Magento Staging - Only the front page shows

I'm attempting to create an Magento staging site and have managed to get the front page to work, but none of the product pages show saying: 'Not Found. The requested URL /couch-rolls.html was not found on this server.' I.E. not a 404 message.

The sub domain is in a parallel directory to the main site, not a sub directory - that's how our hosts does it (using Direct Access).

I've created a copy of the existing database, changed the password for the copy and changed the base_url values in core_config_data

I've amended the staging /app/etc/local.xml with the new database username, password and dbname.

In Magento Admin Panel, there's a separate shop for which I've altered the store view secure and unsecured Base Url fields.

I've deleted /var/cache/* and flushed everything 开发者_如何学编程I can think of but now I've run out of ideas.

So help (please)!

---

you also have to rebuild indexes if you copy your database and verify that the .htaccess and mod_rewrite is in place