PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ui_limit' in 'field list': INSERT INTO {ds_fields} (field, label, field_type, entities, ui_limit, properties) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => taxonomy_description [:db_insert_placeholder_1] => taxonomy description [:db_insert_placeholder_2] => 5 [:db_insert_placeholder_3] => a:1:{s:13:"taxonomy_term";s:13:"taxonomy_term";} [:db_insert_placeholder_4] => s:1:"*"; [:db_insert_placeholder_5] => a:2:{s:4:"code";a:2:{s:5:"value";s:28:"<?php print $description; ?>";s:6:"format";s:8:"php_code";}s:9:"use_token";i:0;} ) in drupal_write_record() (line 7013 of /home/me/public_html/mysite.com/includes/common.inc).

For Limit field I used "*" (no quotes), per help text. Also tried entering nothing, but error generated as well.

For Code, used PHP input filter.

Comments

greta_drupal’s picture

greta_drupal commented

FYI:

Initially, I updated to the latest -dev version (from the previous -dev build) through the D7 module UI. And, I did run update.php, so the database should have been rebuilt. But, I also manually updated -- deleted the old DS and uploaded (FTP) the new files, then ran update.php.

Still gives error.

swentel’s picture

swentel commented

There is currently no upgrade path between version 1 and 2 - and there actually shouldn't be as existing configurations between the both branches will break immensively on the theming side. So you'll have to add the ui_limit column manually for now, but I'll add it to the upgrade path though soon for that little field because I'm sure this will happen a lot.

greta_drupal’s picture

greta_drupal commented

I didn't even realize that I had gone from v1 to v2. Thought that I had been using the latest, always.
In any case, at this point, what would be best: to uninstall the v2 and go back to v1 branch? Or move forward with v2? Is manually adding that field the only requirement?

Not sure what exactly you mean by breaking theming. If you mean only custom template files -- no worries, not using any of that -- only DS UI. If you mean DS UI, then in for a world of hurt.

greta_drupal’s picture

greta_drupal commented

I'm going to uninstall DS, reinstall v2, and start all over again. Oh, boy.

rsgracey’s picture

rsgracey commented

Did it work for you? I'm having the same version clash....

aspilicious’s picture

aspilicious commented

Reinstalling should work. But you'll loose every setting.

greta_drupal’s picture

greta_drupal commented

Reinstalled. Of course, lost everything. Rebuilding it all now. This error, about missing db field, is gone. But, the other DS field ui error persists.

Notice: Undefined offset: 1 in _ds_field_ui_fields() (line 1812 of /home/myacct/public_html/thct.multimediabytyme.com/sites/all/modules/ds/includes/ds.field_ui.inc).

swentel’s picture

swentel commented
Priority: Normal » Major

Moving to major so at least db crashes don't happen

swentel’s picture

swentel commented
Status: Active » Fixed

Upgrade path for this table is now in.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.