Page 1 of 1

Stuck at Creating Primary author...

Posted: Tue Aug 02, 2005 6:41 am
by francisco
Got my web provider to make all the necessary changes so the pre install screen had no errors and only 2 warnings about space mismatches..

Upon doing the install
Checking to see if the database and tables already exists... they do not
Creating default database setup... Done
Creating primary author 'francisco'...

And it doesn't go any further.

Where is the install code?
Tried grep for .php files in several directories for the "Creating primary author" string and did not see any files with that string.

Posted: Tue Aug 02, 2005 7:03 am
by francisco
I think I found the problem..
Looking at the apache logs I see
Call to undefined function: pg_escape_string()

The php is 4.2.3 and that function is supposed to exist since 4.2.0 so I don't understand why it's missing.

Also... I noticed the tables were created even though the install failed .. I think the tables should be done within a transaction so in case of failure nothing gets done in the DB.

Posted: Wed Aug 03, 2005 4:50 pm
by garvinhicking
The transaction is done within one part, only the insert later on fails. We can't combine those queries in one transaction easily and it helps other people to have the tables built so that they can make manual error fixing instead of having nothing to start with...

About the missing function you'll definitely have to talk to your system admin.

Regards,
Garvin

Posted: Fri Aug 05, 2005 8:51 am
by francisco
garvinhicking wrote:We can't combine those queries in one transaction easily
How come?
Don't understand why you can't send a "beging work" to the DB and when done "comit".

If it make sense to not have them in a transaction that's fine I am jut curious why it can't be done.

Posted: Fri Aug 05, 2005 12:16 pm
by garvinhicking
In fact you're right, we do have those "transaction" functions, but with "easily" I was more talking about the effect it might have on wrong installations. I'm not really sure if it's better to be able to start from scratch, or to be able to see which tables were created and manually fix errors... :-/

Regards,
Garvin