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.
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
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
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
Heres a pic [url=https://postimg.org/image/j1os866nl/][/url]
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.
What about the Response section?
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
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
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":[]}
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
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?
Looks like this users does not have permissions to alter tables. Usually permissions can be added in the control panel of your server
All privileges are granted. Any other ideas?
[url=https://postimg.org/image/er7snngl7/][/url]
Sorted :)
How?
Sorted :)
What was the reason?
It was the missing column in the table. Just had to click the structure tab in phpmyadmin - i missed that 8)