Database not installed with the plug
-
Hello, I installed this plugin but the database wasn’t installed, and I am receiving this error message when I try to create a group.
Table ‘wp_multi.wp_23_participants_database_groups’ doesn’t exist
See, I have a multi-site installation but I don’t have 23 installations, the latest is 19.
Could someone to send me a participants database dump file to I can install it mannualy?
Many thnaks,
Paulo Lopes
-
I resolved, installing elsewhere and copying the tables to my multi-site installation. Everything seems well now. In case someone needs this info, here is the default dump from a fresh installation:
— phpMyAdmin SQL Dump
— version 3.3.7deb8
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Nov 14, 2014 at 04:37 PM
— Server version: 5.1.73
— PHP Version: 5.3.3-7+squeeze22SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
—
— Database:pydio
—— ——————————————————–
—
— Table structure for tablewp_23_participants_database
—CREATE TABLE IF NOT EXISTS
wp_23_participants_database(
idint(6) NOT NULL AUTO_INCREMENT,
private_idvarchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
first_nametinytext COLLATE utf8_unicode_ci,
last_nametinytext COLLATE utf8_unicode_ci,
addresstinytext COLLATE utf8_unicode_ci,
citytinytext COLLATE utf8_unicode_ci,
statetinytext COLLATE utf8_unicode_ci,
countrytinytext COLLATE utf8_unicode_ci,
ziptinytext COLLATE utf8_unicode_ci,
phonetinytext COLLATE utf8_unicode_ci,
emailtinytext COLLATE utf8_unicode_ci,
mailing_listtext COLLATE utf8_unicode_ci,
phototext COLLATE utf8_unicode_ci,
websitetext COLLATE utf8_unicode_ci,
intereststext COLLATE utf8_unicode_ci,
approvedtext COLLATE utf8_unicode_ci,
date_recordedtimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
date_updatedtimestamp NULL DEFAULT NULL,
last_accessedtimestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;—
— Dumping data for tablewp_23_participants_database
—— ——————————————————–
—
— Table structure for tablewp_23_participants_database_fields
—CREATE TABLE IF NOT EXISTS
wp_23_participants_database_fields(
idint(3) NOT NULL AUTO_INCREMENT,
orderint(3) NOT NULL DEFAULT ‘0’,
namevarchar(64) COLLATE utf8_unicode_ci NOT NULL,
titletinytext COLLATE utf8_unicode_ci NOT NULL,
defaulttinytext COLLATE utf8_unicode_ci,
groupvarchar(64) COLLATE utf8_unicode_ci NOT NULL,
help_texttext COLLATE utf8_unicode_ci,
form_elementtinytext COLLATE utf8_unicode_ci,
valueslongtext COLLATE utf8_unicode_ci,
validationtinytext COLLATE utf8_unicode_ci,
display_columnint(3) DEFAULT ‘0’,
admin_columnint(3) DEFAULT ‘0’,
sortabletinyint(1) DEFAULT ‘0’,
CSVtinyint(1) DEFAULT ‘0’,
persistenttinyint(1) DEFAULT ‘0’,
signuptinyint(1) DEFAULT ‘0’,
readonlytinyint(1) DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEYname(name),
KEYorder(order),
KEYgroup(group)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;—
— Dumping data for tablewp_23_participants_database_fields
—INSERT INTO
wp_23_participants_database_fields(id,order,name,title,default,group,help_text,form_element,values,validation,display_column,admin_column,sortable,CSV,persistent,signup,readonly) VALUES
(1, 0, ‘first_name’, ‘First Name’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘yes’, 1, 2, 1, 1, 0, 1, 0),
(2, 1, ‘last_name’, ‘Last Name’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘yes’, 2, 3, 1, 1, 0, 1, 0),
(3, 2, ‘address’, ‘Address’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 0, 0),
(4, 3, ‘city’, ‘City’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 3, 0, 1, 1, 1, 0, 0),
(5, 4, ‘state’, ‘State’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 4, 0, 1, 1, 1, 0, 0),
(6, 5, ‘country’, ‘Country’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 1, 1, 1, 0, 0),
(7, 6, ‘zip’, ‘Zip Code’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 1, 1, 1, 0, 0),
(8, 7, ‘phone’, ‘Phone’, NULL, ‘main’, ‘Your primary contact number’, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 0, 0),
(9, 8, ’email’, ‘Email’, NULL, ‘main’, NULL, ‘text-line’, NULL, ‘#^[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}$#i’, 0, 4, 0, 1, 0, 1, 0),
(10, 9, ‘mailing_list’, ‘Mailing List’, ‘Yes’, ‘main’, ‘do you want to receive our newsletter and occasional announcements?’, ‘checkbox’, ‘a:2:{i:0;s:3:”Yes”;i:1;s:2:”No”;}’, ‘no’, 0, 0, 1, 1, 0, 1, 0),
(11, 10, ‘photo’, ‘Photo’, NULL, ‘personal’, ‘Upload a photo of yourself. 300 pixels maximum width or height.’, ‘image-upload’, NULL, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(12, 11, ‘website’, ‘Website, Blog or Social Media Link’, NULL, ‘personal’, ‘Put the URL in the left box and the link text that will be shown on the right’, ‘link’, NULL, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(13, 12, ‘interests’, ‘Interests or Hobbies’, NULL, ‘personal’, NULL, ‘multi-select-other’, ‘a:7:{s:6:”Sports”;s:6:”sports”;s:11:”Photography”;s:11:”photography”;s:10:”Art/Crafts”;s:6:”crafts”;s:8:”Outdoors”;s:8:”outdoors”;s:4:”Yoga”;s:4:”yoga”;s:5:”Music”;s:5:”music”;s:7:”Cuisine”;s:7:”cuisine”;}’, ‘no’, 0, 0, 0, 0, 0, 0, 0),
(14, 13, ‘approved’, ‘Approved’, ‘no’, ‘admin’, NULL, ‘checkbox’, ‘a:2:{i:0;s:3:”yes”;i:1;s:2:”no”;}’, ‘no’, 0, 0, 1, 0, 0, 0, 0),
(15, 14, ‘id’, ‘Record ID’, NULL, ‘internal’, NULL, ‘text-line’, NULL, ‘no’, 0, 0, 0, 1, 0, 1, 1),
(16, 15, ‘private_id’, ‘Private ID’, ‘RPNE2’, ‘internal’, NULL, ‘text’, NULL, ‘no’, 0, 90, 0, 0, 0, 1, 1),
(17, 16, ‘date_recorded’, ‘Date Recorded’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 100, 1, 0, 0, 0, 1),
(18, 17, ‘date_updated’, ‘Date Updated’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 0, 1, 0, 0, 0, 1),
(19, 18, ‘last_accessed’, ‘Last Accessed’, NULL, ‘internal’, NULL, ‘timestamp’, NULL, ‘no’, 0, 0, 1, 0, 0, 0, 1);— ——————————————————–
—
— Table structure for tablewp_23_participants_database_groups
—CREATE TABLE IF NOT EXISTS
wp_23_participants_database_groups(
idint(3) NOT NULL AUTO_INCREMENT,
orderint(3) NOT NULL DEFAULT ‘0’,
displaytinyint(1) DEFAULT ‘1’,
admintinyint(1) NOT NULL DEFAULT ‘0’,
titletinytext COLLATE utf8_unicode_ci NOT NULL,
namevarchar(64) COLLATE utf8_unicode_ci NOT NULL,
descriptiontext COLLATE utf8_unicode_ci,
PRIMARY KEY (id),
UNIQUE KEYname(name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;—
— Dumping data for tablewp_23_participants_database_groups
—INSERT INTO
wp_23_participants_database_groups(id,order,display,admin,title,name,description) VALUES
(1, 1, 1, 0, ‘Participant Info’, ‘main’, NULL),
(2, 2, 1, 0, ‘Personal Info’, ‘personal’, NULL),
(3, 3, 0, 0, ‘Administrative Info’, ‘admin’, NULL),
(4, 4, 0, 0, ‘Record Info’, ‘internal’, NULL);Thanks to all.
how can I install this manually?
I had the same problem, but Im new to wordpress nd dont know how to do this.The is not something you can do without technical knowledge. I suggest you remove the plugin completely and start over.
The topic ‘Database not installed with the plug’ is closed to new replies.