So, if I get it right, you don't have to give that frontend-group any permissions in the security section?

I tried it like that, but that didn't seem to work, maybe because I tried logging in by using the backend login form. It would make sense to provide a frontend 'login form' as page type in the behaviour tab, so the group can actually access the pages.

A couple of quirks I've noticed:

If you don't have a typography.css or a layout.css, it includes the ones from /cms/css...I know you're supposed to have those files but still it doesn't seem like an intuitive fallback.

The other thing is that since upgrading, my local site doesn't know that it's local - ie, no $SilverStripeNavigator bar. Thanks to the magic of apache my local site is actually at www.thisismysite.local rather than just 'localhost', but the old SilverStripe could still tell (somehow).

Just a guess, MySQL 5 on NT changed to using stricter values for nulls, defaults and so on. There is a setting in my.ini for sql-mode that you could try fiddling with. NT mysql didn't like a '' default value for a numeric column but linux mysql happily turned it into a 0.

I ran across this with some different php/mysql app I was testing on both XP and Fedora, the install was fine on linux and errored on XP. It seems to me google turned up the specifics on what to change.

EDIT: in reply to Cifro's post.

======
Doug G
======

I ran into the same problem as Cifro (Win Vista 64 bit, Apache 2.2.6, PHP 5.2.4, MySQL 5.0.45 64 bit).

Obviously MySQL is not happy if you try to insert an empty string into a date field as noted bei Doug G.
The following (totally ugly) patch helps you get around that. I guess it would be generally better to insert null instead of emtpy strings, as Postgres won't be happy with that as well.

/silverstripe-v2.1.0-rc1/sapphire/core/model/Database.php:

