Newsletter-Only Subscriptions for v1.3x

[meadwench]

By refreshing too quickly, I meant that the server I was testing on was 2 yards away on a direct network connection, so any message would have flashed by too quickly for me to see.
On the caching side - clutching at straws really, the thought that it might be returning a cached page with the info still there, or that the DB writes are writing to cache, but not propagating out to the DB.
A couple of judiciously placed debug writes or echo statements to ensure that the code is being executed?

Nope, not returning a cached page, I checked the database via PhpMyAdmin, and the info was still there.

I tried overwriting the files, in case there was a glitch somewhere, but it still isn't deleting when I remove someone via the admin interface.....

[BradSmith]

Installed everything as carefully as possible... but perhaps I skipped a step. I'm getting this error :

1054 Unknown column 'subscribed_date' in 'field list'
in:
[REPLACE INTO subscribers ( customers_id, email_address, email_format, subscribed_date ) VALUES ( '2', '[email protected]', 'HTML', NOW() )]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I'm pretty desperate to get the newsletter installed, so any help is greatly appreciated.

[BradSmith]

After hitting the Back button, I see this...


1054 Unknown column 'confirmed' in 'field list'
in:
[select subscriber_id, customers_id, email_address, email_format, confirmed, subscribed_date from subscribers order by subscriber_id DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.





Subscription Management | | Status: C=Customer N=Newsletter-Only Subscriber P=Pending Confirmation

[ft11]

All of the files have been uploaded, and mods made.

When I hit the 'install' button, the page goes to a blank white, with this left as the address.

/admin/subscription_manager.php?action=install

Going back to the page to install again, only gives the same result.

The database is not being updated. Do you have the necessary SQL that I can manually run thru phpMyAdmin?

That or any suggestions as to what might be wrong. Thanks.

[ft11]

NM. Problem fixed.

[BradSmith]

I'm still desperate for help... We're about to kick off an advertising campaign and having the newsletter would be awesome.

To refresh my situation, I'm getting the following error...


When I click 'SEND' on a Newsletter, I get the following error :

1054 Unknown column 'confirmed' in 'where clause'
in:
[SELECT email_address as customers_email_address FROM subscribers WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help would be greatly appreciated...

[chrisrub]

I installed the newsletter mod, now it breaks my page when you try to subscribe. Test for yourself here: www.axcelsports.com/store

Can someone please help with this? Any idea why it would do that?

[Chuckl]

BradSmith, in your first post above, you refer to an error in a SQL statement - a 'Replace'. Where is that to be found in the Newsletter Subscribers mod? Replace can be dangerous, Update might be safer.

1054 errors are caused by running MySQL 4 code on MySQL 5. A search on the error in the forums will give several solutions.

[Chuckl]

On a closer look, your error seems to be somewhat self inflicted. The Replace did not set a value for the confirmed column, and the default value is 'NULL'. Edit that to '1'.

[BradSmith]

Changing the Confirmed Column Value from NULL to 1 needs to be done from the database by editing a table there, right?

I suppose it's a tad obvious that I've never been involved in this sort of thing before, but I was sort of pushed into the whole web developing thing.