Seagull: Unable to load schema for database and table
I just copied a Seagull project I created a while back to a new development server to do some testing. Copying the www.mydomain.conf.php to localhost.conf.php and changing the database settings to connect to my local database resulted in this when trying to log in:
DataObjects_Usr: ERROR: Unable to load schema for database and table (turn debugging up to 5 for full error message) DB_DataObject Error: Unable to load schema for database and table (turn debugging up to 5 for full error message) Well, turns out it was my the problem was that I had renamed my database. The entities files created by Seagull requires the database to have the same name as it originally had.
So, renaming my local database to have the same name as the production site fixed everything. Just thought I’d throw it out here in case someone experiences the same problem and does a quick google ;-)
Comment by Demian Turner on 2008-10-26 00:30:15 +0000
Hi Bjorn – you could also have renamed sgl/var/cache/entities/$dbname.ini – this is just a standard side effect of using PEAR’s DB_DataObject package.
Comment by Bjørn on 2008-10-26 14:02:16 +0000
Hi Demian :-)
Yeah, I understand that this comes from the generated dataobjects.
Thanks for that tip! IMHO, it’s easier just to have the development/production environment as similar as possible though – something I always try to have .. this was just a slip ;-)