Moving my prestashop from shared host to server

cyberblood · September 7, 2017

Hi.

I decided to move my site from shared host to a server.

I have read many tutorials and suggestions, but noone helped me.

I have 1.6.1.2

Move to macOS server with PHP 7.1 with all Symphony modules needed.

I have changed all fields in the database to 127.0.0.1

I still can't access no one back and front office.

I got this error:

( ! ) Notice: tempnam(): file created in the system's temporary directory in /Library/Server/Web/Data/Sites/Default/classes/PrestaShopAutoload.php on line 158
Call Stack
#	Time	Memory	Function	Location
1	0.0006	366488	{main}( )	.../index.php:0
2	0.0015	427624	require( '/Library/Server/Web/Data/Sites/Default/config/config.inc.php' )	.../index.php:27
3	0.0031	444136	require_once( '/Library/Server/Web/Data/Sites/Default/config/autoload.php' )	.../config.inc.php:64
4	0.0041	492560	PrestaShopAutoload::getInstance( )	.../autoload.php:31
5	0.0041	492656	PrestaShopAutoload->__construct( )	.../PrestaShopAutoload.php:80
6	0.0042	492752	PrestaShopAutoload->generateIndex( )	.../PrestaShopAutoload.php:68
7	0.1959	965184	tempnam ( )	.../PrestaShopAutoload.php:158

( ! ) Fatal error: Uncaught Error: [] operator not supported for strings in /Library/Server/Web/Data/Sites/Default/classes/db/DbQuery.php on line 96
( ! ) Error: [] operator not supported for strings in /Library/Server/Web/Data/Sites/Default/classes/db/DbQuery.php on line 96
Call Stack
#	Time	Memory	Function	Location
1	0.0006	366488	{main}( )	.../index.php:0
2	0.0015	427624	require( '/Library/Server/Web/Data/Sites/Default/config/config.inc.php' )	.../index.php:27
3	0.2087	2155432	ShopCore::initialize( )	.../config.inc.php:114
4	0.2184	2910264	ShopCore->__construct( )	.../Shop.php:400
5	0.2184	2910264	ObjectModelCore->__construct( )	.../Shop.php:131
6	0.2186	2927952	Adapter_EntityMapper->load( )	.../ObjectModel.php:233
7	0.2188	2963192	DbQueryCore->from( )	.../Adapter_EntityMapper.php:45

Scully · September 7, 2017

Why do you take such an exotic setup? I would be very surprised it this setup would work "out from the box".

Your error messages basically say that your PHP version isn't compatible with prestashop. Maybe a 5.6. PHP would work. Maybe...

cyberblood · September 8, 2017

As I see in the Presta requirements, there is shown PHP 5.4 + ......

NicolasIT · September 8, 2017

MacOS? PHP 7.1? exotic setup as Scully said

cyberblood · September 8, 2017

men, I really have no idea what you find as exotic and why?

There are plenty of hosting and servers using Mac mini with macOS Server.Me too have one and it works as charm.

Prestashop creators states that it requires PHP 5.4+ and in same time you says that the problem is with the PHP??

I tried with 5.6 and it doesn't work as well.I moved it from CPanel.

NicolasIT · September 8, 2017

as far as i know macOs servers are 0,1% maybe i didn't know about its growth

edit: you wrote about mac mini server hosting, you can't be serious!

Edited September 8, 2017 by NicolasIT (see edit history)

Scully · September 8, 2017

The setup sounds very strange. Check line 96 in the mentionned file. Try to run a syntax check on some PHP online syntax checker like this one:

http://www.meandeviation.com/tutorials/learnphp/php-syntax-check/v5-3/syntax-check.php

with your file /Library/Server/Web/Data/Sites/Default/classes/db/DbQuery.php

If this ends with success your environment isn't compatible. That easy.

musicmaster · September 8, 2017

If you look at the forum you will see that there are even serious problems with Prestashop 1.6.1.2 and PHP 7.0.

I am not sure about PHP 7.1 compatibility but I see several error reports about it and 1.6.1.11.

