permisos si tiene, lo que no se es como cambiar ese parametro de mysql, desde phpadmin veo ese parametro de binlog_format pero no se como cambiarlo y hablan de ese archivo my.cfg pero no se donde encontrarlo en mi hosting... ipage es el hosting...
a pesar de que el blog es viejo quiero dejar lo siguiente por si alguien busca la misma información.
en la instalación tuve el mismo problema que Ivan también en ipage.com como hosting, sin embargo ellos me confirmaron que no soportan la versión 2.5 de moodle.
tendré que instalar la 1.9 por restricciones de sus servidores.
espero les sirva a alguien la info. tal vez antes de contratar sus servicios de hosting.
saludos cordiales!.
incluyo el chat con el soporte de ipage...
info: Thank you for contacting us.
At the end of our conversation, please keep this window open and complete our one question survey to let us know how we're doing.
Please hold for the next available operator to respond.
info: All operators are currently assisting others. Thanks for your patience. An operator will be with you shortly.
info: All operators are currently assisting others. Thanks for your patience. An operator will be with you shortly.
info: All operators are currently assisting others. Thanks for your patience. An operator will be with you shortly.
info: All operators are currently assisting others. Thanks for your patience. An operator will be with you shortly.
info: You are now chatting with 'Poornima S'
Poornima S: Hi Darwin, how re you?
Poornima S: I am sorry for the wait time.
Darwin: dont worry
Darwin: i need a configuration for the mysql
Poornima S: Sure!
Darwin: is it posible to set... BINLOG_FORMAT to mixed?
Poornima S: I will check it.
Poornima S: Are you asking it in MySQL database configuration?
Darwin: at the my.cnf file under mysqld section
Darwin: binlog_format = 'MIXED'
Poornima S: Please hold on for 4 to 5 minutes while I check this for you.
Darwin: i'm installing moodle versión 2.5 but when the process
Darwin: try con insert to the database says
Darwin: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
Poornima S: Thank you for your patience. I am still working on the issue. Please hold on for 5-6 minutes more.
Darwin: ok
Poornima S: Thank you for holding.
Poornima S: We do not support BINLOG_FORMAT .
Poornima S: Also, the Moodle versión 2.5 does not work on our server. Please install Moodle 1.9.10 version.
Darwin: is that the latest versión that you support?
Poornima S: Yes.
Darwin: ok . gracias!
Poornima S: Thank you!
Poornima S: If you are happy with my support, please grade me 9 or 10 by clicking on the "Rate & Exit” button on the top right corner of this chat window. In case my support did not meet your expectation, please let me know the reason.
Poornima S: Is there anything else I can assist you with today?
Darwin: no.