WBCE CMS Forum

mux

Mitglied

Topics and otherthings doesn't work

Hi,
just trying out wbce. Some things not working well:

- topics module does not work. When clicking on "add" in backend no editor is appearing to add new text, just nothing.
As I have also with wb big problems since mysql software was upgraded to 5.6 (I think, the one with strict mode changes) I think this might be the reason for the problem...
- accordion module: input works, but toggling don't. Can open all items but they don't close automatically (only one item open in accordion mode)
changing preference from accordion to toggle and vv doesn't work, no saving changed option.
-download gallery: can't add files (saving does not work)
- extcal: when adding extcal as section to a page, it's not shown in backend nor all following sections

regards

Beitrag geändert von mux (01.12.2015 00:29:27)

florian

Administrator

Re: Topics and otherthings doesn't work

These are no general errors. I have several WBCE instances with topics working well. It might be indeed a mysql strict problem.
If the toggling of accordion in the frontend does not work, check if the register_frontend_modfiles-lines are included to the template.
The backend troubles sound like a strict mode problem too.

---

Code allein macht nicht glücklich. Jetzt spenden!

mux

Mitglied

Re: Topics and otherthings doesn't work

I'm still testing one module after another and nearly all don't work correctly...I think this is not good - a cms should work with latest database software...

mux

Mitglied

Re: Topics and otherthings doesn't work

more strange things happen: have a page with some different moduls as sections (one4all, procalendar, mpform, wysiwyg). After filling out some spam protection code in frontend (don't know which section produced this spam protection) my page disappeared completly! I was wondering why because in the backend it still exists. Then I noticed that the page was changed from a php.file to a directory! In this directory a new file sdf-0.php has been created...

Beitrag geändert von mux (01.12.2015 00:42:21)

florian

Administrator

Re: Topics and otherthings doesn't work

It's not the fault of the cms. The reason is the outdated code of most modules. Currently we can only recommend not to use WBCE on webspaces which are running in mysql strict mode.
Actually, you will encounter problems with most other cm systems too.

---

Code allein macht nicht glücklich. Jetzt spenden!

mux

Mitglied

Re: Topics and otherthings doesn't work

I think it would be important to give information about this problem. So if the basic systems runs in strict mode, then there should be hints for each non-working module which is linked on your webpage. I came from wb with same problems and hoped to find an alternative here

florian

Administrator

Re: Topics and otherthings doesn't work

About the disappearing page. This could be caused by Oneforall, at least an older version of the module hss this bug, although I thought it would be fixed in ghe current version.
The captcha is generated by mpform.
Generally spoken it is not a so good idea to check three of the most complex modules on the same page. I would not expect that this will work even under "normal" constitutions, e.g. no mysql strict mode. Specially procalendar is not meant to be combined with other modules which generate own child pages the same page. (Forget the last sentence)

Beitrag geändert von florian (02.12.2015 10:58:42)

---

Code allein macht nicht glücklich. Jetzt spenden!

florian

Administrator

Re: Topics and otherthings doesn't work

I think it would be important to give information about this problem. So if the basic systems runs in strict mode, then there should be hints for each non-working module which is linked on your webpage. I came from wb with same problems and hoped to find an alternative here

We know about this problem, but as it is a large effort to fix it, there will be no immediate solution.
https://github.com/WBCE/WebsiteBaker_Co … /issues/63

---

Code allein macht nicht glücklich. Jetzt spenden!

mux

Mitglied

Re: Topics and otherthings doesn't work

I think the strict mode can only be turned off for the whole server not for single databases, can't it? Thus, there would not be anything I could do against this mode and its problems...

florian

Administrator

Re: Topics and otherthings doesn't work

It depends on your webhoster. We had a similar case and there the customer asked his webhost support to switch it off, which was no problem at all. If it is your server, you have to change it in the my.conf, but yes, this seems to be a global configuration. (Just guessing,  I'm not familar with these things at all)

---

Code allein macht nicht glücklich. Jetzt spenden!

grindbatzn

Gast

Re: Topics and otherthings doesn't work

Usually the SQL-Strict Mode wasnt an active choice by the Hoster, it just "happend". (maybe Default Settings)
Ask your hoster to turn it off. You will not be the first one.

marmot

Mitglied

Re: Topics and otherthings doesn't work

Specially procalendar is not meant to be combined with other modules which generate own child pages the same page.

could you report about the experienced problems?

florian

Administrator

Re: Topics and otherthings doesn't work

could you report about the experienced problems?

My mistake. I vaguely reminded some problems about heaving WYSIWYG+Calendar sections on the same page or something this way in former time. It's of no relevance.

---

Code allein macht nicht glücklich. Jetzt spenden!

mux

Mitglied

Re: Topics and otherthings doesn't work

I spoke with my webhoster.  He said  I can temporarily turn off the strict mode by calling the referring order directly after the database connection is established. And this must be done each time when opening a database connection. So I think I should include some code within the class-database.php.  But I really have no idea how and what code to insert.  Maybe someone can help?

marmot

Mitglied

Re: Topics and otherthings doesn't work

Maybe someone can help?

in class.database.php around line 67 find

[== PHP ==]
$this->db_name = DB_NAME;
$this->connected = true;

right after this insert

[== PHP ==]
mysqli_query($this->db_handle,"SET @@sql_mode=''");

mux

Mitglied

Re: Topics and otherthings doesn't work

Thanks!

norhei

Developer

Re: Topics and otherthings doesn't work

Great one!  Marmotthats a  good idea , i have been completely snowblind.  Possibly this won't work on every server but its a very good quick solution.
(I am pretty sure there is a way to turn off setting this from inside PHP and some silly hosters may do that )
What do you think of fetching the mode first and only remove strict mode ?

http://www.sqlines.com/mysql/sql_mode

marmot

Mitglied

Re: Topics and otherthings doesn't work

What do you think of fetching the mode first and only remove strict mode ?

depends on the point of view:
- if you want minimal changes > good idea
- if you think other settings may cause problems too > not so good