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
— https://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
(
id
int(6) NOT NULL AUTO_INCREMENT,
private_id
varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
first_name
tinytext COLLATE utf8_unicode_ci,
last_name
tinytext COLLATE utf8_unicode_ci,
address
tinytext COLLATE utf8_unicode_ci,
city
tinytext COLLATE utf8_unicode_ci,
state
tinytext COLLATE utf8_unicode_ci,
country
tinytext COLLATE utf8_unicode_ci,
zip
tinytext COLLATE utf8_unicode_ci,
phone
tinytext COLLATE utf8_unicode_ci,
email
tinytext COLLATE utf8_unicode_ci,
mailing_list
text COLLATE utf8_unicode_ci,
photo
text COLLATE utf8_unicode_ci,
website
text COLLATE utf8_unicode_ci,
interests
text COLLATE utf8_unicode_ci,
approved
text COLLATE utf8_unicode_ci,
date_recorded
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
date_updated
timestamp NULL DEFAULT NULL,
last_accessed
timestamp 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
(
id
int(3) NOT NULL AUTO_INCREMENT,
order
int(3) NOT NULL DEFAULT ‘0’,
name
varchar(64) COLLATE utf8_unicode_ci NOT NULL,
title
tinytext COLLATE utf8_unicode_ci NOT NULL,
default
tinytext COLLATE utf8_unicode_ci,
group
varchar(64) COLLATE utf8_unicode_ci NOT NULL,
help_text
text COLLATE utf8_unicode_ci,
form_element
tinytext COLLATE utf8_unicode_ci,
values
longtext COLLATE utf8_unicode_ci,
validation
tinytext COLLATE utf8_unicode_ci,
display_column
int(3) DEFAULT ‘0’,
admin_column
int(3) DEFAULT ‘0’,
sortable
tinyint(1) DEFAULT ‘0’,
CSV
tinyint(1) DEFAULT ‘0’,
persistent
tinyint(1) DEFAULT ‘0’,
signup
tinyint(1) DEFAULT ‘0’,
readonly
tinyint(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
(
id
int(3) NOT NULL AUTO_INCREMENT,
order
int(3) NOT NULL DEFAULT ‘0’,
display
tinyint(1) DEFAULT ‘1’,
admin
tinyint(1) NOT NULL DEFAULT ‘0’,
title
tinytext COLLATE utf8_unicode_ci NOT NULL,
name
varchar(64) COLLATE utf8_unicode_ci NOT NULL,
description
text 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.