Error 1054 - Hier eine Allroundlösung gefunden

[rivendarkness]

Meines Erachtens sind das die drei. Es tritt auch nicht bei jedem überall auf. Das es bei dir an so vielen Stellen auftritt ist eher ein seltener Fall

Den Quellcode hier rienzuwerfen bringt nüscht..da jede Version scheinbar immer ein bisschen anders ist. bisher gings auch so. hab schon überlegt einen Patch für jede version zu schreiben

[PowerBeat]

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

select distinct p.products_id, p.products_fsk18, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and p.products_date_added > '1970.01.01' order by p.products_date_added DESC

[XT SQL Error]

hab dann mal den Überblick verloren,weiß jemand wo der -Fehler steckt?

Weil habe beim ersten install keine probleme gehabt ,jetzt server umzug und die installation lief ohne probleme , nur beim aufrufen der index kam sofort dieser fehler.

Danke und Gruß Benny

[peterchen88]

Mysql-Version prüfen und dann ggfls. Mysql5-Update-Patch. Gibts hier irgendwo zum Download, hab ich gesehen.

[rivendarkness]

die problemdatei befindet sich dort: include/modules/default.php

Bei problemen melde dich einfach mal per PN, da kann ich dir direkter helfen

[PowerBeat]

Weiß noch ein anderer Rat was den Fehler betrifft?

Ich dachte immer in einem Forum hilft man sich wenn man Probleme hat,ich bin nicht in der Lage ist es selbst zu beheben.

Es ist nett von rivendarkness mir Hilfe anzubieten ,jedoch kann ich nicht für jedes Problem was auftauchen könnte Pauschal 50 Euro und für jeden weiteren Fehler 25 Euro hinblättern.

Jeder der Hilfe benötigt von ihm kann sich ja melden,

er würde das problem selber beheben (per ftp-zugriff) und verlangt für dieses problem 50 euro pauschal, für weitere, andere probleme (css usw) weitere 25 Euro

edit: 08.01.08. Fehler nicht gefunden andere XTC SW aufgespielt. Jetzt funktioniert es.

Gruß Benny

[FS-Nutrition]

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

select pd.products_name, p.products_id from products_description pd, products p, 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 = '2' and p2c.categories_id = '8'

das meine fehlermeldung,hab soweit alles selbst geschafft nur hier komm ich irgendwie nicht weiter, passiert wenn ich auf sitemap klicke

angezeigt wir die shop content php aber da finde ich nichts, hab es auch direkt in der sitemap.php gesucht hatte einige klammern gesetzt und dann war dort nur noch ein weisser hintergrund...könnte mir jemand viellecht weiterhelfen? danke

[Dietolino]

Ein freundliches Hallo an alle.

Auch meine Shopsuche hat ihren Dienst eingestellt!

Das ist meine Fehlermeldung:

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

SELECT DISTINCT p.products_model, pov.products_options_values_name, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id FROM products p LEFT JOIN manufacturers m using(manufacturers_id), products_description pd LEFT JOIN specials s ON p.products_id = s.products_id, categories c, products_to_categories p2c, products LEFT JOIN products_attributes pa ON p.products_id = pa.products_id LEFT JOIN products_options_values pov ON pa.options_values_id = pov.products_options_values_id WHERE p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '2' AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ( p.products_id = pa.products_id AND (pd.products_name LIKE '%curry%' OR p.products_model LIKE '%curry%' OR p.products_ean like '%curry%' OR m.manufacturers_name LIKE '%curry%' OR pov.products_options_values_name LIKE '%curry%' OR pd.products_description LIKE '%curry%' OR pd.products_short_description LIKE '%curry%' OR pa.attributes_model LIKE '%curry%') OR (pd.products_name LIKE '%curry%' OR p.products_model like '%curry%' OR p.products_ean LIKE '%curry%' OR m.manufacturers_name LIKE '%curry%' OR pd.products_description LIKE '%curry%' OR pd.products_short_description LIKE '%curry%') ) GROUP BY pd.products_id ORDER BY pd.products_name

[XT SQL Error]

Hier kommt meine default.php

<?php

