Za to kolejny problem, jak wchodze w Klienci>Lista to dostaje:
Wystąpiły błędy w obsłudze bazy danych!
ZAPYTANIE: SELECT c.id [1] [8] AS id, CONCAT(UPPER(lastname),
, c.name [2]
[9]) AS customername, status, address, zip, city, countryid,
countries.name [3] [10] AS country, email, ten, ssn, c.info [4]
[11] AS info,
message, c.divisionid, c.paytime AS paytime, COALESCE(b.value, 0)
AS
balance, COALESCE(t.value, 0) AS tariffvalue, s.account,
s.warncount,
s.online, (CASE WHEN s.account = s.acsum THEN 1 WHEN s.acsum > 0
THEN
2 ELSE 0 END) AS nodeac, (CASE WHEN s.warncount = s.warnsum THEN
1
WHEN s.warnsum > 0 THEN 2 ELSE 0 END) AS nodewarn FROM
customersview c
LEFT JOIN countries ON (c.countryid = countries.id [5] [12]) LEFT
JOIN
(SELECT SUM(value) AS value, customerid FROM cash GROUP BY
customerid
) b ON (b.customerid = c.id [6] [13]) LEFT JOIN (SELECT
a.customerid,
SUM((CASE a.suspended WHEN 0 THEN (((100 - pdiscount) * (CASE
WHEN
t.value IS NULL THEN l.value ELSE t.value END) / 100) -
vdiscount)
ELSE ((((100 - pdiscount) * (CASE WHEN t.value IS NULL THEN
l.value
ELSE t.value END) / 100) - vdiscount) * 0 / 100) END) * (CASE
t.period
WHEN 3 THEN 1 WHEN 5 THEN 1/12.0 WHEN 7 THEN 1/6.0 WHEN 4 THEN
1/3.0
ELSE (CASE a.period WHEN 3 THEN 1 WHEN 5 THEN 1/12.0 WHEN 7 THEN
1/6.0
WHEN 4 THEN 1/3.0 ELSE 0 END) END) ) AS value FROM assignments a
LEFT
JOIN tariffs t ON (t.id [7] [14] = a.tariffid) LEFT JOIN
liabilities l ON
(l.id [8] [15] = a.liabilityid AND a.period != 0) WHERE
(a.datefrom
UNIX_TIMESTAMP() OR a.dateto = 0) GROUP BY a.customerid ) t ON
(t.customerid = c.id [9] [16]) LEFT JOIN (SELECT ownerid,
SUM(access) AS
acsum, COUNT(access) AS account, SUM(warning) AS warnsum,
COUNT(warning) AS warncount, (CASE WHEN MAX(lastonline) >
UNIX_TIMESTAMP() - 600 THEN 1 ELSE 0 END) AS online FROM nodes
WHERE
ownerid > 0 GROUP BY ownerid ) s ON (s.ownerid = c.id [10] [17])
WHERE
c.deleted = 0 ORDER BY customername asc
BŁĄD: Unknown column pdiscount in field list