Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Ok I am a Noob moron I passworded a mySQL DBase that eviden


oclgroup

Recommended Posts

tly never had one. now when I try to access admin I get these errors.

Parse error: parse error, unexpected '}' in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 20



Fatal error: Call to undefined function: tep_db_connect() in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/application_top.php on line 142

 

The regular programmer is in the Hospital on a morphine drip and walked me thru entering the user name and pword in the top.php all the did was change the Fatal error line #. I changed the mySQL pword back to nothing but shouldn't it be whatever is in the line? I cannot past the whole code as I am at work a bit longer. I am terrified, this is not my store. :oops:

Link to comment
Share on other sites

Check your database setting in both catalogincludeconfiguation.php and catalogadminincludeconfigure.php

 

near the bottom:

 

// define our database connection

 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

 define('DB_SERVER_USERNAME', 'admin_username');

 define('DB_SERVER_PASSWORD', 'abc123ABC123your_password_here');

 define('DB_DATABASE', 'your_database_name');

 

Good luck!

Link to comment
Share on other sites

Most likely, there is nothing wrong with application_top.php. The error that you are getting in that file looks to be related to the error that you get in database.php. What the error says is that you have a } where it was expecting something else. This could mean that something is missing or that the } is extra. It will probably be pretty easy to see if you paste the first twenty lines (just up to where the error is announced) of includes/functions/database.php

 

