no such table

Hi Ray

I think my local site has become corrupted somehow, as it can no longer find the local connection; all other sites work fine.

If I click on the connection in the WA_Database panel, it says 'No Tables found..'

If I try to set up a new connection, it can't find any databases.

Hope the screenshots help.

I've tried removing the connection scripts, rebuilding the site cache, but no difference.

Hope you have some ideas!

Thanks
Chris

This sounds like your database itself or local server may have issues. This error is coming from your database and not from Dreamweaver.

I did a google search for that error and found:
https://stackoverflow.com/questions/1676688/mysql-connection-not-working-2002-no-such-file-or-directory

Thanks Ray - all Greek to me! I still don't understand why all the other databases on localhost work fine.

Cheers
Chris

Try connecting to the database with php MyAdmin and repairing the database. Are you able to connect to the database through a php page directly?

Tried a repair and optimise - no difference. Can't access pages locally, though I can for other sites.

Baffled!

Cheers
Chris

Unfortunately I'm not a server configuration or database repairs expert and I think that is the source of your problem. Dreamweaver uses a php page to connect to your database, so if that can't be done then there is nothing in Dreamweaver you can change to fix it. First it has to work through php.

OK - thanks anyway.

Cheers
Chris

I have solved it - in a long-winded way!

Created a new site and database + new connection with the same name (worked fine). Copied all the site files across from the old to the new.

Everything working fine now.

Phew!

Thanks you for your willingness to help.

Cheers

Chris