Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help - Cannot access Categories or Admin sections


Guest

Recommended Posts

I get this error when trying to open categories section. I also cannot access my Admin page (will not accept password) I have orders emailed but cannot access the information to send them or process the sale.

If I do a re-install will I loose my orders?

Don't know what to do.

Please help.

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '26'

 

my servers changed (Ipower) and the paths have been effected.

 

Page is Page link

 

Config.php file

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://bi-tronaustralia.com'); // eg, http://bi-trona.ipowermysql.com - should not be empty for productive servers

define('HTTPS_SERVER', 'https://bi-trona.ipower.com'); // eg, https://bi-trona.ipowermysql.com - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'bi-tronaustralia.com');

define('HTTPS_COOKIE_DOMAIN', 'bi-trona.ipower.com');

define('HTTP_COOKIE_PATH', '/ecommerce/os/catalog/');

define('HTTPS_COOKIE_PATH', '/ecommerce/os/catalog/');

define('DIR_WS_HTTP_CATALOG', '/ecommerce/os/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/ecommerce/os/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/users/web/b758/ipw.bi-trona/public_html/ecommerce/os/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

// define our database connection

define('DB_SERVER', 'bi-trona.ipowermysql.com'); // eg, bi-trona.ipowermysql.com - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'bi-trona_p_os1');

define('DB_SERVER_PASSWORD', 'XXXXXX');

define('DB_DATABASE', 'bi-trona_p_os1');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

Link to comment
Share on other sites

 

The section did not mention what changes needed to be made in the files.?

I tried replacing both files with the new edition files and the pages symply did not load, so I restored the old ones again, so still have the problem.

I cannot log into my admin account either.

I have checked the password in the data base settings, and the config files and the password is correct, but the program won't allow it.

Comes up with this error

Authorization Required

This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required.

 

I am now getting worried. :(

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...