TOPIC: Messages do not send
Messages do not send 12 years 1 hour ago #771
|
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
|
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
|
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
|
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
|
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
|
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