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.
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!