Hallo!
Danke für Ihre Antwort. Leider ist ein Update derzeit nicht möglich. Ist Ihnen eine Methode bekannt mit welcher man dieses Problem auch unter der aktuellen vorhandenen Version beseitigen kann?
Grüße
Andre
Hallo!
Danke für Ihre Antwort. Leider ist ein Update derzeit nicht möglich. Ist Ihnen eine Methode bekannt mit welcher man dieses Problem auch unter der aktuellen vorhandenen Version beseitigen kann?
Grüße
Andre
Nachdem wir in unserem Shop die Konfiguration der Suchpräferenzen auf Sortierung nach Namen verändert haben bekommen wir den folgenden Fehler:
ZitatUnknown column 'pc.ordering' in 'order clause' SQL=SELECT DISTINCT SQL_CALC_FOUND_ROWS p.virtuemart_product_id FROM ag25_virtuemart_products AS p WHERE p.virtuemart_product_id IN (1,2,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,204,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,348,350,351,352,353,354,355,356,357,358,359,360,361,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,407,408,409,410,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,462,476,477,478,484,485,486,487,488,489,491,494,495,496,497,499,500,501,504,505,507,508,511,512,513,514,515,516,518,519,520,521,522,523,524,525,526,527,528,531,532,533,534,535,537,539,541,542,550,551,552,553,554,555,556,557,558,559,560,561,562,564,565,566,567,568,569,570,571,572,573,574,575,576,578,579,580,581,582,583,584,585,586,588,589,590,591,592,593,594,603,604,605,607,608,609,610,611,612,613,614,615,616,618,619,622,625,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,648,650,651,652,653,654,655,656,657,658,659,660,661,665,666,667,668,669,670,671,672,674,676,677,678,679,680,681,689,690,691,692,693,694,695,696,697,698,699,700,702,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,721,722,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,743,744,746,747,748,749,750,751,754,755,756,757,758,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,781,782,1026,1028,1029,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1073,1074,1075,1076,1077,1078,1083,1084,1085,1111,1112,1113,1114,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1132,1133,1134,1135,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1162,1163,1164,1165,1166,1167,1168,1169,1171,1172,1173,1174,1175,1198,1200,1201,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1244,1246,1247,1249,1250,1251,1252,1267,1268,1269,1272,1275,1278,1279,1280,1281,1282,1283,1284,1285,1287,1288,1289,1290,1291,1293,1294,1295,1296,1297,1299,1300,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1361,1362,1363,1364,1365,1366,1367) AND `p`.`published`=1 AND p.product_parent_id=0 ORDER BY pc.ordering,product_name ASC LIMIT 0, 24
Der Fehler erscheint nicht, wenn die Präferenzen wieder zurückgestellt werden.
Joomla! 3.4.8
VirtueMart 3.0.12