search

silverstripe-archive / silverstripe-newsletter

NewsletterAdmin is the CMS class for managing the newsletter system.
BSD 3-Clause "New" or "Revised" License
69 stars 59 forks source link

PHP Fatal error: MySQLDatabase.php on line 580 #49

Closed Clustmart closed 11 years ago

Clustmart commented 11 years ago

Hi,

after installing branch "Master" in Silverstripe 3.0.5, I get following error in the webserver log. Please advise. PHP Fatal error: Couldn't run query: \nSELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."Created", "SiteConfig"."LastEdited", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."GlobalUnsubscribe", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName"\nFROM "SiteConfig"\nLIMIT 1 \n\nUnknown column 'SiteConfig.GlobalUnsubscribe' in 'field list' in /localhost/framework/model/MySQLDatabase.php on line 580

Thanks!

wilr commented 11 years ago

Done a dev/build?

Clustmart commented 11 years ago

Yes, I did. And also a flush

Clustmart commented 11 years ago

ok, it seems that build doesn't finish well... I am redirected to http://localhost/Security/login?BackURL=%2Fs4h%2Fdev%2Fbuild and in server log I got PHP Fatal error: Couldn't run query: \nSELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."Created", "SiteConfig"."LastEdited", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."GlobalUnsubscribe", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName"\nFROM "SiteConfig"\nLIMIT 1 \n\nUnknown column 'SiteConfig.GlobalUnsubscribe' in 'field list' in /localhost/framework/model/MySQLDatabase.php on line 580, referer: http://localhost/dev/build Now the entire site is messy.

Clustmart commented 11 years ago

Luckily, that redirect to login page made me to reconsider. Why should I be redirected? The answer is simple: I wasn't logged in and naturally I shoudn't can build....

Again, I did build and now it's working