1. mac4life
  2. RO CSVI
  3. Tuesday, 23 January 2018
  4.  Subscribe via email
Hi

I made an update from version 6 to CSVI Pro 7.4.1
Now I'm unable to use my Google Shopping/Merchant template.
Added a rule removing HTML charcters.
It just doens't work

When i start exporting
The last server response has not been received in a timely fashion. The server may still be busy or stopped the process. You can wait a little longer to see if the server will sent a response or cancel the process.


Log
SELECT `#__virtuemart_products`.`virtuemart_product_id`,
`#__virtuemart_products`.`product_parent_id`,
`#__virtuemart_products`.`product_url`,
`product_sku`,
`product_gtin`,
`#__virtuemart_currencies`.`currency_code_3`,
`#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`,
`product_in_stock`,
`product_availability`
FROM `#__virtuemart_products`
LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency`
LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id`
WHERE #__virtuemart_products.virtuemart_product_id IN (1,2,3,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,24,25,26,28,30,31,32,37,38,39,40,41,42,43,44,45,46,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,66,67,68,69,70,87,88,97,97,101,102,103,104,106,107,108,112,113,114,120,121,123,124,124,126,127,128,129,142,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,181,182,183,184,185,186,187,188,189,189,192,193,194,195,195,196,196,197,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,219,220,221,222,223,224,225,226,227,228,229,230,231,232,235,236,237,238,239,240,242,244,245,246,247,248,249,250,251,252,253,254,255,256,258,259,260,261,264,265,301,306,307,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,333,338,343,344,347,347,348,351,351,352,352,353,353,354,355,356,375,376,377,379,380,381,383,389,390,391,392,393,393,394,395,396,397,398,399,400,401,402,403,405,406,407,408,409,410,411,412,413,414,415,416,418,419,420,422,423,424,425,426,427,427,428,429,432,433,437,438,439,442,443,444,445,458,459,460,467,469,512,513,514,516,517,518,519,520,522,523,524,525,532,533,534,539,541,542,543,545,546,548,549,550,551,552,553,554,555,556,557,559,560,561,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,587,589,594,595,597,598,599,600,602,603,604,606,607,608,609,610,611,612,613,614,616,622,624,626,627,628,629,630,630,631,632,633,643,644,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,671,672,672,673,674,675,677,697,698,699,700,701,702,712,713,714,715,716,717,718,719,720,721,722,723,724,725,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,749,750,750,751,752,753,754,755,758,759,760,761,762,763,763,765,766,767,768,769,770,771,772,773,774,775,776,777,785,786,789,791,793,794,795,796,797,798,799,800,819,820,821,822,823,824,825,826,826,827,831,832,833,834,835,836,839,840,841,842,843,844,845,846,847,848,849,850,851,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,881,881,882,885,886,887,888,889,891,892,893,894,895,896,897,898,899,902,906,906,907,907,908,908,910,912,913,914,915,916,917,918,919,920,920,921,921,922,922,923,923,924,925,926,927,930,933,934,935,936,937,937,938,938,939,940,941,942,943,944,945,946,947,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,976,978,978,979,979,980,981,982,983,984,985,986,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1013,1014,1015,1016,1017,1018,1019,1020,1023,1027,1028,1029,1029,1030,1031,1032,1033,1034,1035,1036,1037,1040,1041,1042,1043,1045,1046,1047,1048,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1093,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1115,1116,1117,1118,1119,1120,1121,1122,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1148,1149,1149,1150,1151,1152,1153,1154,1155,1156,1157,1159,1160,1161,1162,1165,1166,1167,1168,1169,1171,1172,1173,1174,1175,1176,1176,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1225,1226,1227,1228,1229,1230,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1277,1278,1279,1280,1281,1282,1283,1284,1286,1287,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1334,1335,1336,1337,1338,1339,1341,1342,1343,1344,1344,1345,1346,1347,1348,1350,1351,1352,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1365,1366,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1387,1388,1389,1389,1390,1390,1391,1391,1392,1392,1393,1393,1394,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1428,1429,1430,1431,1432,1432,1433,1433,1434,1434,1435,1436,1437,1438,1439,1440,1442,1443,1444,1445,1446,1447,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1477,1478,1479,1480,1481) AND #__virtuemart_products.published = 1 AND #__virtuemart_products.product_in_stock >= 1
GROUP BY #__virtuemart_products.virtuemart_product_id




PHP version 7.0.27
Joomla! version 3.8.3
VirtueMart 3.2.12
CSVI Pro 7.4.1
Accepted Answer Pending Moderation
Hello,
There is nothing wrong i could see as per the query you have posted. Can you check exporting only a few records works? To do that in your export template on File tab set From and To record to get only 10 records and see if exports goes without error. Try increasing it and see where the export breaks.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Tharuna

Now i have this message:

No export file has been created because there are no records to export. Set Output empty file to Yes in the template settings to generate an empty file.


I've attached the log

Thanks

com_csvi.log.21.zip
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
The query in debug log says you have filter set for price and product stock in your template settings and in Options tab. I guess the 10 products which are exported are not matching any of these filter conditions and so you are getting No records to export. Can you create a copy of this template so you still have the original as backup, remove all the filters and then try the export?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Tharuna

OK, I have removed "filter conditions"
New Log

com_csvi.log.23.zip
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
The only filter i see now in the debug log is for product stock level to be 1. Are you sure all of your products have stocks greater than or equal to 1? What if you remove this filter and run the export? Does your export get any record?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi Tharuna
Ok now 10 products have been exported, more than 3min needed

With all products selected, I got this message:

Status error: 500
Status message: Internal Server Error
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Status error: 500
Status message: Internal Server Error

Have a look at 500 error document to know details on this error. You need to check your server error logs and get the actual error which is causing 500 internal server error.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
I just noticed in your debug log that you are exporting product URL with SEF set to Yes on options tab in your export template. I am guessing that is causing the error. You would have reached limits by generating the SEF URLs on export as Joomla sends request to front end for each and every SEF URL generated. Can you try setting Export SEF to No and check the export?

If that is the cause for the issue then there is a option in CSVI to generate SEF URLs before running the export. In CSVI maintenance menu select VirtueMart in first option and in the second option Refresh URLs and select the template and click continue. This option will generate SEF URLs and add them to a CSVI database table. When the export runs with export SEF set to Yes, SEF URLs will be read from this table which makes export to run faster. Let me know if it helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Tharuna

The SEF URL caused the error.
Now it works. Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!