---- Wiadomość Oryginalna ---- Od: "A.L.E.C" alec@alec.pl Do: lista użytkowników LMS lms@lists.lms.org.pl Data: 29 marca 2007 11:59 Temat: Re: [lms] hasło i login urządzeń sieciowy ch

Tak, przypisz im IP. Nie pamiętam tylko, czy w 1.8 można do IP urządzenia przypisać hasło, w 1.9 można.

Idąc za ciosem zrobiłem upgrade 1.8.7 do 1.9.6 (1.8.7 i 1.8.9 nie mają pola hasło)

Wersja LMS: 1.9.6 Belos (1.827/1.19) Wersja LMSDB: 1.9.6 Belos (core: 1.40 / driver: postgres 1.34) Wersja PostgreSQL: 7.4.7 Wersja PHP: 4.3.9 Wersja Smarty: 2.6.16

Niestety pojawiły się błedy i lms praktycznie nie działa. Poniżej wykaz błedów:

Warning: pg_query(): Query failed: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT. in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/lms/lib/LMSDB_driver_postgres.class.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /var/www/lms/lib/LMSDB_driver_postgres.class.php:86) in /var/www/lms/lib/Session.class.php on line 139

Warning: Cannot modify header information - headers already sent by (output started at /var/www/lms/lib/LMSDB_driver_postgres.class.php:86) in /var/www/lms/index.php on line 206

Wystąpiły błędy w obsłudze bazy danych! Zapytanie: ALTER TABLE nodes ADD halfduplex smallint DEFAULT 0 Błąd: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT. Zapytanie: ALTER TABLE tariffs ADD dlimit integer DEFAULT 0 Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block Zapytanie: UPDATE nodes SET halfduplex = 0 Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block Zapytanie: UPDATE tariffs SET dlimit = 0 Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block Zapytanie: ALTER TABLE nodes ALTER halfduplex SET NOT NULL Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block Zapytanie: ALTER TABLE tariffs ALTER dlimit SET NOT NULL Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block Zapytanie: UPDATE dbinfo SET keyvalue = '2007012500' WHERE keytype = 'dbversion' Błąd: ERROR: current transaction is aborted, commands ignored until end of transaction block

Jak poprawnie przeprowadzić upgrade?

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