Z wiadomych przyczyn potrzebowalem stawke zwolniona. wykonalem upgade: Wersja LMS: 1.3-cvs (1.435/1.48) Wersja LMSDB: 1.3-cvs (core: 1.26 / driver: mysql 1.22) Wersja MySQL: 4.0.17-log Wersja PHP: 4.3.3 Wersja Smarty: 2.6.1 Wykonuje upgdade bazy danych, no i sie zaczyna. mysql> source /var/www/lms/doc/UPGRADE-1.2-1.3.mysql; ERROR 1050: Table 'dbinfo' already exists ERROR 1062: Duplicate entry 'dbversion' for key 1
Nastepnie przy dodawaniu taryfy ze zwolnionym vat, owszem dodaje tyle ze ponizej mam: Wystąpiły błędy w obsłudze bazy danych! Podczas wykonywania zapytania: SELECT COUNT(userid) AS count, tariffid, SUM(value)*4 AS value FROM assignments, tariffs, users WHERE userid = users.id AND tariffid = tariffs.id AND deleted = 0 AND period = 0 AND (datefrom <= UNIX_TIMESTAMP() OR datefrom = 0) AND (dateto > UNIX_TIMESTAMP() OR dateto = 0) GROUP BY tariffid Wystąpił błąd: Unknown column 'datefrom' in 'where clause' Podczas wykonywania zapytania: SELECT COUNT(userid) AS count, tariffid, SUM(value) AS value FROM assignments, tariffs, users WHERE userid = users.id AND tariffid = tariffs.id AND deleted = 0 AND period = 1 AND (datefrom <= UNIX_TIMESTAMP() OR datefrom = 0) AND (dateto > UNIX_TIMESTAMP() OR dateto = 0) GROUP BY tariffid Wystąpił błąd: Unknown column 'datefrom' in 'where clause' Podczas wykonywania zapytania: SELECT COUNT(userid) AS count, tariffid, SUM(value)/3 AS value FROM assignments, tariffs, users WHERE userid = users.id AND tariffid = tariffs.id AND deleted = 0 AND period = 2 AND (datefrom <= UNIX_TIMESTAMP() OR datefrom = 0) AND (dateto > UNIX_TIMESTAMP() OR dateto = 0) GROUP BY tariffid Wystąpił błąd: Unknown column 'datefrom' in 'where clause' Podczas wykonywania zapytania: SELECT COUNT(userid) AS count, tariffid, SUM(value)/12 AS value FROM assignments, tariffs, users WHERE userid = users.id AND tariffid = tariffs.id AND deleted = 0 AND period = 3 AND (datefrom <= UNIX_TIMESTAMP() OR datefrom = 0) AND (dateto > UNIX_TIMESTAMP() OR dateto = 0) GROUP BY tariffid Wystąpił błąd: Unknown column 'datefrom' in 'where clause'
Takie pytanko... co spartolilem i jak to naprawic. Pozdrawiam Rafal Plesniak