ripley@stats.ox.ac.uk
2005-Feb-24 19:07 UTC
[Rd] sqlSave reports invalid regular expression '[^[:alnum]_]+' (PR#7704)
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