W dniu 4 grudnia 2011 13:48 użytkownik Tomasz Chiliński < tomasz.chilinski@chilan.com> napisał:
On 04.12.2011 14:18, Sławomir Paszkiewicz wrote:
W dniu 4 grudnia 2011 12:27 użytkownik Tomasz Chiliński napisał:
On 04.12.2011 12:56, Sławomir Paszkiewicz wrote:
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
Jakąś wersję DB pokazuje Ci na dole paska menu? Powinno być 2011113000. Jeśli tak nie pokazuje to zobacz czy nie brakuje plików lib/upgradedb/{postgres,mysql}**.2011113000.php w katalogu z instalacją LMS.
Plik istnieje, a LMS pokazuje:
LMS 1.11-cvs (1.1086/1.32) DB: 2011113000
Używasz MySQL?
Tak.
Wersja LMS: 1.11-cvs (1.1086/1.32) Wersja LMSDB: 1.11-cvs (1.59/1.62) Wersja MySQL: 5.5.17-log Wersja PHP: 5.3.8 Wersja Smarty: 3.1.5
PS. Jak wlaczyc livemap/openstreetmap? Bo netdevmap nic sie nie zmienilo w stosunku do wersji stabilnel.