Radicore Forum: RADICORE Installation Issues

Home » RADICORE » RADICORE Installation Issues » New Install Logon Failure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New Install Logon Failure [message #445]

Sat, 09 December 2006 08:23

jk.harris
Messages: 4
Registered: December 2006

Junior Member

Greetings,

I am a PHP newbie and have just installed radicore on my local Win XP/Apache/PHP 5/Postgre system.
When I attempt to login I get the following error:

----------------------------------------------------------
This application has encountered an unrecoverable error
The following has been reported to the administrator:

2006-12-09 13:38:44
Fatal Error: Object of class pgsql could not be converted to string (# 4096).

Error in line 49 of file 'C:\Data\Website\radicore\includes\dml.pgsql.class.inc'.

Script: /radicore/menu/logon.php

Remote Address: 127.0.0.1

Request URI: /radicore/menu/logon.php
----------------------------------------------------------

I suspect that I have not edited the config.inc file correctly.
Here are some relevant config.inc file lines:
----------------------------------------------------------
$GLOBALS['dbms'] = 'pgsql'; // database engine is PostgreSQL
$GLOBALS['dbhost'] = 'localhost';
$GLOBALS['PGSQL_dbname'] = 'radicore';
if (eregi('^(localhost|desktop|laptop)$', $_SERVER['localhost'])) { // this is for my PC
$GLOBALS['dbusername'] = 'harris';
$GLOBALS['dbuserpass'] = 'grAce';
$GLOBALS['dbprefix'] = null;
----------------------------------------------------------

I do not have a 'PGSQL_dbname'='radicore' (I have created the 'menu', 'workflow', etc. databases. But I do have an system
odbc data source named 'radicore'.

Any recommendations?

Thanks, JWH

JWH

Report message to a moderator

Re: New Install Logon Failure [message #446 is a reply to message #445]

Sat, 09 December 2006 09:03

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

You must create a database called "radicore", then "audit", "dict", etc are created as schemas within the "radicore" database.

I do not know why you are getting "Object of class pgsql could not be converted to string" as that is not a fatal error on either of my PCs.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Install Logon Failure [message #447 is a reply to message #446]

Sat, 09 December 2006 09:51

jk.harris
Messages: 4
Registered: December 2006

Junior Member

Thanks for the speedy reply!

That makes sense. Did I mention that I am also a Postgr newbie Embarassed

?

Will let you know if this solves it.

JWH

Report message to a moderator

Re: New Install Logon Failure [message #448 is a reply to message #445]

Sat, 09 December 2006 10:39

jk.harris
Messages: 4
Registered: December 2006

Junior Member

I have created the Postgre database "radicore" with the appropriate schemas and data from the script files.
However I still get the same "Object of class pgsql could not be converted to string" error mentioned above when logging in... Confused

JWH

Report message to a moderator

Re: New Install Logon Failure [message #449 is a reply to message #448]

Sat, 09 December 2006 11:44

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

You are having some sort of connection error, but the error reporting is showing the wrong error. The "object to string conversion" should be E_NOTICE, not E_FATAL, so should not be reported.

Attached are two files which should remove the "object to string conversion" error so that you can see the *real* error.

Attachment: INCLUDES.zip
(Size: 12.90KB, Downloaded 1120 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Install Logon Failure [message #450 is a reply to message #449]

Sat, 09 December 2006 11:55

jk.harris
Messages: 4
Registered: December 2006

Junior Member

Thanks. No more "converted to string" error. Here's what I get:

----------------------------------------------------------
This application has encountered an unrecoverable error
The following has been reported to the administrator:

2006-12-09 17:52:38
Fatal Error: SQL (# 256).

Error in line 49 of file 'C:\Data\Website\radicore\includes\dml.pgsql.class.inc'.

Script: /radicore/menu/logon.php

Remote Address: 127.0.0.1

Request URI: /radicore/menu/logon.php
----------------------------------------------------------

JWH

Report message to a moderator

Re: New Install Logon Failure [message #451 is a reply to message #450]

Sat, 09 December 2006 13:57

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

I cannot reproduce this fault on my PC. If I try to force a connection error by using a bad password then I get a full error message which tells me just that.

You must have some peculiar setting on your PC which is getting in the way. Can you step through with your debugger to see what condition is firing the error handler?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Install Logon Failure [message #452 is a reply to message #451]

Sun, 10 December 2006 02:14

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

The previous zip file I posted contained the wrong copy of error.inc, so I am attaching another version. Let me know if this works.

Attachment: includes.zip
(Size: 32.03KB, Downloaded 1155 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Install Logon Failure [message #458 is a reply to message #445]

Wed, 13 December 2006 17:42

niel
Messages: 4
Registered: December 2006

Junior Member

I seem to be having a similar problem, but with the MySQLi interface, not postgre. Initially I had the same error, but on line 47 of the 'dml.mysqli.class.inc' file.

I downloaded the second set of include files and now get 'Catchable fatal error: Object of class mysql could not be converted to string in D:\WWW\Working\!Test\radicore\includes\error.inc on line 223' instead.

I'm using Apache 2.2, PHP 5.2.0 on a Win2K3 Server.

Report message to a moderator

Re: New Install Logon Failure [message #459 is a reply to message #458]

Wed, 13 December 2006 19:11

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

I have found a difference in behaviour when running with my debugger turned ON or OFF. I corrupted my user name to force an error and I got the same message as you did. Then I turned my debugger ON to trap the error and guess what - no error! WTF!

After a bit of trial and error I discovered that when my custom error handler is activated the $errcontext argument has different contents depending whether debug is on or off, so $errcontext['this'] is missing, which indicates that the error was triggered from an object and not a function. I then try to save the error message in this object so that I can retrieve it later.

I have managed to solve this particular problem by saving the error message in a static variable instead. See attached error.inc file for details.

You should then see a proper error message which tells you why the connection to the database failed.