Installing LG Data Matrix

Hi, Andy. LG Data Access is a third party extension. So I’m going to move this topic for you.

I am getting the same error:

MySQL ERROR:

Error Number: 1064

Description: 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 'WHERE Field = 'lg_field_conf'' at line 1

Query: SHOW COLUMNS FROM `exp_weblog_fields` WHERE Field = 'lg_field_conf'

Did you guys download from Leevi’s github before he formally announced it? There was a small problem with that one where it checks for a version number around line 485, but the version number hasn’t been updated properly…

Thanks for your response slapshotw.

I downloaded it yesterday from this page:

http://leevigraham.com/cms-customisation/expressionengine/lg-data-matrix/

which I assumed was the latest version (6.1. Version 1.1.1).

Do you think I should try an older version?

Many thanks,

Andy

yeah, I also downloaded from his site last night (monday, feb 8)

Same error for me as well. Downloaded version 1.0.0. Installed fine but I now get this error:

Notice: unserialize() [function.unserialize]: Error at offset 177 of 180 bytes in /nfs/c01/h03/mnt/33026/domains/[removed]/html/system/extensions/ext.lg_data_matrix_ext.php on line 629

Hrmmm…

Just hit the same issues with v1.1.1 downloaded this one: http://leevigraham.com/downloads/lg-data-matrix.1.0.0.zip

And all works fine (after copying all 3 js files onto the server).

Thanks for the link DevStudio. Unfortunately I still can’t get it working. As soon as I upload the files to the ‘extensions’ directory and try to get to the ‘Extensions Manager’ page via the Control Panel I just get a blank page. Once I remove the lg_data_matrix files from the server the Extensions Manager page is back to normal. Strange.

Not sure if I’m failing to do something correctly?

Did you remove all of the v1.1.1 files first?

No idea if it makes a difference, but I did leave the language file from v1.1.1 when I copied up the v1.0.

I overwrote all the existing files with the ones I downloaded from that link you supplied. Do you think it’s worth a shot deleting all LG Data Matrix files any trying again from scratch?

With v1.1.1 there’s also a sub-folder under cp_themes that contains a JavaScript file and isn’t needed in v1.0, so I’d delete that.

But if I can get it working, it should be possible on another build, unless it’s conflicting with another plug-in (doubtful).

Remove all traces of v1.1.1 and start again with v1.0. It’s a great plugin, so worth the effort. Hopefully it won’t be long before v1.1.1 is sorted.

Hi, just wondering if you guys got it working. Are you all working with 1.0.0 then? (As I just downloaded 1.1.1 also …)

Thanks!

oops

For anyone with this error, I suggest checking out this post: http://ellislab.com/forums/viewreply/541485/

It appears the error is caused by older versions of MySQL. The suggested change in ext.lg_data_matrix_ext.php line 418 from

$field_query = $DB->query("SHOW COLUMNS FROM `exp_weblog_fields` WHERE Field = 'lg_field_conf'");

to

$field_query = $DB->query("SHOW COLUMNS FROM `exp_weblog_fields` LIKE 'lg_field_conf'");

got the extension installed.