PowerCMS and PowerStore Integration Challange
Eric,
The database connection files for PowerCMS and PowerStore are located as follows:
PowerCMS files are at root including the Connections directory for PowerCMS database connections
PowerStore files are located under root in a directory called "store" and under the store directory the Connections folder for the PowerStore database connections is located.
With this configuration if I don't include the PowerCMS includes in the PowerStore home page everything works fine both in PowerStore and PowerCMS. PowerStore connects to the somersf3_choicesStore Table accordingly. No errors. and Power CMS connects to it's database somersf3_choicesCMS.
Here is the PoweCMS connections code located in the Connections directory under root: (passwords X'd out for security)
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "somersf3_choicesCMS";
$username_localhost = "somersf3_choices";
$password_localhost = "XXXXXXXXX";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Here is the PowerStore connections code located in the Connections directory under root, under the directory called store, in the folder call Connections: (passwords X'd out for security):
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "localhost";
$database_localhost = "somersf3_choicesStore";
$username_localhost = "somersf3_choices";
$password_localhost = "XXXXXXXXXX";
$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Again the only thing I am changing in the overall setup is adding the PowerCMS includes in the PowerStore home page. I really need to get this resolved. Again if providing you access to the site is helpful let me know.
Thanks,
Mike