When all countries enabled and using location_views, I get a "Got a packet bigger than 'max_allowed_packet' bytes" error

alex_b - March 19, 2007 - 14:34
Project:Location Views
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

I created a view of a single CCK content type that has location enabled. The view exposes the location module's country list as a filter. When I enable all countries that come with location module, I get a "Got a packet bigger than 'max_allowed_packet' bytes" error when views module tries to cache the view.

The packet is indeed huge: < 1 MB. The query is attached

Any ideas on how to make this smaller?

Alex

AttachmentSize
huge_cache_query_from_location_views.mysql_.gz_.txt187.93 KB

#1

geodaniel - March 21, 2007 - 16:43
Project:Location» Location Views
Version:5.x-1.x-dev» <none>

Just moving this over to the location_views queue

 
 

Drupal is a registered trademark of Dries Buytaert.