Database not recognized

[Zalil]

Hello Chris
First thanks for the software. When all is set and working I will sure donate…
I need some guidance with installation.
Here is what I did:
1- I uploaded all files to my site: http://seashoresunset.com/calendar
2- I set “ac-config.inc.php” to:
Database host: localhost
Database name: seashoresunset
Database prefix: zalmanse (the database full name is “zalmanse_seashoresenset”)
(User and Pass too)

3- I ran: ac-install.php
But encounter: ERROR SELECTING THE DATABASE TABLE
4- Then I added the table manually as you suggested in another post.
Yet no dice… Unable to connect to database. Please check your data.

Any clue will help.

[chris]

Hi,
Well *something* must be wrong with your database connection data.
You will need to use the fill database name (ie. zalmanse_seashoresenset - I have changed this now)
You might have to redefine your password and check all the other data.

Chris

[Zalil]

Do you mean to change the setup in “ac-config.inc.php” to:
Database host: localhost
Database name: zalmanse_seashoresunset
Database prefix: zalmanse

???

[chris]

No, I was referring to you double checking your database connection data (username, password and database name).
With your current settings the code is not able to connect to the database so one (or more) of those values must be wrong.
Feel free to send me a pm with your server details (ftp and "exact" database connection data) if you want me to take a look.

Chris

[chris]

I suspect that your username is wrong - most servers don't allow such short usernames for database access and often apend other data to the name automatically.
Of course I might be wrong

Chris

[Zalil]

I created a new database to no avail

Let's see if I have ac-config.inc correctly:

define("AC_DB_HOST","localhost");
define("AC_DB_NAME","calendar");
define("AC_DB_USER","xx");
define("AC_DB_PASS","xx");
define("AC_DB_PREFIX","zalmanse");

A- I use an addon domain, do I still use "localhost" ?
B- The full name of the DB is zalmanse_calendar. Do I enter the full name in AC_DB_NAME? if so what about AC_DB_PREFIX?
I tried both anyway...no good...

[chris]

The db name must be the compelte name ie.zalmanse_calendar. Likewise the user name must be the complete name.
You do not need to have anything in the AC_DB_PREFIX.

Chris

[chris]

Fixed it.
As I suggested yesterday, your username was incomplete - it needed to have "zalmanse_" before it.

You need to take a look at your install file in the browser once more time to get the login data then don't forget to delete or rename it.

Chris

[Zalil]

Hi Chris,
Thank you for bearing with me on this one.
I saw that you managed to fix it. How in the world did you do that?! Did you actually hacked into my site?

[Zalil]

Anyway I think I managed to mess it up again

I amended the config file as you suggested to:

define("AC_DB_HOST","localhost");
define("AC_DB_NAME","zalmanse_calendar");
define("AC_DB_USER","zalmanse_xx");
define("AC_DB_PASS","xx");
define("AC_DB_PREFIX","");

Now I get again the dreaded ERROR SELECTING THE DATABASE TABLE...

What am I doing wrong????