Confused about MySQL path

[Guest]

I am getting these errors in my admin page

 

Warning: Unable to access /home/virtual/site313/fst/var/www/html/var/www/html/catalog/includes/data/rates.php in /home/virtual/site313/fst/var/www/html/adminis/includes/include_once.php on line 4

 

These appear throughout the page.

 

I understand that I probably configured it incorrectly and I've been trying to fix things. Here is what I have so far

 

// define our database connection

define('DB_SERVER', $HTTP_ENV_VARS['krishno_com']);

define('DB_SERVER_USERNAME', 'krishno');

define('DB_SERVER_PASSWORD', 'i'll keep this blank');

define('DB_DATABASE', 'catalog');

define('USE_PCONNECT', 1);

 

I think that I have the first DB_SERVER line messed up.

 

Maybe I'm looking in the wrong area. Any other ideas. I don't have access to the DB setup since I do it all through a virtual server.

[jficarra]

Kris,

 

Looks like you've got the paths hosed up when you did the installation.

 

Warning: Unable to access /home/virtual/site313/fst/var/www/html/var/www/html/catalog/includes/data/rates.php in /home/virtual/site313/fst/var/www/html/adminis/includes/include_once.php on line 4

 

I'ts looking for rates.php in /home/virtual/site313/fst/var/www/html/var/www/html/catalog/includes. It should probably be something like /home/virtual/site313/fst/catalog/includes...you're adding in two /var/www/html paths somewhere.

 

If you're not getting database connect errors, your database should be fine...I'm leaning more towards misconfigured paths also considering your adminis path post earlier.

[Guest]

Damn you're good. Fixed that error (I had added that extra /var thing where I didn't need to).

 

Ready for the next error?

 

I am also getting this one

 

Warning: Supplied argument is not a valid MySQL result resource in /home/virtual/site313/fst/var/www/html/adminis/includes/functions/database.php on line 39

[jficarra]

Kris,

 

Can you specify what you were doing when you got that error? Does it happen every time after a specific event?

 

In my database.php file, line #39 is blank, but the tep_db_query function is *near* line 39. Looks like something might be passing a bad query to this function. Did you make any modifications or add any contributions?

 

-Jim

[Guest]

actually things are working fine since I upgraded to 2.2 and used the install walkthrough.

 

The only problem now is I'll get this every now and then when jumping around the site.

 

Warning: MySQL: Too many open persistent links (2) in /home/virtual/site313/fst/var/www/html/catalog/includes/functions/database.php on line 17

Unable to connect to database server!

 

When I refresh it everything is fine.

[jficarra]

Warning: MySQL: Too many open persistent links (2) in /home/virtual/site313/fst/var/www/html/catalog/includes/functions/database.php on line 17  

Unable to connect to database server!

 

Open up /home/virtual/site313/fst/var/www/html/catalog/includes/configure.php and /home/virtual/site313/fst/var/www/html/adminis/includes/configure.php and check the following setting:

 

define('USE_PCONNECT', 'false');

 

If it's set to 'true' try setting it to 'false' like I have here. This will turn off perisistent database connections.

[Guest]

I think that might have worked. I jumped around and nothing has happend yet.

 

As for posting a new topic. I apologize. I thought that it was a new topic since I was dealing with 2.2 instead of what we were working with before.

 

I really appreciate all of the help.

 

Things seem to be working great now.