problem with database

[devashanti]

I just did a new install and it never asked me to run the setupSQL.php file. I tried to do it manually but got an error, so i created the database manually but when i try to access the event manager i get a message to use the setup manager to for defining the database (no where is there a place to create the db table - but i shouldn't need it.) I have installed the calendar before on another url without trouble...

Any ideas what to do?

[ve9gra]

Make sure you have a database already setup, with appropriate rights for a user. Then enter that information in the Setup Manager. Once you save the settings, the script will check to make sure you have the table. If you don't it will prompt you to run the setupSQL.php. If the rights aren't properly assigned, you'll get an error.

[devashanti]

I'm using the same user that is used on the other database (that is working) and that user have all priveleges in the database.

[ve9gra]

Other database? If the user profile you're using doesn't have root level access to MySQL server, you should create the database manually, or use a database that's already there. What you're specifying in the Setup Manager is the database name and not the table. The table name is preset to "epc_calendar".

I would suggest you use the database you already have, and not worry about creating a separate database (which can cause problems if you're using the calendar in collaboration with a CMS like Joomla or PHP-Nuke).

[devashanti]

I should have been clearer, I'm sorry. I plan to install many of these calendars. Several will be on the same domain. The one I have already installed has a database called events, the epc_calendar table exists there. For the new install I created a database called portevents, this database also has a table I manually created called epc_calendar. I have a database/system user called webuser, this user is set up on several databases in my system ( have 8 databases for different apps so far) and have never had a problem with this user. The user was added to my portevents database and given all permissions. My config.inc.php file in the new calendar install has been modified to point to the new portevents database. Everything is defined the same as the config.inc.php file for my existing calendar that works fine, except it points to the portevents database. This should work, but it doesn't.

[Brian]

FYI, you can use the same database for each install. Just manually change the table name in the config.inc.php file for each installation.

You should also NOT create the table in the database manually. If it already exists, the calendar will not attempt to recreate it.