email not beeing sent - Cobalt 8

Цитата

stblink

Total posts: 501
09 Апр 2013 11:56

I configured cron as you described, here's the result (set to 5 minutes):

--2013-04-09 17:50:01-- http://www.mysite.net/w3/index.php?option=com_cobalt

Resolving www.mysite.net... 5.9.104.173

Connecting to www.mysite.net|5.9.104.173|:80... connected.

HTTP request sent, awaiting response... 303 See other

Location: http://www.mysite.net/w3/index.php?option=com_cobalt& ;lang=br [following]

--2013-04-09 17:50:02-- http://www.mysite.net/w3/index.php?option=com_cobalt& ;lang=br

Reusing existing connection to www.mysite.net:80.

HTTP request sent, awaiting response... 500 Visualiza\303\247\303\243o n\303\243o encontrada [nome, tipo, prefixo]: cobalt, html, cobaltView

2013-04-09 17:50:02 ERROR 500: Visualiza\303\247\303\243o n\303\243o encontrada [nome, tipo, prefixo]: cobalt, html, cobaltView.

On section parameteres:

Send e-mail alert is set to ON

All events below this option have notification set to registered.

But i don't receive any e-mail from cobalt.

Heres the translation of the error message: View not found [name, type, prefix]

Последние изменения: 02 Март 2014

Цитата

Sergey

Total posts: 13,748
10 Апр 2013 02:42

I do not see task=cron.sendAlert in the URL
Also add lang=br or it will redirect and produce 303 error.

Цитата

stblink

Total posts: 501
10 Апр 2013 10:11

If i access the page threw browser this is what i get:

Error: 500 - SQL=SELECT id, email FROM jvdwg_users WHERE block = 0 AND id IN(SELECT user_id FROM jvdwg_js_res_subscription_params WHERE subscribe = 1 AND schedule = 1 AND last_send < NOW() - INTERVAL 1 MINUTE)

Цитата

Sergey

Total posts: 13,748
11 Апр 2013 05:01

Fixed in update we will release today.

Цитата

stblink

Total posts: 501
11 Апр 2013 08:18

thanks

Цитата

stblink

Total posts: 501
27 Апр 2013 12:29

Updated Cobalt to latest version.

Still not sending e-mails. Here's the error when i access the page.

Error: 1054 - Unknown column 'subscribe' in 'where clause' SQL=SELECT id, email FROM jvdwg_users WHERE block = 0 AND id IN( SELECT user_id FROM jvdwg_js_res_user_options WHERE subscribe = 1 AND schedule = 1 AND last_send < NOW() - INTERVAL 1 MINUTE)

Цитата

Sergey

Total posts: 13,748
29 Апр 2013 01:28

Please give me screenshot with structure of jvdwg_js_res_user_options table.

Цитата

Sergey

Total posts: 13,748
30 Апр 2013 00:13

Thank you. I have fixed this error in next update.

Цитата

stblink

Total posts: 501
09 Июль 2013 12:26

the column is lastsend and not last_send

already changed:

components\com_cobalt\controllers\cron.php

lines:

242

Цитата

stblink

Total posts: 501
09 Июль 2013 13:26

After fixed the cron.php it now displays a blank page, is it normal?

However the events of the section is untouched (Cobalt default) and send e-mail option is set to YES.

I receive e-mails from acymailing and Joomla default registration (activation link) so it's not an e-mail configuration problem (smtp)

I added a record as a user and approved it, no one received any kind of notification and i went to check table js_res_user_options and it's exactly as it was 2 month ago when i posted a screenshot.

Цитата

Sergey

Total posts: 13,748
10 Июль 2013 07:34

After fixed the cron.php it now displays a blank page, is it normal?

Yes

After fixed the cron.php it now displays a blank page, is it normal?

I added a record as a user and approved it, no one received any kind of notification and i went to check table js_res_user_options and it's exactly as it was 2 month ago when i posted a screenshot.

I see. now i have found that all alerts sending mechanism is wrong. I have to redo it.

Цитата

stblink