[Salvo]

Hi all

I have downloaded the program and is online for testing at moment.

I like to try it before having it with my OSC catalog...

I have one question.. Does anyone know how I could have ie. Specials from OSC to be sent as newsletter?

Thanks

Salvo

[AlanThompson]

Hi

I have installed PHPList and it works fine.
I have made the changes to the necessary OSC files and when submitting a new account (with the newsletter box ticked) I get the following error:

1146 - Table 'db72914343.PHPLIST_user_user' doesn't exist

I also get the same error if i try to edit any users details from within the OSC admin screens.

Any ideas from you genuises out there ?

thanks in advance!
Alan

[AlanThompson]

AlanThompson, on Apr 25 2006, 09:59 PM, said:

Hi

I have installed PHPList and it works fine.
I have made the changes to the necessary OSC files and when submitting a new account (with the newsletter box ticked) I get the following error:

1146 - Table 'db72914343.PHPLIST_user_user' doesn't exist

I also get the same error if i try to edit any users details from within the OSC admin screens.

Any ideas from you genuises out there ?

thanks in advance!
Alan

I just fixed this myself - i noticed that the table prefix default was PHPLIST_ whereas in phpMyAdmin, the table was showing up as phplist_ so i changed that and it now works.
Hope this info might be useful to anyone else who might have made this simple mistake!

[Buttonman]

I have a few questions about this mod that I hope someone can answer:

1) Is the information flow both ways (someone uses phpList to opt out leads to an update in Zen Cart, and when someone opts out of Zen Cart it updates phpList)

2) Is additional information available within phpList (country, name etc)

3) Is there any reduction in the phpList functionality such as bounced email recording and automatic unsubscribe etc.

Thanks for your experienced comments.

Scott

[higgalls]

Buttonman, on Apr 26 2006, 10:19 AM, said:

I have a few questions about this mod that I hope someone can answer:

1) Is the information flow both ways (someone uses phpList to opt out leads to an update in Zen Cart, and when someone opts out of Zen Cart it updates phpList)

2) Is additional information available within phpList (country, name etc)

3) Is there any reduction in the phpList functionality such as bounced email recording and automatic unsubscribe etc.

Thanks for your experienced comments.

Scott

Hey, Basically, the details about who is on the mailing list is stored directly in PHPList database (not in the oscommerce database). So, if someone unsubscribes in PHPList, it should reflect that change in OsCommerce also.

I believe you can add attributes to the PHPList, but I haven't tried doing it as I dont record those details in PHPList myself.

Because it links in with the PHPList database, all functionality in PHPList should remain exactly the same.

Hope this helps you out a little bit.

Cheers,
Chris

[procomp65]

AlanThompson, on Apr 25 2006, 09:42 PM, said:

I just fixed this myself - i noticed that the table prefix default was PHPLIST_ whereas in phpMyAdmin, the table was showing up as phplist_ so i changed that and it now works.
Hope this info might be useful to anyone else who might have made this simple mistake!

I have another error and don't know how to sort it out
"1142 - SELECT command denied to user 'chaos_osc1'@'localhost' for table 'user_user'

select id, email, foreignkey from phplistdb.user_user where email = 'lanie@chaos.com'
any suggestions
chaos_osc1 is oscommerce data base
chaos_plst1 is my phplist data base.
The user_user table, part of which database is that

Thanks

[higgalls]

procomp65, on Jun 5 2006, 03:09 AM, said:

I have another error and don't know how to sort it out
"1142 - SELECT command denied to user 'chaos_osc1'@'localhost' for table 'user_user'

select id, email, foreignkey from phplistdb.user_user where email = 'lanie@chaos.com'
any suggestions
chaos_osc1 is oscommerce data base
chaos_plst1 is my phplist data base.
The user_user table, part of which database is that

Thanks

Hi,

All I can tell is that you either must not have the permissions set correctly for the database (as it appears that the user does not have the appropriate priveledges), or you have not set the database prefix in the mod for the PHPList database as 'chaos_plst1' (or maybe 'chaos_plst1_').

Regards,
Chris

[rkoechel2004]

stonebridgecomputing, on Jun 4 2006, 09:34 PM, said:

Hi,

All I can tell is that you either must not have the permissions set correctly for the database (as it appears that the user does not have the appropriate priveledges), or you have not set the database prefix in the mod for the PHPList database as 'chaos_plst1' (or maybe 'chaos_plst1_').

Regards,
Chris

Chris-

Thanks for posting this in here, I was just about to dive into coding something similar to this. You saved me a ton of time.

-Ryan

[higgalls]

rkoechel2004, on Jun 13 2006, 08:29 AM, said:

Chris-

Thanks for posting this in here, I was just about to dive into coding something similar to this. You saved me a ton of time.

-Ryan

Hey,

Not a problem.

Post any updates that you to it if you can

Cheers,
Chris

[procomp65]

stonebridgecomputing, on Jun 13 2006, 02:13 AM, said:

Hey,

Not a problem.

Post any updates that you to it if you can

Cheers,
Chris

Thanks Chris

I still don't come right. I have changed priviledges to all for all users on both databases.
Here is how my config file looks

define('PHPLIST_DB', 'phplistdb.'); //the name of the phplist database if same as osC, leave blank
define('PHPLIST_TABLE_PREFIX', ''); //if a table prefix is used give it here (if none, leave blank)
define('PHPLIST_LISTNO', '2'); //the listnumber to subscribe/unsubscribe users to/from (must have been created in phplist)

where should what go

Thanks
Wilco

[higgalls]

procomp65, on Jun 18 2006, 06:40 AM, said:

Thanks Chris

I still don't come right. I have changed priviledges to all for all users on both databases.
Here is how my config file looks

