[wrong column name in 3rd party plg] MYSQL Error 1054

iamrobert2
Topic Author
Offline
Junior Member

10 years 1 month ago #45782 by iamrobert2

[wrong column name in 3rd party plg] MYSQL Error 1054 was created by iamrobert2

Hi,

My site has broke with the following error code:

Code:

1054 - Unknown column 'x.itemid' in 'where clause' SQL=SELECT x.type_id FROM jo_flexicontent_items_ext AS x WHERE x.itemid = 6

I have:
1. optimized and repaired databases
2. tried changing the home page - but just brings up another error
3. tried upgrading to FLEXIcontent version 2.1.3 r1866

Any ideas?

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 1 month ago #45783 by ggppdk

Replied by ggppdk on topic [wrong column name in 3rd party plg] MYSQL Error 1054

Hello

you are lucky it seems we have the same extension installed,

i found a wrong column name in Nonumber nnframework system plugin:

edit file:
plugins\system\nnframework\helpers\assignments\flexicontent.php

find lines:

Code:

$query->select('x.type_id');
$query->from('#__flexicontent_items_ext AS x');
$query->where('x.itemid = '.(int) $main->_params->id);

and change the last line to be:

Code:

$query->where('x.item_id = '.(int) $main->_params->id);

Do you have the commercial version of Nonumber Advanced Module manager ?

please post back here if this is fixed, and if it is the above case, then also ask Nonumber developer to include the fix

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

iamrobert2
Topic Author
Offline
Junior Member

10 years 1 month ago #45788 by iamrobert2

Replied by iamrobert2 on topic [wrong column name in 3rd party plg] MYSQL Error 1054

Hi Georgios,

Yes I own the commercial version.

There are 2 versions referencing:

where('x.itemid = ' . (int) $parent->params->id)

Line 56:

Code:

$parent->q->clear()
->select('t.name')
->from('#__flexicontent_tags_item_relations AS x')
->join('LEFT', '#__flexicontent_tags AS t ON t.id = x.id')
->where('x.itemid = ' . (int) $parent->params->id)
->where('t.published = 1');
$parent->db->setQuery($parent->q);
$tags = $parent->db->loadColumn();

Line 83:

Code:

$parent->q->clear()
			->select('x.type_id')
			->from('#__flexicontent_items_ext AS x')
			->where('x.itemid = ' . (int) $parent->params->id);
		$parent->db->setQuery($parent->q);
		$type = $parent->db->loadResult();

Changing the 2nd one to:

Code:

->where('x.item_id = '.(int) $main->_params->id);

seemed to fix it - but have fixed both.

Manny Thanks for your help.

Regards,

Robert

Changed to

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 1 month ago #45789 by ggppdk

Replied by ggppdk on topic [wrong column name in 3rd party plg] MYSQL Error 1054

Hello

thanks for feedback,

i don't have the commercial version installed but, i guess this particular part of the code is also there in the free version too, since i found it while doing a recursive text search

Regards

Please Log in or Create an account to join the conversation.