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

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Fri 25 Feb 2005 - 05:06:49 EST

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@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@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>

-- 
Brian D. Ripley,                  ripley@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

______________________________________________
R-devel@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Received on Fri Feb 25 04:14:00 2005

This archive was generated by hypermail 2.1.8 : Fri 25 Feb 2005 - 04:32:26 EST