define('PHPLIST_DB', 'phplistdb.'); //the name of the phplist database if same as osC, leave blank
define('PHPLIST_TABLE_PREFIX', ''); //if a table prefix is used give it here (if none, leave blank)
define('PHPLIST_LISTNO', '2'); //the listnumber to subscribe/unsubscribe users to/from (must have been created in phplist)

where should what go

Thanks
Wilco

Hey,

Sorry but im a bit confused (could be because I just woke up though).
What is the actual problem you are having?

You will have 2 databases: 1 for OsCommerce, and 1 for PHPList.

You should already have PHPList installed and working in order to use this mod. If you dont, then you need to get it installed and working FIRST, and then try this mod.

Do you know how to set those configuration options?

It has been a long time since I installed this contrib, so I can't really rememeber how I got it working.
I do remember that I did have an error at some stage and it was because I don't use any attributes in PHPList (for things such as First Name, Last Name, Country, etc). What I did was in the file that links OsCommerce across to PHPList, I simply commented out the lines where it refers to attributes, and then it worked.

Sorry I can't be of any more help at the moment.

Cheers,
Chris

[procomp65]

stonebridgecomputing, on Jun 18 2006, 12:09 AM, said:

Hey,

Sorry but im a bit confused (could be because I just woke up though).
What is the actual problem you are having?

You will have 2 databases: 1 for OsCommerce, and 1 for PHPList.

You should already have PHPList installed and working in order to use this mod. If you dont, then you need to get it installed and working FIRST, and then try this mod.

Do you know how to set those configuration options?

It has been a long time since I installed this contrib, so I can't really rememeber how I got it working.
I do remember that I did have an error at some stage and it was because I don't use any attributes in PHPList (for things such as First Name, Last Name, Country, etc). What I did was in the file that links OsCommerce across to PHPList, I simply commented out the lines where it refers to attributes, and then it worked.

Sorry I can't be of any more help at the moment.

Cheers,
Chris

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

Quote

1142 - SELECT command denied to user 'chaospag_osc1'@'localhost' for table 'phplist_user_user'

select id, email, foreignkey from phplistdb.phplist_user_user where email = 'lelanie@chaosparts.com'

[TEP STOP]

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

[blanktape]

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_phplist.phplist_user_user where email = 'me@jamesyang.info'' at line 1

select id, email, foreignkey from rocketz_net_-_phplist.phplist_user_user where email = 'me@jamesyang.info'


Hmm...syntax error....

can someone suggest me where to look for??

james

[blanktape]

blanktape, on Jun 30 2006, 02:08 PM, said:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_phplist.phplist_user_user where email = 'me@jamesyang.info'' at line 1

select id, email, foreignkey from rocketz_net_-_phplist.phplist_user_user where email = 'me@jamesyang.info'
Hmm...syntax error....

can someone suggest me where to look for??

james

This happens with the file account_newsletters.php.

thanks in advance.

[samoth]

procomp65, on Jun 18 2006, 09:33 AM, said:

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.

[samoth]

blanktape, on Jun 30 2006, 11:08 PM, said:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_phplist.phplist_user_user where email = 'me@jamesyang.info'' at line 1

select id, email, foreignkey from rocketz_net_-_phplist.phplist_user_user where email = 'me@jamesyang.info'
Hmm...syntax error....

can someone suggest me where to look for??

james

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.

[barryjacq2]

I do not want to pass the last name across to PHPList so I leave the attribute for last name empty as instructed.

define('PHPLIST_LASTNAME', ' '); //the atributenumber for the users lastname (if created in phplist otherwise leave empty)

But I get the following error message:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 7603, 'aaaaaaaaalast')' at line 1

insert into virtua38_plst1.phplist_user_user_attribute (attributeid, userid, value) values ( , 7603, 'aaaaaaaaalast')

[TEP STOP]

I tried putting a space as well as leaving the field empty - both produced the same error.
Any ideas what is causing this problem?

[higgalls]

barryjacq2, on Aug 21 2006, 11:07 AM, said:

I do not want to pass the last name across to PHPList so I leave the attribute for last name empty as instructed.

define('PHPLIST_LASTNAME', ' '); //the atributenumber for the users lastname (if created in phplist otherwise leave empty)

But I get the following error message:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 7603, 'aaaaaaaaalast')' at line 1

insert into virtua38_plst1.phplist_user_user_attribute (attributeid, userid, value) values ( , 7603, 'aaaaaaaaalast')

[TEP STOP]

I tried putting a space as well as leaving the field empty - both produced the same error.
Any ideas what is causing this problem?

In the script, go through and remove any line that has reference to attributes as that is what is causing the problem. I had to remove those lines myself, and it is working fine.

Let me know how you go.

Cheers,
Chris

[barryjacq2]

stonebridgecomputing, on Aug 20 2006, 06:20 PM, said:

In the script, go through and remove any line that has reference to attributes as that is what is causing the problem. I had to remove those lines myself, and it is working fine.

Let me know how you go.

Cheers,
Chris

Thanks Chris for the suggestion. For the time being I created the lastname attribute in PHPlist and set it to not-required. That seems to be a work around that avoids having to change the code.
Barry

[barryjacq2]

Problem with making two database users the same name.

I have another osCommerce installation that I want to use with my phplist database. The problem is that they are both on different servers. When you create a new database user on the server it prefixes the user name with the login name for the server.

For example all users on my server virtua38 begin with server1_ for example server_user1
All users on my other server begin with server2_, so even if I choose the same name (user1 in phpMyAdmin), the actual user name is different i.e. server1_user1.

This obviously causes a problem when you want to add the same user that is accessing your osCommerce database to your PHPlist database, since it is impossible to create two users having the same name.

Can anyone suggest any solution (apart from moving both applications to the same server)?

Thanks anyone.
Barry