Bug?

[Kev@Flexi.Net]

I've just found that Actinic has issues with 's in Fragment titles. Occurances of ' in fragment titles aren't handled gracefully at all and result in the title being truncated and the fragment content not showing. It also prevents the preview for that page to show.

Any one else experiencing the same problem?

It seems to be due to the 's not being escaped when performing sql queries. I'm not sure if it's on the initial insert or on subsequent selects.

Kev

[Kev@Flexi.Net]

Don't try this if you havn't got a database backup! If will prevent you from uploading your site.

It also brings up an error when loading Actinic, says data truncated and something about fields being too long in the linked database.

[Kev@Flexi.Net]

Ok. I've done some more investiagation and it appears that there are 2 bugs in the catalog fragments.

1. 's are not being escaped in sql queries for the Fragment Title. Results in SQL errors.

2. The Text field is being limited to a certain amount of characters. This doesn't look like it's a database design limitation, rather something in the Actinic program. Needs some more investigation but it seems to either enter more text into the database than the program can cope with (may be linked to the above error) or it generates a data truncated error when adding the text.

Symptoms after encountering the bugs range from data truncated errors to errors when opening actinic and not being able to preview/upload the site.

If this isn't the best place to submit bug reports, where is?

Thanks,
Kev

[Pneumatus]

Kev,

There was a problem with truncation in 7.0.0 but it was supposed to have been fixed in the latest patch (7.0.1). Are you running the latest patch?

[Kev@Flexi.Net]

Hi,

I'm not running 7.0.1 at the moment as I've copied the site from a running installation to do a site re-design. I'll try doing the upgrade and see if that fixes the problem.

I'll post here when I have more info.

Kev

[cdicken]

The truncation issue is fixed in 7.0.1, but the issue with the apostrophes will not be addressed until 7.0.2. I suggest you try and avoid using apostrophes in the titles of fragments inserted in the section pages.

[Kev@Flexi.Net]

I can confirm that the truncation problem has been fixed in 7.0.1

There is still an issue with an SQL error when adding a fragment that has ' in the title. Error message is as follows:

Syntax error (missing operator) in query expression '`sFragmentTitle` = 'Pelle Pelle Men's' AND [nParentSectionID] = 142'.

After the initial error dialog there appear to be no further problems with using 's in fragment titles.

Kev