If you have sensitive info in that file for some reason, please x it out before posting (replacing it with Xs retains the structure but doesn't give away the info). Make a copy of the file before making further changes.

 

Hth,

Matt

Link to comment
Share on other sites

<?php

/*

 $Id: database.php,v 1.18 2003/02/11 01:31:01 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/



 function tep_db_connect($server = DB_SERVER, $username = root, $password = bones, $database = DB_DATABASE, $link = sharpweblabs_com_-_) {

   global $$link;



   if (USE_PCONNECT == 'true') {

     $$link = mysql_pconnect($server, $username, $password);

   } else {

     $$link = mysql_connect($server, $username, $password);

   }



   if ($$link) mysql_select_db($database);



   return $$link;

 }



 function tep_db_close($link = 'db_link') {

   global $$link;



   return mysql_close($$link);

 }



 function tep_db_error($query, $errno, $error) { 

   die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

 }



 function tep_db_query($query, $link = 'db_link') {

   global $$link;



   if (STORE_DB_TRANSACTIONS == 'true') {

     error_log('QUERY ' . $query . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());



   if (STORE_DB_TRANSACTIONS == 'true') {

      $result_error = mysql_error();

      error_log('RESULT ' . $result . ' ' . $result_error . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   return $result;

 }



 function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

   reset($data);

   if ($action == 'insert') {

     $query = 'insert into ' . $table . ' (';

     while (list($columns, ) = each($data)) {

       $query .= $columns . ', ';

     }

     $query = substr($query, 0, -2) . ') values (';

     reset($data);

     while (list(, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= 'now(), ';

           break;

         case 'null':

           $query .= 'null, ';

           break;

         default:

           $query .= ''' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ')';

   } elseif ($action == 'update') {

     $query = 'update ' . $table . ' set ';

     while (list($columns, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= $columns . ' = now(), ';

           break;

         case 'null':

           $query .= $columns .= ' = null, ';

           break;

         default:

           $query .= $columns . ' = '' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ' where ' . $parameters;

   }



   return tep_db_query($query, $link);

 }



 function tep_db_fetch_array($db_query) {

   return mysql_fetch_array($db_query, MYSQL_ASSOC);

 }



 function tep_db_num_rows($db_query) {

   return mysql_num_rows($db_query);

 }



 function tep_db_data_seek($db_query, $row_number) {

   return mysql_data_seek($db_query, $row_number);

 }



 function tep_db_insert_id() {

   return mysql_insert_id();

 }



 function tep_db_free_result($db_query) {

   return mysql_free_result($db_query);

 }



 function tep_db_fetch_fields($db_query) {

   return mysql_fetch_field($db_query);

 }



 function tep_db_output($string) {

   return stripslashes($string);

 }



 function tep_db_input($string) {

   return addslashes($string);

 }



 function tep_db_prepare_input($string) {

   if (is_string($string)) {

     return trim(stripslashes($string));

   } elseif (is_array($string)) {

     reset($string);

     while (list($key, $value) = each($string)) {

       $string[$key] = tep_db_prepare_input($value);

     }

     return $string;

   } else {

     return $string;

   }

 }

?>

 

Help :cry:

Link to comment
Share on other sites

Check your database setting in both catalogincludeconfiguation.php and catalogadminincludeconfigure.php

 

near the bottom:

 

// define our database connection

 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

 define('DB_SERVER_USERNAME', 'admin_username');

 define('DB_SERVER_PASSWORD', 'abc123ABC123your_password_here');

 define('DB_DATABASE', 'your_database_name');

 

Good luck!

 

 

Did that now I am getting this;

 

Warning: Access denied for user: 'sharpweb@localhost' (Using password: YES) in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 17

Unable to connect to database server!

Link to comment
Share on other sites

Error Message;

 

Warning: Access denied for user: 'sharpweb@localhost' (Using password: YES) in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

 

 

<?php

/*

 $Id: database.php,v 1.18 2003/02/11 01:31:01 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/



 function tep_db_connect($server = DB_SERVER, $username = sharpweb, $password = bones, $database = DB_DATABASE, $link = sharpweblabs_com) {

   global $$link;



   if (USE_PCONNECT == 'true') {

     $$link = mysql_pconnect($server, $username, $password);

   } else {

     $$link = mysql_connect($server, $username, $password);

   }



   if ($$link) mysql_select_db($database);



   return $$link;

 }



 function tep_db_close($link = 'db_link') {

   global $$link;



   return mysql_close($$link);

 }



 function tep_db_error($query, $errno, $error) { 

   die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

 }



 function tep_db_query($query, $link = 'db_link') {

   global $$link;



   if (STORE_DB_TRANSACTIONS == 'true') {

     error_log('QUERY ' . $query . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());



   if (STORE_DB_TRANSACTIONS == 'true') {

      $result_error = mysql_error();

      error_log('RESULT ' . $result . ' ' . $result_error . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   return $result;

 }



 function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

   reset($data);

   if ($action == 'insert') {

     $query = 'insert into ' . $table . ' (';

     while (list($columns, ) = each($data)) {

       $query .= $columns . ', ';

     }

     $query = substr($query, 0, -2) . ') values (';

     reset($data);

     while (list(, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= 'now(), ';

           break;

         case 'null':

           $query .= 'null, ';

           break;

         default:

           $query .= ''' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ')';

   } elseif ($action == 'update') {

     $query = 'update ' . $table . ' set ';

     while (list($columns, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= $columns . ' = now(), ';

           break;

         case 'null':

           $query .= $columns .= ' = null, ';

           break;

         default:

           $query .= $columns . ' = '' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ' where ' . $parameters;

   }



   return tep_db_query($query, $link);

 }



 function tep_db_fetch_array($db_query) {

   return mysql_fetch_array($db_query, MYSQL_ASSOC);

 }



 function tep_db_num_rows($db_query) {

   return mysql_num_rows($db_query);

 }



 function tep_db_data_seek($db_query, $row_number) {

   return mysql_data_seek($db_query, $row_number);

 }



 function tep_db_insert_id() {

   return mysql_insert_id();

 }



 function tep_db_free_result($db_query) {

   return mysql_free_result($db_query);

 }



 function tep_db_fetch_fields($db_query) {

   return mysql_fetch_field($db_query);

 }



 function tep_db_output($string) {

   return stripslashes($string);

 }



 function tep_db_input($string) {

   return addslashes($string);

 }



 function tep_db_prepare_input($string) {

   if (is_string($string)) {

     return trim(stripslashes($string));

   } elseif (is_array($string)) {

     reset($string);

     while (list($key, $value) = each($string)) {

       $string[$key] = tep_db_prepare_input($value);

     }

     return $string;

   } else {

     return $string;

   }

 }

?>

Link to comment
Share on other sites

Warning: Access denied for user: 'sharpweb@localhost' (Using password: YES) in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 17

Unable to connect to database server!

 

I have to assume you have something like this:

 

// define our database connection

 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

 define('DB_SERVER_USERNAME', 'sharpweb');

 define('DB_SERVER_PASSWORD', '********');

 define('DB_DATABASE', 'your_database_name');

 

Your User or Password or both is not vaild.

 

in MySQL (like PHPMYADMIN) make sure you have the following

 

users - host:

 

sharpweb - %

sharpweb - localhost

sharpweb - 127.0.0.1

 

all with the same password.

 

Good Luck

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...