I did what edwardsmark describes:
my problem was actually two-fold:
1) the following tables had to be removed
2) then i just started over from the beginning.
also, one of the plug-ins has to be disabled every time i create a new site, and then enabled afterwards. i can live with that !
And I was finally able to re-install the network, that was great, a first!
However, once I made a new sub-domain I ended up with the same original problem when trying to access the sub-domain web site:
Error establishing a database connection
I then removed the following config code (again):
define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', true );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'e-worldreview.com' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );
Once I take this out I can access the sub-domain web site but then I can't access the sub-domain through the the multi-site directory sense it's been removed.(?)
I've had HostGator tech help me twice with this and everything in the .htaccess and config files is always right.
HostGator changed my config file back to the original status which didn't have the above multi-site code in it, that is how I found removing the above code to allow me to access my sub-domain sites through URL address but not through the web site admin page sense that code was removed. (Am I making sense?)
So, can someone - Andrea_r - help me out here what the heck am I doing wrong that I can't get this to work.
I've been beating my head on this for over a month now, I'm about to give up and just use individual sub-domain creation - Agh!!!