#6830 – Not saving the title and description.

Hi

There is an error happening when saving the data:

1054 Unknown column 'og_custom_description' in 'field list

This means that when last version was installed, sh404SEF database tables structure was not properly updated and is missing the 'og_custom_description" column. I tried installing the latest dev version but that did not fix the issue yet.

What's really odd is that there's no error showing during the installation. If the addition of the "og_custom_description" was failing, this would show during installation.

1 - What's the history of the site? is this a brand new site where sh404SEF was installed for the first time?
2 - Did you restore any sh404SEF data from a previous version of the site?
3 - Can you provide PHPMyadmin access or equivalent?

Best regards

Hi

1 -

- It is installed for the first time here

http://xxxx.com/scuolasci/

Is this on the same server as https://www.xxxx.com/?

2 - The table structure is indeed incorrect. It's missing not only og_custom_description but also several more fields that were added in last version. I think this is happening because of the MYSQL version, 5.5. It should be ok but it seems this server does not make the changes sh404SEF tells it to do when modifying database table structure.
I'll dig more into it and get back to you.

Best regards

Hi

So I think I found the problem, your mysql server 5.5 did not like the latest addition of raw content fields. I have changed the raw content fields content type to Medium text and that seems to work better (tested on http://xxxx.com/scuolasci/).

You can download a modified version from the [download area] and install on your main site.

Let me know.

Best regards

Hi

Can't say much as I did not look at the tables on that site. However it seems pretty odd that just one site does not work.

Is this with the very latest sh404SEF, 4.18.2, published today?

Best regards

Hi

This is a mysql server issue, nothing can be done from inside Joomla. At minimum, I would need phpmyadmin access.
Also, it would need to be a higher level access to phpmyadmin, for your other site, I could not access the users and check their permissions.
It still looks like your db user cannot ALTER db tables.

Regards

Hi

So I reinstalled sh404SEF and to my surprise it remained configured like the previous one.

As it's kinda easy to uninstall an extension by mistake (a single click in the wrong place), sh404SEF automatically saves is entire configuration in a file (in the /media/directory) and reloads it upon installing back. It's been like that since Joomla 1.0. If you want configuration to be reset, you can do so by going to "Advanced" configuration and enable/disable which parts of sh404SEF data you want to keep when uninstalling.
For instance, you can tell it to delete all db tables when uninstalling, so that you don't have to do it by hand.

I take this opportunity to ask you if it is ok to paste in this way the facebook pixel code like I did here:

That's exactly for that kind of usage this feature is for, for all those extra code that sh404SEF does not handle with its own UI but you still need to insert in your pages.

Finally I ask you one last thing: how did you understand that the error was this:

The saving that was failing is done through ajax. By opening the chrome dev tools, on the "Network" tab, you can see all AJAX requests made by the page at any time (under the XRH sub-tab). For each ajax request you can see:
- which request is made (URL, parameters)
- requests and response from server headers and status code
- full content of the response.

In your case, instead of the regular JSON ajax response, I could see Joomla replying with an error page showing the error message (setting Error display in Joomla still required to view the actual message).

Glad you sorted it out. There's still something unclear here, as sh404SEF should have been able to fix the existing tables after installing again.

Best regards