Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent Help Needed - mysql db update from local machine won't work!


hmluo

Recommended Posts

Dear All:

 

We updated our site contents, especially on the payment preferences and paypal module configuration using Web Standard Payment method. We tested the localhost and everything seems working proper, and we could submit a "buy now" order and hit the paypal sandbox. Our site on godaddy.com has been working since January, including some basic database functions, for example, registering a new user.

 

Then we backed the database and all source from godday.com to our local machine, and first moved all folders and files under catalog over to goddy. At this stage, our site still worked fine, except payment related functionaly. Finally we used mysqldump to create a backup for the local mysql db, and then used phpMyAdmin to import the .sql file to godday. Suddenly, we got warnings like the following:

 

Warning: error_log(/var/log/www/tep/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in /home/content/c/s/i/csiadm/html/includes/functions/database.php on line 41

 

Warning: error_log(/var/log/www/tep/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in /home/content/c/s/i/csiadm/html/includes/functions/database.php on line 48

 

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/c/s/i/csiadm/html/includes/functions/database.php:41) in /home/content/c/s/i/csiadm/html/includes/functions/sessions.php on line 102

 

Warning: error_log(/var/log/www/tep/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in /home/content/c/s/i/csiadm/html/includes/functions/database.php on line 41

 

Warning: error_log(/var/log/www/tep/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in /home/content/c/s/i/csiadm/html/includes/functions/database.php on line 48

 

Those lines corresponds to the negeric tep_db_querry. After the warning, normal non-db related contents appeared OK, but "My Account" would also generate similar warnings, all pointing to database.php.

 

Could anyone tell me where We did something wrong, or ignore some procedures? You can go to visit our site: http://consistent-income.com/ to see the warnings.

 

By the way, we updated the mysql db before in this way. Only this time, we did finally choose and put in the payment module.

 

Thank you all very much in advance!

 

HM

Link to comment
Share on other sites

Admin -> Configuration -> Logging

 

On that page set "Store Database Queries " false

 

Save it.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...