lots of errors during install/setting up of the tables

[patrick]

i have just installed phpScheduleIt 1.2.7 on my remotely hosted webspace, i've set up the config files to use the only existing db my provider allows and after logging on as the admin user on the phpScheduleIt setup page, i was asked to have it set up the tables.

here's what i got:

Creating database...Failed: DB Error: already exists

Selecting database...Success

Creating announcement table...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating login table...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating reservations table...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating resources table...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating permission table...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table schedules...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table schedule_permission...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table reservation_users...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table anonymous_users...Failed: DB Error: syntax error

Creating table additional_resources...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table reservation_resources...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table mutex...Failed: DB Error: syntax error

Insert values...Failed: DB Error: syntax error

Insert values...Failed: DB Error: syntax error

Creating table groups...Failed: DB Error: syntax error

Creating table user_groups...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating table reminders...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating index...Failed: DB Error: syntax error

Creating database user...Failed: DB Error: insufficient permissions

Creating default schedule...Failed: DB Error: syntax error

when i check with phpmyadmin, these tables have been created using the instructions that i have copy and pasted:
additional_resources
announcements
anonymous_users
DefLink
groups
login
mutex
permission
reminders
reservations
reservation_resources
reservation_users
resources
schedules
schedule_permission
user_groups

can someone please give me pointers to what i should check, and what are the most common things that people with very limited php knowledge miss during installation?

thank you.
patrick

[patrick]

any pointers or information, anyone?  
is there anything more that i can post here to be more precise?

[rcole]

any pointers or information, anyone?  
is there anything more that i can post here to be more precise?

Patrick:

I am still having similar problems myself, so I do not have a solution for you.

[patrick]

ah … i don't feel to be alone with this anymore …

[Aldric]

I would not take my comments as gospel, but it looks like you do not have the appropriate authority to create the tables in whatever database you are using. I think you need to have all permissions including the grant privilege.

[patrick]

Thanks Aldric, that's a good starting point. How could I make sure that privileges are set correctly?

[Nick]

Correct, if you're installing remotely where you cant control permission, you should follow the instructions in install/remote_host_install.html

This will show you how to create the DB through a tool like phpMyAdmin

[katy]

"Correct, if you're installing remotely where you cant control permission, you should follow the instructions in install/remote_host_install.html

This will show you how to create the DB through a tool like phpMyAdmin"

I have followed the instructions in install/remote_host_install.html

When I hit Go from MyphpAdmin, I get this error: #1044 - Access denied for user 'wealthw1'@'localhost' to database 'phpScheduleIt'

I have spent about an hour on the phone with my host test support. They said that because it was a shared server, I did not have permissions. The remote_host_install.html doesn't say what to do in a case like this.

I went to the Manual Installation in the readme. Can you please tell me in simple language what this means:

2) The initial database must be set up. There is an included setup file for this. To execute the setup file in mysql, navigate to the MySQL executable directory (usually /usr/local/mysql/bin) and at the shell prompt type the following:

mysql -u root -p < %path to directory%/install/setup.sql


Thank you so much -- I really appreciate your time!
Katy

[Nick]

Are you saying your hosting company isn't letting you create databases?  Is it possible that there is more than one login set up for this account and the one you are using is not an administrator?

I'd see if your hosting company provides any documentation on creating databases.  If it's not allowed, I'm afraid phpScheduleIt will not work on your host.