TOPIC: Newsletter not published or not accessible

Re: Newsletter not published or not accessible 10 years 11 months ago #1192

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
Perfect ... you can send me the credential to

This email address is being protected from spambots. You need JavaScript enabled to view it.

Lhacky.
The administrator has disabled public write access.

Re: Newsletter not published or not accessible 10 years 11 months ago #1193

sent
The administrator has disabled public write access.

Re: Newsletter not published or not accessible 10 years 11 months ago #1194

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
I saw your message ... I'll working on your test envirnoment this evening (I can't access it from here now).
Anyway I saw the jinc.log and I would like you try to execute those query against your database server

SELECT sendername, senderaddr, type, name, description, disclaimer, optin_subject, optin, welcome_subject, welcome, default_template, optinremove_subject, optinremove, on_subscription, jcontact_enabled, captcha, front_theme, front_max_msg, front_type, attribs, replyto_name, replyto_addr, notify, notice_id, input_style, suspended FROM #__jinc_newsletter n WHERE id = 1 AND published = 1

and

SELECT sendername, senderaddr, type, name, description, disclaimer, optin_subject, optin, welcome_subject, welcome, default_template, optinremove_subject, optinremove, on_subscription, jcontact_enabled, captcha, front_theme, front_max_msg, front_type, attribs, replyto_name, replyto_addr, notify, notice_id, input_style, suspended FROM #__jinc_newsletter n WHERE id = 6 AND published = 1

where #_ is your Joomla! table prefix. That query return just one row, but in your environment I guess is returning an error or an empty result.

Let me know.

Lhacky.
The administrator has disabled public write access.

Re: Newsletter not published or not accessible 10 years 11 months ago #1196

  • admin
  • admin's Avatar
  • OFFLINE
  • Posts: 553
  • Thank you received: 14
  • Karma: 1
Hi,

I probably understood the problem of you installation.
Is it possible you updated JINC from version 0.9.x or previous? If so, you probably did not follow the instructions reported here

lhacky.altervista.org/jextensions/index....ding-from-jinc-0-9-x

to migrate from JINC 0.9.x to 1.0.x. Anyway you can (re)execute them and this should solve the problem. Actually the problem was that the jinc_newsletter table has no 'suspended' column that is related to a new JINC feature introduced with JINC 1.0.

I hope this solve your problem ... I'm waiting for you answer.

Best Regards,

Lhacky.
The administrator has disabled public write access.

Re: Newsletter not published or not accessible 10 years 11 months ago #1197

I will try it and let you know
The administrator has disabled public write access.

Re: Newsletter not published or not accessible 10 years 11 months ago #1198

This SQl Query seems to fix the issues.
Execute this queries against your MySQL Server substituting the characters #_ with your Joomla! table prefix
ALTER TABLE `#__jinc_message` ADD COLUMN `tem_id` int NOT NULL default 0

ALTER TABLE `#__jinc_subscriber` ADD COLUMN `ipaddr` INT UNSIGNED default 0

ALTER TABLE `#__jinc_template` ADD COLUMN `cssfile` varchar(1024) NOT NULL default ''

ALTER TABLE `#__jinc_newsletter` ADD COLUMN `suspended` int NOT NULL default 0

DROP TABLE IF EXISTS `#__jinc_report`;
CREATE TABLE IF NOT EXISTS `#__jinc_report` (
`proc_id` int(10) unsigned NOT NULL,
`subs_id` int(10) unsigned NOT NULL,
`error_code` int(4) unsigned NOT NULL,
PRIMARY KEY (`proc_id`, `subs_id`)
) DEFAULT CHARSET=utf8;
The administrator has disabled public write access.
Time to create page: 0.034 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 15 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 15 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 15 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
Saturday the 4th. Joomla 2.5 templates.