Issue With Email Exporter

seandigitalsave · July 10, 2017, 12:00am

When I click the export button, progress bar flashes up and flashes off again. Nothing happens. Not enough time for it to be a timeout. Just flashes up and off again.

Since April, server has been upgraded massively hardware.

ecomlabs · July 10, 2017, 12:00am

When I click the export button, progress bar flashes up and flashes off again. Nothing happens. Not enough time for it to be a timeout. Just flashes up and off again.

Since April, server has been upgraded massively hardware.

Did you check server error logs? If you are familiar with the developer console of your browser, check request and response parameters

seandigitalsave · July 10, 2017, 12:00am

This is the response headers.

			Cache-Control
		
			no-store, no-cache, must-revalidate
	
			Connection
		
			Keep-Alive
	
			Content-Encoding
		
			gzip
	
			Content-Length
		
			12086
	
			Content-Type
		
			text/html; charset=utf-8
	
			Date
		
			Mon, 10 Jul 2017 15:31:45 GMT
	
			Expires
		
			Thu, 19 Nov 1981 08:52:00 GMT
	
			Keep-Alive
		
			timeout=5, max=100
	
			Pragma
		
			no-cache
	
			Server
		
			Apache/2.4.25 (cPanel) OpenSSL/1.0.1e-fips mod_bwlimited/1.4
	
			Set-Cookie
		
			sid_admin_f4397=68d8dc40025e28496c0c7e32d64a7074-0-A; expires=Mon, 24-Jul-2017 15:31:45 GMT; Max-Age=1209600; path=/; domain=.www.digitalsave.co.uk; HttpOnly
	
			Vary
		
			Accept-Encoding,User-Agent
	
			X-Powered-By
		
			PHP/7.0.20

view source

			Accept
		
			text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
	
			Accept-Encoding
		
			gzip, deflate, br
	
			Accept-Language
		
			en-US,en;q=0.5
	
			Connection
		
			keep-alive
	
			Cookie
		
			_ga=GA1.3.223394504.1497005511; cookieconsent_dismissed=yes; sid_customer_f4397=b60636f06fd5f40a52538e8274cb7b0f-1-C; sid_admin_f4397=68d8dc40025e28496c0c7e32d64a7074-0-A; _gid=GA1.3.1491510172.1499700102
	
			Host
		
			www.digitalsave.co.uk
	
			Upgrade-Insecure-Requests
		
			1
	
			User-Agent
		
			Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0

seandigitalsave · July 10, 2017, 12:00am

Heres a pic [url=https://postimg.org/image/j1os866nl/][/url]

seandigitalsave · July 10, 2017, 12:00am

Server Error Log for today. I ran the exporter a few mins before this post again, but it didnt appear to generate any new errors.

[Mon Jul 10 12:58:21.286455 2017] [access_compat:error] [pid 25375] [client 66.249.66.76:36766] AH01797: client denied by server configuration: /home/digitalsaveadmin/public_html/var/cache/misc/assets/design/themes/buyshop, referer: http://www.digitalsave.co.uk/puregear-express-folio-wallet-case-for-iphone-6-6s-plus-black.html

[Mon Jul 10 12:30:31.884414 2017] [access_compat:error] [pid 22568] [client 217.155.33.154:62896] AH01797: client denied by server configuration: /home/digitalsaveadmin/public_html/var/cache/misc/assets, referer: http://www.digitalsave.co.uk/delivery-information.html

[Mon Jul 10 07:11:21.351340 2017] [access_compat:error] [pid 32189] [client 66.249.66.75:59018] AH01797: client denied by server configuration: /home/digitalsaveadmin/public_html/var/cache/misc/assets/design/themes/buyshop, referer: http://www.digitalsave.co.uk/phone-accessories/phone-tablet-protection/cases/iphone/page-2/

[Mon Jul 10 05:38:47.959841 2017] [core:crit] [pid 28188] (13)Permission denied: [client 80.82.77.139:55143] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:47.452497 2017] [core:crit] [pid 25179] (13)Permission denied: [client 80.82.77.139:50734] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:44.236267 2017] [core:crit] [pid 28056] (13)Permission denied: [client 80.82.77.139:50526] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:44.119980 2017] [core:crit] [pid 28057] (13)Permission denied: [client 80.82.77.139:50207] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:44.017731 2017] [core:crit] [pid 25173] (13)Permission denied: [client 80.82.77.139:50090] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:43.906522 2017] [core:crit] [pid 25175] (13)Permission denied: [client 80.82.77.139:49931] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 05:38:43.596463 2017] [core:crit] [pid 28188] (13)Permission denied: [client 80.82.77.139:49448] AH00529: /home/digitalsaveadmin/public_html/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/home/digitalsaveadmin/public_html/' is executable

