Seagull Forum: Installation and upgrades => DB Problem after upgrading PHP to 5.2.0

Members

FAQ

Home

Home » Support » Installation and upgrades » DB Problem after upgrading PHP to 5.2.0

Show: Today's Messages :: Show Polls :: Message Navigator

DB Problem after upgrading PHP to 5.2.0 [message #707]

Sun, 24 December 2006 06:35

chris
Messages: 5
Registered: May 2006

Junior Member

Hi,

I just upgraded PHP to 5.2.0 and now I can't log into the administration. This is the error I am getting:

DB_DataObject Error: Unable to load schema for database and table (turn debugging up to 5 for full error message)

Where do I turn debugging to 5? Just wondering what I need to do 'cause right now I have no clue what's wrong Mad

Thanks for any help,
-- Chris

Report message to a moderator

Re: DB Problem after upgrading PHP to 5.2.0 [message #708 is a reply to message #707 ]

Sun, 24 December 2006 14:08

demianturner
Messages: 476
Registered: May 2006
Location: London, UK

Senior Member
Administrator

Hi Chris

Setting db_dataobject debug level to 5 is done in the config file, same place as all other config settings in Seagull. You should be glad we use a single config file and not 32 like symfony Wink

Sounds like you haven't seen it yet, you can find the config in seagull/var/<your-hostname>.conf.php. Search for the key

$conf['debug']['dataObject'] = '0';

and change it to 5.

But your problem is most likely that db_dataobject generated classes for you in PHP4, and now it sees you are using PHP5. Easiest is to do a fresh Seagull install with PHP5 then reinstall your custom modules and 'rebuild'.

cheers

Demian
Project Maintainer
http://trac.seagullproject.org/wiki/Contributing
http://trac.seagullproject.org/wiki/Installation/FromSVN

Report message to a moderator

Re: DB Problem after upgrading PHP to 5.2.0 [message #710 is a reply to message #708 ]

Sun, 24 December 2006 19:35

chris
Messages: 5
Registered: May 2006

Junior Member

Hi Demian, thanks for the reply. I actually upgraded from PHP 5.1.4 to PHP 5.2.0 since I migrated my site to another server. I did have to export then import the database which was upgraded from Mysql 5.0.21 to Mysql. 5.0.27. Could that have something to do with it?

If I have to reinstall and reimport my modules, what tables do I have to import for the publisher module? Since many of my current pages were created in publisher. Really I don't have any custom modules that I need to import. Just my custom theme, and all my pages in the db. Maybe you can tell me how I should import my db properly?

Thanks much,
-- Chris

[Updated on: Sun, 24 December 2006 19:37]

Report message to a moderator

Re: DB Problem after upgrading PHP to 5.2.0 [message #711 is a reply to message #710 ]

Sun, 24 December 2006 20:00

demianturner
Messages: 476
Registered: May 2006
Location: London, UK

Senior Member
Administrator

Hi Chris

I've never heard of a db re-import being needed when moving from Mysql 5.0.21 to Mysql. 5.0.27. Same goes for minor PHP upgrade. I suggest you go the db_dataobject debuglevel = 5 route, sounds like something unusual. Also try the latest Seagull 0.6.1 and see if there are any probs with that.

cheers

Demian
Project Maintainer
http://trac.seagullproject.org/wiki/Contributing
http://trac.seagullproject.org/wiki/Installation/FromSVN

Report message to a moderator

Re: DB Problem after upgrading PHP to 5.2.0 [message #712 is a reply to message #707 ]

Sun, 24 December 2006 20:15

chris
Messages: 5
Registered: May 2006

Junior Member

Hi Demian,

I forgot to mention I don't have the line:

$conf['debug']['dataObject'] = '0';

This is all I have in the debug array:

$conf['debug']['authorisationEnabled'] = '1';
$conf['debug']['customErrorHandler'] = '1';
$conf['debug']['sessionDebugAllowed'] = '1';
$conf['debug']['production'] = '0';
$conf['debug']['showBacktrace'] = '1';
$conf['debug']['profiling'] = '0';
$conf['debug']['emailAdminThreshold'] = 'PEAR_LOG_EMERG';
$conf['debug']['showBugReporterLink'] = '1';
$conf['debug']['showUntranslated'] = '1';

I pretty much set all those variables to 5, but no cigar.

Report message to a moderator

Re: DB Problem after upgrading PHP to 5.2.0 [message #725 is a reply to message #707 ]

Fri, 29 December 2006 00:44

chris
Messages: 5
Registered: May 2006

Junior Member

I found the problem. It was because I renamed by database which I imported from my other server. My old database was named _livesite and my new database was name _website.

So I found that in var/cache/entities there were two files that I had to rename to match my renamed database, which looked like this:

var/cache/entities/_livesite.ini -> renamed to: var/cache/entities/_website.ini

and

var/cache/entities/_livesite.links.ini -> renamed to: var/cache/entities/_website.links.ini

Once I did that, everything started working great.

[Updated on: Fri, 29 December 2006 00:44]

Report message to a moderator

Previous Topic:	not past first page of install
Next Topic:	mod_security incompatibility with SGL

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 2 15:18:58 BST 2010

Total time taken to generate the page: 0.01588 seconds

.:: Contact :: Home ::.