help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

[SOLVED] Backend events error

Re: [SOLVED] Backend events error

1 year 5 months ago - 1 year 5 months ago
#30409
Run this sql script and the events come back:
Code:
ALTER TABLE j4arz3_jem_attachments MODIFY added datetime NULL DEFAULT null; ALTER TABLE j4arz3_jem_categories MODIFY description mediumtext NULL DEFAULT null , MODIFY meta_keywords text NULL DEFAULT null , MODIFY meta_description text NULL DEFAULT null , MODIFY checked_out_time datetime NULL DEFAULT null , MODIFY note varchar(255) NULL DEFAULT null , MODIFY language varchar(7) NULL DEFAULT null , MODIFY created_time datetime NOT NULL DEFAULT current_timestamp() , MODIFY path varchar(255) NULL DEFAULT null , MODIFY metadata varchar(2048) NULL DEFAULT null , MODIFY modified_time datetime NULL DEFAULT null , MODIFY email varchar(200) NULL DEFAULT null; ALTER TABLE j4arz3_jem_cats_event_relations MODIFY ordering tinyint(11) NOT NULL DEFAULT 0; ALTER TABLE j4arz3_jem_events MODIFY modified datetime NULL DEFAULT null , MODIFY created datetime NOT NULL DEFAULT current_timestamp() , MODIFY meta_keywords varchar(200) NULL DEFAULT null , MODIFY meta_description varchar(255) NULL DEFAULT null , MODIFY checked_out_time datetime NULL DEFAULT null , MODIFY attribs varchar(5120) NOT NULL DEFAULT '''' , MODIFY language char(7) NOT NULL DEFAULT ''''; ALTER TABLE j4arz3_jem_groups MODIFY description mediumtext NULL DEFAULT null , MODIFY checked_out_time datetime NULL DEFAULT null; ALTER TABLE j4arz3_jem_venues MODIFY locdescription mediumtext NULL DEFAULT null , MODIFY meta_keywords text NULL DEFAULT null , MODIFY meta_description text NULL DEFAULT null , MODIFY created datetime NOT NULL DEFAULT current_timestamp() , MODIFY modified datetime NULL DEFAULT null , MODIFY checked_out_time datetime NULL DEFAULT null , MODIFY publish_up datetime NULL DEFAULT null , MODIFY publish_down datetime NULL DEFAULT null , MODIFY attribs varchar(5120) NULL DEFAULT null , MODIFY language char(7) NULL DEFAULT null; UPDATE j4arz3_jem_config SET value = 'H:i' WHERE keyname = 'formattime'; UPDATE j4arz3_jem_config SET value = 'H' WHERE keyname = 'formathour'; UPDATE j4arz3_jem_config SET value = '{"css_backend_usecustom":"0","css_backend_customfile":"","css_calendar_usecustom":"0","css_calendar_customfile":"","css_colorpicker_usecustom":"0","css_colorpicker_customfile":"","css_geostyle_usecustom":"0","css_geostyle_customfile":"","css_googlemap_usecustom":"0","css_googlemap_customfile":"","css_jem_usecustom":"0","css_jem_customfile":"","css_print_usecustom":"0","css_print_customfile":"","css_color_bg_filter":"","css_color_bg_h2":"","css_color_bg_jem":"","css_color_bg_table_th":"","css_color_bg_table_td":"","css_color_bg_table_tr_entry2":"","css_color_bg_table_tr_hover":"","css_color_bg_table_tr_featured":"","css_color_border_filter":"","css_color_border_h2":"","css_color_border_table_th":"","css_color_border_table_td":"","css_color_font_h2":"","css_color_font_table_th":"","css_color_font_table_td":"","css_color_font_table_td_a":""}' WHERE keyname ='css'; UPDATE j4arz3_jem_config SET value = 'jpg,gif,png,webp' WHERE keyname = 'image_filetypes'; INSERT IGNORE INTO `j4arz3_jem_config` (`keyname`, `value`, `access`) VALUES ('flagicons_path', 'media/com_jem/images/flags/w20-png/', '0'); ALTER TABLE `j4arz3_jem_events` ADD `minbookeduser` INT NOT NULL DEFAULT '0' AFTER `maxplaces`; ALTER TABLE `j4arz3_jem_events` ADD `maxbookeduser` INT NOT NULL DEFAULT '0' AFTER `minbookeduser`; ALTER TABLE `j4arz3_jem_events` ADD `reservedplaces` INT NOT NULL DEFAULT '0' AFTER `maxbookeduser`;
I don't know why but in your JEM installation hasn't applied the sql update.
Last edit: 1 year 5 months ago by McKillo.

Please Log in or Create an account to join the conversation.

Re: [SOLVED] Backend events error

1 year 5 months ago
#30412
I don't know it, but your previous JEM version was 3.0.6 (old beta/draft from dev without suport and update) and for it, you have all these error. The script of JEM 4.0 didn't detect your version and all sql script don't work and don't update. JEM 4 detects old 2.3.x version to migration from JEM 2.3.x to JEM 4.0, not 3.0.

But the previous message should be solved the issue and shoul be see the event in the eventlist view and de calendar module.

At the end, you can run this other script to clean key in the _jem_config table:
Code:
DELETE FROM `j4arz3_jem_config` WHERE `keyname`='evdelrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='eventeditrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='evpubrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='locdelrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='locpubrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vcalendar'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vcategories'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vcategory'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='veditevent'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='venueeditrec'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='version'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vevent'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vvenue'; DELETE FROM `j4arz3_jem_config` WHERE `keyname`='vvenues';

In the future, I recommend you update JEm from stable versions published on the web, so you will have support and avoid errors.
The following user(s) said Thank You: wesselsjan

Please Log in or Create an account to join the conversation.

Re: [SOLVED] Backend events error

1 year 5 months ago
#30413
With your help my local website works correct now. I deleted the test-site at Kerken in Assen.
For updating JEM from now on I'll use the stable versions.

Please Log in or Create an account to join the conversation.

Re: [SOLVED] Backend events error

1 year 5 months ago
#30414
Perfect, Glad to hear it and enjoy JEM.
Case closed and solved.

Please Log in or Create an account to join the conversation.

Time to create page: 0.526 seconds