Dragonfly CMS - German Community

dcorwin · Investigator Offline Joined: Jun 03, 2004 Posts: 14

I get the following when I try to change Events4U's default view to month:

Array:

On /admin.php?op=CalendarConfigSave
While executing query "UPDATE cms_events4u_config  SET defaultview='month', minuterange='10', usetopics='1', allowaddarticle='1', allowuserpost='1', userautoactive='0',  allowanonpost='1', anonautoactive='0', AdminEditAll='1', weekbeginn='0', interdate='1', AdminType='radminsuper', listcount='15', listStarttime='0', listEnddate='1', listEndtime ='0', listEnddate2='0', listBrTime='0', catListCols='3', TextEvents='1', ShowPopup='0', showlinks='0', showblock='1' , TimeArray='09:00:00, 10:00:00, 11:00:00, 12:00:00, 13:00:00, 14:00:00, 15:00:00, 16:00:00, 17:00:00, 19:00:00' , searchcount='30', searchTopics='1'  WHERE id='1'"

the following error occured: Unknown column 'weekbeginn' in 'field list'

I then went in to sql and changed it from'day' to 'month' by hand and it won't change. Is 'month' the word it's looking for even?

Thanks

Ertan

it is solved bug

delete with phpmyadmin the $prefix_events4u_config table

and create new one :

CREATE TABLE `cms_events4u_config` (
`id` int(9) NOT NULL auto_increment,
`defaultview` varchar(25) NOT NULL default 'day',
`minuterange` int(10) NOT NULL default '15',
`usetopics` varchar(10) NOT NULL default '1',
`allowaddarticle` int(1) NOT NULL default '0',
`allowuserpost` int(1) NOT NULL default '0',
`userautoactive` int(1) NOT NULL default '0',
`allowanonpost` int(1) NOT NULL default '0',
`anonautoactive` int(1) NOT NULL default '0',
`AdminEditAll` int(1) NOT NULL default '1',
`weekbeginn` int(1) NOT NULL default '0',
`interdate` int(1) NOT NULL default '1',
`AdminType` varchar(25) NOT NULL default 'radminsuper',
`listcount` int(10) NOT NULL default '4',
`listStarttime` int(1) NOT NULL default '1',
`listEnddate` int(1) NOT NULL default '0',
`listEndtime` int(1) NOT NULL default '0',
`listEnddate2` int(1) NOT NULL default '0',
`listBrTime` int(1) NOT NULL default '0',
`catListCols` int(3) NOT NULL default '4',
`TextEvents` int(1) NOT NULL default '1',
`ShowPopup` int(1) NOT NULL default '0',
`showlinks` int(1) NOT NULL default '0',
`showblock` int(1) NOT NULL default '1',
`TimeArray` text NOT NULL,
`searchcount` int(5) NOT NULL default '30',
`searchTopics` int(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ;

dcorwin · Investigator Offline Joined: Jun 03, 2004 Posts: 14

This code unfortunately generates and sql error when I return to my cpgnuke site.

Array:

On /admin.php?op=CalendarAdmin 
While executing query "select aid, pwd, , radminsuper from cms_authors where aid='admin'" 

the following error occured: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ' radminsuper from cms_authors where aid='admin'' at line 1

Ertan

oohhpps

insert data for config table :

INSERT INTO `cms_events4u_config` VALUES (1, 'day', 10, '1', 1, 1, 0, 1, 0, 1, 1, 0, 'radminsuper', 15, 0, 1, 0, 0, 0, 3, 1, 0, 0, 1, '09:00:00, 10:00:00, 11:00:00, 12:00:00, 13:00:00, 14:00:00, 15:00:00, 16:00:00, 17:00:00, 19:00:00', 30, 1);

dcorwin · Investigator Offline Joined: Jun 03, 2004 Posts: 14

Danke CpgNuke4U! Works great, now onto the new block!