Install problem

[jiopi]

When I'm usin the automated install,

1) Verify the following default settings before continuing. Or you can change them in /config/config.php.
Database Name: x_db
Database User: x_user (this is not any application user, but the user for your database: x_db)
Database Host: localhost (or localhost)
 
2) You MUST provide credentials of a MySQL user who has privileges to create databases. If you do not know, contact your database admin. In many cases, root will work.
MySQL User

Password
 
3) You are upgrading from version 2 to version 2.1

Executing: ../../database_schema/upgrades/2.1/schema.sql
Failed! Details...
SQL Statement:

ALTER TABLE `resources` ADD COLUMN `admin_group_id` SMALLINT(5) unsigned
Error Code:
1146
Error Text:
Table 'x_db.resources' doesn't exist
Executing: ../../database_schema/upgrades/2.1/data.sql
Failed! Details...
SQL Statement:
insert into roles values (3, 'Resource Admin', 3)
Error Code:
1146
Error Text:
Table 'x_db.roles' doesn't exist

What is the problem? Why is it trying to upgrade 2.0 to 2.1 when the packet is 2.1?

[Nick]

Just so I understand, did you already have 2.0 installed at one point?

[jiopi]

Just so I understand, did you already have 2.0 installed at one point?

No.

I did create the mysql database x_db before the installation, is this correct?

[Nick]

Is this a server you own or a hosted site?

[jiopi]

Is this a server you own or a hosted site?

Hosted.

[Nick]

I threw together some instructions for installing/upgrading in a hosted environment. In most cases, the automated install won't work because host's lock down database security.

Here's what you'll likely need to do:

Adding the database and user

    Select the MySQL Databases tool
    Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
    Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt2' is the recommended database name.
    Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.

Creating tables

    Open phpMyAdmin.
    Click on the database name that you just created in the left panel.
    Click the SQL tab at the top of the page.
    Import "/database_schema/schema-utf8.sql" to phpscheduleit2
    Import "/database_schema/data-utf8.sql" to phpscheduleit2

[jiopi]

I threw together some instructions for installing/upgrading in a hosted environment. In most cases, the automated install won't work because host's lock down database security.

Here's what you'll likely need to do:

Adding the database and user

    Select the MySQL Databases tool
    Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
    Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt2' is the recommended database name.
    Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.

Creating tables

    Open phpMyAdmin.
    Click on the database name that you just created in the left panel.
    Click the SQL tab at the top of the page.
    Import "/database_schema/schema-utf8.sql" to phpscheduleit2
    Import "/database_schema/data-utf8.sql" to phpscheduleit2

I did that, but used import tool for importing, as those lines did not work. So now I should be able to use the program? But I can't log in? I have username and password in config.php, but those doesn't work.

[jiopi]

Also there is no registration option anywhere.

[jiopi]

Figured it out, I needed to still install with some of the three options, sample data worked. But when I used the

Create the user based on configuration /config/config.php (x_user)

it gives error message:

Executing: ../../database_schema/schema-utf8.sql
Succeeded!
Executing: ../../database_schema/create-user.sql

Failed! Details...
SQL Statement:
GRANT ALL on x_db.* to 'x_user'@'localhost' identified by 'password'
Error Code:
1044
Error Text:
Access denied for user 'x'@'localhost' to database 'x_db'

Executing: ../../database_schema/data-utf8.sql
Succeeded!

So it takes the _user part of the username when it tries to access. Is this a problem?
 

[wingoo]

Edit the config file to allow self register, disable captcha, and then register using the email address you put in the config file as the admin email.

Once you have created your login, you can disable self register again if you want to create any future logins yourself rather than let them self register.

Hope this helps