/* -----------------------------------------------------------------------------------------

$Id: default.php,v 1.28 2004/05/08 18:13:41 fanta2k Exp $

XT-Commerce - community made shopping

http://www.xt-commerce.com

Copyright © 2003 XT-Commerce

-----------------------------------------------------------------------------------------

based on:

© 2000-2001 The Exchange Project (earlier name of osCommerce)

© 2002-2003 osCommerce(default.php,v 1.84 2003/05/07); www.oscommerce.com

© 2003 nextcommerce (default.php,v 1.11 2003/08/22); www.nextcommerce.org

Released under the GNU General Public License

-----------------------------------------------------------------------------------------

Third Party contributions:

Enable_Disable_Categories 1.3 Autor: Mikel Williams | [email protected]

Customers Status v3.x © 2002-2003 Copyright Elari [email protected] | www.unlockgsm.com/dload-osc/ | CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/elari/?sortby=date#dirlist

Released under the GNU General Public License

---------------------------------------------------------------------------------------*/

$default_smarty = new smarty;

$default_smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/');

$default_smarty->assign('session',session_id());

$main_content = '';

// include needed functions

require_once(DIR_FS_INC . 'xtc_customer_greeting.inc.php');

require_once(DIR_FS_INC . 'xtc_get_path.inc.php');

require_once(DIR_FS_INC . 'xtc_draw_hidden_field.inc.php');

require_once(DIR_FS_INC . 'xtc_check_categories_status.inc.php');

require_once(DIR_FS_INC . 'xtc_image_button.inc.php');

