[FX.php List] neocache error storing cache item

[david weiner]

I think I figured it out - I changed the result to:
$result = mysql_query($query) or die (mysql_error());

and was able to get php to tell me:
Got a packet bigger than 'max_allowed_packet' bytes

Hope this helps someone along the way. Also, if anyone wants to try  
this, the neocode documentation is a little wrong and if you follow it  
completely you should change their $link statement to be two  
statements or do it as one - but they have it written up as two but  
incomplete.

- David


On Feb 24, 2009, at 3:12 PM, Leo R. Lundgren wrote:

> I'm not familiar with Neonode, but have you turned on debugging on  
> the MySQL server, to see what (if anything) Neonode is doing when  
> the error occurs?
>
>
> 24 feb 2009 kl. 23.55 skrev david weiner:
>
>> Hi,
>> I've got neocode's cache function running and successfully storing  
>> to a mysql table and it's working great for all my queries up to a  
>> request limit of ~650 records. When I set my request to >650  
>> (ideally 2000) I get an error storing cache item.
>>
>> With debug turned on I get the following:
>> Performing find...
>> Beginning action...
>> Attempting to retrieve cached action from MySQL.
>> Cached action not found: performing action.
>> Storing action result in cache.
>> Caching action.
>> Error storing cache item!
>>
>> So I know it's working and the cache field is defined as longtext  
>> which means it should be able to store something like a trillion  
>> characters.
>>
>> I know this isn't directly an FX question, but when I asked neocode  
>> why their stuff wasn't working they offered to solve it for $500.  
>> I'd appreciate it if anyone has an idea for where to look.
>>
>> Thanks,
>> David
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> -|
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list