Home » Authentication » LiveUser » Bug #5351

[2005-09-09 16:18 UTC] reg at dav-muz dot net

Description:
------------
Sorry for my english in advance. ^_^

I have try to create the database with "install.php".
Notices and fatal errors born in function "installSchema" at "$manager =& MDB2_Schema::factory($dsn, $options);" line.

I've tested it with different databases and complexity, with and without options, in browser and in shell mode.

Versions:
LiveUser 0.16.6
LiveUser_Admin 0.3.4
MDB2 2.0.0beta5
MDB2_Schema 0.2.0

If I could, I vote for SQL schemas because is really more flexible.

Expected result:
----------------
Expected result: tables in database.

Actual result:
--------------
Only "auth_schema.xml" file was created.
Only "liveuser_users" table was created in the database but, for me, it is not complete because the primary field is not setted.

Below, the output.

Warning: fopen(auth_schema.xml): failed to open stream: Permission denied in /home/dati/www/php/MDB2/Schema/Writer.php on line 199

Warning: fwrite(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 238

Warning: fwrite(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 310

Warning: fwrite(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 335

Warning: fwrite(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 351

Warning: fwrite(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 380

Warning: fclose(): supplied argument is not a valid stream resource in /home/dati/www/php/MDB2/Schema/Writer.php on line 381

int(1)

<!-- This single notice below is reported 33 times identically -->

Notice: Undefined property: mdb in /home/dati/www/php/MDB2/Driver/mysql.php on line 800

Notice: Undefined property: mdb in /home/dati/www/php/MDB2/Driver/mysql.php on line 783

Fatal error: Call to a member function on a non-object in /home/dati/www/php/MDB2/Driver/mysql.php on line 798

[2005-09-09 16:22 UTC] reg at dav-muz dot net

Sorry, fopen, fwrite and fclose is my error. Do not consider they. The bug remain the same.

[2005-09-09 21:28 UTC] at php dot net

This all sounds a bit fishy. Do you even have a mysql driver installed? You seem to have some code there, but it certainly does not correspond to MDB2_Driver_mysql 0.1.0 nor CVS as the lines numbers simply dont match and I dont remember ever having used a "mdb" property.

Anyways as for SQL files being more flexible. Thats hardly the case. We have had that and it meant anyone trying to get things working on a different RDBMS than MySQL had to hack the file.

[2005-09-14 14:26 UTC] reg at dav-muz dot net

I am not sure to have correctly understood that you have written, however I try to answer. ^_^

> Do you even have a mysql driver installed?

Yes

Fot me, the problem is the schema generated. But I do not understand from what the schema is generated.

> Anyways as for SQL files being more flexible.

If I have an ouput in SQL, and not in XML, I can use that to generate the database. With SQL I can working around the problem. I wont include LiveUser and LiveUser_Admin in my CMS and, for me, SQL is better.

[2005-09-14 20:49 UTC] reg at dav-muz dot net

I'm impressed...

I have reinstalled the PEAR package: the problem has changed.
I have debugged install.php, PEAR::LiveUser and PEAR::MBD2 without results for 4 hours...
And when I have commented and decommented the 123 and 141 lines, the problem it has been resolved alone!!! =8O

Until yesterday I have not used ZendStudioServer (that install ZendOptimizer) and the reinstallation of PEAR package is made today.
In my opinion, ZendOptimizer is not good to use in developing.

In definitive, it is a sucker-time-waster bogus :(
Thank you for your aid.