Bom dia,
Galera, estou migrando meu projeto, alterando apenas o banco, estou passando de mysql para postgresql, consegui ajeitar alguns erros do meu menu no meu template, debuguei e vi que os erros estavam em tabelas com letra maiusculas e tal, porém, ajeitando um erro, apareceu outro;
Database query failed (error # %s): %s SQL=SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM jgovce_jevents_repetition as rpt LEFT JOIN jgovce_jevents_vevent as ev ON rpt.eventid = ev.ev_id LEFT JOIN jgovce_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid LEFT JOIN jgovce_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN jgovce_jevents_rrule as rr ON rr.eventid = rpt.eventid WHERE ev.catid IN(-1) AND rpt.endrepeat >= '2013-12-01 00:00:00' AND rpt.startrepeat <= '2013-12-31 23:59:59' AND ev.state=1 AND ev.access IN (1,1,5) AND icsf.state=1 AND icsf.access IN (1,1,5)
ERROR: function month(timestamp without time zone) does not exist
LINE 2: rpt.startrepeat as yup, MONTH(rpt.startrepeat ) as mup, DAYO...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
********** Error **********
ERROR: function month(timestamp without time zone) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Character: 133
Ele não reconhece as funções YEAR, MONTH e tal..
Pesquisando na internet, descobri que o correto é extratct(YEAR from rpt.startrepeat) ao invés de YEAR(rpt.startrepeat). e assim com os outros também...
Testei isso e realmente deu certo, agora como eu altero essa sintaxe no joomla?!
