eroare dupa instalarea "last visit mod "

[mad_mihai]

Couldn't retrieve user today data

DEBUG MODE

SQL Error : 1054 Unknown column 'user_lastlogon' in 'field list'

SELECT user_id,username,user_allow_viewonline,user_level,user_lastlogon FROM phpbb_users WHERE user_id!="-1" AND user_session_time >= 1166220000 AND user_session_time< 1166306399 ORDER BY username

Line : 281
File : index.php




<b>Ma poate ajuta cineva?</b>

[seelview]

Fa editarile la baza de date. In pachetul de instalare iti da si instructiuni de SQL pe care le faci in phpmyadmin.

[Etherfast]

Mai mult ca sigur nu ai urmat instructiunile SQL ale mod-ului respectiv.
Vezi daca gasesti un fisier .php in arhiva care introduce tabelele in baza de date, sau vezi daca ai in fisierul de instalare niste instructiuni --- [SQL] --- care nu au fost inca executate.

[mad_mihai]

am avut un fisier .php si l-am rulat inainte de a modifica celelate fisiere

[mad_mihai]

'ALTER TABLE '.USERS_TABLE.' ADD user_lastlogon INT (11) DEFAULT "0" not null',
'UPDATE '.USERS_TABLE.' SET user_lastlogon=user_lastvisit WHERE user_lastlogon="0"',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("hidde_last_logon", "0")',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totaltime INT (11) DEFAULT "0"',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totallogon INT (11) DEFAULT "0"',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totalpages INT (11) DEFAULT "0"',
'UPDATE '. USERS_TABLE .' SET user_totaltime=(user_session_time-user_lastlogon) WHERE user_totaltime="0" AND user_lastlogon>0',
'UPDATE '. USERS_TABLE .' SET user_totallogon=1 WHERE user_totallogon="0" AND user_session_time<>"0"'



trebuiau facute comenzile astea

nu am reusit sa fac decat cele care adauga in tabela (alter) restul nu am reusit

[mad_mihai]

am sters toate modificarile si o iau de la inceput