Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Problem after myPHPadmin emptied


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




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')




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

Link to comment
Share on other sites


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

  • Create New...