Support archive | go to Low

Unknown column 'entry_id'

Xujie Zheng 23 Nov 2016 18:56 problem, complete

Hi, we have encouter this following error blocking us to edit low variable on ee 3.4.4. Could you help us? Also I cannot select relationship in the data type to replace the old playa. Could you also look into this?

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entry_id' in 'where clause':
SELECT * FROM ('exp_upload_prefs') WHERE 'entry_id' IN ('3') AND 'site_id' = '1' ORDER BY 'row_order' asc, 'name'

Replies

Low 23 Nov 2016 19:05

This seems odd. I'll need to take a look myself. Please send SuperAdmin login credentials to hi at gotolow dot com if you can.
Xujie Zheng 23 Nov 2016 19:26

I just did, Thank you

Low 23 Nov 2016 19:30

Hmm, it didn't come through. Can you try again, but this time send it to lodewijk@gmail.com?
Low 23 Nov 2016 19:40

Looks like it's actually a Transcribe issue. The first error shown is:

call_user_func_array() expects parameter 1 to be a valid callback, class 'Transcribe_ext' does not have a method 'transcribe_grid_query'

ee/legacy/libraries/Extensions.php, line 243

I've disabled the Transcribe extension, and then it works just fine.

And you're correct about the Relationships field. That isn't compatible in a LV context, since the native Relationships field expects two entries to be related, not an entry and a global variable. It's a limitation of EE's native Relationships field, I'm afraid.
Xujie Zheng 23 Nov 2016 19:43

So what should I use to replace playa? since they are not offering an update for ee3. Thank you
Low 23 Nov 2016 19:46

If you're after just selecting entries (not inside a Grid), then the Select Entries variable type would work.

If you need to use it in a Grid field, then I'm not sure if there is an alternative.
Xujie Zheng 23 Nov 2016 19:55

I am a newbie with this plugin, I am just wondering how I can get slideshow(Engilish ) show up on the front page blank space? Many thanks
Low 23 Nov 2016 20:00

Looking at your templates, you've got this right there:
```
{exp:low_variables:pair var="lv_slideshow_{exp:utils:current_lang}" parse="inward"}
```
I'm thinking you're trying to turn off Transcribe here, which took care of placing the "en" part of the variable.

You could replace it with
```
{exp:low_variables:pair var="lv_slideshow_en" parse="inward"}
```
to see what the output would be.

Note that this is just a how-to for using LV, so be sure to check the docs on using Grid vars: http://gotolow.com/addons/low-variabl...
Xujie Zheng 23 Nov 2016 20:30

Hm, it is not quiet working, I suspect this is related to transcribe as well, I would go to them as hope I can get some answer from them. But could you tell me where did you disable transcribe? Thanks!
Low 23 Nov 2016 20:32

In Developer > Utilities > Debug Extensions

Xujie Zheng 23 Dec 2016 14:05

Hi, we have experience some gird problem with low variable function. I am pretty new to expressengine. Just wondering what is the row_order and entry_id do for
1. exp_upload_prefs
2. exp_sites
3. exp_modules

It seems like this is a new feature in the database for ee 3+, because it does not existed in my ee1/2 database.

I am wondering what I can do if I want to manually add the value for these three table?

Low 23 Dec 2016 14:21

Not sure what you mean, here. Maybe you're better off asking the EllisLab crew, as this looks more related to native Grid/EE stuff than with Low Variables.

Xujie Zheng 23 Dec 2016 14:31

We have just ended the support with EllisLab, it will be great if you can share some thought on this. Or even could you send me screenshots of database of these three tables so that I can see the correlation for the row_order and entry_id? This error is coming from the low variable function, because low variable need the row_order and entry_id to perform some task according to the php file.

Low 23 Dec 2016 14:34

row_order is the order in which the Grid rows should appear. entry_id is the entry ID (or Variable ID) the Grid field is related to.

But really, this sounds like a different issue than the one here, and it also sounds like a botched migration. Not like a bug in LV, so I'm not sure how much support I can offer.

The 3 tables you mention hardly have anything to do with Low Variables.

Xujie Zheng 23 Dec 2016 14:36

Thank you very much! I will look into this.
Xujie Zheng 1 Feb 2017 20:18

Hi,

We have encounter an issue where low variable cannot find the type. Our entire website is broken right now.

This is the php error log output:
[01-Feb-2017 15:07:13 America/New_York] PHP Fatal error: Class name must be a valid object or a string in /mnt/stor9-wc1-dfw1/659720/dev.c2c.grassrootsenterprise.net/web/content/manage/user/addons/low_variables/libraries/Low_variables_types.php on line 336

And the following is on the web page
Undefined index: low_textarea

user/addons/low_variables/libraries/Low_variables_types.php, line 331 hide details

Severity: E_NOTICE

Fatal error: Class name must be a valid object or a string in /mnt/stor9-wc1-dfw1/659720/dev.c2c.grassrootsenterprise.net/web/content/manage/user/addons/low_variables/libraries/Low_variables_types.php on line 336

Low 1 Feb 2017 20:29

This is a conversation that's separate from the main one, so I created a new thread to continue the discussion.

Please reference the new conversation here: Cannot find variable type low_textarea