TOPIC: Messages do not send

Messages do not send 12 years 1 hour ago #771

  • MacChap
  • MacChap's Avatar
  • OFFLINE
  • Posts: 12
  • Karma: 0
Hi

Nicely thought out component but have had a couple of issues. The first was related to using the JCE Editior but I managed to find one of your patches that fixed that.
More seriously, I am unable to send a mewsletter (message) It is a public newsletter and I have registered 2 subscribers. I'm including the debug log below & attaching a screenshot of the sending screen.. You will see that I have tried both personal and bulk sending options.
Joomla Version 1.5.24
Jinc Version 0.9.4
I can send standard Joomla Mass mail OK.
Hope you can assist!
[EDIT] I should add that Preview messages send OK ....
[2nd EDIT] More info: When a message is sent there is a Javascript error reported:
Timestamp: 09/05/2012 19:28:53
Error: not well-formed
Source File: www.tennysonplayers.org.uk/administrator...task=send&format=raw
Line: 1, Column: 1
Source Code:
{"status":"3","tot_recipients":"2","sent_messages":0,"sent_success":0,"last_subscriber_time":0,"server_time":"Wed, 09 May 2012 19:28:53 +0100","start_time":"Wed, 09 May 2012 19:28:53 +0100"}
2012-05-09 09:48:29 qt3tb25is616na8962qhbd8r41 WARNING ERROR_ERR047
2012-05-09 14:47:50 6r9kej4ideuifidle40hed2ok4 WARNING ERROR_ERR047
2012-05-09 14:47:50 6r9kej4ideuifidle40hed2ok4 WARNING ERROR_ERR047
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT proc_id, proc_status, UNIX_TIMESTAMP(proc_start_time) AS proc_start_time, UNIX_TIMESTAMP(proc_last_update_time) AS proc_last_update_time, proc_client_id, proc_sent_messages, proc_sent_success, UNIX_TIMESTAMP(proc_last_subscriber_time) AS proc_last_subscriber_time, proc_last_subscriber_id FROM #__jinc_process WHERE proc_msg_id = 6 AND proc_status != 3
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: INSERT INTO #__jinc_process (proc_msg_id, proc_status, proc_start_time, proc_last_update_time) VALUES (6, 0, now(), 0)
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_status = 2 , proc_client_id = '1336579027830_4649' WHERE proc_id = 27
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 6
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Bulk Message Building
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG PublicRetriever: executing query SELECT COUNT(p.pub_email) AS num_subs FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL)
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER Sending process: 0 - 0
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER BulkMessage: Sleep time 500000 - Max mails 1 Max BCC 50 Send mail 1
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER BulkMessage: Newsletter loaded
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER BulkMessage: going to add recipients
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER PublicRetriever: Start time 0 Start id 0 Multiplexer 50
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG PublicRetriever: executing query: SELECT p.pub_email as usermail, UNIX_TIMESTAMP(p.pub_datasub) as last_time, p.pub_id as last_id, att0.value as `attr_name` FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id LEFT JOIN `#__jinc_attribute_name` att0 ON p.pub_id = att0.id AND n.news_id = att0.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL) AND ( UNIX_TIMESTAMP(p.pub_datasub) > 0 OR (UNIX_TIMESTAMP(p.pub_datasub) = 0 AND p.pub_id > 0) ) ORDER BY p.pub_datasub, p.pub_id LIMIT 0, 50
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER BulkMessage: found 0 subscribers
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_status = 3 WHERE proc_id = 27
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 FINER Process: triggering message sent event
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG StatisticalEvent: Executing query: INSERT INTO `#__jinc_stats_event` (`stat_type`, `stat_date`, `stat_news_id`) VALUES (2, now(), 1)
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG SentMsgEvent: executing query: UPDATE #__jinc_newsletter SET news_lastsent = now() WHERE news_id = 1
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG SentMsgEvent: executing query: UPDATE #__jinc_message SET msg_datasent = now() WHERE msg_id = 6
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_last_subscriber_time = FROM_UNIXTIME(0), proc_last_update_time = NOW(), proc_last_subscriber_id = 0, proc_sent_success = 0, proc_sent_messages = 0 , proc_start_time = FROM_UNIXTIME(1336579028) WHERE proc_id = 27
2012-05-09 16:57:08 i972alkmhq2odv1gose65ma214 DEBUG JSON: {"status":"3","tot_recipients":"2","sent_messages":0,"sent_success":0,"last_subscriber_time":0,"server_time":"Wed, 09 May 2012 16:57:08 +0100","start_time":"Wed, 09 May 2012 16:57:08 +0100"}
2012-05-09 16:57:49 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: executing query SELECT tem_id, tem_name FROM #__jinc_template
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 5
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Personal Message Building
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1
2012-05-09 16:58:03 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:58:07 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: executing query SELECT tem_id, tem_name FROM #__jinc_template
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 5
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Personal Message Building
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1
2012-05-09 16:58:11 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:58:18 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: executing query SELECT tem_id, tem_name FROM #__jinc_template
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 6
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Bulk Message Building
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1
2012-05-09 16:58:20 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT proc_id, proc_status, UNIX_TIMESTAMP(proc_start_time) AS proc_start_time, UNIX_TIMESTAMP(proc_last_update_time) AS proc_last_update_time, proc_client_id, proc_sent_messages, proc_sent_success, UNIX_TIMESTAMP(proc_last_subscriber_time) AS proc_last_subscriber_time, proc_last_subscriber_id FROM #__jinc_process WHERE proc_msg_id = 6 AND proc_status != 3
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: INSERT INTO #__jinc_process (proc_msg_id, proc_status, proc_start_time, proc_last_update_time) VALUES (6, 0, now(), 0)
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 6
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Personal Message Building
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1 AND published = 1
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG Newsletter: Executing query: SELECT a.acc_grp_id, a.acc_role, g.grp_name FROM #__jinc_access a LEFT JOIN #__jinc_group g ON a.acc_grp_id = g.grp_id WHERE acc_news_id = 1
2012-05-09 16:58:26 i972alkmhq2odv1gose65ma214 DEBUG PublicRetriever: executing query SELECT COUNT(p.pub_email) AS num_subs FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL)
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT proc_id, proc_status, UNIX_TIMESTAMP(proc_start_time) AS proc_start_time, UNIX_TIMESTAMP(proc_last_update_time) AS proc_last_update_time, proc_client_id, proc_sent_messages, proc_sent_success, UNIX_TIMESTAMP(proc_last_subscriber_time) AS proc_last_subscriber_time, proc_last_subscriber_id FROM #__jinc_process WHERE proc_msg_id = 6 AND proc_status != 3
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_status = 2 , proc_client_id = '1336579109309_1353' WHERE proc_id = 28
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG MessageFactory: Executing query: SELECT m.msg_id, m.msg_body, m.msg_subject, m.msg_plaintext, m.msg_attachment, m.msg_bulkmail, msg_news_id FROM #__jinc_message m LEFT JOIN #__jinc_newsletter n ON m.msg_news_id = n.news_id WHERE msg_id = 6
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER MessageFactory: Personal Message Building
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: Executing query: SELECT news_sendername, news_senderaddr, news_type, news_name, news_description, news_disclaimer, news_optin_subject, news_optin, news_welcome_subject, news_welcome, news_default_template, news_optinremove_subject, news_optinremove, news_on_subscription, news_jcontact_enabled, news_captcha, news_front_theme, news_front_max_msg, news_front_type, news_attributes, news_replyto_name, news_replyto_addr, news_notify, news_noti_id, news_input_style FROM #__jinc_newsletter n WHERE news_id = 1
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER NewsletterFactory: Building Public Newsletter with PublicRetriever
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG PublicRetriever: executing query SELECT COUNT(p.pub_email) AS num_subs FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL)
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER Sending process: 0 - 0
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER PersonalMessage: Sleep time 500000 - Max mails 1 Send mail 1
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER PersonalMessage: Newsletter loaded
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER PersonalMessage: going to add recipients
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER PublicRetriever: Start time 0 Start id 0 Multiplexer 1
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG PublicRetriever: executing query: SELECT p.pub_email as usermail, UNIX_TIMESTAMP(p.pub_datasub) as last_time, p.pub_id as last_id, att0.value as `attr_name` FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id LEFT JOIN `#__jinc_attribute_name` att0 ON p.pub_id = att0.id AND n.news_id = att0.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL) AND ( UNIX_TIMESTAMP(p.pub_datasub) > 0 OR (UNIX_TIMESTAMP(p.pub_datasub) = 0 AND p.pub_id > 0) ) ORDER BY p.pub_datasub, p.pub_id LIMIT 0, 1
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER PersonalMessage: found 0 subscribers
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_status = 3 WHERE proc_id = 28
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 FINER Process: triggering message sent event
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG StatisticalEvent: Executing query: INSERT INTO `#__jinc_stats_event` (`stat_type`, `stat_date`, `stat_news_id`) VALUES (2, now(), 1)
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG SentMsgEvent: executing query: UPDATE #__jinc_newsletter SET news_lastsent = now() WHERE news_id = 1
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG SentMsgEvent: executing query: UPDATE #__jinc_message SET msg_datasent = now() WHERE msg_id = 6
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG Process: executing query: UPDATE #__jinc_process SET proc_last_subscriber_time = FROM_UNIXTIME(0), proc_last_update_time = NOW(), proc_last_subscriber_id = 0, proc_sent_success = 0, proc_sent_messages = 0 , proc_start_time = FROM_UNIXTIME(1336579109) WHERE proc_id = 28
2012-05-09 16:58:29 i972alkmhq2odv1gose65ma214 DEBUG JSON: {"status":"3","tot_recipients":"2","sent_messages":0,"sent_success":0,"last_subscriber_time":0,"server_time":"Wed, 09 May 2012 16:58:29 +0100","start_time":"Wed, 09 May 2012 16:58:29 +0100"}
2012-05-09 17:10:07 i972alkmhq2odv1gose65ma214 DEBUG NewsletterFactory: executing query SELECT news_id, news_name FROM #__jinc_newsletter
Attachments:
The administrator has disabled public write access.

