Newsletter-Only Subscriptions for v1.3x

1062 error ... again.
1062 Duplicate entry '0' for key 1
in:
[insert into myshop_subscribers (email_address, email_format, subscribed_date, confirmed) VALUES ([email protected]', 'HTML', now(), 'TDYzLj')]

I know it is not really a problem from this module...... i think i got this from a common problem from exporting and importing sql data from one to another mysql server..with diff. server versions ( mine was 5.X --> 4.X )

how can i solve this?

Quote:

---

Originally Posted by kookiewookie

1062 error ... again.
1062 Duplicate entry '0' for key 1

---

This will fix that one table:

Code:

---

ALTER TABLE `subscribers` CHANGE `subscriber_id` `subscriber_id` INT( 11 ) NOT NULL AUTO_INCREMENT

---

Remember to add your DB prefix if needed.


It meants the auto_increment attribute was dropped from the table. If you chose export compatibility 4.0 you likely dropped the auto_increment value on all your tables-or it does that in mine.

I usually export as 5.0, then edit and change ENGINE to TYPE and edit out any 'charset' settings I might have (needless to say I export the structure and data separately or it takes forever to edit the structure file. :)

You'll want to check your other tables as well to see if any have the autoincrement value. If you fix it piecemeal you may miss some.

-Ng_

many many thanks for the fix! and the advice........ i have been mixing up things with the export settings.... just forgot about the old way, with this new export functions, and indeed just remove the char SET en ENGINE= TYPE....


This export comp. function gave me headache thanks for reminding me on the better export method.

Question for those wanting to import emails:

Do any of you have records that are not broken by newlines e.g.:
email,format|email,format

vs

email,format
email,format

If so I need to take a slightly different tack in the import function.
It's set up to take any delimiter (comma, | \t etc) and allows you to specify where in the record to pull the address/format from (in case you have other fields in there), but right now breaks records by newlines.

Anyone needing something more flexible?

Get back to me.

Danke,

-Ng_

Hi notgoddess,

I installed your patch for the wide box in IE thanks it works perfect! I take this oppertunity to bow to the goddess, I don't know how you do all of this with all those kids and a full time job. When I can I will donate because I think your greater than sliced bread. Thanks again!

Quote:

---

Originally Posted by NotGoddess

Oh, in case anyone is wondering, the wishlist so far is:
Fix the newsletter script itself (occassionally errors out sending large groups) or at least note what emails were sent so manual fixes can avoid duplication.

---

has there been any fixes for this issue. i tried to send newsletter to 6000+ emails and if failed in both time.

now, i created groups thru the query_builder, grouped those 6000emails into 200s... every 200 at once...but still not sure if that will work or not ...
what # of emails do you think this script can handle ??

I haven't had a chance to look too far into it yet, sorry.
Right now I can suggest that you check your time limits...do a php info for:

max_execution_time (usually 30)

max_input_time (usually -1)

and see if you can set the execution time higher either with a php.ini or htaccess (not sure if you can set them in htaccess). The script already sets the time limit (set_time_limit) to 600 seconds, which should be more than long enough (it's not enabled if you are in safe mode tho), so it's possible one of the other settings is affecting it.

-Ng_

Another option is to use the Cart to get the emails, but export them and mail the newsletter from a mailing list program, like GroupMail (recommended by DrByte).

There's an email exporter in the downloads area that I've tested with subscriptions and since it lets you choose what email group to export you can grab all subscribers & not just customers. (Since that works so easily I won't be adding an exporter to the subscription manager and reinvent the wheel-I'll just do the importer).

-Ng_

max_execution_time Local value:60 Master value: 30

to be honest, i dont know how to create a php.ini file for that... (using shared hosting) and neither with htaccess...
do u have any guide...

i will research about GroupMail, i was also thinking of phpmail ...

geeee, i reinstalled the subscribtion, and now i forgot how i fixed the sidebox width issue... which file was that...