Manual install

[wingoo]

For some reason, I cannot run the automatic install. It wont select / create the database.

As an alternative, I tried creating the database and manually importing the schema.

I can import Schema

But run into an error when I try to run Create User  GRANT ALL on phpscheduleit2.* to 'schedule_user'@'127.0.0.1' identified by 'password';

I can manually create a user and give all permissions but the name is restricted to seven characters in the control panel. Does the user have to have this name and if not where does it need changing in which files?

I can also import Data

But run into the error again if I try to run Sample Data

Many thanks for any help.

[Nick]

You just reminded me of a huge gap in the manual install documentation. Here is what you need to do to create the user for a manual install (assuming you have access to cPanel on your server):

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

Please let me know if that makes sense

[wingoo]

That worked fine thanks Nick.

Now I am just having problems migrating the old data.

It comes back with unknown error.

I presume the install password required is for 2.01 as 1.2 did not have one in the config, the screen did not make that clear.

I will play around a bit more and see if I can find anything else I might be entering or doing wrong in the migrate.

[Nick]

I'm going to put some logging in there to help troubleshoot migration issues.