Re:Messages do not send 11 years 11 months ago #774

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
Hi MacChap,
I analyzed your log. I did not find any errors ... it seems you have two subscribers, but that they have not confirmed the subscription clicking the opt-in message?
Is it possible? Can you check that the subscribers are in state 'confirmed' and not in state 'Waiting for opt-in confirmation'? You can see this in subscriber list ...
Thanks for you contribution and Best Regards,
Lhacky.
The administrator has disabled public write access.

Re:Messages do not send 11 years 11 months ago #775

  • MacChap
  • MacChap's Avatar
  • OFFLINE
  • Posts: 12
  • Karma: 0
Thanks for your response, Lhacky

Their subscriptions are confirmed - they are test subscribers using email accounts I own. Their status is Active in the Subscribers List screen. I'm sure I have everything set up correctly.....?????

Best regards

Chris
The administrator has disabled public write access.

Re:Messages do not send 11 years 11 months ago #776

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
Hi,
I analyzed the source code ... and the problem seems to be this query ...


SELECT p.pub_email as usermail, UNIX_TIMESTAMP(p.pub_datasub) as last_time, p.pub_id as last_id, att0.value as `attr_name`FROM #__jinc_newsletter n LEFT JOIN #__jinc_public_subscriber p ON p.pub_news_id = n.news_id LEFT JOIN `#__jinc_attribute_name` att0 ON p.pub_id = att0.id AND n.news_id = att0.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL) AND ( UNIX_TIMESTAMP(p.pub_datasub) > 0 OR (UNIX_TIMESTAMP(p.pub_datasub) = 0 AND p.pub_id > 0) ) ORDER BY p.pub_datasub, p.pub_id LIMIT 0, 50


