[FX.php List] neocache error storing cache item

[david weiner]

Thanks for the suggestion - unfortunately I'm at a loss for how to  
turn debugging on (I'm using the macports install if that matters) in  
mysql - I've tried various things like raising the limit on php  
execution times but it didn't make a difference and since the error  
comes directly out of their storing script I'm pretty sure the problem  
has to do with writing out the data to the row.

Here's the relevant part of their code:
# add cache row
             $query = "INSERT INTO " . $this->cache_table .  
" (fx_cache_key, fx_cache_return, fx_cache_created) ";
             $query .= "VALUES ('" . $storageKey . "', '" .  
str_replace("'", "\\'", serialize($returnResult)) . "' , now())";
             $result = mysql_query($query);
             if (!$result) {
                 print 'Error storing cache item!';
                 die();
             }

Thanks,
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