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 [8] AS id, CONCAT(UPPER(lastname), , c.name
[9]) AS customername, status, address, zip, city, countryid,
countries.name [10] AS country, email, ten, ssn, c.info [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 [12]) LEFT JOIN
(SELECT SUM(value) AS value, customerid FROM cash GROUP BY customerid
) b ON (b.customerid = c.id [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 [14] = a.tariffid) LEFT JOIN liabilities l ON
(l.id [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 [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 [17]) WHERE
c.deleted = 0 ORDER BY customername asc
BŁĄD: Unknown column pdiscount in field list