Error. Please install plugin again.

  • Resolved plerix

    (@plerix)


    5 years, 3 months ago

    Hi all,

    Impossible to create a calendar in the free version.
    In debug log I see:

    [05-Aug-2019 16:46:17 UTC] Erreur de la base de données WordPress Unknown column 'def_year' in 'field list' pour la requête 
INSERT INTO <code>lwp_9_spidercalendar_calendar</code> 
(<code>id</code>, <code>title</code>, <code>gid</code>, <code>def_year</code>, <code>def_month</code>, <code>def_zone</code>, <code>time_format</code>, <code>allow_publish</code>, <code>published</code>) 
VALUES 
(NULL, 'Cours WordPress', '', '2019', '', 'Asia/Muscat', '0', '', 1) faite par do_action('toplevel_page_SpiderCalendar'), WP_Hook->do_action, WP_Hook->apply_filters, Manage_Spider_Calendar, apply_spider_calendar

    When I go to the table I see those fields:

    1	idPrimaire	int(11)			Non	Aucun(e)		AUTO_INCREMENT	 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	2	title	varchar(255)	utf8_general_ci		Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	3	gid	varchar(255)	utf8_general_ci		Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	4	def_zone	varchar(255)	utf8_general_ci		Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	5	time_format	tinyint(1)			Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	6	allow_publish	varchar(255)	utf8_general_ci		Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	7	start_month	varchar(255)	utf8_general_ci		Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus
	8	published	tinyint(1)			Non	Aucun(e)			 Modifier Modifier	 Supprimer Supprimer	
Plus Plus

    So the error seems logic as the field is missing … but I do not understand why …
    (Running under WordPress 5.2.2 multisite)

    I have tryed to reinstall the plugin without any change …

    Thanks a lot in advance ??
    Philippe

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)

  • Greetings!

    Please navigate to phpmyadmin and check whether the lwp_9_spidercalendar_calendar table has been successfully created. In case it is not created, then you most probably are facing with the permissions issue and the plugin is being unable to create the tables.
    In the below-mentioned case, you are required to contact your Hosting Provider in order to solve the existing issue.

    Thank you!

    Thread Starter plerix

    (@plerix)

    Hi Shushan,

    As you can see here upper I’ve attached the print of the table … so it exists ??
    The table is currently empty … which is normal after installation.

    When trying to add the first calendar, the insert fails because :

    • fields “def_year” and “def_month” don’t exits in the table but are required in the insert request.
    • field start_month doesn’t exit in the insert request.

    So either the query is incorrect, or the table created does not meet expectations.
    I have tryed to reinstall the plugin after having deleted all the calendar tables without any change.

    Regards,
    Philippe

    • This reply was modified 5 years, 3 months ago by plerix.
    • This reply was modified 5 years, 3 months ago by plerix.

    Hi there,

    Please be informed that there is no issue from our side. Would you, please try to operate with the Event Calendar as the mentioned issue will not persist in there?

    Thank you!

    Thread Starter plerix

    (@plerix)

    Hi,

    The Event Calendar works well (already tested) but doesn’t give me a widget with a mini calendar.
    I’ll search other solutions.

    Thanks.
    Philippe

    Greetings!

    Please be informed that a widget with the mini calendar is available in the Event Calendar Plugin.

    Navigate to Appearance > Widgets page to begin publishing your calendar as a widget. From the left side of this dashboard, look for the Event Calendar Widget. Click on it, then select the widget area where you wish to have the calendar. Here is the link for your review.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error. Please install plugin again.’ is closed to new replies.