[Rd] sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7703)

Prof Brian Ripley ripley at stats.ox.ac.uk
Thu Feb 24 19:06:49 CET 2005


Do not use R-bugs for reports on compatibility of obselete versiond of 
packages with unreleased versions of R!

You did not give the RODBC version no.  The current version, 1.1-3, is 
compatible with R-devel.  1.1-2 was not (alongside a dozen or so CRAN 
packages).

The only bugs here are in the report.

On Thu, 24 Feb 2005 david.whiting at ncl.ac.uk wrote:

> Full_Name: David Whiting
> Version: 2.1.0 Under development (unstable)
> OS: linux
> Submission from: (NULL) (82.39.106.169)
>
>
> I have just upgraded from a previous version (2.0.0?) and found some of my code
> that used okay to run now gives an error. The function being called is
> sqlSave(). I am pretty sure (but not 100% certain) that the data frame I am
> trying to save has not changed. I am 100% sure that the ODBC connection
> information for MySQL has not changed and I have not updated MySQL.
>
>> sqlSave(lh, data, "survey")
> Error in gsub(pattern, replacement, x, ignore.case, extended, fixed) :
> 	invalid regular expression '[^[:alnum]_]+'
>> traceback()
> 4: gsub("[^[:alnum]_]+", "", colnames)
> 3: mangleColNames(names(colspecs))
> 2: sqltablecreate(tablename, colspecs = colspecs, keys = keys)
> 1: sqlSave(lh, data, "survey")
>
>> str(data)
> `data.frame':	192 obs. of  171 variables:
> [...]
> (I can send the whole structure if that will help)
>
>> version
>         _
> platform i686-pc-linux-gnu
> arch     i686
> os       linux-gnu
> system   i686, linux-gnu
> status   Under development (unstable)
> major    2
> minor    1.0
> year     2005
> month    02
> day      24
> language R
>>
>
> ______________________________________________
> R-devel at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595



More information about the R-devel mailing list