On Tue, 14 Aug 2007 14:58:25 +0200, A.L.E.C wrote

Dariusz Kowalczyk wrote:

...

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, email, ten, ssn, c.info AS info, message, (SELECT COALESCE(SUM(value),0) FROM cash WHERE customerid = c.id ) AS balance FROM customersview c WHERE deleted = 0 GROUP BY c.id, lastname, c.name, status, address, zip, city, email, ten, ssn, c.info, message ORDER BY customername asc Błąd: Table 'lms.customersview' doesn't exist

upgrade ci się nie udał, wykonaj polecenia z lib/upgradedb/mysql.2007071600.php.

-- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl

---

lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms

najnowszy mysql.2007080100.php ma w sobie tylko tyle ----------------- $DB->BeginTrans();

$DB->Execute("UPDATE dbinfo SET keyvalue = ? WHERE keytype = ?", array('2007080100', 'dbversion'));

$DB->CommitTrans(); ----------------------- wiec wyglada na to że to dlatego się nie udał

jak rozumiem mam wrócić do starszej wersji (przedostatniej)

Dariusz Kowalczyk

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms