* *Witam Po upgradzie servera i zalogowaniu do userpanela takie kwiatki , inne bledy usunalem - ale z tym niestety nie umiem sobie poradzic Lms dziala ok - tylko to, mial ktos z was moze podobny problem ? Strict Standards: Declaration of ULMS::GetCustomer() should be compatible with LMS::GetCustomer($id, $short = false) in */xxx/xxx/xxx/htdocs/lib/ULMS.class.php* on line *94 * -- Pozdrawiam Mariusz
W dniu 2014-01-17 15:12, Mariusz G. Bednarek pisze:
* *Witam Po upgradzie servera i zalogowaniu do userpanela takie kwiatki , inne bledy usunalem - ale z tym niestety nie umiem sobie poradzic Lms dziala ok - tylko to, mial ktos z was moze podobny problem ?
Strict Standards: Declaration of ULMS::GetCustomer() should be compatible with LMS::GetCustomer($id, $short = false) in */xxx/xxx/xxx/htdocs/lib/ULMS.class.php* on line *94 *
A userpanel tez upgrajdnołeś? -- Waldemar Dymkiewicz, administrator urządzeń sieciowych "Easy Com" Świątek Piotr, ul. Jodłowa 7, Góra tel. 65 544 18 82 wew. 4
W dniu 17.01.2014 15:27, Waldemar Dymkiewicz pisze:
W dniu 2014-01-17 15:12, Mariusz G. Bednarek pisze:
* *Witam Po upgradzie servera i zalogowaniu do userpanela takie kwiatki , inne bledy usunalem - ale z tym niestety nie umiem sobie poradzic Lms dziala ok - tylko to, mial ktos z was moze podobny problem ?
Strict Standards: Declaration of ULMS::GetCustomer() should be compatible with LMS::GetCustomer($id, $short = false) in */xxx/xxx/xxx/htdocs/lib/ULMS.class.php* on line *94 * A userpanel tez upgrajdnołeś?
a nie :) apache + php -- Pozdrawiam Mariusz Bednarek mariusz(at)propl.com W@BRING iNTERNET sOLUTIONS http://switch.pl http://propl.com tel. 44 737-89-65 44 789-09-35 fax. 44 789-09-42 cell 509-506-846
W dniu 17.01.2014 15:27, Waldemar Dymkiewicz pisze:
* A userpanel tez upgrajdnołeś?
niestety po upgradzie dalej to samo jedynie zahaszowanie error_reporting Default Value: E_ALL & ~E_NOTICE ^ E_STRICT Development Value: E_ALL | E_STRICT Production Value: E_ALL & ~E_DEPRECATED w php.ini - przynosi efekt - jednak z przyczyn politycznych , ta opcja musi byc wlaczona naprawde nikt nie wie jak to odpalic ? nigdy do tej pory nie mialem problemu po upgradzie apacha i php -- Pozdrawiam Mariusz
A userpanel tez upgrajdnołeś?
Dodatkowo po updacie posypaly sie bazy Wystąpiły błędy w obsłudze bazy danych! *Zapytanie:* SELECT c.id AS id, CONCAT(UPPER(lastname), ' ', c.name) AS customername, status, address, zip, city, countryid, countries.name AS country, email, ten, ssn, c.info 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) LEFT JOIN (SELECT SUM(value) AS value, customerid FROM cash GROUP BY customerid ) b ON (b.customerid = c.id) LEFT JOIN (SELECT a.customerid, SUM((CASE a.suspended WHEN 0 THEN (CASE discount WHEN 0 THEN (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) ELSE ((100 - discount) * (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END)) / 100 END) ELSE (CASE discount WHEN 0 THEN (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) * 0 / 100 ELSE (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) * discount * 0 / 10000 END) 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 = a.tariffid) LEFT JOIN liabilities l ON (l.id = a.liabilityid AND a.period != 0) WHERE (a.datefrom <= UNIX_TIMESTAMP() OR a.datefrom = 0) AND (a.dateto > UNIX_TIMESTAMP() OR a.dateto = 0) GROUP BY a.customerid ) t ON (t.customerid = c.id) 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) WHERE c.deleted = 0 ORDER BY customername asc *Błąd:* Unknown column 'discount' in 'field list' -- Pozdrawiam Mariusz
Dnia 20 stycznia 2014 9:14 "Mariusz G. Bednarek" <mariusz@propl.com> napisał(a):
A userpanel tez upgrajdnołeś?
Dodatkowo po updacie posypaly sie bazy Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT c.id AS id, CONCAT(UPPER(lastname), ' ', c.name) AS customername, status, address, zip, city, countryid, countries.name AS country, email, ten, ssn, c.info 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) LEFT JOIN (SELECT SUM(value) AS value, customerid FROM cash GROUP BY customerid ) b ON (b.customerid = c.id) LEFT JOIN (SELECT a.customerid, SUM((CASE a.suspended WHEN 0 THEN (CASE discount WHEN 0 THEN (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) ELSE ((100 - discount) * (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END)) / 100 END) ELSE (CASE discount WHEN 0 THEN (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) * 0 / 100 ELSE (CASE WHEN t.value IS NULL THEN l.value ELSE t.value END) * discount * 0 / 10000 END) 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 = a.tariffid) LEFT JOIN liabilities l ON (l.id = a.liabilityid AND a.period != 0) WHERE (a.datefrom <= UNIX_TIMESTAMP() OR a.datefrom = 0) AND (a.dateto > UNIX_TIMESTAMP() OR a.dateto = 0) GROUP BY a.customerid ) t ON (t.customerid = c.id) 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) WHERE c.deleted = 0 ORDER BY customername asc Błąd: Unknown column 'discount' in 'field list' -- Pozdrawiam Mariusz Witam, teraz w bazie zamiast discount masz vdiscount i pdiscount. Przypisz pole discount do dowolnego z nowych i pójdzie :) -- Pozdrawiam Jacek
uczestnicy (3)
-
Jacek -
Mariusz G. Bednarek -
Waldemar Dymkiewicz