So my advice would be to upgrade your shop to the newest 1.6.1.x version before you move it to the new server.

cyberblood · September 9, 2017

I switched to PHP 5.6.31 with all needed extension Mcrypt etc.

Now I get this:

 Notice: Undefined variable: id_lang in /Library/Server/Web/Data/Sites/Default/override/classes/Dispatcher.php on line 469
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1632	14427024	Dispatcher->getController( )	.../Dispatcher.php:259
4	0.1633	14430128	Dispatcher::isArticleLink( )	.../Dispatcher.php:335

( ! ) Notice: Undefined variable: id_lang in /Library/Server/Web/Data/Sites/Default/override/classes/Dispatcher.php on line 518
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1632	14427024	Dispatcher->getController( )	.../Dispatcher.php:259
4	0.1668	14430360	Dispatcher::isBlogLink( )	.../Dispatcher.php:340

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4334	29716496	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4348	29720000	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4354	29723288	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4356	29726552	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4359	29749352	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4362	29759552	JmsMegamenu->genItem( )	.../megamenu.php:161

( ! ) Notice: Trying to get property of non-object in /Library/Server/Web/Data/Sites/Default/modules/jmsdropmegamenu/megamenu.php on line 206
Call Stack
#	Time	Memory	Function	Location
1	0.0002	241632	{main}( )	.../index.php:0
2	0.1632	14425840	DispatcherCore->dispatch( )	.../index.php:28
3	0.1733	15179640	ControllerCore->run( )	.../Dispatcher.php:367
4	0.2100	20034880	IndexControllerCore->initContent( )	.../Controller.php:189
5	0.2100	20035240	FrontControllerCore->initContent( )	.../IndexController.php:37
6	0.2100	20035320	HookCore::exec( )	.../FrontController.php:579
7	0.3409	27541632	HookCore::coreCallHook( )	.../Hook.php:542
8	0.3409	27547048	JmsSetting->hookdisplayHeader( )	.../Hook.php:587
9	0.3890	28032528	JmsSetting->exec( )	.../jmssetting.php:1649
10	0.3939	28735600	JmsDropMegaMenu->hookDisplayTop( )	.../jmssetting.php:986
11	0.4334	29706960	JmsMegamenu->render( )	.../jmsdropmegamenu.php:1213
12	0.4334	29707192	JmsMegamenu->nav( )	.../megamenu.php:143
13	0.4368	29818712	JmsMegamenu->genItem( )	.../megamenu.php:161
[PrestaShopDatabaseException]

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hot2hot_presta.il.legend' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


		SELECT
			p.id_product,  MAX(product_attribute_shop.id_product_attribute) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`,
			MAX(image_shop.`id_image`) id_image, il.`legend`,
			ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable,
			IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock,
			product_shop.`date_add` > "2017-07-11" as new, product_shop.`on_sale`
		FROM `ps_product_sale` ps
		LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product`
		 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
		LEFT JOIN `ps_product_attribute` pa
			ON (p.`id_product` = pa.`id_product`)
		 LEFT JOIN ps_product_attribute_shop product_attribute_shop
		ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
		 LEFT JOIN ps_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
		LEFT JOIN `ps_product_lang` pl
			ON p.`id_product` = pl.`id_product`
			AND pl.`id_lang` = 1 AND pl.id_shop = 1 
		LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
		ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
		LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
		LEFT JOIN `ps_category_lang` cl
			ON cl.`id_category` = product_shop.`id_category_default`
			AND cl.`id_lang` = 1 AND cl.id_shop = 1 
			
		LEFT JOIN `ps_category_product` cp on cp.`id_product` = p.`id_product`
		
		WHERE product_shop.`active` = 1
		AND p.`visibility` != 'none'
		AND p.`id_product` IN (16,17,18,19,20,21,22,23,24,25,31,32,33,34,35,36,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,65,66,67,95,96,105,108,109,110,111,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,135,136,137,138,139,140,141,142,143,144,145,146,148,149,150,151,152,153,154,155,156,157,158,159,160,162,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,212,214,215,216,217,218,219,220,221,222,224,225,226,227,228,229,230,231,232,233,235,236,237,238,239,240,241,244,245,246,247,249,250,251,253,254,255,256,257,259,260,261,262,263,264,266,267,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,313,314,315,316,317,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,342,344,345,346,348,349,350,352,354,357,358,359,360,361,364,365,366,367,368,369,370,371,372,373,375,376,377,378,379,380,381,382,383,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,406,407,408,409,410,411,412,413,414,415,416,417,419,420,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,445,447,448,449,450,451,452,453,454,455,456,457,458,459,461,462,464,465,468,469,470,471,472,473,474,476,477,479,480,481,482,483,484,485,486,487,489,493,494,495,496,498,499,502,504,507,509,510,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,540,541,542,544,545,546,547,549,550,551,552,553,555,557,558,559,560,561,562,563,564,565,566,569,571,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,597,598,600,601,602,603,604,605,608,609,610,611,613,614,615,616,617,618,619,620,621,622,623,624,625,627,628,629,630,631,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,660,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,683,684,685,686,687,688,689,690,691,692,693,694,695,696,698,699,700,701,702,704,705,706,707,709,710,711,713,714,715,716,717,718,719,720,721,722,723,724,725,726,728,730,731,733,734,735,737,738,740,741,744,745,746,747,748,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,775,776,777,778,779,780,782,783,784,785,786,788,790,791,792,793,795,796,797,798,799,800,801,802,803,804,807,808,809,811,812,813,814,815,816,817,818,819,820,821,822,825,826,827,828,829,831,834,836,837,838,839,840,841,842,844,845,846,849,850,853,854,855,856,857,858,859,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,877,878,879,881,883,885,887,888,892,893,895,896,897,898,900,901,902,904,905,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,934,935,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,959,960,961,962,963,964,965,966,967,968,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1016,1018,1019,1020,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,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,1070,1071,1072,1073,1074,1075,1077,1078,1079,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1134,1135,1136,1137,1139,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1152,1153,1155,1156,1157,1158,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1197,1199,1200,1202,1203,1204,1205,1206,1207,1208,1209,1210,1213,1214,1215,1217,1218,1220,1222,1223,1224,1225,1226,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1254,1255,1256,1257,1258,1259,1267,1268,1271,1272,1273,1274,1281,1282,1284,1287,1288,1289,1290,1292,1293,1294,1298,1300,1301,1302,1303,1304,1306,1308,1309,1311,1313,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1336,1338,1339,1340,1341,1344,1345,1346,1347,1349,1350,1351,1354,1355,1358,1359,1360,1364,1365,1367,1368,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1395,1396,1397,1399,1400,1425,1426,1427,1428,1429,1430,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1443,1448,1451,1455,1456,1457,1458,1459,1460,1461,1465,1466,1467,1468,1469,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1529,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1567,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1608,1609,1610,1611,1612,1613,1614,1615,1616,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1636,1639,1640,1641,1642,1643,1644,1645,1646,1648,1649,1650,1651,1652,1653,1656,1657,1658,1659,1661,1662,1663,1664,1665,1666,1669,1671,1679,1684,1685,1686,1687,1693,1694,1698,1699,1701,1706,1708,1710,1711,1712,1716,1717,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1747,1748,1749,1756,1757,1758,1759,1760,1761,1763,1764,1765,1767,1768,1769,1770,1771,1772,1773,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1793,1794,1795,1796,1797,1799,1800,1801,1803,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1818,1821,1822,1823,1824,1830,1831,1833,1834,1835,1836,1838,1839,1840,1841,1842,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1858,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1944,1945,1946,1947,1948,1949,1950,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964)
		AND cp.`id_category` = 2
		
		GROUP BY product_shop.id_product
		ORDER BY sales DESC
		LIMIT 0, 8

