Tickets :: Comment on [#14177] ActiveSync SQL error

* Your Email Address
* Spam protection	Enter the letters below: .__..___.. ..___.. . \| \| _/ \| \| _/ \|__\| \|__\|./__.\|__\|./__.\| \|
Comment	>>>>> Additionally I found out that the last entry before the error occurs >>>>> is the query for the last share in "SELECT * FROM kronolith_sharesng >>>>> ORDER BY share_name ASC" (which according to the debug log seems to >>>>> be query used by horde-alarms to get the list of shares). >>>> >>>> By this I wanted to say it seems that the error occurs after all >>>> shares from kronolith_sharesng have already been processed. >>> >>> Using the admin phpshell in Horde, look to see what the following >>> produces (using Kronolith's scope): >>> >>> $kronolith_shares = $injector->getInstance('Kronolith_Shares'); >>> var_dump(array_keys($kronolith_shares->listAllShares())); >>> >>> See if there are any "empty-ish" values listed. >> >> Yeah indeed it end with: >> >> [1451]=> >> int(0) >> [1452]=> >> int(1) >> >> What should we do about them? > > Those array values should be string values (share names) and not even > integers. Look in your share table (probably kronolith_sharesng) and > see if you can find any shares with a share name of 0 or 1 (or ANY > integer value). My guess is those are old left over cruft.
Attachment
Watch this ticket