XAMPP w/PG addon: Cannot drop database.

Problems with the Linux version of XAMPP, questions, comments, and anything related.

XAMPP w/PG addon: Cannot drop database.

Postby greno » 05. October 2006 14:44

I am receiving the following error when trying to drop a database using XAMPP 1.5.4.a w/Postgresql Addon (for 1.5.0|PG8.1):

SQL error:

ERROR: cannot drop the currently open database


Notice: Only variable references should be returned by reference in /opt/lampp/phppgadmin/libraries/adodb/adodb-connection.inc.php on line 497

I've searched on this error but have not found any solution.
greno
 
Posts: 54
Joined: 04. October 2006 19:25

Postby Wiedmann » 05. October 2006 15:00

You have two errors:
1)
Notice: Only variable references should be returned by reference in /opt/lampp/phppgadmin/libraries/adodb/adodb-connection.inc.php on line 497

Use a newer version of adodb (without this "bug"). As a result of this "bug", this library don't (can't) close the active database connection.

2)
ERROR: cannot drop the currently open database

Within the postgresql server, you can't drop a database while you have a active database connection to the database you want drop (see point 1).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

XAMPP w/PG addon: Cannot drop database.

Postby greno » 06. October 2006 01:05

Could you recommend a version? I upgraded to a very recent version and it is throwing errors:

Notice: Undefined property: ADORecordSet_postgres7::$f in /opt/lampp/phppgadmin/classes/database/ADODB_base.php on line 120

Warning: require_once(./classes/database/-3.php) [function.require-once]: failed to open stream: No such file or directory in /opt/lampp/phppgadmin/libraries/lib.inc.php on line 163

Fatal error: require_once() [function.require]: Failed opening required './classes/database/-3.php' (include_path='.:/opt/lampp/lib/php') in /opt/lampp/phppgadmin/libraries/lib.inc.php on line 163
greno
 
Posts: 54
Joined: 04. October 2006 19:25


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 3 guests