Re: [phpesp-general] Parallel installation of 2.1.2 fails

[Franky V. L. <lie...@te...>]

On Wed, Feb 11, 2009 at 5:45 AM, David Liontooth <lio...@co...>wrote:

>
> I've had phpESP 1.8.2 running for a long time, and also installed 2.0.2
> successfully. I'm now attempting to install 2.1.2 and having no luck.
>
> I want to run the versions in parallel, so I define a new db for the
> 2.1.2 version, and create a new database by editing mysql_create.sql and
> issuing
>
>   mysql -u root -p < mysql_create.sql
>
> This works fine; I check the result in phpMyAdmin. I browse to the
> location given in phpESP.ini.php and get this:
>
> "If you see this screen and you have phpesp already installed using the
> current db config, it might be because the default table prefix setting
> has changed. Use this link to update non-prefixed tables to the correct
> prefix, or change the variable $DB_PREFIX in the config file."
>
> I do have phpesp already installed, but not using the current db config.
> Clicking on "Install" or "this link" only generates errors. phpmyadmin
> shows the new database remains empty.
>
> Is there a problem installing parallel versions using 2.1.2? It's
> looking like it's seeing the old db called phpesp and tries to use it,
> even though phpESP.ini.php has the new db name and user.
>
> Peter Flynn had similar issues; were they resolved?
>
> I tried starting over and commenting out the prefix lines, to no effect:
>
> // $DB_PREFIX = "phpesp_";   // If you want your database tables to use
> a prefix, set it here.
> // $OLD_DB_PREFIX = "";   // When switching prefixes, enter the current
> db prefix here.
>
> This line from phpESP.ini.php.default made path assumptions that are
> incorrect:
>
> $ESPCONFIG['adodb_pathto_db'] = "/var/www/phpESP/scripts/db/esp.dbm";
>
> I made a copy to phpESP.ini.php and corrected it, but it had no visible
> effect. Is there some other variable that is assuming the db is called
> phpesp or that the program is on the path /var/www/phpESP/? Anything we
> need to be looking out for when doing parallel installations? I'm just
> guessing that's the source of the problem.
>
> Apache's log has no errors.
>
> During this process I removed 2.0.2 and then reinstalled it without
> problems; for this version I ran mysql_populate.sql and everything works.
>
> Cheers,
> Dave



Well, please post the content of phpESP.ini.php (leave out the password of
course).
Also: the mysql create script is an old thingie that might not work
correctly anymore for new versions of mysql. You can always try by just
creating a new database and user using phpmyadmin or so. I'm going to remove
this sql script and recommend manual creation of the db anyway (as all other
tools do as well).

Franky