Subdirectory Multisite 404 error

Hello. I’ve been having trouble with adding sites to my Multisite install. I’m using subdirectory. example.com works but example.com/site leads to a 404 error.

Starting with a fresh install of WordPress I added this line to wpconfig.php

/* Multisite */
define( 'WP_ALLOW_MULTISITE', true );

After setting up Multisite through the dashboard I followed the directions adding this to wpconfig.php (under the first line I added)

define('MULTISITE', true);
define('SUBDOMAIN_INSTALL', false);
define('DOMAIN_CURRENT_SITE', 'example.com');
define('PATH_CURRENT_SITE', '/');
define('SITE_ID_CURRENT_SITE', 1);
define('BLOG_ID_CURRENT_SITE', 1);

then I replaced the existing lines in .htaccess, so that it now has this

# BEGIN WordPress
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]
# END WordPress

After doing this and setting up the first site in the network I get the 404 error when trying to edit or view that site.

I’m using shared hosting through Godaddy. Been reading other posts but still confused with the problem. Should I be using a domain mapping plugin to redirect the subdirectory site? WordPress is installed in the root. I have other sites on the same hosting account, could that be the problem?