[Mon Jul 10 01:04:21.186228 2017] [access_compat:error] [pid 14412] [client 66.249.66.75:52386] AH01797: client denied by server configuration: /home/digitalsaveadmin/public_html/var/cache/misc/assets/design/themes/buyshop, referer: http://www.digitalsave.co.uk/tech21-impactology-evo-mesh-band-for-iphone-6-plus.html

ecomlabs · July 11, 2017, 12:00am

What about the Response section?

seandigitalsave · July 11, 2017, 12:00am

I get this .503 Service Temporarily Unavailable error [url=https://postimg.org/image/85iiokpax/][/url]

			POST haha.php
		
		
			503 Service Temporarily Unavailable
		
		
			digitalsave.co.uk
		
		
			1.2 KB
		
		
			185.116.215.81:443
		
		
			 
			 
			 
			 
			 
			 
			1.16s

Headers Post Response HTML Cache Cookies

view source

			Cache-Control
		
			no-store, no-cache, must-revalidate
	
			Connection
		
			close
	
			Content-Encoding
		
			gzip
	
			Content-Type
		
			text/html; charset=utf-8
	
			Date
		
			Tue, 11 Jul 2017 10:31:35 GMT
	
			Expires
		
			Thu, 19 Nov 1981 08:52:00 GMT
	
			Pragma
		
			no-cache
	
			Retry-After
		
			300
	
			Server
		
			Apache/2.4.25 (cPanel) OpenSSL/1.0.1e-fips mod_bwlimited/1.4
	
			Set-Cookie
		
			sid_admin_f4397=43b961cdb4fd8fa18ac2366bcf875b0a-0-A; expires=Tue, 25-Jul-2017 10:31:35 GMT; Max-Age=1209600; path=/; domain=.www.digitalsave.co.uk; HttpOnly
	
			Transfer-Encoding
		
			chunked
	
			Vary
		
			Accept-Encoding,User-Agent
	
			X-Accel-Buffering
		
			no
	
			X-Powered-By
		
			PHP/7.0.20

view source

			Accept
		
			text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
	
			Accept-Encoding
		
			gzip, deflate, br
	
			Accept-Language
		
			en-US,en;q=0.5
	
			Connection
		
			keep-alive
	
			Content-Length
		
			407
	
			Content-Type
		
			application/x-www-form-urlencoded
	
			Cookie
		
			_ga=GA1.3.223394504.1497005511; cookieconsent_dismissed=yes; sid_customer_f4397=b60636f06fd5f40a52538e8274cb7b0f-1-C; sid_admin_f4397=43b961cdb4fd8fa18ac2366bcf875b0a-0-A; _gid=GA1.3.1491510172.1499700102
	
			Host
		
			www.digitalsave.co.uk
	
			Referer
		
			https://www.digitalsave.co.uk/haha.php?dispatch=exim.export§ion=subscribers
	
			Upgrade-Insecure-Requests
		
			1
	
			User-Agent
		
			Mozilla/5.0 (Windows NT 10.0; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0

seandigitalsave · July 11, 2017, 12:00am

And response...

Service unavailable

.bigEntrance{
animation-name: bigEntrance;
-webkit-animation-name: bigEntrance;
animation-duration: 1.6s;
-webkit-animation-duration: 1.6s;
animation-timing-function: ease-out;
-webkit-animation-timing-function: ease-out;
visibility: visible !important;
}

@keyframes bigEntrance {
0% {
transform: scale(0.3) rotate(6deg) translateX(-30%) translateY(30%);
opacity: 0.2;
}
30% {
transform: scale(1.03) rotate(-2deg) translateX(2%) translateY(-2%);
opacity: 1;
}
45% {
transform: scale(0.98) rotate(1deg) translateX(0%) translateY(0%);
opacity: 1;
}
60% {
transform: scale(1.01) rotate(-1deg) translateX(0%) translateY(0%);
opacity: 1;
}
75% {
transform: scale(0.99) rotate(1deg) translateX(0%) translateY(0%);
opacity: 1;
}
90% {
transform: scale(1.01) rotate(0deg) translateX(0%) translateY(0%);
opacity: 1;
}
100% {
transform: scale(1) rotate(0deg) translateX(0%) translateY(0%);
opacity: 1;
}
}

@-webkit-keyframes bigEntrance {
0% {
-webkit-transform: scale(0.3) rotate(6deg) translateX(-30%) translateY(30%);
opacity: 0.2;
}
30% {
-webkit-transform: scale(1.03) rotate(-2deg) translateX(2%) translateY(-2%);
opacity: 1;
}
45% {
-webkit-transform: scale(0.98) rotate(1deg) translateX(0%) translateY(0%);
opacity: 1;
}
60% {
-webkit-transform: scale(1.01) rotate(-1deg) translateX(0%) translateY(0%);
opacity: 1;
}
75% {
-webkit-transform: scale(0.99) rotate(1deg) translateX(0%) translateY(0%);
opacity: 1;
}
90% {
-webkit-transform: scale(1.01) rotate(0deg) translateX(0%) translateY(0%);
opacity: 1;
}
100% {
-webkit-transform: scale(1) rotate(0deg) translateX(0%) translateY(0%);
opacity: 1;
}
}

body {
margin-top: 100px;
font-family: Tahoma;
}

.banner {
background-color: #fe5652;
border-radius: 24px;
color: #ffffff;
font-weight: normal;
font-size: 68px;
padding: 10px;
text-align: center;
margin-left: auto;
margin-right: auto;

display: inline-block;
zoom: 1;
display*: inline; /* ie hack */

}

.banner-inner {
border-radius: 20px;
border: 4px solid #ffffff;
padding: 30px;
text-transform: uppercase;
letter-spacing: 2px;
}

.container {
text-align:center;
}

.message {
margin-top: 20px;
font-size: 20px;
text-align: center;
}

Service
unavailable

Sorry, service is temporarily unavailable.

{"notifications":[]}

ecomlabs · July 11, 2017, 12:00am

Here is the reason

Unknown column 'user_mailing_lists.lang_code' in 'field list' (1054)SELECT subscribers.subscriber_id, subscribers.email as "E-mail", user_mailing_lists.list_id as "Mailing list", user_mailing_lists.lang_code as "Language" FROM cscart_subscribers as subscribers LEFT JOIN cscart_user_mailing_lists as user_mailing_lists ON user_mailing_lists.subscriber_id = subscribers.subscriber_id LIMIT 0, 30

Try to add the lang_code column to the cscart_user_mailing_lists table manually

seandigitalsave · July 11, 2017, 12:00am

^{I have added columns before (not to this table/db, just in general) but this time I don't seem to have the options to add?}

[url=https://postimg.org/image/uogb69r3z/][/url]

Any ideas - had a good Google as well but can't find anything as to why the add column is missing but cant find much?

ecomlabs · July 11, 2017, 12:00am

Looks like this users does not have permissions to alter tables. Usually permissions can be added in the control panel of your server

seandigitalsave · July 11, 2017, 12:00am

All privileges are granted. Any other ideas?

[url=https://postimg.org/image/er7snngl7/][/url]

seandigitalsave · July 11, 2017, 12:00am

Sorted :)

tbirnseth · July 11, 2017, 12:00am

How?

ecomlabs · July 12, 2017, 12:00am

Sorted :)

What was the reason?

seandigitalsave · July 12, 2017, 12:00am

It was the missing column in the table. Just had to click the structure tab in phpmyadmin - i missed that 8)