Monday 17 November 2003 6:46:47 pm

I found a way to do so... but after wizard completion, It ends up with error Kernel 20.

Thank you to check upper message in the forum. Give me a clue before I drop frozen !!!

Tuesday 02 March 2004 12:00:32 am

Hi

The problem is probably that your hosting provider does not allow listing of databases in MySQL using 'show tables'. This command is being run to check connection, and list databases later in the installation.

This seems to be a somewhat widespread problem, so we'll try to fix it in the next 3.3 release and future 3.4 releases.

In the current 3.3-3 version there is no othersolution than manualy editing :
lib/classes/ezdb/ezmysldb.php
set eZMySQLDB::availableDatabases() to always return false.

--
Kåre Høvik

Kåre Høvik

Thursday 04 March 2004 1:08:37 pm

changed the code in the 3.3.3 and still no luck still getting

The selected selected user has not got access to any databases. Change user or create a database for the user.
i can login to phpmyadmin just fine so i know i have the access

if you want to use the url and hosting as a test bed lets do it i just need to get this working

Monday 15 March 2004 3:14:32 am

Hi

Before I commit this patch, could some with the problem please try to see if this fixes anything.

--- lib/ezdb/classes/ezmysqldb.php      (revision 5508)
+++ lib/ezdb/classes/ezmysqldb.php      (working copy)
@@ -624,6 +624,11 @@
         $databases = array();
         $i = 0;
         $numRows = mysql_num_rows( $databaseArray );
+        if ( count( $numRows ) == 0 )
+        {
+            return false;
+        }
+
         while ( $i < $numRows )
         {
             $databases[] = mysql_db_name($databaseArray, $i);

Thanks for the help.

--
Kåre Høvik

Kåre Høvik

Tuesday 16 March 2004 5:50:34 am

Hi

try to replace the function availableDatabases() with this :

    function availableDatabases()
    {
        $databaseArray = mysql_list_dbs( $this->DBConnection );

        if ( $this->errorNumber() != 0 )
        {
            return null;
        }

        $databases = array();
        $i = 0;
        $numRows = mysql_num_rows( $databaseArray );
        if ( count( $numRows ) == 0 )
        {
            return false;
        }

        while ( $i < $numRows )
        {
            $databases[] = mysql_db_name($databaseArray, $i);
            ++$i;
        }
        return $databases;
    }

in lib/ezdb/classes/ezmysqldb.php

If does not work try this :

    function availableDatabases()
    {
        return false;
    }

Please let me know what works/does not work

--
Kåre Høvik

Kåre Høvik

Tuesday 23 March 2004 6:55:54 pm

Hi
I have just experienced similar problems. I couldn't create multiple sites (templates?) when installing and kept sending me back to the db initialization box. In the end I simply proceeded with the 'plain' template, but when I tried to acess both admin and user pages I got a:

kernel (50)
* No database connection could be made, the system might not behave properly.

Don't really know what to do, I spent a long time ftp-ing the files over a dialup modem, and I don't really want to go through re-writing scripts because I don't know much about how to do so.

Cheers,
Daniel

Also:
The user and admin pages come up as my_site/ezP-folder/index.php which is not secure? I did ftp the .htaccess file asd instructed but with no joy