WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: Events Calendar] sql errors in 2.5 (2 posts)

  1. atrais
    Member
    Posted 6 years ago #

    Hi, I'm trying to install it in 2.5, I get :

    WordPress database error 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 'wpbhf_EventsCalendar_main' at line 1 for query SHOW TABLES LIKEwpbhf_EventsCalendar_mainmade by createTable WordPress database error Table 'wpbhf_eventscalendar_main' already exists for query CREATE TABLEwpbhf_EventsCalendar_main(idMEDIUMINT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,eventTitleVARCHAR( 255 ) NOT NULL ,eventDescriptionTEXT NOT NULL ,eventLocationVARCHAR( 255 ) NULL ,eventStartDateDATE NOT NULL ,eventStartTimeTIME NULL ,eventEndDateDATE NOT NULL ,eventEndTimeTIME NULL ,accessLevelVARCHAR( 255 )) made by dbDelta WordPress database error Duplicate column name 'accessLevel' for query ALTER TABLEwpbhf_EventsCalendar_mainADDaccessLevelVARCHAR(255) NOT NULL DEFAULT 'public' made by createTable WordPress database error 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 'wpbhf_EventsCalendar_external' at line 1 for query SHOW TABLES LIKE wpbhf_EventsCalendar_external made by createTable WordPress database error Table 'wpbhf_eventscalendar_external' already exists for query CREATE TABLE wpbhf_EventsCalendar_external (id MEDIUMINT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , externalType VARCHAR( 255 ) NOT NULL , externalName VARCHAR( 255 ) NOT NULL , externalAddress VARCHAR( 255 ) NOT NULL) made by dbDelta .... etc

    http://wordpress.org/extend/plugins/events-calendar/

  2. snumb130
    Member
    Posted 6 years ago #

    I will look and see what I can find out but this is the first time I have had this error reported so let me see if I can recreate it.

Topic Closed

This topic has been closed to new replies.

About this Topic