View automatically created with name that is too long - can't delete it, can't edit it
| Project: | SimpleViews |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
I created a content type that had a long name and asked that a View automatically be created. When I went in to edit the view I started getting SQL errors.
"user warning: Data too long for column 'name' at row 1 query: INSERT INTO views_object_cache (sid, obj, name, data, updated) VALUES ..."
The name field is defined as varchar(32) and the generated view name is longer than that.
The Delete button does not appear as it normally does so I cannot get rid of the view. I can't find where it is being stored. I restarted my browser and Apache. I cleared the cache. It is not in the Views table or the Simpleviews table.
Maybe leave off the simpleviews prefix if the name will be too long. The description still let's us know that it was generated by SimpleViews
#1
Forget about the Can't Delete part of the issue. The Delete button never showed up because I was never able to save it. I renamed the content type to a shorter name and the view disappeared.
#2
This is a good one to note, though - I can't easily fix it right now but I'll keep an eye on it and see if there is a way to prevent it in the future. Thanks.