Need Help Connection to UserSpice

[edenitx]

Thank You for your respond.

I redid the installation. It is saying this a lot of errors.

Database connection successful!

Error performing query ' CREATE TABLE

Code:

email

(

Code:

id

int(11) NOT NULL,

Code:

website_name

varchar(100) NOT NULL,

Code:

smtp_server

varchar(100) NOT NULL,

Code:

smtp_port

int(10) NOT NULL,

Code:

email_login

varchar(150) NOT NULL,

Code:

email_pass

varchar(100) NOT NULL,

Code:

from_name

varchar(100) NOT NULL,

Code:

from_email

varchar(150) NOT NULL,

Code:

transport

varchar(255) NOT NULL,

Code:

verify_url

varchar(255) NOT NULL,

Code:

email_act

int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

email

(

Code:

id

,

Code:

website_name

,

Code:

smtp_server

,

Code:

smtp_port

,

Code:

email_login

,

Code:

email_pass

,

Code:

from_name

,

Code:

from_email

,

Code:

transport

,

Code:

verify_url

,

Code:

email_act

) VALUES (1, 'User Spice', 'mail.userspice.org', 587, 'noreply@userspice.org', 'password', 'Your Name', 'noreply@userspice.org', 'Swift_SmtpTransport', 'localhost/us4/users/verify.php', 0); ':

Error performing query ' CREATE TABLE

Code:

keys

(

Code:

id

int(11) NOT NULL,

Code:

stripe_ts

varchar(255) NOT NULL,

Code:

stripe_tp

varchar(255) NOT NULL,

Code:

stripe_ls

varchar(255) NOT NULL,

Code:

stripe_lp

varchar(255) NOT NULL,

Code:

recap_pub

varchar(100) NOT NULL,

Code:

recap_pri

varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' CREATE TABLE

Code:

pages

(

Code:

id

int(11) NOT NULL,

Code:

page

varchar(100) NOT NULL,

Code:

private

int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

pages

(

Code:

id

,

Code:

page

,

Code:

private

) VALUES (1, 'index.php', 0), (2, 'z_us_root.php', 0), (3, 'users/account.php', 1), (4, 'users/admin.php', 1), (5, 'users/admin_page.php', 1), (6, 'users/admin_pages.php', 1), (7, 'users/admin_permission.php', 1), (8, 'users/admin_permissions.php', 1), (9, 'users/admin_user.php', 1), (10, 'users/admin_users.php', 1), (11, 'users/edit_profile.php', 1), (12, 'users/email_settings.php', 1), (13, 'users/email_test.php', 1), (14, 'users/forgot_password.php', 0), (15, 'users/forgot_password_reset.php', 0), (16, 'users/index.php', 0), (17, 'users/init.php', 0), (18, 'users/join.php', 0), (19, 'users/joinThankYou.php', 0), (20, 'users/login.php', 0), (21, 'users/logout.php', 0), (22, 'users/profile.php', 1), (23, 'users/times.php', 0), (24, 'users/user_settings.php', 1), (25, 'users/verify.php', 0), (26, 'users/verify_resend.php', 0), (27, 'users/view_all_users.php', 1), (28, 'usersc/empty.php', 0); ':

Error performing query ' CREATE TABLE

Code:

permissions

(

Code:

id

int(11) NOT NULL,

Code:

name

varchar(150) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

permissions

(

Code:

id

,

Code:

name

) VALUES (1, 'User'), (2, 'Administrator'); ':

Error performing query ' CREATE TABLE

Code:

permission_page_matches

(

Code:

id

int(11) NOT NULL,

Code:

permission_id

int(15) NOT NULL,

Code:

page_id

int(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

permission_page_matches

(

Code:

id

,

Code:

permission_id

,

Code:

page_id

) VALUES (2, 2, 27), (3, 1, 24), (4, 1, 22), (5, 2, 13), (6, 2, 12), (7, 1, 11), (8, 2, 10), (9, 2, 9), (10, 2, 8), (11, 2, 7), (12, 2, 6), (13, 2, 5), (14, 2, 4), (15, 1, 3); ':

Error performing query ' CREATE TABLE

Code:

profiles

(

Code:

id

int(11) NOT NULL,

Code:

user_id

int(11) NOT NULL,

Code:

bio

text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

profiles

(

Code:

id

,

Code:

user_id

,

Code:

bio

) VALUES (1, 1, '
This is the Admin\'s bio.
'), (2, 2, 'This is your bio'), (18, 18, 'This is your bio'); ':

Error performing query ' CREATE TABLE

Code:

settings

(

Code:

id

int(50) NOT NULL,

Code:

recaptcha

int(1) NOT NULL DEFAULT '0',

Code:

force_ssl

int(1) NOT NULL,

Code:

login_type

varchar(20) NOT NULL,

Code:

css_sample

int(1) NOT NULL,

Code:

us_css1

varchar(255) NOT NULL,

Code:

us_css2

varchar(255) NOT NULL,

Code:

us_css3

varchar(255) NOT NULL,

Code:

css1

varchar(255) NOT NULL,

Code:

css2

varchar(255) NOT NULL,

Code:

css3

varchar(255) NOT NULL,

Code:

site_name

varchar(100) NOT NULL,

Code:

language

varchar(255) NOT NULL,

Code:

track_guest

int(1) NOT NULL,

Code:

site_offline

int(1) NOT NULL,

Code:

force_pr

int(1) NOT NULL,

Code:

reserved1

varchar(100) NOT NULL,

Code:

reserverd2

varchar(100) NOT NULL,

Code:

custom1

varchar(100) NOT NULL,

Code:

custom2

varchar(100) NOT NULL,

Code:

custom3

varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

settings

(

Code:

id

,

Code:

recaptcha

,

Code:

force_ssl

,

Code:

login_type

,

Code:

css_sample

,

Code:

us_css1

,

Code:

us_css2

,

Code:

us_css3

,

Code:

css1

,

Code:

css2

,

Code:

css3

,

Code:

site_name

,

Code:

language

,

Code:

track_guest

,

Code:

site_offline

,

Code:

force_pr

,

Code:

reserved1

,

Code:

reserverd2

,

Code:

custom1

,

Code:

custom2

,

Code:

custom3

) VALUES (1, 0, 0, '', 1, '../users/css/color_schemes/standard.css', '../users/css/sb-admin.css', '../users/css/custom.css', '', '', '', 'UserSpice', 'en', 0, 0, 0, '', '', '', '', ''); ':

Error performing query ' CREATE TABLE

Code:

users

(

Code:

id

int(11) NOT NULL,

Code:

email

varchar(155) NOT NULL,

Code:

username

varchar(255) NOT NULL,

Code:

password

varchar(255) NOT NULL,

Code:

fname

varchar(255) NOT NULL,

Code:

lname

varchar(255) NOT NULL,

Code:

permissions

int(11) NOT NULL,

Code:

logins

int(100) NOT NULL,

Code:

account_owner

tinyint(4) NOT NULL DEFAULT '0',

Code:

account_id

int(11) NOT NULL DEFAULT '0',

Code:

company

varchar(255) NOT NULL,

Code:

stripe_cust_id

varchar(255) NOT NULL,

Code:

billing_phone

varchar(20) NOT NULL,

Code:

billing_srt1

varchar(255) NOT NULL,

Code:

billing_srt2

varchar(255) NOT NULL,

Code:

billing_city

varchar(255) NOT NULL,

Code:

billing_state

varchar(255) NOT NULL,

Code:

billing_zip_code

varchar(255) NOT NULL,

Code:

join_date

datetime NOT NULL,

Code:

last_login

datetime NOT NULL,

Code:

email_verified

tinyint(4) NOT NULL DEFAULT '0',

Code:

vericode

varchar(15) NOT NULL,

Code:

title

varchar(100) NOT NULL,

Code:

active

int(1) NOT NULL,

Code:

custom1

varchar(255) NOT NULL,

Code:

custom2

varchar(255) NOT NULL,

Code:

custom3

varchar(255) NOT NULL,

Code:

custom4

varchar(255) NOT NULL,

Code:

custom5

varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

users

(

Code:

id

,

Code:

email

,

Code:

username

,

Code:

password

,

Code:

fname

,

Code:

lname

,

Code:

permissions

,

Code:

logins

,

Code:

account_owner

,

Code:

account_id

,

Code:

company

,

Code:

stripe_cust_id

,

Code:

billing_phone

,

Code:

billing_srt1

,

Code:

billing_srt2

,

Code:

billing_city

,

Code:

billing_state

,

Code:

billing_zip_code

,

Code:

join_date

,

Code:

last_login

,

Code:

email_verified

,

Code:

vericode

,

Code:

title

,

Code:

active

,

Code:

custom1

,

Code:

custom2

,

Code:

custom3

,

Code:

custom4

,

Code:

custom5

) VALUES (1, 'userspicephp@gmail.com', 'admin', '$2y$12$1v06jm2KMOXuuo3qP7erTuTIJFOnzhpds1Moa8BadnUUeX0RV3ex.', 'Admin', 'User', 1, 0, 1, 0, 'UserSpice', '', '', '', '', '', '', '', '2016-01-01 00:00:00', '2016-05-11 10:25:01', 1, '322418', '', 0, '', '', '', '', ''), (2, 'noreply@userspice.org', 'user', '$2y$12$HZa0/d7evKvuHO8I3U8Ff.pOjJqsGTZqlX8qURratzP./EvWetbkK', 'user', 'user', 1, 0, 1, 0, 'none', '', '', '', '', '', '', '', '2016-01-02 00:00:00', '2016-01-02 00:00:00', 1, '970748', '', 1, '', '', '', '', ''); ':

Error performing query ' CREATE TABLE

Code:

users_online

(

Code:

id

int(10) NOT NULL,

Code:

ip

varchar(15) NOT NULL,

Code:

timestamp

varchar(15) NOT NULL,

Code:

username

varchar(100) NOT NULL,

Code:

session

varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

users_online

(

Code:

id

,

Code:

ip

,

Code:

timestamp

,

Code:

username

,

Code:

session

) VALUES (26, '::1', '1455555707', '', ''), (27, '192.171.42.122', '1462976510', '', ''); ':

Error performing query ' CREATE TABLE

Code:

users_session

(

Code:

id

int(11) NOT NULL,

Code:

user_id

int(11) NOT NULL,

Code:

hash

varchar(255) NOT NULL,

Code:

uagent

text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

users_session

(

Code:

id

,

Code:

user_id

,

Code:

hash

,

Code:

uagent

) VALUES (38, 1, 'e5c284103ce354831561e3b447d1758976c799922d7e20743e9f8c290dfe078f', 'Mozilla (Windows NT 6.1; Win64; x64) AppleWebKit (KHTML, like Gecko) Chrome Safari'); ':

Error performing query ' CREATE TABLE

Code:

user_permission_matches

(

Code:

id

int(11) NOT NULL,

Code:

user_id

int(11) NOT NULL,

Code:

permission_id

int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ':

Error performing query ' INSERT INTO

Code:

user_permission_matches

(

Code:

id

,

Code:

user_id

,

Code:

permission_id

) VALUES (100, 1, 1), (101, 1, 2), (102, 2, 1); ':

Error performing query ' ALTER TABLE

Code:

email

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

keys

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

pages

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

permissions

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

permission_page_matches

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

profiles

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

settings

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

users

ADD PRIMARY KEY (

Code:

id

), ADD KEY

Code:

EMAIL

(

Code:

email

) USING BTREE; ':

Error performing query ' ALTER TABLE

Code:

users_online

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

users_session

ADD PRIMARY KEY (

Code:

id

); ':

Error performing query ' ALTER TABLE

Code:

user_permission_matches

ADD PRIMARY KEY (

Code:

id

); ':

Tables imported successfully