samoth
-
Posts
3 -
Joined
-
Last visited
Posts posted by samoth
-
-
Chris
Yes I have 2 databases nl. chaospag_osc1 and chaospag_plst1
Phplist and osc are up and running without errors for about 3 months already. It's just when I installed the mod that I got the error
There are 3 osc files that you have to mod : (according to install doc only add and replace)
catalog/create_account.php
catalog/account_newsletters.php
catalog/admin/customers.php
2 new files:
catalog/includes/phplist_define.php
catalog/admin/includes/phplist_define.php
I have changed the define files to what ever I could and still get the error, Is there anything I have to define in the 3 osc files.
Please try and help once more, if I don't get it to work I will stop and remove the mod.
Thanks
Wilco
Hi Wilco,
You seem to have problem with permissions for user chaospag_osc1, this user must have permissions to connect to, alter and so on the phplist database.
This mod is made in the way that is uses the same database user for both databases. Ie. it uses the username that has privileges for the Oscommerce database to connect to the phplist db, because of this you must set up the same db user for both databases or give the oscommerce db user privileges/permissions to the phplist db.
This can be done through commandline, phpmyadmin (if permitted by hosting provider) or by some other way supported by the hosting provider.
If you can't control creation, permissions or other handling of database users, I am sorry, this mod is not for you (at least not in its present state). I don't have either the need for or knowledge in rewriting the mod for this purpose.
Regards
Thomas A.
-
Hi all,
When I did this contribution I did it for a single host environment. Meaning that the Mysql databases must be on the same host, sorry. But maybe you can find information on Mysql's support site.
Though I am running osC and PHPlist in separate databases, you should be able to run both applications in the same database. If so you have to leave the definition of the variable PHPLIST_DB empty/blank in the file phplist_define.php. This should work:
define('PHPLIST_DB', '');
This 'MyoScommerceDatabase.MyphpListDatabasephplist_user_user' seems to point out that there is a little dot forgotten in the above statement. If you are using ver 0.6 you must remember to put a dot after the db name, like this:
define('PHPLIST_DB', 'phplistdb.');
I am using this on live osC and PHPlist installations and it is actually working as I intended it to. But maybe there is a problem in the description for account_newsletter.php, I will look into this.
Thanks for using this contrib and to Chris for setting up this forum thread. I have uploaded a new version with requirements description. If there is anything that seems unclear, let me know.
Regards
Thomas
PHPList integration to OsCommerce
in General Add-Ons Support
Posted
Hi James,
This seems to be a database name problem, are you sure your database name is 'rocketz_net_-_phplist'?
Isn't it possible it should be 'rocketz_net_phplist' instead?
I think the sytax error is reffering to the '-'-sign, this sign is probably not allowed in mysql naming conventions.
Regards
Thomas A.