Closed (duplicate)
Project:
Sortable Grid Views Plugin
Version:
7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Reporter:
Created:
30 Jun 2011 at 19:53 UTC
Updated:
1 Jul 2011 at 02:52 UTC
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
Comment #1
cutmedia commentedComment #2
cutmedia commentedsorry wrong title now SQLSTATE[HY000], means sql cant create the table but the table is already there created on install.
Comment #3
Countzero commentedDid you set the row style to 'Sortable Grid' as in http://drupal.org/node/1144364#comment-4584118 ?
Comment #4
cutmedia commentedI 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.
Comment #5
cutmedia commentedComment #6
Countzero commentedNo 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.