News & Article Management [Support]

[ideasgirl]

Well, apparently something is wrong, this is my patch:

# News Scroller Config
INSERT INTO configuration VALUES ('', 'News Sidebox Scroller Days', 'NEWS_SCROLLER_NUMBER_OF_DAYS', '7', 'The news sidebox scroller will only contain news from the past xx news days', '2504', '100', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Height', 'NEWS_SCROLLER_HEIGHT', '250', 'The height of the news sidebox scroller box', '2504', '101', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Amount', 'NEWS_SCROLLER_AMOUNT', '2', 'The amount to scroll by', '2504', '102', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Delay', 'NEWS_SCROLLER_DELAY', '100', 'The amount of delay when scrolling', '2504', '103', NULL, now(), NULL, NULL);
UPDATE configuration, configuration_group SET configuration.configuration_group_id = configuration_group.configuration_group_id WHERE configuration_group.configuration_group_title = 'News & Articles Management' AND configuration.configuration_group_id = '2504'; 

but it stops while processing.

[dreamscape]

That Update statement should be commented out. It doesn't work with the Zen Cart SQL Patch tool.

The Select & Update statement after it should be the one that runs and it should read:

SELECT @group_id := configuration_group_id FROM configuration_group WHERE configuration_group_title = 'News & Articles Management';
UPDATE configuration SET configuration_group_id = @group_id where configuration_group_id = '2504';

If you've already run the INSERT INTO configuration VALUES ... statement, don't run it again. Just run what I've posted above.

[ideasgirl]

B I N G O ! Thanks!

[tajul_ashyqin]

its not working for me though... the scroller setting still wont appear where it should be!

[icemanchai]

Is this News and Articles module support multilanguage?

If not, is there any code suggest to add for this function?

Thanks.

[tajul_ashyqin]

Is this News and Articles module support multilanguage?

If not, is there any code suggest to add for this function?

Thanks.

yup, it is support multilanguage function... no special code required!

[ideasgirl]

Is it supposed to go to the last article post when clicking on "Articles....more"? or is it supposed to go to to the archive? or....?

How can I make the archive page to display the intro/summary for each article?

[icemanchai]

Thanks Tajul_ashyqin. I want to clarify that:

Does it mean I can input three different news interpretation for switching among three languages environment?

Or you mean I can type in different language but only showed one kind of language whenever I switch the language environments?


Thanks.

[Asdesign]

I'm in big trouble.

I installed this contribution + the optional news scroller. It went fine except of the SQL patch of the scroller which isn't ending correctly, it only installed the sidebox but not the statements required for changing the height and such. Luckly, I found a solution for that earlier in this thread so that one is pretty much solved. ANYWAY, I have the FCK editor installed and it doesn't seem to work properly with the articles management so I changed back to HTML AREA and it works (still need to solve this tho). Thing is, before I figured it was the FCK editor causing a php error on the articles management, I went back and re-ran the SQL patches for the article management and now I have it appearing twice in the admin 'configuration' menu I found an uninstall SQL patch earlier in this thread but that doesn't work correctly so I'm in trouble. How can I totally remove Article management from the SQL so I can cleanly install it again?

[ts232]

Well, apparently something is wrong, this is my patch:

# News Scroller Config
INSERT INTO configuration VALUES ('', 'News Sidebox Scroller Days', 'NEWS_SCROLLER_NUMBER_OF_DAYS', '7', 'The news sidebox scroller will only contain news from the past xx news days', '2504', '100', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Height', 'NEWS_SCROLLER_HEIGHT', '250', 'The height of the news sidebox scroller box', '2504', '101', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Amount', 'NEWS_SCROLLER_AMOUNT', '2', 'The amount to scroll by', '2504', '102', NULL, now(), NULL, NULL),
                                 ('', 'News Sidebox Scroller Delay', 'NEWS_SCROLLER_DELAY', '100', 'The amount of delay when scrolling', '2504', '103', NULL, now(), NULL, NULL);
UPDATE configuration, configuration_group SET configuration.configuration_group_id = configuration_group.configuration_group_id WHERE configuration_group.configuration_group_title = 'News & Articles Management' AND configuration.configuration_group_id = '2504'; 

but it stops while processing.

I had the same problem, for me the solution was to modify the UPDATE part of the query tio include the zen_ prefix. I did this in phpMyAdmin, but you could probably also do it useing the Admin->SQL Update option. The correct sql should be:

UPDATE zen_configuration, zen_configuration_group SET zen_configuration.configuration_group_id = zen_configuration_group.configuration_group_id WHERE zen_configuration_group.configuration_group_title = 'News & Articles Management' AND zen_configuration.configuration_group_id = '2504'

PLEASE, backup your DB before you try it!