During Zencart Installation, Can't connect to Database. WHy?

[myjasonlee]

Hi All,

I am installing zencart everything was ok up until i got to the databse setup page. It says that it cannot connect to DB.

Database connect failed
Access denied for user 'my username1'@'PI #' (using password: NO)

I dont use any SSL yet. I saw posting about changing configure.php but no details given.

Kindly help to advise what could be done to resolve this
Thank you for your help in advance

Jason

[Ajeh]

Usually that means you:

1 made a database

2 made the username

3 added the username to the database ... oops ... betcha missed step 3 ...

[myjasonlee]

Hi Ajeh

Thanks for the advice given.
Actually I can still go to next level of installation even though I have this error after I clicked continue for 2 times continuously. I am not sure what will be the error.

After clicking continue at this DB setting page, it loads to the next page with below error

1146 Table 'mydb1.configuration' doesn't exist
in:
[update configuration set configuration_value='/home/www/mywebsite/catalog/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

I reload and it shows "1146 Table 'mydb1.configuration' doesn't exist in:[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]"

What should I update or add looking at this error sentence?
Do let me know the correct file, directory and what to be done?

Thanks a lot

Jason

[Ajeh]

If you peek in phpMyAdmin and refresh the database at this point ... do you see anything in the database tables?

[myjasonlee]

Hi Ajeh

Thanks for helping out. Really appreciate it.
I went to phpadmin, seeing my still alive mydb1 database.
I clicked it and all I am prmpt to do is to create new table for mydb1.
It has given me the blank fill to put down new name and number of fields before I can click go.
So should I be doing this table creation? I am not sure what will be the DB fields and parameter I need.
If for the sake of this zencart installation, I have to simply create some table, then I would do for sure. ( I did not do earlier as I worried I cant revive anything, I have tried installation and files upload for 6 times and quite tiring since each time I have many obstacles...)

Thanks to help out

Jason

[Ajeh]

If you have created a clean, empty table ...

Then you create a username and password ...

Then you add the username to the table with All Rights checked ...

you should then have full access to the new, empty database table so that when Zen Cart installs it can access it to add all of the database table structure and data ...

[myjasonlee]

Hi Ajeh

In fact as mentioned I have the DB name and password created. It is empty but not sure how clean it is.

I still have errors goes:
"1146 Table 'mydb1.configuration' doesn't exist in:[update configuration set configuration_value='/home/www/myweb.freehostia.com/catalog/cache' where configuration_key='SESSION_WRITE_DIRECTORY']
"

WHat are the table and configuration refer to? What can I do to resolve this?

Using test.php file in my website, the connection of DB works and shows it can be connected with username, password I have.

Thanks to help

Jason

[myjasonlee]

Hi All

The status of the web browser is done during this error reporting.
It is showing the installation in progress

Then this page stay there and without any progress even I keep waiting.
I tried reloading, it went back to previous page where I have to key in details for the DB setting all over again

Kindly help

Jason
++++++++++++++++++++++++++++++++++++
Installation In Progress...

1146 Table 'mydb1.configuration' doesn't exist
in:
[update configuration set configuration_value='/home/www/myweb/catalog/cache' where configuration_key='SESSION_WRITE_DIRECTORY']


+++++++++++++++++++++++++++++++++++++++

[stevesh]

Are you sure you're giving Zencart the correct database name?

Many shared hosting accounts prepend your account user name to the database name, so if you create a database named mydb1, and your hosting control panel user name is wombats the database name you would need to supply to the Zencart installation would be wombats_mydb1. Same with the database user name if you create one specifically for Zencart.

[myjasonlee]

Hi Stevesh & All

Thanks for helping out.
I confirmed the database name is correct.
The reason is when I use different name, it will give me connection is denied as the error.
For my case, it is about table for a .configuration extension file does not exist.
Is there any way to locate this file and correct it?


1146 Table 'mydb1.configuration' doesn't exist
in:
[update configuration set configuration_value='/home/www/myweb/catalog/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

Thanks to help, please

best rgds
CheangLong