nel trasferire il dominio ho perso l'admin

[deltabiri]

ho da poco traferito su aruba il m io sito www.tentazionishop.it/index.php ma mi e' sparito la sezione admin...le cartelle con i file sono state caricate, ma non esce nulla sto notando diversi errori anche nel sito (sara' il msql5 ?) inizio a correggerre qualcosa, se intanto qualcuno mi aiuta con il problema dell'admin ne sarei grato. grazie anticipati

[dynamo]

se vado su http://www.tentazionishop.it/admin/ mi esce questo errore Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /web/htdocs/www.tentazionishop.it/home/admin/includ ... tabase.php on line 19
Unable to connect to database server!


controlla il file configure

[vampire]

in particolare sistema i dati di accesso al database del configure.php

[deltabiri]

nel file configure ho settato con i nuovi dati:
db-server
username
password
database
e fs-catalog dove ho messo il link cosi /www.tentazionishop.it/
altre cose non ne ho cambiate....devo?
poi ieri sera ho aggiornato la index e advanced_search_result.php per il mysql5 e mi sono apparsi ? al posto di €, uno sfondo che utilizzo su ebay e un box che per scegliere regali che utilizzavo un'anno fa' ....come mai sono riapparsi? e che c'entra lo sfondo del negozio ebay?

[deltabiri]

p.s. errore anche nella ricerca, sempre lo stesso 1054 - Unknown column 'p.products_id' in 'on clause' anche se ho fatto l'aggiornamento,
mentre per la faq
Warning: require(includes/languages/italian/faq.php) [function.require]: failed to open stream: No such file or directory in /web/htdocs/www.tentazionishop.it/home/faq.php on line 14

Warning: require(includes/languages/italian/faq.php) [function.require]: failed to open stream: No such file or directory in /web/htdocs/www.tentazionishop.it/home/faq.php on line 14

Fatal error: require() [function.require]: Failed opening required 'includes/languages/italian/faq.php' (include_path='.:/php5/lib/php/') in /web/htdocs/www.tentazionishop.it/home/faq.php on line 14

[deltabiri]

scusate, non sapevo ci fossero 2 file configure .... ho settato anche l'altro e mi e' apparsa la schermata della login, solo che qualsiasi cosa vado a cliccare mi porta su una pagina vuota, dove sbaglio?

[dynamo]

ricontrolla il file perchè hai sbagliato qualcosa nel modificare magari hai dimenticato qualche /

[deltabiri]

provo a postare l'intero codice:

Codice: Seleziona tutto

<?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.tentazionishop.it'); // eg, http://localhost - should not be empty for productive servers
  define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers
  define('ENABLE_SSL', false); // secure webserver for checkout procedure?
  define('HTTP_COOKIE_DOMAIN', 'www.tentazionishop.it');
  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/');

  define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
  define('DIR_FS_CATALOG', 'www.tentazionishop.it');
  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
  define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
  define('DB_SERVER', 'server'); // eg, localhost - should not be empty for productive servers
  define('DB_SERVER_USERNAME', 'l'username');
  define('DB_SERVER_PASSWORD', 'la password');
  define('DB_DATABASE', 'database');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

per la pagina delle faq ho risolto...nel trasferire il tutto e' stata saltata

[deltabiri]

sono riuscito a sistemare anche questo...se in futuro serve a qualcuno posto il codice:

Codice: Seleziona tutto

<?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.tentazionishop.it'); // eg, http://localhost - should not be empty for productive servers
  define('HTTP_CATALOG_SERVER', 'http://www.tentazionishop.it');
  define('HTTPS_CATALOG_SERVER', '');
  define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
  define('DIR_FS_DOCUMENT_ROOT', '/web/htdocs/www.tentazionishop.it/home/'); // where the pages are located on the server
  define('DIR_WS_ADMIN', '/admin/'); // absolute path required
  define('DIR_FS_ADMIN', '/web/htdocs/www.tentazionishop.it/home/admin/'); // absolute pate required
  define('DIR_WS_CATALOG', '/'); // absolute path required
  define('DIR_FS_CATALOG', '/web/htdocs/www.tentazionishop.it/home/'); // absolute path required
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
  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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
  define('DB_SERVER', 'server'); // eg, localhost - should not be empty for productive servers
  define('DB_SERVER_USERNAME', 'user');
  define('DB_SERVER_PASSWORD', 'pass');
  define('DB_DATABASE', 'database');
  define('USE_PCONNECT', 'false'); // use persisstent connections?
  define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

[deltabiri]

mi manca da sistemare solo che non si vedono le immagini dei prodotti nelle categorie, mentre se entro nel prodotto e' tutto ok.
e il problema della funzione cerca, che mi risponde cosi:
1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%slip%' or p.products_model like '%slip%' or m.manufacturers_name like '%slip%' or p2pef.products_extra_fields_value like '%slip%') )

[TEP STOP]
so' che e' un errore comune e come dicevo ho fatto anche l'aggiornamento sia nella index cosi:

Codice: Seleziona tutto

 // show the products of a specified manufacturer
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
}
} else {
// show the products in a given categorie
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
} else {
// We show them all
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_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 = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
}
}

che nel file advanced_search_result.php

Codice: Seleziona tutto

$from_str = "from ((" . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

in piu' ho eseguito quanto riportato nel file how_to_fix_1054_error ma nonostante tutto mi da' ancora errore

[deltabiri]

risolto anche il problema del simbolo ? al posto di € (admin-localizzazione-valute-euro...modifica)
mi rimangono ancora i 2 problemi sopraelencati....se qualcuno ne sa' qualcosa non facci il timido

[deltabiri]

up, non riesco a risolvere

[dynamo]

up, non riesco a risolvere

puoi rifare il punto della situazione che mi son perso

[deltabiri]

si certo:
nella funzione cerca mi risponde con:

1054 - Unknown column 'p.products_id' in 'on clause'
select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%slip%' or p.products_model like '%slip%' or m.manufacturers_name like '%slip%' or p2pef.products_extra_fields_value like '%slip%') )
[TEP STOP]

ho controllato nel qui nel forum e in tutte le discussioni portano a modificare advanced_search_result con il file how_to_fix_1054_error e quello per la index 1054-problem. Io li ho modificati entrambi ma il risultato non cambia.

per il resto sto cercando ancora, anche se sembrano finiti gli errori...speriamo.

[hsg26]

si certo:
nella funzione cerca mi risponde con:

1054 - Unknown column 'p.products_id' in 'on clause'
select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%slip%' or p.products_model like '%slip%' or m.manufacturers_name like '%slip%' or p2pef.products_extra_fields_value like '%slip%') )
[TEP STOP]

ho controllato nel qui nel forum e in tutte le discussioni portano a modificare advanced_search_result con il file how_to_fix_1054_error e quello per la index 1054-problem. Io li ho modificati entrambi ma il risultato non cambia.

per il resto sto cercando ancora, anche se sembrano finiti gli errori...speriamo.

prova ad usare il file della RC2a... secondo me non dovresti avere problemi...