Using MySQL database

[arconline]

During the installation, and trying to use MySQL database I get the following error:

There was an error reading data from the mySQL database.

However, the connection to the database was successful!


Please click to run the installation script, setupSQL.php (http://pennylane.coop/calendar/setup/setupSQL.php?PHPSESSID=512765891b881ef1996a00808c5 73a73) to set up the database.

The error was reported as:

Table 'baseland.epc_calendar' doesn't exist

When i Click setupSQL.php i get the following message:

Warning! This will erase any existing data in the table "epc_calendar" on your SQL server.

Are you sure you want to set up and initialize the SQL database? YES (http://pennylane.coop/calendar/setup/setupSQL.php?setup=yes)

[Close this window if you do not wish to continue...]


I do not want to initialize the SQL Database as I have hundreds of tables already defined there. It seem that your program would wipe them all out.

[Brian]

As it says, "This will erase any existing data in the table...".

Not anything else. :)

[redcrew]

I have the same error message when I try to set up the Easy PHP Calendar to use the database already in use by WordPress.

Just to clarify - this error message should really say:

Please click to run the installation script, setupSQL.php (http://pennylane.coop/calendar/setup/setupSQL.php?PHPSESSID=512765891b881ef1996a00808c5 73a73) to set up the table in the database.

Is that correct?

[Brian]

It will set up the table for the calendar in the specified database.

[redcrew]

My apologies, I guess I'm not explaining myself very well. For me, the message:

Are you sure you want to set up and initialize the SQL database? YES

indicates to me that if I select YES, my current SQL database will be initialized, or completely re-written.

To me, initialized means "brand new", which would delete any existing tables in the database.

My suggestion was re-wording the message so it would be more clear what the exact action of selecting YES would be - creating a new table in the existing SQL database.

[Brian]

I see what you're saying now. You are right. It could be worded better.

[kidsvt]

We are purchasing a second calendar license to be used on our same domain. I have downloaded the files and uploaded them to a subfolder called "calendar2" on our webserver (since the "calendar" folder is already being used by the first calendar.)

I would like to use MYSQL with the second calendar as well. Because we already have one functioning calendar, our database already has a table called epc_calendar. How can I install the second calendar to use the database without wiping out all of the data in the first calendar?

Gail

[Brian]

Manually edit the config.inc.php file and change the "epc_calendar" table name to a new name for the second calendar.