Installato in Remoto Aruba - Errore MySQL - HEEELP!
Inviato: 11/04/2006, 4:53
Ciao,
ho installato manualmente su aruba, hosting linux.
- importato la tabella
- configurato i due configure.php
il sito si vede e pure una contribution che prende prodotti random dal db e li mostra nella home funziona se apro la index...
PERO' se clicco su una categoria quando entro nel menu della sottocategoria NON mostra le anteprime dei prodotti e mi da questo ERRORE:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.keikoitalia.net/home/includes/funct ... tabase.php on line 99
se poi clicco per entrare in una sottocategoria invece da questo ERRORE:
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 = '3' and p2c.categories_id = '57'
[TEP STOP]
vi posto il configure.php, avrei bisogno di un aiuto.
-------------------------------------------------------------------------------------
<?php
/*
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.keikoitalia.net'); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'http://www.keikoitalia.net'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', false); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', '/');
define('HTTPS_COOKIE_DOMAIN', '');
define('HTTP_COOKIE_PATH', '');
define('HTTPS_COOKIE_PATH', '');
define('DIR_WS_HTTP_CATALOG', '/');
define('DIR_WS_HTTPS_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/');
//Added for BTS1.0
define('DIR_WS_TEMPLATES', 'templates/');
define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');
define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');
//End BTS1.0
define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_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', '62.149.150.52'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'Sqlxxxxx');
define('DB_SERVER_PASSWORD', 'xxxxxxxx');
define('DB_DATABASE', 'Sqlxxxxx_x');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>
-------------------------------------------------------------------------------------
GRAZIE A TUTTI ANTICIPATAMENTE!
ho installato manualmente su aruba, hosting linux.
- importato la tabella
- configurato i due configure.php
il sito si vede e pure una contribution che prende prodotti random dal db e li mostra nella home funziona se apro la index...
PERO' se clicco su una categoria quando entro nel menu della sottocategoria NON mostra le anteprime dei prodotti e mi da questo ERRORE:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.keikoitalia.net/home/includes/funct ... tabase.php on line 99
se poi clicco per entrare in una sottocategoria invece da questo ERRORE:
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 = '3' and p2c.categories_id = '57'
[TEP STOP]
vi posto il configure.php, avrei bisogno di un aiuto.
-------------------------------------------------------------------------------------
<?php
/*
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.keikoitalia.net'); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'http://www.keikoitalia.net'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', false); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', '/');
define('HTTPS_COOKIE_DOMAIN', '');
define('HTTP_COOKIE_PATH', '');
define('HTTPS_COOKIE_PATH', '');
define('DIR_WS_HTTP_CATALOG', '/');
define('DIR_WS_HTTPS_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/');
//Added for BTS1.0
define('DIR_WS_TEMPLATES', 'templates/');
define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');
define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');
//End BTS1.0
define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_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', '62.149.150.52'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'Sqlxxxxx');
define('DB_SERVER_PASSWORD', 'xxxxxxxx');
define('DB_DATABASE', 'Sqlxxxxx_x');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>
-------------------------------------------------------------------------------------
GRAZIE A TUTTI ANTICIPATAMENTE!