it should return two row, but it seems it does not. Can you execute it using for example phpmyadmin and substituting the string '#_' with your Joomla! table prefix? Can you tell me what is the result ?
If it return 0 rows can you remove the 'AND (p.pub_random = ... LIMIT 0, 50) clausole to see if something changes?
Thanks and sorry for these questions ...
Lhacky.
The administrator has disabled public write access.

Re:Messages do not send 11 years 11 months ago #777

  • MacChap
  • MacChap's Avatar
  • OFFLINE
  • Posts: 12
  • Karma: 0
I ran the query as:

SELECT p.pub_email as usermail, UNIX_TIMESTAMP(p.pub_datasub) as last_time, p.pub_id as last_id, att0.value as `attr_name`FROM jos_jinc_newsletter n LEFT JOIN jos_jinc_public_subscriber p ON p.pub_news_id = n.news_id LEFT JOIN `jos_jinc_attribute_name` att0 ON p.pub_id = att0.id AND n.news_id = att0.news_id WHERE n.news_id = 1 AND (p.pub_random = '' OR p.pub_random IS NULL) AND ( UNIX_TIMESTAMP(p.pub_datasub) > 0 OR (UNIX_TIMESTAMP(p.pub_datasub) = 0 AND p.pub_id > 0) ) ORDER BY p.pub_datasub, p.pub_id LIMIT 0, 50

I get an error: #1146 - Table 'web196db1.jos_jinc_attribute_name' doesn't exist
The administrator has disabled public write access.

Re:Messages do not send 11 years 11 months ago #778

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
Hi,
for some reason the name attribute table (default attibute) is missing ... recreate it with this query

CREATE TABLE IF NOT EXISTS `jos_jinc_attribute_name` (
`news_id` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL,
`value` varchar(255),
PRIMARY KEY (`news_id`, `id`)
) DEFAULT CHARSET=utf8;

and try to re-execute the previous query. If no errors appear try to resend the newsletter ... and let me know.
Lhacky.
The administrator has disabled public write access.
Time to create page: 0.041 seconds

JINC Forum Latest

0 Topics

Recent Discussions

There are no topics to display.
0 Topics

Who Is Online

Total users online: 0 Members and 5 Guests Online
Legend:  Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 1355 | Total Subjects: 358
  • Total Sections: 3 | Total Categories: 7
  • Today Open: 0 | Yesterday Open: 0
  • Today Total Answer: 0 | Yesterday Total Answer: 0

plgJPiwik Forum Latest

0 Topics

Recent Discussions

There are no topics to display.
0 Topics

Who Is Online

Total users online: 0 Members and 5 Guests Online
Legend:  Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 1355 | Total Subjects: 358
  • Total Sections: 3 | Total Categories: 7
  • Today Open: 0 | Yesterday Open: 0
  • Today Total Answer: 0 | Yesterday Total Answer: 0

plgLTPA Forum Latest

0 Topics

Recent Discussions

There are no topics to display.
0 Topics

Who Is Online

Total users online: 0 Members and 5 Guests Online
Legend:  Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 1355 | Total Subjects: 358
  • Total Sections: 3 | Total Categories: 7
  • Today Open: 0 | Yesterday Open: 0
  • Today Total Answer: 0 | Yesterday Total Answer: 0
Thursday the 9th. Joomla 2.5 templates.