Support archive

Select Entries not returning correct Entry ID

wesbaker 12 May 2010 21:42 problem, complete

It appears that when using the Select Entries field it the value of the variable ends up being the index (+1) of where it is in the drop down list. For example if you had three items and you choose the third item, that field returns 3 as it's entry ID regardless of the item's actual entry ID.

Replies

1. Low 12 May 2010 22:25

   Hey Wes,
   
   I take it you're using the EE1 version? It seems like you're right. I'll investigate further tomorrow (it's 00:23 here, at the moment) and send you a fix as soon as I'm able.

2. Low 13 May 2010 07:42

   I've found the bug and fixed it. I'll release an update later today. If you need a fix sooner, drop me an email so I can send you a patched file.

3. Low 13 May 2010 17:01

   Wes, v1.2.1 of Low Variables should fix the problem.

4. wesbaker 13 May 2010 17:40

   It seems to fix the problem, but I can't get into the administration area without getting this error:
   
   

   MySQL ERROR:
   
    Error Number: 1060
   
    Description: Duplicate column name 'variable_notes'
   
    Query: ALTER TABLE 'exp_low_variables' ADD 'variable_notes' TEXT NOT NULL AFTER 'variable_label'

   
   
   I've tried deleting the column, but it continues to try and recreate it on each page. I also noticed that the version number in the Modules page is "Copyright (".

5. Low 13 May 2010 19:11

   ::facepalm::
   
   I'm on it.

6. Low 13 May 2010 19:34

   Wes, can you try to download it again and replace the files with the newly downloaded version? You might have to change the 'module_version' field of the Low_variables row inside exp_modules to 1.2.0 before you do, if it's not a proper version number.

7. wesbaker 13 May 2010 20:36

   Took care of it for me. Thanks for your quick work Low.

8. Low 13 May 2010 22:06

   Glad you got it working, Wes!