events aren't showing up

[juanita]

I've successfully installed the script and am able to go to the admin page to enter events. However, after adding events, it tells me

--Number of events currently in SQL database:0--

and therefore the calendar at

www.mimadrejuanita.com/test.php

does not show any events.

I turned on the option to use MySQL for events.

What am I doing wrong?

Go ahead and test it. The username is Juanita and the password is villagonza.

Thanks.

[Brian]

Can you try to use a flat-file database and let me know if it works properly?

[juanita]

There's no esdates.txt file in the extracted folder. I added set, set the attributes to 646 and got the following error:

There was an error writing to the flat-file database 'esdates.txt'.

Make sure the database directory has write permissions (chmod 777).

You may also need to set the permissions of the database 'esdates.txt' to at least 646.

So I went back and turned sql on and got the following message:

There was an error reading data from the mySQL database.

However,the connection to the database was successful!

You should run the installation script,setupSQL.php to set up the database.

The error was reported as:

Unknown column 'startDate' in 'where clause'

so I ran setup and got the following message:

> The connection to the mySQL database was successful!

> The calendar table already appears to exist in the mySQL database.

> You should now be able to use the ESCalendar Script with it's mySQL functions.

So i went back to admin, added a test event and got the same thing:

--Number of events currently in SQL database:0--

Thanks and aloha.

Juanita

[Brian]

The esdates.txt file will be created for you as long as the correct permissions are set on the database directory.

Did you upgrade from Version 4?

[juanita]

No, I bought whatever is the version that's was emailed to me to download.

[Brian]

Can you PM me FTP access to your server?

[juanita]

sorry, what's pm and how do I do it?

[Brian]

Just click my name on the left and select to send me a Private Message (PM).

[Brian]

It appears that calendar was a pre-existing table in the database. I went into your setup and changed the table name to something else then ran the SQL setup script again.

All is well now.

[juanita]

Thank you very much. One last question from a novice: which file am I supposed to erase once I get everything working?


Thanks,
Juanita

[Brian]

You shoud remove the setupSQL.php file from the setup directory.