On page admin/content/blocks if you set only the items per page filter, and type filter is empty, there are error, and never can get back:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT COUNT(*) AS expression FROM {bean} b WHERE (type IN ()) ; Array ( ) in PagerDefault->execute() (line 74 of /home/panparks/public_html/includes/pager.inc).
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | bean_1288438.patch | 1.79 KB | drewish |
| #2 | 1288438_2_bean_admin_page_broken.patch | 482 bytes | szantog |
| #1 | 1288438_1_bean_admin_page_broken.patch | 481 bytes | szantog |
Comments
Comment #1
szantog commentedand patch
Comment #2
szantog commentedsorry, misspelling variable
Comment #3
indytechcook commentedI agree, that was bugging me.
http://drupal.org/commitlog/commit/22232/acdd2e1817015e5804516bc503c9b58...
Comment #5
drewish commentedThis is still a problem when you first visit the page or reset the filters you won't see any blocks. I changed bean_get_filter() around to simplify it a bit and always return those keys—I'm assuming that the values in the session will be valid. That let's us simplify the query building in bean_list() and avoid showing people a list with no blocks.
Comment #6
indytechcook commentedThanks Drewish.
http://drupal.org/commitlog/commit/22232/07538a7d47bef76b6f7c4ed42fae12d...