Ok due to some DNS propogation issues we had to delete a new subdomain from our system and tried to add it back to the new site at a later date.
Anyways now when I try to add this subdomain to the new site I get the error below. (but the URL appears on the URL screen for the site afterwards)
I have tried deleting the url from the system root urls, removing from the designs folder etc and re-adding it but with no success.
Even though the Site URL gets updated the SITE URL screen, none of the child assets receive the URL in their web paths.
Any clues on where to look to resolve this error?
Fatal error: Uncaught exception 'Exception' with message 'Unable to insert lookup values for Site asset "NSSC" (#57079) due to database error: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "ast_lookup_value_pk"' in /var/www/matrix/core/assets/site/site.inc:630 Stack trace: #0 /var/www/matrix/core/hipo/jobs/hipo_job_update_lookups.inc(307): Site->updateLookups() #1 /var/www/matrix/core/hipo/hipo_job.inc(1263): HIPO_Job_Update_Lookups->processLookups(Array, 'hipo_job_update…') #2 /var/www/matrix/core/hipo/hipo_job.inc(1160): HIPO_Job->processWeb(Array, 'hipo_job_update…') #3 /var/www/matrix/core/hipo/hipo_herder.inc(209): HIPO_Job->process() #4 /var/www/matrix/core/include/mysource.inc(1391): HIPO_Herder->processWeb() #5 /var/www/matrix/core/include/mysource.inc(326): MySource->_processGlobalActions() #6 /var/www/matrix/core/include/init.inc(233): MySource->init() #7 /var/www/matrix/core/web/index.php(28): require_once('/var/www/matrix…') #8 {main} thrown in /var/www/matrix/core/assets/site/site.inc on line 630
OK Solved, we just manually deleted the reference to the URL in this table: sq_ast_lookup_value
When the url was deleted, a row was left in the table sq_ast_lookup_value.
I suspect when I deleted the URL from the site originally the hippo job failed before all the references were updated
Cheers Mat