114 replies to this topic

[dragon5]

Well, I bit the bullet and paid Lunarpages for a full restore from a previous day. This seems to have solved the problem. They could not figure out what happened. Fortunately, I went into the db and backed up any customer data that I would lose in the rollback. Lesson learned....... If it 'aint broke', don't fix it! Sure would like to have had the ability to use PHPList though.

Chris, Thanks for your efforts.
Tom

ps. I have noticed that Lunarpages seems to get a lot of trashing around the web. I need to say, that I have had only a MOST EXCELLENT experience with them for 4 years now.

[dragon5]

Well, new problem. After the host did a rollback, everything works fine EXCEPT I now get this error msg when attempting to access my site:

1016 - Can't open file: 'whos_online.MYI' (errno: 145)

delete from whos_online where time_last_click < '1164752442'

[TEP STOP]

Any ideas?
Thanks
Tom

[dragon5]

who's_online was corrupt. All is now well.
Thanks

[higgalls]

dragon5, on Nov 29 2006, 10:15 AM, said:

who's_online was corrupt. All is now well.
Thanks

Excellent, Glad it is all working now.

Cheers,
Chris

[guinness28_fr]

I didn't install phplist contrib, but it seems that I have an error message like you :

Quote

Warning: mysql_pconnect(): Access denied for user 'root'@'amanda.nfrance.com' (using password: NO) in /home/eq53496/secure/catalog/includes/functions/database.php on line 17
Unable to connect to database server!

What can I do ?
Would you have an idea ?
It seems that I'm trying to connect to my DB with root , but that's not my login.
Where can I change it ?

[higgalls]

guinness28_fr, on Nov 30 2006, 05:28 AM, said:

I didn't install phplist contrib, but it seems that I have an error message like you :
What can I do ?
Would you have an idea ?
It seems that I'm trying to connect to my DB with root , but that's not my login.
Where can I change it ?

Hi,

Was your OSC store fully working beforehand?

Was PHPList fully working beforehand?

Does your post have anything to do with this contrib or PHPList?

Regards,
Chris

[lostndazed]

Hey Chris and everyone.

I've got osCommerce installed and phpList both installed in the same database.

I came here to research before I install the contribution to connect the two programs.

Anyway, I am wondering about your efforts to put a newsletter signup form on your contact page.

Correct me if I'm wrong, but doesn't the phpList contrib merely copy a logged in customer's email info from osCommerce and into the phpList program? If that's the case, and IF the customer is not logged in, what happens when a customer is not logged in? Then will the signup information will go straight to phpList, bypassing osCommerce entirely?

If the newsletter signup info goes straight into phpList, then other than a logged in user, no extra php coding should be required, right? So a regular newsletter form should be ok on every other page except the create account page, right?

Wouldn't that be a simple html form that is created at www.yoursite.com/lists/ then view the source?

Is my logic wrong?

[lostndazed]

OK, I'm thoroughly confused.

If I use this contribution, will I be able to use the phpList program?

I just want to have the email addresses collected from customers in osCommerce go into phpList program. Will this contribution do that?
Or is it merely substituting database tables and the newsletter to be sent is generated in osCommerce? (That would be a pointless exercise for me.)

[lostndazed]

Ok, I have an answer via email:

Once you have gotten this contrib installed and working, it WILL allow you to use PHPList as normal. This contrib simply puts the email addresses collected from the customers in OsCommerce, and puts them straight into phpList.

Yippee! Thanks!

[lostndazed]

Well! That was the quickest contribution I've ever done.

There doesn't seem to be any problems in initial tests. This was the first contribution I've done that didn't have any errors to fix! Crossing my fingers that all stays good.

Thanks Chris for bringing this to the osC contributions and forum.

[lostndazed]

I have another question, though.
How do I fix it where the already registered for newsletter folks can get put into phpLIst.

Do I need to export them? Or Go down the customers list in admin and re-register them?