at line 791 in file classes/db/Db.php
786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }
DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 350 - modules/jmsproductfilter/jmsproductfilter.php] - [1 Arguments]
JmsProductFilter::sqlCategoryProduct - [line 141 - modules/jmsproductfilter/jmsproductfilter.php] - [4 Arguments]
JmsProductFilter->getTopSellerProduct - [line 360 - modules/jmsproductfilter/jmsproductfilter.php] - [3 Arguments]
JmsProductFilter->hookdisplayHome - [line 587 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 40 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore->initContent - [line 189 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Scully · September 9, 2017

Take a correct environment and I am glad to help out. But with this kind of setup.... it's like trying to replace a BMW engine with one from Volkswagen.

cyberblood · September 9, 2017

Hi Scully, with all respect to you I'm fallowing all instructions:

Apache/2.4.25 (Unix)

PHP 5.6.31 with all extension required for Prestashop as Mcrypt etc.

MYSQL Server 5.7.19

I have another OS X Server and i'm running great site , but it's not Prestashop.

There is nothing wired in this.Or if it is, just let me know which of the mentioned requirements I didn't follow?

Edited September 9, 2017 by cyberblood (see edit history)

Scully · September 9, 2017

You are correct, but I also said that PHP 5.6. might work. Your posted errors show two separate problems.

1st ) some php code throws errors which should not be the case. You could now inspect each of this code lines and adapt them for your php version. This is possible but it might need quite some time. And you have to consider not having seen all errors. The shop has many functions which are not executed on every step. So testing all functions might unhide some more errors.

2nd ) my SQL error: This is related to a datatabase engine with does not provide the function needed. Maybe a newer version helps.

