8 Sty
2018
8 Sty
'18
09:20
mam to samo.
2018-01-08 8:19 GMT+01:00 Marcin <marcin@nicram.net>:
> Błąd: Unknown column ' [ http://c.id/ | c.id ] ' in 'on clause'
>
> To Cię nie nakierowało?
> Co Ci drukuje "DESCRIBE customerview"?
>
> 2018-01-07 16:56 GMT+01:00 Marcin Świerkowski <marcin@itcom.pl>:
>
>> wrzuciłem czystego nowego lms z GIT'a i to samo
>> więc albo mam jakiegoś starego mysql ( na postgres wszystko działa )
>> albo jest jakiś mismasz w zapytaniu ( niekompatybilny z mysql )
>>
>> Wersja LMS: 1.11-git
>> Wersja LMSDB: 2018010500
>> Wersja MySQL: 5.5.54-0ubuntu0.12.04.1
>> Wersja PHP: 5.3.10-1ubuntu3.26
>> Wersja Smarty: 3.1.31
>>
>>
>> ----- Oryginalna wiadomość -----
>> Od: "Marcin" <marcin@nicram.net>
>> Do: "lista użytkowników LMS" <lms@lists.lms.org.pl>
>> Wysłane: środa, 3 stycznia, 2018 11:07:24
>> Temat: Re: [lms] błędy po UPGRADE do aktualnej wersji z GIT
>>
>> podejrzewam, że w strukturze nie masz widoku customerview
>>
>> 2018-01-03 10:01 GMT+01:00 Marcin Świerkowski < [ mailto:marcin@itcom.pl
>> | marcin@itcom.pl ] > :
>>
>>
>> .......?m=customersearch&search=1
>> wyszukiwanie klientów
>>
>> Wystąpiły błędy w obsłudze bazy danych!
>> Zapytanie: SELECT [ http://c.id/ | c.id ] AS id, CONCAT(UPPER(lastname),
>> ' ', [ http://c.name/ | c.name ] ) AS customername, status,
>> full_address, address, zip, city, countryid, [ http://countries.name/ |
>> countries.name ] AS country, cc.email, ccp.phone, ten, ssn, [
>> http://c.info/ | c.info ] AS info, extid, 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 customerview c LEFT JOIN (SELECT customerid,
>> (GROUP_CONCAT(contact SEPARATOR ',')) AS email FROM customercontacts WHERE
>> (type & 8 > 0) GROUP BY customerid) cc ON cc.customerid = [ http://c.id/
>> | c.id ] LEFT JOIN (SELECT customerid, (GROUP_CONCAT(contact SEPARATOR
>> ',')) AS phone FROM customercontacts WHERE (type & 5 > 0) GROUP BY
>> customerid) ccp ON ccp.customerid = [ http://c.id/ | c.id ] LEFT JOIN
>> countries ON (c.countryid = [ http://countries.id/ | countries.id ] )
>> LEFT JOIN (SELECT SUM(value) AS value, customerid FROM cash GROUP BY
>> customerid ) b ON (b.customerid = [ http://c.id/ | c.id ] ) LEFT JOIN
>> (SELECT a.customerid, SUM((CASE a.suspended WHEN 0 THEN (((100 -
>> a.pdiscount) * (CASE WHEN t.value IS null THEN l.value ELSE t.value END) /
>> 100) - a.vdiscount) ELSE ((((100 - a.pdiscount) * (CASE WHEN t.value IS
>> null THEN l.value ELSE t.value END) / 100) - a.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 ( [ http://t.id/ | t.id ] = a.tariffid) LEFT JOIN
>> liabilities l ON ( [ http://l.id/ | l.id ] = a.liabilityid AND a.period
>> != 0) WHERE a.commited = 1 AND a.datefrom <= UNIX_TIMESTAMP() AND (a.dateto
>> > UNIX_TIMESTAMP() OR a.dateto = 0) GROUP BY a.customerid ) t ON
>> (t.customerid = [ http://c.id/ | 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 AND ipaddr
>> <> 0 GROUP BY ownerid ) s ON (s.ownerid = [ http://c.id/ | c.id ] )
>> WHERE c.deleted = 0 AND (CONCAT(UPPER(c.lastname), ' ', UPPER( [
>> http://c.name/ | c.name ] )) LIKE UPPER('%a%') OR (UPPER(address) LIKE
>> UPPER('%a%') OR UPPER(post_address) LIKE UPPER('%a%') OR EXISTS (SELECT 1
>> FROM customer_addresses ca JOIN vaddresses va ON [ http://va.id/ | va.id
>> ] = ca.address_id AND ca.customer_id = [ http://c.id/ | c.id ] WHERE
>> UPPER(va.address) LIKE UPPER('%a%'))) OR (UPPER(zip) LIKE UPPER('%a%') OR
>> UPPER(post_zip) LIKE UPPER('%a%') OR EXISTS (SELECT 1 FROM
>> customer_addresses ca JOIN vaddresses va ON [ http://va.id/ | va.id ] =
>> ca.address_id AND ca.customer_id = [ http://c.id/ | c.id ] WHERE
>> UPPER(va.zip) LIKE UPPER('%a%'))) OR (UPPER(city) LIKE UPPER('%a%') OR
>> UPPER(post_city) LIKE UPPER('%a%') OR EXISTS (SELECT 1 FROM
>> customer_addresses ca JOIN vaddresses va ON [ http://va.id/ | va.id ] =
>> ca.address_id AND ca.customer_id = [ http://c.id/ | c.id ] WHERE
>> UPPER(va.city) LIKE UPPER('%a%'))) OR EXISTS (SELECT 1 FROM
>> customercontacts WHERE customerid = [ http://c.id/ | c.id ] AND
>> customercontacts.type & 8 = 8 AND contact LIKE '%a%')) ORDER BY
>> customername asc
>> Błąd: Unknown column ' [ http://c.id/ | c.id ] ' in 'on clause'
>>
>>
>> _______________________________________________
>> lms mailing list
>> [ mailto:lms@lists.lms.org.pl | lms@lists.lms.org.pl ]
>> [ http://lists.lms.org.pl/mailman/listinfo/lms |
>> http://lists.lms.org.pl/mailman/listinfo/lms ]
>>
>>
>>
>> --
>> Pozdrawiam
>> Marcin / nicraM
>>
>> _______________________________________________
>> lms mailing list
>> lms@lists.lms.org.pl
>> http://lists.lms.org.pl/mailman/listinfo/lms
>> _______________________________________________
>> lms mailing list
>> lms@lists.lms.org.pl
>> http://lists.lms.org.pl/mailman/listinfo/lms
>>
>
>
>
> --
> Pozdrawiam
> Marcin / nicraM
>
> _______________________________________________
> lms mailing list
> lms@lists.lms.org.pl
> http://lists.lms.org.pl/mailman/listinfo/lms
>
>