Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Confused about MySQL path


Guest

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...