DATABASE ERROR : The customer details could not be retrieved
error code : 1054
error message : Unknown column 'trans.type' in 'field list'
sql that failed was : SELECT 0_debtors_master.name,
0_debtors_master.curr_code, 0_payment_terms.terms,
0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,
0_credit_status.reason_description,
Sum(IFNULL(IFNULL(IF(trans.type=11 OR trans.type=12 OR
trans.type=2, -1, 1) * (trans.ov_amount + trans.ov_gst +
trans.ov_freight + trans.ov_freight_tax +
trans.ov_discount),0),0)) AS Balance, Sum(IF
((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,
trans.due_date, trans.tran_date))) >= 0,IFNULL(IF(trans.type=11 OR
trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +
trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +
trans.ov_discount),0),0)) AS Due, Sum(IF ((TO_DAYS('2011-09-18') -
TO_DAYS(IF (trans.type=10, trans.due_date, trans.tran_date))) >=
30,IFNULL(IF(trans.type=11 OR trans.type=12 OR trans.type=2, -1,
1) * (trans.ov_amount + trans.ov_gst + trans.ov_freight +
trans.ov_freight_tax + trans.ov_discount),0),0)) AS Overdue1,
Sum(IF ((TO_DAYS('2011-09-18') - TO_DAYS(IF (trans.type=10,
trans.due_date, trans.tran_date))) >= 60,IFNULL(IF(trans.type=11
OR trans.type=12 OR trans.type=2, -1, 1) * (trans.ov_amount +
trans.ov_gst + trans.ov_freight + trans.ov_freight_tax +
trans.ov_discount),0),0)) AS Overdue2 FROM 0_debtors_master LEFT
JOIN 0_debtor_trans trans ON trans.tran_date <= '2011-09-18' AND
0_debtors_master.debtor_no = trans.debtor_no AND trans.type <> 13
, 0_payment_terms, 0_credit_status WHERE
0_debtors_master.payment_terms = 0_payment_terms.terms_indicator
AND 0_debtors_master.credit_status = 0_credit_status.id AND
0_debtors_master.debtor_no = '' GROUP BY 0_debtors_master.name,
0_payment_terms.terms, 0_payment_terms.days_before_due,
0_payment_terms.day_in_following_month,
0_debtors_master.credit_limit, 0_credit_status.dissallow_invoices,
0_credit_status.reason_description
Seems that system upgrade to version 2.1 has been performed for
this company already.
If something has gone wrong and you want to retry upgrade process
you MUST perform database restore from last backup file
first.Database upgrade to version 2.1 failed for company
'Windrolinx'.
You should restore company database from latest backup fileSQL
script execution failed in line 54: Table 'acc2.0_company' doesn't
existDatabase upgrade to version 2.3 failed for company
'Windrolinx'.
You should restore company database from latest backup file
SQL script execution failed in line 54: Table 'acc2.0_company'
doesn't existDatabase upgrade to version 2.3 failed for company
'Windrolinx'.
You should restore company database from latest backup file
System is blocked after source upgrade until database is updated
on System/Software Upgrade page
Were the logs cleaned first to remove non-browser access (i.e. crawlers, etc)?
I’ve observed this on my own applications. Where I have thumbnails set to expire a month in the future, quite often the browser will re-fetch the images if I don’t visit the page for a couple of days. The large number of tiny images and scripts my browser has seen in the meantime have pushed my cacheable images out of its cache.
The cache is a danger for privacity (try Picasa!) and spend many sectors in HD (1 byte file = 32 kb in many modern HD)
Then many people (with ADSL conections) goes to:
IE: Tools/Internet Options/Advanced Options and X the last one: Empty temp folder…
Firefox: Tools/Options/Privacity/Clean always…
t
However, I this Martin Kenny could have an interesting point in his comment.
I’m going to use this information in a recommended im making. Thanks
This is the second in a series of articles describing experiments conducted to learn more about optimizing web page performance. You may be wondering why you?re reading a performance article on the YUI Blog. It turns out that most of web page performan…
That might require some sort of quick survey to determine either cache settings or how people use their cache (as one other person mentioned, for security some people have it set to clean always)
That makes sense, but what about caching in the browser? What are the downsides to browser caching?
The percentage of users with an empty cache is:
# of unique users with at least TWO 200 response / total # of unique users
Whatever metrics you guys have put up is invalid. It doesn’t depict anything about users who clears the cache everytime or browsers with settings that ignores cached files. Moreover the percentage of users with empty cache who are first time visitors to a website is 100%. The data that you guys have put up now is based on the total number of visitors to the website on that day of experiment. The user who has visited the website the first day is not required to visit the website on the second day. The graph depicts on how many new visitors are visiting the tracking pages every day. Not the users who ignore cached files.
I suspect that with a portal site such as Yahoo that forced page refreshes are a non-trivial number of requests.
@Dave: I think you make an interesting point. We do run this experiment on different Yahoo! pages to determine correlations with usage patterns. Next time we’ll run it over a longer period of time and share our findings here.
@prathap: The purpose of the experiment was to find the percentages of users and page views visiting Yahoo! pages with an empty cache each day. Whatever reason why the image was not in the browser’s cache, the fact is the browser had to download the entire image again and that was what we were measuring. When the percentages dropped to a steady state, the returning users (with a full cache) reached a constant.
If you could guarantee that most/all of your users had a full cache all the time, it would STILL be better and faster to concatenate static files wherever possible. Images should be sprite-ified, and CSS and JS should be minified.
In fact, according to my rough measurements, having a single
scripttag instead of several can significantly reduce the time required to parse and execute the code, even if we’re talking about inline scripts, where cache has no effect.In short, caching is great and all, but don’t count on it to solve any problems. Build for the empty-cache situation, and you’ll usually benefit all of your users.
Heute mal zum Thema, wie bekomme ich müde bzw. langsame Webseiten munter.Zuerst der schöne Artikel »Website Performance Tweaks« (s. 3. und 4.):learningtheworld.eu/2007/performance/CSS-Sprites: was ist das, was bringt das, wie geht das:yuiblog.com/bl…
[Steve Souders is Yahoo!’s Chief Performance Yahoo!. This is one in a series of blogs describing the best practices he’s developed at Yahoo! for improving performance. This article is based on Chapter 3, Rule 1: Make Fewer HTTP Requests from……
http://httpd.apache.org/docs/2.0/mod/mod_deflate.html
Steve Souders of Yahoo’s “Exceptional Performance Team” gave an insanely great presentation at Web 2.0 about optimizing website performance by focusing on front end issues. Unfortunately I didn’t get to see it in person but the Web 2.0 talks……