Need Help Connection to UserSpice

[edenitx]

Hello

I am kind of still in stages of learning more i already do have knowledge about coding, analyzing the code where and how to but i am having a bit trouble trying to set up this and i want to learn and know what i need to do.

I am using wamp server for testing, i already imported database.sql under my db myaccount. I was checking tutorial but it only shows for UserSpice 3.0 which it has different folders i did not see the modules. I am trying to set it up and get it show and work, can someone help me out with this and direct me to where i can read about this what i need to do, thank you.

[mudmin]

So, in version 4.x, you don't have to do any sort of importing.

All you do is create a blank database in the phpmyadmin.

Then, you go in your browser and navigate to the folder that you unzipped userspice. For instance, if it was in the c:\www\us4 folder (for WAMP), you just go to

localhost/us4

in your browser

That will automatically guide you through the install. After you get to the "cleanup" page of the installer, you're given a link to go to your new userspice "home" page that gives you instructions from there.

If I can be of any more help, please don't hesitate to ask.

[edenitx]

Thank You for your respond.

I did that and i went through the process but now after the install was done i get this.

Warning: require_once(C:/wamp/wwwC:\wamp\www\MyAccount/users/helpers/helpers.php): failed to open stream: Invalid argument in C:\wamp\www\UserSpice4.0.0\core\init.php on line 23
Call Stack
# Time Memory Function Location
1 0.0050 130416 {main}( ) ...\index.php:0
2 0.0060 153712 require_once( 'C:\wamp\www\UserSpice4.0.0\users\includes\frontend\header.php' ) ...\index.php:1
3 0.0070 168888 require_once( 'C:\wamp\www\UserSpice4.0.0\core\init.php' ) ...\header.php:21


and this


Fatal error: require_once(): Failed opening required 'C:/wamp/wwwC:\wamp\www\MyAccount/users/helpers/helpers.php' (include_path='.;C:\php\pear') in C:\wamp\www\UserSpice4.0.0\core\init.php on line 23
Call Stack
# Time Memory Function Location
1 0.0050 130416 {main}( ) ...\index.php:0
2 0.0060 153712 require_once( 'C:\wamp\www\UserSpice4.0.0\users\includes\frontend\header.php' ) ...\index.php:1
3 0.0070 168888 require_once( 'C:\wamp\www\UserSpice4.0.0\core\init.php' ) ...\header.php:21


I know that something is not right but i cant understand what i need to change. Thank You

[brian]

Since you are just starting out, I might recommend you start with the Alpha 4 build. Why? Because the key changes that were made to some architectural elements are more or less frozen, and we will enter "Beta" phase soon, so you will be fine going with the Alpha 4 at the moment (or we can post what should be the beta for you).

The reason for this, is that based on the text of the errors I see, I suspect the paths were not entered correctly. In UserSpice 4.0, it required the user to enter the paths. In 4.1, the paths are automatically detected and will avoid the problems you are having.

If you want to stay with what you have, then I will defer to @mudmin since he knows that section of the init a little better.

[mudmin]

That's definitely a path issue. Because you're using WAMP and it looks like you set you unzipped your userspice 4.0 in c:\
c:\wamp\www\UserSpice4.0.0 you need to edit the path in the core\init.php to read

/UserSpice4.0.0/

If you have problems because of the periods in your folders I'd just rename the folder to us4 and change your path in init.php to
/us4/

That said, US 4.1 Alpha is a superior product. If I were building something new I'd start there and know that there to play around and know that the full release of 4.1 is coming next week.

[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

[brian]

Did you drop all the tables in the database before retrying the installation? Anything else change?