if (xtc_check_categories_status($current_category_id)>=1) {

$error=CATEGORIE_NOT_FOUND;

include(DIR_WS_MODULES . FILENAME_ERROR_HANDLER);

} else {

if ($category_depth == 'nested') {

if (GROUP_CHECK=='true') {

$group_check="and c.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$category_query = "select

cd.categories_description,

cd.categories_name,

cd.categories_heading_title,

c.categories_template,

c.categories_image from " .

TABLE_CATEGORIES . " c, " .

TABLE_CATEGORIES_DESCRIPTION . " cd

where c.categories_id = '" . $current_category_id . "'

and cd.categories_id = '" . $current_category_id . "'

".$group_check."

and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

$category_query = xtDBquery($category_query);

$category = xtc_db_fetch_array(&$category_query,true);

if (isset($cPath) && ereg('_', $cPath)) {

// check to see if there are deeper categories within the current category

$category_links = array_reverse($cPath_array);

for($i = 0, $n = sizeof($category_links); $i < $n; $i++) {

if (GROUP_CHECK=='true') {

$group_check="and c.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$categories_query = "select cd.categories_description,

c.categories_id,

cd.categories_name,

cd.categories_heading_title,

c.categories_image,

c.parent_id from " .

TABLE_CATEGORIES . " c, " .

TABLE_CATEGORIES_DESCRIPTION . " cd

where c.categories_status = '1'

and c.parent_id = '" . $category_links[$i] . "'

and c.categories_id = cd.categories_id

".$group_check."

and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'

order by sort_order, cd.categories_name";

$categories_query = xtDBquery($categories_query);

if (xtc_db_num_rows(&$categories_query,true) < 1) {

// do nothing, go through the loop

} else {

break; // we've found the deepest category the customer is in

}

}

} else {

if (GROUP_CHECK=='true') {

$group_check="and c.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$categories_query = "select cd.categories_description,

c.categories_id,

cd.categories_name,

cd.categories_heading_title,

c.categories_image,

c.parent_id from " .

TABLE_CATEGORIES . " c, " .

TABLE_CATEGORIES_DESCRIPTION . " cd

where c.categories_status = '1'

and c.parent_id = '" . $current_category_id . "'

and c.categories_id = cd.categories_id

".$group_check."

and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'

order by sort_order, cd.categories_name";

$categories_query = xtDBquery($categories_query);

}

$rows = 0;

while ($categories = xtc_db_fetch_array(&$categories_query,true)) {

$rows++;

$cPath_new = xtc_get_path($categories['categories_id']);

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

$image='';

if ($categories['categories_image']!='') {

$image=DIR_WS_IMAGES.'categories/'.$categories['categories_image'];

}

$SEF_parameter='';

if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') $SEF_parameter='&category='.xtc_cleanName($categories['categories_name']);

$categories_content[]=array(

'CATEGORIES_NAME' => $categories['categories_name'],

'CATEGORIES_HEADING_TITLE' => $categories['categories_heading_title'],

'CATEGORIES_IMAGE' => $image,

'CATEGORIES_LINK' => xtc_href_link(FILENAME_DEFAULT, $cPath_new.$SEF_parameter),

'CATEGORIES_DESCRIPTION' => $categories['categories_description']);

}

$new_products_category_id = $current_category_id;

include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);

$image='';

if ($category['categories_image']!='') {

$image=DIR_WS_IMAGES.'categories/'.$category['categories_image'];

}

$default_smarty->assign('CATEGORIES_NAME',$category['categories_name']);

$default_smarty->assign('CATEGORIES_HEADING_TITLE',$category['categories_heading_title']);

$default_smarty->assign('CATEGORIES_IMAGE',$image);

$default_smarty->assign('CATEGORIES_DESCRIPTION',$category['categories_description']);

$default_smarty->assign('language', $_SESSION['language']);

$default_smarty->assign('module_content',$categories_content);

// get default template

if ($category['categories_template']=='' or $category['categories_template']=='default') {

$files=array();

if ($dir= opendir(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/')){

while (($file = readdir($dir)) !==false) {

if (is_file( DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/'.$file) and ($file !="index.html")){

$files[]=array(

'id' => $file,

'text' => $file);

}//if

} // while

closedir($dir);

}

$category['categories_template']=$files[0]['id'];

}

$default_smarty->caching = 0;

$main_content= $default_smarty->fetch(CURRENT_TEMPLATE.'/module/categorie_listing/'.$category['categories_template']);

$smarty->assign('main_content',$main_content);

} elseif ($category_depth == 'products' || $_GET['manufacturers_id']) {

//fsk18 lock

$fsk_lock='';

if ($_SESSION['customers_status']['customers_fsk18_display']=='0') {

$fsk_lock=' and p.products_fsk18!=1';

}

// show the products of a specified manufacturer

if (isset($_GET['manufacturers_id'])) {

if (isset($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {

// sorting query

$sorting_query=xtc_db_query("SELECT products_sorting,

products_sorting2 FROM ".

TABLE_CATEGORIES."

where categories_id='".(int)$_GET['filter_id']."'");

$sorting_data=xtc_db_fetch_array($sorting_query);

if (!$sorting_data['products_sorting']) $sorting_data['products_sorting']='pd.products_name';

$sorting=' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

// We are asked to show only a specific category

if (GROUP_CHECK=='true') {

$group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$listing_sql = "select DISTINCT p.products_fsk18,

p.products_shippingtime,

p.products_model,

pd.products_name,

p.products_ean,

p.products_price,

p.products_tax_class_id,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.products_id,

p.manufacturers_id,

p.products_price,

p.products_discount_allowed,

p.products_tax_class_id

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)$_GET['manufacturers_id'] . "'

and p.products_id = p2c.products_id

and pd.products_id = p2c.products_id

".$group_check."

".$fsk_lock."

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' ".$fsk_lock."

and p2c.categories_id = '" . (int)$_GET['filter_id'] . "'".$sorting;

} else {

// We show them all

if (GROUP_CHECK=='true') {

$group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$listing_sql = "select p.products_fsk18,

p.products_shippingtime,

p.products_model,

p.products_ean,

pd.products_name,

p.products_id,

p.products_price,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.manufacturers_id,

p.products_discount_allowed,

p.products_tax_class_id

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

".$group_check."

".$fsk_lock."

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

and p.manufacturers_id = m.manufacturers_id ".$fsk_lock."

and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {

// sorting query

$sorting_query=xtc_db_query("SELECT products_sorting,

products_sorting2 FROM ".

TABLE_CATEGORIES."

where categories_id='".$current_category_id."'");

$sorting_data=xtc_db_fetch_array($sorting_query);

if (!$sorting_data['products_sorting']) $sorting_data['products_sorting']='pd.products_name';

$sorting=' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

// We are asked to show only specific catgeory

if (GROUP_CHECK=='true') {

$group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$listing_sql = "select p.products_fsk18,

p.products_shippingtime,

p.products_model,

p.products_ean,

pd.products_name,

p.products_id,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.manufacturers_id,

p.products_price,

p.products_discount_allowed,

p.products_tax_class_id

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)$_GET['filter_id'] . "'

and p.products_id = p2c.products_id

and pd.products_id = p2c.products_id

".$group_check."

".$fsk_lock."

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' ".$fsk_lock."

and p2c.categories_id = '" . $current_category_id . "'".$sorting;

} else {

// sorting query

$sorting_query=xtc_db_query("SELECT products_sorting,

products_sorting2 FROM ".

TABLE_CATEGORIES."

where categories_id='".$current_category_id."'");

$sorting_data=xtc_db_fetch_array($sorting_query);

if (!$sorting_data['products_sorting']) $sorting_data['products_sorting']='pd.products_name';

$sorting=' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

// We show them all

if (GROUP_CHECK=='true') {

$group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$listing_sql = "select p.products_fsk18,

p.products_shippingtime,

p.products_model,

p.products_ean,

pd.products_name,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.products_id,

p.manufacturers_id,

p.products_price,

p.products_discount_allowed,

p.products_tax_class_id

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

".$group_check."

".$fsk_lock."

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' ".$fsk_lock."

and p2c.categories_id = '" . $current_category_id . "'".$sorting;

}

}

// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($_GET['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' and p.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' order by cd.categories_name";

} else {

$filterlist_sql = "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . $current_category_id . "' order by m.manufacturers_name";

}

$filterlist_query = xtDBquery($filterlist_sql);

if (xtc_db_num_rows(&$filterlist_query,true) > 1) {

$manufacturer_dropdown= xtc_draw_form('filter', FILENAME_DEFAULT, 'get');

if (isset($_GET['manufacturers_id'])) {

$manufacturer_dropdown.= xtc_draw_hidden_field('manufacturers_id', $_GET['manufacturers_id']);

$options = array(array('text' => TEXT_ALL_CATEGORIES));

} else {

$manufacturer_dropdown.= xtc_draw_hidden_field('cPath', $cPath);

$options = array(array('text' => TEXT_ALL_MANUFACTURERS));

}

$manufacturer_dropdown.= xtc_draw_hidden_field('sort', $_GET['sort']);

$manufacturer_dropdown.= xtc_draw_hidden_field(xtc_session_name(), xtc_session_id());

while ($filterlist = xtc_db_fetch_array(&$filterlist_query,true)) {

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

}

$manufacturer_dropdown.= xtc_draw_pull_down_menu('filter_id', $options, $_GET['filter_id'], 'onchange="this.form.submit()"');

$manufacturer_dropdown.= '</form>' . "\n";

}

}

// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($_GET['manufacturers_id'])) {

$image = xtc_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'");

$image = xtc_db_fetch_array($image);

$image = $image['manufacturers_image'];

} elseif ($current_category_id) {

$image = xtc_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . $current_category_id . "'");

$image = xtc_db_fetch_array($image);

$image = $image['categories_image'];

}

include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

} else { // default page

if (GROUP_CHECK=='true') {

$group_check="and group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

$shop_content_query=xtc_db_query("SELECT

content_title,

content_heading,

content_text,

content_file

FROM ".TABLE_CONTENT_MANAGER."

WHERE content_group='5'

".$group_check."

AND languages_id='".$_SESSION['languages_id']."'");

$shop_content_data=xtc_db_fetch_array($shop_content_query);

$default_smarty->assign('title',$shop_content_data['content_heading']);

include(DIR_WS_INCLUDES . FILENAME_CENTER_MODULES);

if ($shop_content_data['content_file']!=''){

ob_start();

if (strpos($shop_content_data['content_file'],'.txt')) echo '<pre>';

include(DIR_FS_CATALOG.'media/content/'.$shop_content_data['content_file']);

if (strpos($shop_content_data['content_file'],'.txt')) echo '</pre>';

$shop_content_data['content_text']=ob_get_contents();

ob_end_clean();

}

$default_smarty->assign('text',str_replace('{$greeting}',xtc_customer_greeting(),$shop_content_data['content_text']));

$default_smarty->assign('language', $_SESSION['language']);

// set cache ID

if (USE_CACHE=='false') {

$default_smarty->caching = 0;

$main_content= $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html');

} else {

$default_smarty->caching = 1;

$default_smarty->cache_lifetime=CACHE_LIFETIME;

$default_smarty->cache_modified_check=CACHE_CHECK;

$cache_id = $_SESSION['language'].$_SESSION['currency'].$_SESSION['customer_id'];

$main_content= $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html',$cache_id);

}

$smarty->assign('main_content',$main_content);

}

}

?>

Wäre toll, wenn ein netter Shopkollege sich das mal anschauen könnte.

Vielen Dank im Voraus

Dietolino

[Dietolino]

Für den jenigen, der mir den Searchfehler in userem shop www.senfgourmet.de beseitigt, stelle ich ein schönes Senfpaket aus verschiedenen Senfen inclusive Versand zusammen.

Gruß Dietolino ;)

[polkhigh33]

schalt mal deine pm's frei, dietolino

[Dietolino]

schalt mal deine pm's frei, dietolino

Hallo, habe ich gemacht ...

[Dietolino]

OK, hat sich erledigt.

[michael-kom]

Hallo,

haben das selbe Problem. Einen XT Shop Version 3.03 der weiterhin unter einer mySQL-Datenbank 5 laufen soll. Die Kategorien lassen sich nicht aufrufen. Wie kann man diesen Fehler beseitigen. Welche Datein müssen angepaast werden. Wer kann dies für uns erledigen? PN bitte.

[Peanuts]

Hallo, leider haben wir zur Zeit das gleiche Problem:

Beim klick auf eine Produkt-Kategorie kommt folgende Fehlermeldung:

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

select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id 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 = '2' and p2c.categories_id = '53' ORDER BY pd.products_name

[XT SQL Error]

Wer kann mir denn dabei helfen dies zu beseitigen, bzw kann dies für mich gegen einen kleinen Obulus erledigen? Ich habe so gut wie keine Ahnung von PHP etc.

Bitte um Eure mithilfe !!!!

[michael-kom]

Die Lösung wird wohl diese sein,

[Peanuts]

Hallo,

danke für Deine Antwort.

Hast Du denn Ahnung damit - ich habe keinen blassen Schimmer wie man das macht !

Villeicht findet sich ja jemand der das für mich machen kann.

MfG

Stefan

[rivendarkness]

hehe, Peanuts, du hast doch von mir heut früh eine PN erhalten. Guck da doch mal rein

[michael-kom]

Hallo, wir haben das Problem gelöst bekommen, der von uns installierte Shop der Version 3.03 unter mySQL5 läuft nun einwandfrei. Im Grunde steht zwar alles hier in diesem Theard beschrieben wie man es einbindet, aber der besseren Übersicht halber eine Aufstellung, welche Datein geändert werden müssten, bzw geändert wurden (nicht von mir).

Für die Anzeige der Kategorien:

/includes/modules/default.php

Für die Suchfunktion:

advanced_search_result.php

Für Neue Artikel:

products_new.php

Wer die Dateien benötigt, schreibt kurz eine PN. Ich sende sie dann per Mail an Euch. Natürlich kostenlos.

[moklis]

Hallo,

Anfang dieser Woche hat mein Host (one.com) auch ein MySQL Datenbankupdate von 4.1 auf 5.0 durchgeführt, woraufhin mein shop nur noch Fehlermeldungen geliefert hat.

Dank der Fehlermeldungen und mit Hilfe dieses Forums hab ich den shop relativ schnell wieder zum Laufen bekommen:D .

Allerdings sind nun Heute, ohne weitere Eingriffe einfach meine Produkte verschwunden. Das heißt die product_info.php ist einfach leer und es erscheint auch keine Fehlermeldung:confused:

Kann mir vielleicht jemand helfen oder erklären was da passiert sein könnte?

Das ist der shop: http://www.pazianas.de/xtcommerce/index.php/cPath/1

und da gehts dann nicht mehr weiter: http://www.pazianas.de/xtcommerce/pr...products_id/13

[rivendarkness]

naja das da keine Fehlermeldung erscheint ist normal, um deinen shop zu schützen, so das hacker keinen tieferen eindruck von deinen strukturen und configurationen bekommt. und das die product_info.php leer ist ist eben der Fehler

warum die plötzlich leer ist kann mehrere Ursachen haben, z.b. kann ein hacker versucht haben einzudringen und hat dabei fehler gemacht oder er wollte genau das erreichen (skriptkiddies) oder dein provider hat irgendein backup fehlerhaft zurückgespielt, was auch immer...ursachensuche macht sich hier schwer. es bleibt nur eins: einfach hinnehmen und die datei mit einer mit gefüllten inhalt ersetzen

[moklis]

Hallo rivendarkness,

Gut das du auch am Wochenende hier bist (gut für mich natürlich )

Als ich geschrieben habe das die product_info.php leer ist meinte ich eigentlich nur die Seite mit den Produktdetails und nicht die .php Datei selber, die ist immer noch randvoll mit Sachen die ich nicht verstehe.

Ich sollte vielleicht erwähnen das ich keine Ahnung von php und Datenbanken habe, ich kann nur Fehlermeldungen in Suchmaschinen kopieren und dann detailliert beschriebene Anweisungen ausführen:o

Meinst du das du dem Fehler vielleicht auf die Schliche kommen könntest wenn ich meine product_info.php hier mal reinkopieren würde?

Ich machs einfach mal.

  <?php

/* -----------------------------------------------------------------------------------------

   $Id: product_info.php,v 1.34 2004/04/26 10:31:17 fanta2k Exp $   


   XT-Commerce - community made shopping

   http://www.xt-commerce.com


   Copyright (c) 2003 XT-Commerce

   -----------------------------------------------------------------------------------------

   based on: 

   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)

   (c) 2002-2003 osCommerce(product_info.php,v 1.94 2003/05/04); www.oscommerce.com 

   (c) 2003      nextcommerce (product_info.php,v 1.46 2003/08/25); www.nextcommerce.org


   Released under the GNU General Public License 

   -----------------------------------------------------------------------------------------

   Third Party contribution:

   Customers Status v3.x  (c) 2002-2003 Copyright Elari [email protected] | www.unlockgsm.com/dload-osc/ | CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/elari/?sortby=date#dirlist

   New Attribute Manager v4b                            Autor: Mike G | [email protected] | http://downloads.ephing.com   

   Cross-Sell (X-Sell) Admin 1                          Autor: Joshua Dechant (dreamscape)

   Released under the GNU General Public License

   ---------------------------------------------------------------------------------------*/


   //include needed functions


   require_once(DIR_FS_INC . 'xtc_get_shipping_status_name.inc.php');

   require_once(DIR_FS_INC . 'xtc_check_categories_status.inc.php');


 $info_smarty = new Smarty;

 $info_smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/'); 


    if (GROUP_CHECK=='true') {

   $group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

  }

  $product_info_query = xtc_db_query("select

                                      p.products_fsk18,

                                      p.products_discount_allowed,

                                      p.products_id,

                                      pd.products_name,

                                      pd.products_description,

                                      p.products_model,

                                      p.products_shippingtime,

                                      p.products_quantity,

                                      p.products_weight,

                                      p.products_image,

                                      p.products_status,

                                      p.products_ordered,

                                      pd.products_url,

                                      p.products_tax_class_id,

                                      p.products_date_added,

                                      p.products_date_available,

                                      p.manufacturers_id,

                                      p.product_template,

                                      p.product_template

                                      from " . TABLE_PRODUCTS . " p,

                                      " . TABLE_PRODUCTS_DESCRIPTION . " pd 

                                      where p.products_status = '1'

                                      and p.products_id = '" . (int)$_GET['products_id'] . "'

                                      and pd.products_id = p.products_id

                                      ".$group_check."

                                      and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");


  if (!xtc_db_num_rows($product_info_query)) { // product not found in database


  $error=TEXT_PRODUCT_NOT_FOUND;

  include(DIR_WS_MODULES . FILENAME_ERROR_HANDLER);



  } else {

    if (ACTIVATE_NAVIGATOR=='true') {

    include(DIR_WS_MODULES . 'product_navigator.php');

    }

    xtc_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'");

    $product_info = xtc_db_fetch_array($product_info_query);


    //fsk18 lock

    if ($_SESSION['customers_status']['customers_fsk18_display']=='0' && $product_info['products_fsk18']=='1') {


  $error=TEXT_PRODUCT_NOT_FOUND;

  include(DIR_WS_MODULES . FILENAME_ERROR_HANDLER);



    } else {

    if (xtc_get_products_price($product_info['products_id'], $price_special=0, $quantity=1)!='0.00') {

    $products_price=xtc_get_products_price($product_info['products_id'], $price_special=1, $quantity=1);

    } else {

    $products_price='';

    }

    // check if customer is allowed to add to cart

    if ($_SESSION['customers_status']['customers_status_show_price']!='0') {

        // fsk18

        if ($_SESSION['customers_status']['customers_fsk18']=='1') {

            if ($product_info['products_fsk18']=='0') {

            $info_smarty->assign('ADD_QTY',xtc_draw_input_field('products_qty', '1','size="3"') . ' ' . xtc_draw_hidden_field('products_id', $product_info['products_id']));

            $info_smarty->assign('ADD_CART_BUTTON', xtc_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART));

        }

        } else {

        $info_smarty->assign('ADD_QTY',xtc_draw_input_field('products_qty', '1','size="3"') . ' ' . xtc_draw_hidden_field('products_id', $product_info['products_id']));

        $info_smarty->assign('ADD_CART_BUTTON', xtc_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART));

        }

    }


    if ($product_info['products_fsk18']=='1') {

    $info_smarty->assign('PRODUCTS_FSK18','true');

    }

    if (ACTIVATE_SHIPPING_STATUS=='true') {

    $shipping_status=xtc_get_shipping_status_name($product_info['products_shippingtime']);

    $info_smarty->assign('SHIPPING_NAME',$shipping_status['name']);

    if ($shipping_status['image']!='')  $info_smarty->assign('SHIPPING_IMAGE','admin/images/icons/'.$shipping_status['image']);

    }

    $info_smarty->assign('FORM_ACTION',xtc_href_link(FILENAME_PRODUCT_INFO, xtc_get_all_get_params(array('action')) . 'action=add_product'));

    $info_smarty->assign('PRODUCTS_PRICE',$products_price);

    $info_smarty->assign('PRODUCTS_ID',$product_info['products_id']);

    $info_smarty->assign('PRODUCTS_NAME',$product_info['products_name']);

    $info_smarty->assign('PRODUCTS_MODEL',$product_info['products_model']);

    $info_smarty->assign('PRODUCTS_QUANTITY',$product_info['products_quantity']);

    $info_smarty->assign('PRODUCTS_WEIGHT',$product_info['products_weight']);

    $info_smarty->assign('PRODUCTS_STATUS',$product_info['products_status']);

    $info_smarty->assign('PRODUCTS_ORDERED',$product_info['products_ordered']);

    $info_smarty->assign('PRODUCTS_PRINT', '<img src="'.DIR_WS_ICONS.'print.gif"  style="cursor:hand" onClick="javascript:window.open(\''.xtc_href_link(FILENAME_PRINT_PRODUCT_INFO,'products_id='.$_GET['products_id']).'\', \'popup\', \'toolbar=0, width=640, height=600\')">');

    $info_smarty->assign('PRODUCTS_DESCRIPTION',stripslashes($product_info['products_description']));

    $image='';

    if ($product_info['products_image']!='') {

    $image=xtc_href_link(DIR_WS_INFO_IMAGES . $product_info['products_image']);

    }

    $info_smarty->assign('PRODUCTS_IMAGE',$image);

    $info_smarty->assign('PRODUCTS_POPUP_LINK','javascript:popupWindow(\'' . xtc_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\')');


        if ($_SESSION['customers_status']['customers_status_public'] == 1 && $_SESSION['customers_status']['customers_status_discount'] != '0.00') {

      $discount = $_SESSION['customers_status']['customers_status_discount'];

      if ($product_info['products_discount_allowed'] < $_SESSION['customers_status']['customers_status_discount']) $discount = $product_info['products_discount_allowed'];

      if ($discount != '0.00' ) {

        $info_smarty->assign('PRODUCTS_DISCOUNT',$discount . '%');

};


    }


include(DIR_WS_MODULES . 'product_attributes.php');

include(DIR_WS_MODULES . 'product_reviews.php');



    if (xtc_not_null($product_info['products_url'])) {

    $info_smarty->assign('PRODUCTS_URL',sprintf(TEXT_MORE_INFORMATION, xtc_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)));


    }


    if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

        $info_smarty->assign('PRODUCTS_DATE_AVIABLE',sprintf(TEXT_DATE_AVAILABLE, xtc_date_long($product_info['products_date_available'])));



    } else {

        $info_smarty->assign('PRODUCTS_ADDED',sprintf(TEXT_DATE_ADDED, xtc_date_long($product_info['products_date_added'])));


    }


 if ($_SESSION['customers_status']['customers_status_graduated_prices'] == 1) {

 include(DIR_WS_MODULES.FILENAME_GRADUATED_PRICE);

 }

 include(DIR_WS_MODULES . FILENAME_PRODUCTS_MEDIA);

 include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

  }

  if ($product_info['product_template']=='' or $product_info['product_template']=='default') {

          $files=array();

          if ($dir= opendir(DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/product_info/')){

          while  (($file = readdir($dir)) !==false) {

        if (is_file( DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/product_info/'.$file) and ($file !="index.html")){

        $files[]=array(

                        'id' => $file,

                        'text' => $file);

        }//if

        } // while

        closedir($dir);

        }

  $product_info['product_template']=$files[0]['id'];

  }



  $info_smarty->assign('language', $_SESSION['language']);

  // set cache ID

  if (USE_CACHE=='false') {

  $info_smarty->caching = 0;

  $product_info= $info_smarty->fetch(CURRENT_TEMPLATE.'/module/product_info/'.$product_info['product_template']);

  } else {

  $info_smarty->caching = 1;	

  $info_smarty->cache_lifetime=CACHE_LIFETIME;

  $info_smarty->cache_modified_check=CACHE_CHECK;

  $cache_id = $_GET['products_id'].$_SESSION['language'].$_SESSION['customers_status']['customers_status_name'].$_SESSION['currency'];

  $product_info= $info_smarty->fetch(CURRENT_TEMPLATE.'/module/product_info/'.$product_info['product_template'],$cache_id);

  }



  }

  $smarty->assign('main_content',$product_info);


  ?>[/PHP]

[rivendarkness]

achso...ja dann is die also doch nich leer dann liegts nicht an der datei.

also als erstes was ich dann vermute wäre, das die berechtigungen verschiedener ordner nicht richtig gesetzt sind. führe doch nochmal den installer aus, der müsste dir gleich am anfang sagen, welche ordner welche fehlenden berechtigungen haben. und natürlich den installer nicht bis zu ende ausführen, das is nur zum gucken da

als weiteres überprüfe mal deinen cache. lösche den cache und deaktiviere ihn erstmal und guck dann nochmal obs nicht geht oder doch

[moklis]

so, nach 4 Jahren, 2 neuen Rechnern und 3 neuen Festplatten ist der installer zu meiner ollen XT-C v1.0 Beta2 Version leider nicht mehr auffindbar.

online hab ich nur die neueste 304SP2.1_release zum download gefunden.

Bringt das was den installer der neuen version mal rüberlaufen zu lassen?

Der cache ist es natürlich nicht, soviel Ahnung hab ich dann doch noch:cool:

[rivendarkness]

das is aber schon ganz schön alt...du solltest vielleicht gleich auf eine neuere version umstellen, alleine schon aus sicherheitsgründen...ob der installer was bringt weiß ich nicht, da ich die version 1 nicht kenne. es ist eine betaversion sagst du...noch einen grund sowas nicht einzusetzen...du siehst ja wo das hinführt

stell doch einmal alle ordner auf chmod 777...ich weiß das sollte man nicht tun, allerdings kannst du dann alle ordner wieder auf 755 stellen und sehen bei welchen ordnern es hängt...aber wie gesagt mein dringlicher rat wäre es die neuste version und NIEMALS eine Betaversion produktiv zu nutzen.

[moklis]

hallo,

ok, das mit dem update auf die neueste version wird gemacht sobald mein administrator aus der babypause zurück ist;) .

ich hab mal die PHP-Fehleranzeige aktiviert und dann folgende Fehlermeldung bekommen:

Warning: main(DIR_FS_INCxtc_get_shipping_status_name.inc.php) [function.main]: failed to open stream: No such file or directory in /customers/pazianas.de/pazianas.de/httpd.www/xtcommerce/product_info.php on line 26

Fatal error: main() [function.require]: Failed opening required 'DIR_FS_INCxtc_get_shipping_status_name.inc.php' (include_path='.:/usr/lib/php') in /customers/pazianas.de/pazianas.de/httpd.www/xtcommerce/product_info.php on line 26

kann das noch von nem laien wie mir behoben werden oder sollte ich damit auch lieber auf meinen admin warten:confused:

[rivendarkness]

ay, klingt so als ob ein paar pfadangaben nicht stimmen.

gehe mal in die include/config.php und include/config.org.php und überprüfe die pfadangaben, ob die stimmen, insofern es solche configs in der version schon gibt...