[lostndazed]

lostndazed, on Mar 4 2007, 10:14 PM, said:

I have another question, though.
How do I fix it where the already registered for newsletter folks can get put into phpLIst.

Do I need to export them? Or Go down the customers list in admin and re-register them?

Hm, apparently it isn't a problem. My site is so new that there are no people registered in osC for newletters.

[mutter]

Hi, i am very interesed in this contrib.

But i want to be able to add non registered customers to the mailing list via a form in the store.

For example, guest fill form, script check if guest email is from an actual customer, if not then subscribe to phplist. If email already from a customer, display error an tell them to log on and subscribe from there.

This contrib already do this?

[rkscscc]

mutter,

Point your guest to your sign-up page for phplists, phplists will automatically check whether they are already subscribed or not... Point out in this page that if they are already subscribed, that they should go to your shop and log in from there....

-------------------------------------------

On other matters, I have installed this last night, seperate DB's, same server, gave osc_user full permision in phplist DB in php, fiddled around for a bit setting up lists,pages and all the rest, and then went about getting the php_settings.php file set up correctly, all is well and it's working like a dream!!!!!

[mutter]

rkscscc, on Mar 18 2007, 06:45 AM, said:

mutter,

Point your guest to your sign-up page for phplists, phplists will automatically check whether they are already subscribed or not... Point out in this page that if they are already subscribed, that they should go to your shop and log in from there....

Riaan, are you sure that phplist check automatically if the user is already suscribed or not?

Cause when i try to add an existing email to phplist (v2.10.4). phplist just resend the confirmation mail to that email, and do not show any message saying that the email is already in the list.

But, when removing a email from phplist via the unsuscribe page. phplist checks if the user exist, and if not shows an error message.

Later...

[gregy]

got it working .. works great, but i have two questions;

- deleting customer in customers.php is still not deleting email from phplist. Any fix for this?
- is it possible to set somewhere that every registered customer is automatically added to newsletter. Of course he is able to unsubsrcibe later .. In this case checkbox would be hidden

thanx for answers!

Edited by gregy, 30 March 2007, 18:20.

[mutter]

gregy, on Mar 30 2007, 06:17 PM, said:

got it working .. works great, but i have two questions;

- deleting customer in customers.php is still not deleting email from phplist. Any fix for this?
- is it possible to set somewhere that every registered customer is automatically added to newsletter. Of course he is able to unsubsrcibe later .. In this case checkbox would be hidden

thanx for answers!

- If i remember, there isnt any code in the contrib for deleting customers email from phplist when you delete a customer. Should be easy to implement using the forgeinkey.

- YOu could change the checkbox field in create_account.php to a hidden field with the same values of the checked when is checked or deleting the checkbox field from the form and set the $newsletter variable to true deleting the surrounding if statment.

[gregy]

thanx for the answer .. since i'm no programer or coder i wonder how these lines should look like?

		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" cellspacing="2" cellpadding="2">
			  <tr>
				<td class="main"><?php echo ENTRY_NEWSLETTER; ?></td>
				<td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . '&nbsp;' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>

thanks for support .. if someone can add lines for deleting emails in customers.php then this contrib. would be awesome!

[mutter]

Try deleting this:

	  <tr>
		<td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" cellspacing="2" cellpadding="2">
			  <tr>
				<td class="main"><?php echo ENTRY_NEWSLETTER; ?></td>
				<td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . '&nbsp;' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>

Search for:

	if (isset($HTTP_POST_VARS['newsletter'])) {
	  $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
	} else {
	  $newsletter = false;
	}

Change it to:

	  $newsletter = true;

That should do what you want, later..

[gregy]

great! .. works like a charm! Thank you a lot.

Now, i was thinking, what if user try to create an account with already entered email in phplist database, cause he was already signed up for newsletter? .. would script ignore email? Oscommerce will register customer, cause mail is not in osc database .. what will phplist say?

Should i test this case?