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
