Newsletter-Only Subscriptions for v1.3x

Quote:

---

Originally Posted by Chuckl

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.....

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.

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 http://rickrushart.com/admin/include...ton_remove.gif http://rickrushart.com/admin/include...bscription.gif | http://rickrushart.com/admin/include...scriptions.gif | http://rickrushart.com/admin/include...ton_import.gif Status: C=Customer N=Newsletter-Only Subscriber P=Pending Confirmation

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.

NM. Problem fixed.

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...

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?

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.

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'.

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.