I've just moved a site I developed on a local WAMP setup to a LAMP server by migrating the MYSQL database, then copying the SS2.2.2 directory over. Had to tinker with the .htaccess because I moved the install from the a subdirectory to the root, and to default to PHP5, and had to edit the _config.php for the new MYSQL connection details, but the site now comes up fine.
However, now at the new location when I connect to the CMS I have 2 problems:
1) I can't edit the password on the admin account to change it from the default - the admin user doesn't even show up on the user list even though I'm logged in as admin.
2) When I save & publish changes or new pages in the CMS, they're not reflected on the site, even with the flush keyword specified.
It's been mentioned that there may be some case sensitivity issues with the migration from WAMP to LAMP, and I suppose there could be some issues related to the fact that the development box was running MySQL 5.0.something and the deployment server is on 4.1.something.
Any suggestions on solving these two issues?