Support archive

Error after creating Playa Variable

agntc 23 May 2012 14:18 problem, complete

Hi there,

I just did my first install with low variables. Unfortunately after I created my second variable with a Playa type I now get an error on every page. Any ideas?

Low Vairables: 2.2.1
Playa: 4.3

A Database Error Occurred
Error Number: 1054

Unknown column 'parent_var_id' in 'where clause'

SELECT 'child_entry_id' FROM ('exp_playa_relationships') WHERE 'parent_var_id' = '7' ORDER BY 'rel_order'

Filename: third_party/playa/ft.playa.php

Line Number: 1424

Any help would be appreciated!

Replies

1. Low 23 May 2012 15:38

   Hi! Make sure you've followed Playa's upgrade instructions to the letter, including visiting the fieldtype settings page, to trigger its upgrade routine.

2. Sjoerd 27 Sep 2012 12:07

   Same problem here. Installed a fresh version of Playa 4.3.3. but that didn't help...
   Low Variables 2.3.1
   EE 2.5.3
   
   When clicking on the Low Variables tab:
   
   A Database Error Occurred
   
   Error Number: 1054
   
   Unknown column 'parent_var_id' in 'where clause'
   
   SELECT 'child_entry_id' FROM ('exp_playa_relationships') WHERE 'parent_var_id' = '16' ORDER BY 'rel_order'
   
   Filename: third_party/playa/ft.playa.php
   
   Line Number: 1463

3. Low 27 Sep 2012 12:14

   Hmm, looks like the var column in the Playa table wasn't created. You might want to alert P&T, and in the meantime follow these instructions.

4. Sjoerd 27 Sep 2012 12:34

   Thanks! That fixed it.