Drupal 7.4
Views 7x dev latest (29 June)
Saving the order gives an error:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'nid' at row 1: INSERT INTO {sgrid} (nid, rank, view_display) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => [:db_insert_placeholder_1] => 0 [:db_insert_placeholder_2] => taxonomy_term_page ) in sgrid_view_sgrid_form_submit() (line 73 of C:\xampp\htdocs\test\sites\all\modules\sgrid\sgrid.module).
No output created for the order it seems.

Comments

cutmedia’s picture

Title: PDOException: SQLSTATE[23000] » PDOException: SQLSTATE[HY000]
cutmedia’s picture

sorry wrong title now SQLSTATE[HY000], means sql cant create the table but the table is already there created on install.

Countzero’s picture

Assigned: Unassigned » Countzero

Did you set the row style to 'Sortable Grid' as in http://drupal.org/node/1144364#comment-4584118 ?

cutmedia’s picture

I thought I`d followed the instruction but forgot the order by sgrid. works now...
Sorry for the time wasting, one tired developer here, couldnt see anything wrong in the code.
Warning to everyone follow the instructions.

cutmedia’s picture

Status: Active » Fixed
Countzero’s picture

Category: bug » support
Priority: Major » Normal
Status: Fixed » Closed (duplicate)

No problem. I guess I'll have to emphasis some points in the instructions, as you're not the first.

And yes, I know what a tired developer is :p.

Hope the module will fit your needs.