339,340c339,340
< 							$this->query($sql, null);
< 						}
---
> 							$this->query($sql, null);			
> 						}					
347d346
< $fieldList = Database::replaceWithNull($fieldList);
358,372d356
< 	}
< 
< 	/** Replaces "''" with "null", recursively walks through the given array.
< 	* @ param string $array Array where the replacement should happen
< 	*/
< 	protected function replaceWithNull(&$array) {
< 		$array = str_replace('\'\'', "null", $array);
< 		if (is_array($array)) {
< 			foreach($array as $key => $value) {
< 				if (is_array($value)) {
< 					array_walk($array, array(Database, 'replaceWithNull'));
< 				}
< 			}
< 		}
< 		return $array;

Using ?flush=1 after the installation and it seems to have been working fine.

I was under the impression that Created and LastEdited were the same time when the page was created for the first time? This may have changed since the last time I had a problem, but if that's still the case then it looks like there might be something broken here.

I've filed a ticket at [url=http://open.silverstripe.com/ticket/1442]http://open.silverstripe.com/ticket/1442 for this.

When I make some changes to one of my pages and click on the "Save and publish"-button I get a "Published successfully"-message. So far so good, but when I click on any other page in the tree I get the "Unsaved changes"-modal message. I suppose it's not the way it should be, and I really don't think it's me... Not a big problem but a bit anoying...

On install
Building database schema...

( ! ) Fatal error: Cannot redeclare class HTML_BBCodeParser in /usr/local/php5/lib/php/HTML/BBCodeParser.php on line 84
Call Stack
# Time Memory Function Location
1 0.0003 77012 {main}( ) ../install.php:0
2 0.0041 94512 Installer->install( $config = array ('template' => 'default', 'go' => 'Installing SilverStripe...', 'database' => 'MySQLDatabase', 'mysql' => array ('server' => 'localhost', 'username' => 'root', 'password' => 'removed', 'database' => 'ss'), 'username' => 'admin', 'password' => 'password', 'firstname' => '', 'surname' => '', 'devsites' => 'localhost\r\n127.0.0.1', 'phpbb2mysql_data' => 'a:2:{s:11:"autologinid";s:0:"";s:6:"userid";i:-1;}') ) ../install.php:57
3 0.3399 1092132 ManifestBuilder::compileManifest( ) ../install.php:606
4 0.5471 1675508 ManifestBuilder::allClasses( $classManifest = array ('AssetAdmin' => '/Users/httpd/Sites/ss/cms/code/AssetAdmin.php', 'AssetTableField' => '/Users/httpd/Sites/ss/cms/code/AssetTableField.php', 'BulkLoader' => '/Users/httpd/Sites/ss/cms/code/BulkLoader.php', 'BulkLoaderAdmin' => '/Users/httpd/Sites/ss/cms/code/BulkLoaderAdmin.php', 'CMSActionOptionsForm' => '/Users/httpd/Sites/ss/cms/code/CMSActionOptionsForm.php', 'CMSHelp' => '/Users/httpd/Sites/ss/cms/code/CMSHelp.php', 'CMSMain' => '/Users/httpd/Sites/ss/cms/code/CMSMain.php', 'CommentAdmin' => '/Users/httpd/Sites/ss/cms/code/CommentAdmin.php', 'CommentTableField' => '/Users/httpd/Sites/ss/cms/code/CommentTableField.php', 'Diff' => '/Users/httpd/Sites/ss/cms/code/Diff.php', 'FileList' => '/Users/httpd/Sites/ss/cms/code/FileList.php', 'GenericDataAdmin' => '/Users/httpd/Sites/ss/cms/code/GenericDataAdmin.php', 'ImprintStats' => '/Users/httpd/Sites/ss/cms/code/ImprintStats.php', 'LeftAndMain' => '/Users/httpd/Sites/ss/cms/code/LeftAndMain.php', 'MemberList' => '/Users/httpd/Sites/ss/cms/code/MemberList.php', 'MemberTableField' => '/Users/httpd/Sites/ss/cms/code/MemberTableField.php', 'BatchProcess' => '/Users/httpd/Sites/ss/cms/code/Newsletter/BatchProcess.php', 'BouncedList' => '/Users/httpd/Sites/ss/cms/code/Newsletter/BouncedList.php', 'Newsletter' => '/Users/httpd/Sites/ss/cms/code/Newsletter/Newsletter.php', 'NewsletterEmailProcess' => '/Users/httpd/Sites/ss/cms/code/Newsletter/NewsletterEmailProcess.php', 'NewsletterList' => '/Users/httpd/Sites/ss/cms/code/Newsletter/NewsletterList.php', 'NewsletterType' => '/Users/httpd/Sites/ss/cms/code/Newsletter/NewsletterType.php', 'RecipientImportField' => '/Users/httpd/Sites/ss/cms/code/Newsletter/RecipientImportField.php', 'SubscribeForm' => '/Users/httpd/Sites/ss/cms/code/Newsletter/SubscribeForm.php', 'TemplateList' => '/Users/httpd/Sites/ss/cms/code/Newsletter/TemplateList.php', 'Unsubscribe' => '/Users/httpd/Sites/ss/cms/code/Newsletter/Unsubscribe.php', 'UnsubscribedList' => '/Users/httpd/Sites/ss/cms/code/Newsletter/UnsubscribedList.php', 'NewsletterAdmin' => '/Users/httpd/Sites/ss/cms/code/NewsletterAdmin.php', 'UserDefinedForm' => '/Users/httpd/Sites/ss/cms/code/PageTypes/UserDefinedForm.php', 'ReportAdmin' => '/Users/httpd/Sites/ss/cms/code/ReportAdmin.php', 'SecurityAdmin' => '/Users/httpd/Sites/ss/cms/code/SecurityAdmin.php', 'SideReport' => '/Users/httpd/Sites/ss/cms/code/SideReport.php', 'StaticExporter' => '/Users/httpd/Sites/ss/cms/code/StaticExporter.php', 'ThumbnailStripField' => '/Users/httpd/Sites/ss/cms/code/ThumbnailStripField.php', 'WidgetAreaEditor' => '/Users/httpd/Sites/ss/cms/code/WidgetAreaEditor.php', 'Akismet' => '/Users/httpd/Sites/ss/cms/code/sitefeatures/Akismet.php', 'MathSpamProtection' => '/Users/httpd/Sites/ss/cms/code/sitefeatures/MathSpamProtection.php', 'PageComment' => '/Users/httpd/Sites/ss/cms/code/sitefeatures/PageComment.php', 'PageCommentInterface' => '/Users/httpd/Sites/ss/cms/code/sitefeatures/PageCommentInterface.php', 'SSAkismet' => '/Users/httpd/Sites/ss/cms/code/sitefeatures/SSAkismet.php', 'Page' => '/Users/httpd/Sites/ss/mysite/code/Page.php', 'RSSFeed' => '/Users/httpd/Sites/ss/sapphire/api/RSSFeed.php', 'RestfulService' => '/Users/httpd/Sites/ss/sapphire/api/RestfulService.php', 'SapphireSoapServer' => '/Users/httpd/Sites/ss/sapphire/api/SapphireSoapServer.php', 'SimplePie' => '/Users/httpd/Sites/ss/sapphire/api/SimplePie.php', 'Spyc' => '/Users/httpd/Sites/ss/sapphire/api/Spyc.php', 'CliController' => '/Users/httpd/Sites/ss/sapphire/cli/CliController.php', 'DailyTask' => '/Users/httpd/Sites/ss/sapphire/cli/DailyTask.php', 'MonthlyTask' => '/Users/httpd/Sites/ss/sapphire/cli/MonthlyTask.php', 'ScheduledTask' => '/Users/httpd/Sites/ss/sapphire/cli/ScheduledTask.php', 'WeeklyTask' => '/Users/httpd/Sites/ss/sapphire/cli/WeeklyTask.php', 'ArrayData' => '/Users/httpd/Sites/ss/sapphire/core/ArrayData.php', 'ArrayLib' => '/Users/httpd/Sites/ss/sapphire/core/ArrayLib.php', 'ClassInfo' => '/Users/httpd/Sites/ss/sapphire/core/ClassInfo.php', 'Convert' => '/Users/httpd/Sites/ss/sapphire/core/Convert.php', 'Cookie' => '/Users/httpd/Sites/ss/sapphire/core/Cookie.php', 'Core' => '/Users/httpd/Sites/ss/sapphire/core/Core.php', 'Debug' => '/Users/httpd/Sites/ss/sapphire/core/Debug.php', 'Email' => '/Users/httpd/Sites/ss/sapphire/core/Email.php', 'Extension' => '/Users/httpd/Sites/ss/sapphire/core/Extension.php', 'HTTP' => '/Users/httpd/Sites/ss/sapphire/core/HTTP.php', 'ManifestBuilder' => '/Users/httpd/Sites/ss/sapphire/core/ManifestBuilder.php', 'Object' => '/Users/httpd/Sites/ss/sapphire/core/Object.php', 'Requirements' => '/Users/httpd/Sites/ss/sapphire/core/Requirements.php', 'SSViewer' => '/Users/httpd/Sites/ss/sapphire/core/SSViewer.php', 'Session' => '/Users/httpd/Sites/ss/sapphire/core/Session.php', 'ViewableData' => '/Users/httpd/Sites/ss/sapphire/core/ViewableData.php', 'ContentController' => '/Users/httpd/Sites/ss/sapphire/core/control/ContentController.php', 'ContentNegotiator' => '/Users/httpd/Sites/ss/sapphire/core/control/ContentNegotiator.php', 'Controller' => '/Users/httpd/Sites/ss/sapphire/core/control/Controller.php', 'Director' => '/Users/httpd/Sites/ss/sapphire/core/control/Director.php', 'FormResponse' => '/Users/httpd/Sites/ss/sapphire/core/control/FormResponse.php', 'HTTPResponse' => '/Users/httpd/Sites/ss/sapphire/core/control/HTTPResponse.php', 'ModelAsController' => '/Users/httpd/Sites/ss/sapphire/core/control/ModelAsController.php', 'NestedController' => '/Users/httpd/Sites/ss/sapphire/core/control/NestedController.php', 'RootURLController' => '/Users/httpd/Sites/ss/sapphire/core/control/RootURLController.php', 'ComponentSet' => '/Users/httpd/Sites/ss/sapphire/core/model/ComponentSet.php', 'CurrentPageIdentifier' => '/Users/httpd/Sites/ss/sapphire/core/model/CurrentPageIdentifier.php', 'DB' => '/Users/httpd/Sites/ss/sapphire/core/model/DB.php', 'DataObject' => '/Users/httpd/Sites/ss/sapphire/core/model/DataObject.php', 'DataObjectDecorator' => '/Users/httpd/Sites/ss/sapphire/core/model/DataObjectDecorator.php', 'DataObjectLog' => '/Users/httpd/Sites/ss/sapphire/core/model/DataObjectLog.php', 'DataObjectSet' => '/Users/httpd/Sites/ss/sapphire/core/model/DataObjectSet.php', 'Database' => '/Users/httpd/Sites/ss/sapphire/core/model/Database.php', 'DatabaseAdmin' => '/Users/httpd/Sites/ss/sapphire/core/model/DatabaseAdmin.php', 'ErrorPage' => '/Users/httpd/Sites/ss/sapphire/core/model/ErrorPage.php', 'GhostPage' => '/Users/httpd/Sites/ss/sapphire/core/model/GhostPage.php', 'HiddenClass' => '/Users/httpd/Sites/ss/sapphire/core/model/HiddenClass.php', 'Hierarchy' => '/Users/httpd/Sites/ss/sapphire/core/model/Hierarchy.php', 'Image' => '/Users/httpd/Sites/ss/sapphire/core/model/Image.php', 'MySQLDatabase' => '/Users/httpd/Sites/ss/sapphire/core/model/MySQLDatabase.php', 'RedirectorPage' => '/Users/httpd/Sites/ss/sapphire/core/model/RedirectorPage.php', 'SQLMap' => '/Users/httpd/Sites/ss/sapphire/core/model/SQLMap.php', 'SQLQuery' => '/Users/httpd/Sites/ss/sapphire/core/model/SQLQuery.php', 'SiteTree' => '/Users/httpd/Sites/ss/sapphire/core/model/SiteTree.php', 'Staged' => '/Users/httpd/Sites/ss/sapphire/core/model/Staged.php', 'Versioned' => '/Users/httpd/Sites/ss/sapphire/core/model/Versioned.php', 'VirtualPage' => '/Users/httpd/Sites/ss/sapphire/core/model/VirtualPage.php', 'Boolean' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Boolean.php', 'Currency' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Currency.php', 'DBField' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/DBField.php', 'Date' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Date.php', 'Datetime' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Datetime.php', 'Decimal' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Decimal.php', 'Enum' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Enum.php', 'Float' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Float.php', 'HTMLText' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/HTMLText.php', 'HTMLVarchar' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/HTMLVarchar.php', 'Int' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Int.php', 'Percentage' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Percentage.php', 'SSDatetime' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/SSDatetime.php', 'Text' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Text.php', 'Time' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Time.php', 'Varchar' => '/Users/httpd/Sites/ss/sapphire/core/model/fieldtypes/Varchar.php', 'Notifications' => '/Users/httpd/Sites/ss/sapphire/email/Notifications.php', 'QueuedEmail' => '/Users/httpd/Sites/ss/sapphire/email/QueuedEmail.php', 'QueuedEmailDispatchTask' => '/Users/httpd/Sites/ss/sapphire/email/QueuedEmailDispatchTask.php', 'Archive' => '/Users/httpd/Sites/ss/sapphire/filesystem/Archive.php', 'File' => '/Users/httpd/Sites/ss/sapphire/filesystem/File.php', 'Filesystem' => '/Users/httpd/Sites/ss/sapphire/filesystem/Filesystem.php', 'Folder' => '/Users/httpd/Sites/ss/sapphire/filesystem/Folder.php', 'GD' => '/Users/httpd/Sites/ss/sapphire/filesystem/GD.php', 'PostBackup' => '/Users/httpd/Sites/ss/sapphire/filesystem/PostBackup.php', 'TarballArchive' => '/Users/httpd/Sites/ss/sapphire/filesystem/TarballArchive.php', 'AjaxFormAction' => '/Users/httpd/Sites/ss/sapphire/forms/AjaxFormAction.php', 'AjaxUniqueTextField' => '/Users/httpd/Sites/ss/sapphire/forms/AjaxUniqueTextField.php', 'AutocompleteTextField' => '/Users/httpd/Sites/ss/sapphire/forms/AutocompleteTextField.php', 'BankAccountField' => '/Users/httpd/Sites/ss/sapphire/forms/BankAccountField.php', ...) ) ../ManifestBuilder.php:123
5 2.0564 21144452 include_once( '/Users/httpd/Sites/ss/sapphire/parsers/HTML/BBCodeParser/Filter/Basic.php' ) ../ManifestBuilder.php:199
6 2.1141 21153272 require_once( '/usr/local/php5/lib/php/HTML/BBCodeParser/Filter.php' ) ../Basic.php:28
7 2.1905 21314004 require_once( '/usr/local/php5/lib/php/HTML/BBCodeParser.php' ) ../Filter.php:2

And the results of pear l:
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.3.2 stable
Auth_SASL 1.0.2 stable
Cache 1.5.5RC4 beta
Cache_Lite 1.7.2 stable
Config 1.10.11 stable
Console_Getargs 1.3.4 stable
Console_Getopt 1.2.3 stable
Console_Table 1.0.7 stable
DB 1.7.12 stable
DB_DataObject 1.8.7 stable
DB_Pager 0.7 stable
Date 1.4.7 stable
Games_Chess 1.0.1 stable
Gtk_FileDrop 1.0.2 stable
HTML_AJAX 0.5.2 beta
HTML_BBCodeParser 1.2.2 stable
HTML_Common 1.2.4 stable
HTML_Common2 2.0.0beta1 beta
HTML_Form 1.3.0 stable
HTML_QuickForm 3.2.9 stable
HTML_QuickForm2 0.1.0 alpha
HTML_QuickForm_Controller 1.0.8 stable
HTML_Table 1.8.1 stable
HTML_TagCloud 0.1.1 beta
HTML_Template_IT 1.2.1 stable
HTML_TreeMenu 1.2.0 stable
HTTP 1.4.0 stable
HTTP_Request 1.4.1 stable
HTTP_Upload 0.9.1 stable
Image_Text 0.6.0beta beta
Log 1.9.11 stable
MDB 1.3.0 stable
MDB2 2.4.1 stable
MDB2_Driver_mysql 1.4.1 stable
MDB2_Driver_mysqli 1.4.1 stable
MDB2_Driver_sqlite 1.4.1 stable
MDB2_Schema 0.8.1 beta
MIME_Type 1.0.0 stable
Mail 1.1.14 stable
Net_SMTP 1.2.10 stable
Net_Socket 1.0.8 stable
Net_URL 1.0.15 stable
Net_UserAgent_Detect 2.3.0 stable
Numbers_Words 0.15.0 beta
PEAR 1.6.2 stable
PEAR_Command_Packaging 0.1.2 alpha
PEAR_Delegator 0.1.0 alpha
PEAR_Frontend_Gtk 0.4.0 beta
PEAR_Frontend_Web 0.7.1 beta
PEAR_Info 1.7.0 stable
PEAR_PackageFileManager 1.6.1 stable
PEAR_PackageFileManager_Frontend 0.7.0 alpha
PEAR_PackageFileManager_Frontend_Web 0.6.0 alpha
PEAR_PackageFileManager_GUI_Gtk 1.0.1 stable
PEAR_PackageUpdate 0.7.0 beta
PEAR_PackageUpdate_Gtk2 0.3.2 beta
PEAR_PackageUpdate_Web 0.4.0 beta
PEAR_RemoteInstaller 0.3.1 alpha
PHP_Compat 1.6.0a1 alpha
PHP_CompatInfo 1.4.3 stable
PHP_DocBlockGenerator 1.1.1 stable
PHP_FunctionCallTracer 1.0.0 stable
Pager 2.4.4 stable
PhpDocumentor 1.4.0 stable
QA_Peardoc_Coverage 1.1.0 stable
SCA_SDO 1.2.3 stable
SQL_Parser 0.5 devel
Services_Trackback 0.6.1 beta
Structures_Graph 1.0.2 stable
System_Command 1.0.6 stable
Text_CAPTCHA 0.3.1 alpha
Text_CAPTCHA_Numeral 1.2.0 stable
Text_Diff 0.2.1 beta
Text_Figlet 1.0.0 stable
Text_Highlighter 0.7.0 beta
Text_Password 1.1.0 stable
Text_Wiki 1.2.0 stable
Validate 0.7.0 beta
Var_Dump 1.0.3 stable
XML_Beautifier 1.1 stable
XML_DTD 0.4.2 alpha
XML_Parser 1.2.8 stable
XML_RPC 1.5.1 stable
XML_Tree 2.0.0RC2 beta
XML_Util 1.1.4 stable

Trying to upgrade an existing installation(test) with data pages
in it (a 2.0.2b installation) allows me to get to the data pages
but not the CMS.
I upgraded by copying cms, jsparty, and sapphire from a clean 2.1.0rc1
installation. Then doing a db/build?flush=1 and a home?flush=1
I get the error when attempting /admin (which is redirected to /Security/login
and I never actually get the login page) and generates the error:

Fatal error: Call to undefined method stdClass::allMethodNames() in /var/www/html/w/sapphire/core/Object.php on line 203

However taking a clean 2.0.2rc2 installation, and upgrading it I
can access the cms as normal.

My installation was originally based off of 2.0.2b. I have tried installing
a clean 2.0.2rc2 then overlaying the mysite, and assets from
my 2.0.2b directory and restoring the database.
That works (running as a 2.0.2rc2) to access data and cms.
But then when I attempt to upgrade to 2.1.0rc1 from there, I have the same
problem with accessing the CMS.

It obviously is something to do with the database but I don't know what.
I can point my updated installation code (2.0.2rc1) to the clean
2.0.2rc1 database and it works to access the CMS (of course the formating
is from my css and templates and I don't have access to my data since
I'm pointing to a clean database).

Since I have the problem in the login of the cms (since I can't get past
that. I looked at the differences (my upgraded database and a clean 2.0.2rc1
database) in the Group and Member tables. They match with the expected changes
in dates, names, and passwords.

Looking at sapphire/core/Object.php the error is coming from "addMethodsFrom",
could this mean that there is a problem with a function in one of
my code (page) extensions? Would that have not been caught in the db/build?flush=1
or the access of the page (after flushing) but caught in the CMS initialization?

Looking at some of the other comments, I built my installation from modifying the tutorial (so
I didn't have Blackcandy). In the clean installations I installed with the blackcandy template.
Could this be a possible cause?

I've actually been having the problem with the daily builds from 7Sep and 9Sep as well.