[Tickets #2518] RESOLVED: Missing leading slash in sqlhome VFS

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2518
-----------------------------------------------------------------------
 Ticket             | 2518
 Updated By         | rosenfeld at alum.mit.edu
 Summary            | Missing leading slash in sqlhome VFS
 Queue              | Gollem
 Version            | HEAD
 State              | Bogus
 Priority           | 1. Low
 Type               | Bug
 Owners             | Michael Slusarz
-----------------------------------------------------------------------


rosenfeld at alum.mit.edu (2005-08-26 04:47) wrote:

I didn't write a script, but here's the steps I followed.  This assumes that
no one had uploaded a new file since the upgrade.

DELETE FROM horde_vfs WHERE LEFT(vfs_path, 1) <> '/'

UPDATE horde_vfs SET vfs_path = RIGHT(vfs_path, LENGTH(vfs_path) -1) WHERE
LEFT(vfs_path, 1) = '/'

These queries worked on my table with ~100 entries.  I haven't tested them
heavily and can't imagine how they'd work on foreign charsets or paths with
escape sequences.  I know it's not much, but hopefully it's something.