Sitemap Generation Issue - URLBuilder - must be type of string - error

[digitalstartup]

@live4soccer7

Is this table: catalog_product_entity_media_gallery

suppose to have varchar(255) NULL with no default value?

Yes. Here is a screenshot of a vanilla database

@live4soccer7

There is a setting in the back of magento that says to include images or not in the sitemap. I changed this to no and it generated without issues on the default magento sitemap generation.

Good spot!

@live4soccer7

I’ll go back and c:c, reindex, recompile, deploy-static content. Pretty sure that covers everything. They need a command that just does everything.

You can string commands together in SSH by using “&&”. So, an example of this might look like:

Before

rm -rf var/cache/* var/page_cache/* generated/code/*
bin/magento setup:upgrade
bin/magento setup:di:compile
bin/magento setup:static-content:deploy en_US en_GB -f
bin/magento indexer:reindex
bin/magento cache:clean
bin/magento cache:flush

After

rm -rf var/cache/* var/page_cache/* generated/code/* && bin/magento setup:upgrade && bin/magento setup:di:compile && bin/magento setup:static-content:deploy en_US en_GB -f && bin/magento indexer:reindex && bin/magento cache:clean && bin/magento cache:flush