Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem after myPHPadmin emptied


Guest

Recommended Posts

After deleting some values in myPHPadmin to start fresh with a easypopulate import, i discovered i could no onger access my admin in osc. the following error came up.

 

I backed up the osc DB, but without admin i cant restore it. Any Ideas?

 

Error report as follows:

 

Warning: open_basedir restriction in effect. File is in wrong directory in /usr/local/psa/home/vhosts/bizbuddie.com/httpdocs/catalog/admin/includes/application_top.php on line 199

 

Fatal error: Failed opening required 'includes/languages/.php' (include_path='.:/usr/local/lib/php') in /usr/local/psa/home/vhosts/bizbuddie.com/httpdocs/catalog/admin/includes/application_top.php on line 199

 

When navigating to the catalog an error is reported like this under the heading New Products For December:

 

1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_NEW_PRODUCTS' at line 1

 

select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added DESC limit MAX_DISPLAY_NEW_PRODUCTS

 

[TEP STOP]

 

Ive emptied values under myPHPadmin before without troubles, but this is a first for me.

Link to comment
Share on other sites

The first error has nothing to do with osCommerce or phpMyAdmin, it's an open_basedir problem. Search for it in the forums or on www.php.net

 

It basically limits where php may look for files and is a php configuration setting that has probably been set by your provider.

 

The second error *could* come from the fact that you might have emptied some defined values with phpMyAdmin that shouldn't have been emptied out (mainly the table 'configuration')

 

HTH

Mattice

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...