Error when running /dev/build

[abitran]

After updating my google-analytics module with composer, I get the following error when running /dev/build:

Couldn't run query: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."Created", "SiteConfig"."LastEdited", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."Locale", "SiteConfig"."GoogleAnalyticsCode", "SiteConfig"."GoogleAnalyticsProfileId", "SiteConfig"."GoogleAnalyticsEmail", "SiteConfig"."GoogleAnalyticsPassword", "SiteConfig"."UseGoogleUniversalSnippet", "SiteConfig"."GlobalUnsubscribe", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName" FROM "SiteConfig" WHERE ("SiteConfig"."Locale" = 'en_US') LIMIT 1 Unknown column 'SiteConfig.UseGoogleUniversalSnippet' in 'field list'

SS 3.1.x-dev

[wilr]

SilverStripe is querying SiteConfig as part of the build process. You'll need to put the website into 'dev' mode and then rebuild your database so it doesn't check site config or use the CLI wrapper.

[abitran]

But my website is already in dev mode:
/* What kind of environment is this: development, test, or live (ie, production)? */
define('SS_ENVIRONMENT_TYPE', 'dev');

/AB

[wilr]

Then I would try use the cli version (sake dev/build) or go into your database and drop the entire siteconfig table and rebuild from scratch. Please use the forum or IRC issue for support questions.

[abitran]

I'm always on IRC :) thanks wilr! will try the cli version.

abitran

[abitran]

Ok.. I tried sake, without success, then I drop the SiteConfig table with the googleanalytics module installed and was impossible to recreate the SiteConfig table. Then I erased the googleanalytics folder and edit _config.php, rerun /dev/build and the SiteConfig table was created. Again I tried with the googleanalytics module, and after running /dev/build, the same error:
Unknown column 'SiteConfig.GoogleAnalyticsCode' in 'field list'

abitran

[silverstripesk]

hi guys, why is this issue closed? Error is still there. SS 3.1.5 dev/build works fine, latest SS produces this error...

[wilr]

This is closed because the module cannot do anything about it. It's a SilverStripe limitation that querying the SiteConfig / Member tables while doing migrations need to either be done in dev or cli modes. Not the modules responsibility.

[silverstripesk]

Of course, I tried it in DEV mode via URL and with sake also, but no success.
How to reproduce it? Install clean SS 3.1.5 with your module, after switch to latest SS version. DEV/BUILD is impossible even using sake...

[laminbarrow]

I have had a similar issue today and in the end, i found out that i have some code that was extending the "Controller" class and in it, i have some code that was referring "SiteConfig" in the "afterInit" method . The controller class get called in the dev/build process and at that point your siteconfig dataextension tables have not been created yet.

TO fix it, i simply change my code to extend "ContentController" instead of the base "Controller" and the issue was solved.