multi article status change problem

Hello

I'm using J3.1.5 and FC V1789.

No problem to change the status of one article when using the status button in the list of articles.

If using the menu button [change status] the status change is done but after I get the following error :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=UPDATE xxxx_flexicontent_items_versions SET value = 0 WHERE item_id = 22 AND valueorder = 1 AND field_id = 10 AND version =

Best regards

Michel

Hello

SQL error reporting is ON in J3.1 by default, will commit fix for this

-- to apply test a fix now:

edit file:
administrator/components/com_flexicontent/models/parentclassitem.php

find line about 3332:
. ' AND version = ' . $v
change to:
. ' AND version = ' .(int)$v

thanks for report

Regards

Hello,

I get something strange to do the patch (perhaps it's a local problem from my computer) : Generally I edit the php.file directly on the server with the provider CPANEL editor. I could'nt do it for this file : Each time I tried to open it in the CPANEL editor, the page was blocked (tested with FF, Chrome and Opera).
For this file I was obliged to download it, update it locally and upload the new version.

I don't know if the problem comes from my PC or from the file.

Best regards

Michel

Hello

The cpanel login can also be used as FTP (usually)

so log via FTP and edit the file, but:

it is also available here:
v2.1.1 r1791 (RC, almost done)
code.google.com/p/flexicontent/downloads/list

---

IMPROVEMENTS

---

1. Improved component installer to
- abort installation only if installing for first time,
- to provide more clear feedback of what when wrong and if a rollback / abort was done
2. Improved print link in category-like views to display according to current
filtering

---

FIXES (J3.1 specific)

---

1. Fixed universal module being empty
2. Fixed SQL error while creating filters in J3.x after upgrading from J2.5
3. Fixed duplicating/deleting templates in J3.x (replaced mootools AJAX with jQuery AJAX)
4. Fixed using CAPTCHA form field
5. Fixed FLEXIcontent finder (smart search) plugin in J3.x
6. Fixed frontend AJAX voting being broken in J3.1
7. Fixed multi-item change state in backend items manager being broken for J3.1

---

FIXES (All Joomla version)

---

1. Fixed frontend order override for "Best rated" and "Most commented"
2. Fixed jumpy behavior when sorting fields in positions of template layouts
3. Fixed / allowed using single quotes in tags
4. Fixed the single quote being truncated half way by FLEXIcontent strip and cut text helper function
5. Fixed FACETED filters in category view being empty, while also doing text
6. Fixed/Improved frontend autocomplete to include currently typed word in autocomplete list, and not to display duplicate results due to having uppercase letters,

---

NEW FEATURES

---

1. Added preview to CSV import task, and made it multi-step (AJAX based) to avoid timeouts, ability to continue interrupted import

2. Added ability to call plugin functions as tasks via frontend controller (these are limited to an 'allowed' list of functions)

3. Added 2 tasks to file field, that are used to optionally display button that opens a popup e-mail FORM with the purpose of sharing the file download link with a friend