Overall - you could try to disable all non standard modules and see if this helps. Chances exists some errors might go away this way.

cyberblood · September 9, 2017

@Scully at first I'd like to THANK YOU for your time! I highly appreciate it!

I'm using this PHP 5.6.31 package precompiled by your compatriots https://php-osx.liip.ch

This is my ini file:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; This file extends the default php.ini-development shipped with PHP
; http://svn.php.net/viewvc/php/php-src/trunk/php.ini-development
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; adjust those settings as required
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[liip]
memory_limit = 256M

; Liip Zurich
date.timezone = Europe/Zurich
date.default_latitude  = 47.38
date.default_longitude =  8.5244

; Liip Fribourg
; date.default_latitude  = 46.8042
; date.default_longitude =  7.1547


; from the manual http://php.net/manual/en/datetime.configuration.php

; Lat/Long for SE corner of Parliament Square (near Big Ben/Houses of Parliament):
; date.timezone = "Europe/London"
; date.default_latitude  = 51.500181
; date.default_longitude = -0.12619

; Berlin center district near "Neptunbrunnen"
; date.timezone = "Europe/Berlin"
; date.default_latitude  = 52.5194
; date.default_longitude = 13.4067

; date.timezone = "Asia/Shanghai"
; date.default_latitude  =  31.5167
; date.default_longitude = 121.4500


detect_unicode = Off
session.gc_maxlifetime = 14400
error_reporting = E_ALL | E_STRICT
error_log = /var/log/apache2/php_errors.log
mysql.default_socket = /tmp/mysql.sock

;disable gc, since it seems to crash ext/intl [chregu, 3.1.2011]
;enabled it again, let's see if it works better now [chregu, 3.4.2013]
;zend.enable_gc = off

; if you need to create phar files, activate this setting
; phar.readonly = false

; Liip PHP extensions you should have at hand for development
; apc (available but disabled by default)
; curl
; gettext
; intl
; mbstring
; memcache
; memcached
; mongodb
; mssql
; mysql
; mysqli
; mysqlnd
; OAuth
; openssl
 pdo
 pdo_mysql
; pdo_pgsql
; pdo_sqlite
; pgsql
; Phar
; solr
; tidy
; xhprof
; xsl
; xslcache (available but disabled by default)
; xdebug

musicmaster · September 9, 2017

When I look on the internet for Jmsdropmegamenu I encounter something that runs with Prestashop 1.5. Are you sure your version can run with 1.6.1?

