Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#37 2011-05-05 12:45:12

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_matrix – Multi-article update tabs

Hi Doug,

It might be you … or rather an MySQL issue. I’ll email you for some more diagnostics.

Adi

Offline

#38 2011-05-05 14:16:03

douglgm
Member
From: Bristol
Registered: 2006-08-23
Posts: 182
Website

Re: adi_matrix – Multi-article update tabs

Turns out it was an SQL issue (I’m running 5.1 on my development webserver).

Looks like it’s a feature of MySQL 5, as mentioned in the link you sent me.

“In MySQL 4 and prior, if you set int_column = ‘’, it was converted to the zero value. In MySQL 5 it causes error “Incorrect integer value”.

To have the old behaviour you should execute set sql_mode = ‘’; — empty string means ‘traditional MySQL-mode’

Doing this in my my.ini fixed the problem. Thanks for the quick response.

Doug.

Offline

#39 2011-05-06 17:54:49

oliverker
Plugin Author
From: Huddersfield
Registered: 2008-07-14
Posts: 90
Website

Re: adi_matrix – Multi-article update tabs

Hi,

Notice: Undefined index: custom_11 in /home/public_html/textpattern/lib/txplib_misc.php(653) : eval()’d code on line 1030
Notice: Undefined index: custom_12 in /home/public_html/textpattern/lib/txplib_misc.php(653) : eval()’d code on line 1030
Notice: Undefined index: custom_13 in /home/public_html/textpattern/lib/txplib_misc.php(653) : eval()’d code on line 1030

Is this because Im using glz_custom_fields ? If it is it doesn’t seem to be working. I have had it working on a site with >10 custom fields

Offline

#40 2011-05-06 19:44:05

CeBe
Plugin Author
From: Caen - Fr
Registered: 2010-06-25
Posts: 345
Website

Re: adi_matrix – Multi-article update tabs

gomedia a écrit:

Thanks to CeBe for testing & supplying French translations again.

My pleasure :)
Once again, big thanks for your work !

Offline

#41 2011-05-06 23:04:17

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_matrix – Multi-article update tabs

oliverker wrote:

Is this because Im using glz_custom_fields ? If it is it doesn’t seem to be working.

I must admit, I haven’t tested it but I did get a report that it was OK. I’ll contact you directly for more details.

Offline

#42 2011-05-13 18:49:03

jeremywood
Member
Registered: 2007-12-12
Posts: 26

Re: adi_matrix – Multi-article update tabs

I’ve run into the same problem as oliverker—adi_matrix doesn’t like my custom fields 11 and 12 from glz_custom_fields. One other note—in my case those are “textarea” controls, which probably shouldn’t be editable with adi_matrix anyway.

Offline

#43 2011-06-06 13:54:02

aswihart
Member
From: Pittsburgh, PA
Registered: 2006-07-22
Posts: 345
Website

Re: adi_matrix – Multi-article update tabs

Same issue as above with the custom fields, any update?

I have a spattering of custom field types besides textarea, but the ones that raise the errors are all custom_11 or greater.

Last edited by aswihart (2011-06-06 13:55:50)

Offline

#44 2011-06-06 15:56:42

jpdupont
Member
Registered: 2004-10-01
Posts: 752

Re: adi_matrix – Multi-article update tabs

Is it possible to sort by other fields ?

I want to sort the matrix by some custom field !

BTW, same issue as above with custom_11 …

Offline

#45 2011-06-06 16:55:06

aswihart
Member
From: Pittsburgh, PA
Registered: 2006-07-22
Posts: 345
Website

Re: adi_matrix – Multi-article update tabs

Great work on this brilliant plugin, Adi!

I got rid of the custom_field errors with adi_matrix, after I deleted all but custom_11 and custom_12 (these I could only reset), shifting some fields to unused lower numbers. glz_custom_fields won’t let me delete 11 and 12 for some reason, and while I could drop the columns directly in the database, I’m not sure that’s a good idea.

Any plans to support the glz_custom_field widgets (select, checkbox, etc…) in the batch editing screen?

Last edited by aswihart (2011-06-06 16:57:52)

Offline

#46 2011-06-07 04:14:27

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_matrix – Multi-article update tabs

aswihart wrote:

Great work on this brilliant plugin, Adi!

Thanks, and apologies for my tardy response. Client work is my mistress at the moment.

Any plans to support the glz_custom_fields widgets (select, checkbox, etc…) in the batch editing screen?

Yes, cooperation with glz_custom_fields is on my list. I need a copy of glz_custom_field for testing though.

jpdupont wrote:

Is it possible to sort by other fields ?

I want to sort the matrix by some custom field !

Yep, sounds reasonable (do you mean sort by cf values or cf names?)

There’s good news. The bad news is that it’ll probably be a couple of months before I can do anything. Sorry.

Offline

#47 2011-06-07 16:58:37

jpdupont
Member
Registered: 2004-10-01
Posts: 752

Re: adi_matrix – Multi-article update tabs

Fine !
I want to sort by cf value.

Offline

#48 2011-06-09 11:04:24

aswihart
Member
From: Pittsburgh, PA
Registered: 2006-07-22
Posts: 345
Website

Re: adi_matrix – Multi-article update tabs

Cf names would be in the column header, correct? You would only want to sort by values I would think. Great news, thanks for your work on this Adi.

Offline

Board footer

Powered by FluxBB