cyberblood · September 9, 2017

Yes, more than sure.I run it w/out any problems on the current host.

Scully · September 9, 2017

Last suggestion: Why not try to take the exact same PHP version as you had before. It this doesn't work its simply an incompatibility between the PHP versions of differen platforms.

musicmaster · September 10, 2017

I see one other thing:

SELECT list is not in GROUP BY clause and contains nonaggregated column 'hot2hot_presta.il.legend' 
which is not functionally dependent on columns in GROUP BY clause; 
this is incompatible with sql_mode=only_full_group_by

First of all, this is obviously not Prestashop but some plugin as Prestashop doesn't have a legend table.

"only_full_group_by" has do with Mysql that sometime ago decided to become a bit stricter in which "GROUP BY" queries it accepted. I leave it to you to search the internet to find the details. Anyway, it looks like your application has a query that doesn't qualify for those new stricter criteria. There are basically three ways out:

- use an older version of Mysql

- use Mariadb

- disable the stricter criteria with a query like ""SET SESSION sql_mode=(SELECT REPLACE([spam-filter]sql_mode,'ONLY_FULL_GROUP_BY',''))");

"

cyberblood · September 10, 2017

I have switched to the previous version of MySQL and the DB error disappeared.Unfortunately the dispatcher one still exists.

I thing that there is some error with the Firndly URLs.Because I see the site, but because I;m in dev mode I see erros above and the links doesn't work.

Mod rewrite is enable, I removed the .htaccess but the dispatcher error continiues.I use ZZ clean urls free module.

I have no access to the back office as well.

musicmaster · September 10, 2017

The problem is caused by an override. So you should check (by disabling them) which module is causing this problem.

My guess is that it is the menu. My advice would be to uninstall it and then re-install it.

cyberblood · September 11, 2017

Hi.I thing the same, but i have no access to the back office

musicmaster · September 11, 2017

The best thing you can do now is to install Prestools (it works outside the backoffice) and use it to clear the cache (under Tools&Stats->Shop Rescue). Of course you can clear the cache manually too by deleting files, but in that case you should know what you are doing as a mistake is easily made.

Edited September 13, 2017 by musicmaster (see edit history)

musicmaster · September 12, 2017

If you are lucky just emptying the cache may solve your problem.

Otherwise this same Shop Rescue page has also an option to disable all non-Prestashop modules. Activating should be a sure way to allow you into your backoffice. Of course you then still need to find a way to get the menu working - maybe by re-installing or resetting.

cyberblood · September 15, 2017

clearing the cache didn't work.

This is the entire error I got.Below these errors the frontend appears with no image working and no links are working when click.

Another thing is that trying to access the back office I got some errors, but I see the login.When click to login the fields disappears.

I compared the cookies and keys, they are the same as in the current host.

UPDATE

I noticed that on my current hosting in the .htaccess it uses a reference to suPHP which is the PHP handler (i really have no idea what is this).

OS X doesn't have suPHP installed! Despite of this during the test on the server I'm trying to move prestashop there is a OSP handler.Do i have to make some changes?

What I also have tried is to install fresh installation of the version 1.6.1.2 and it passed all requirements, but when I tried to change the language and selected the new one it didn't reloaded, but displayed a blank page! What I thing is that there is an issue with the writing files, but I have no idea about this handlers.

Edited September 17, 2017 by cyberblood (see edit history)

musicmaster · September 18, 2017

In post #22 I recommended some other trick that you didn't yet implement. You might try that too.

However, your experiments with a fresh installation seem to point to file rights issues - probably involving ownership. SuPHP is about ownership so that would fit. There are experiments and investigations you could do yourself on this issue but I think the best is to ask your hosting provider.

Scully · September 18, 2017

For the time used as per now you would had easily found an affordable solution with an appropriate hosting service.

cyberblood · September 19, 2017

Is it necessary to switch into maintenance mode before make backup in order to work on the new hosting?

Edited September 19, 2017 by cyberblood (see edit history)

Moving my prestashop from shared host to server

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in