Thanks for pointing that out. I've run the "create table" uploaded with that bug report and it fails for the same reason using MySQL 4.1.12 on linux and 5.0.18-nt So this is not a limitation of RMySQL. Regards Mark
On 3/24/06, Jeffrey Horner <[EMAIL PROTECTED]> wrote: > Mark Van De Vyver wrote: > > My apologies, > > > > I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows > > XP with latest patches. > > > > MySQL is "server version: 4.1.12" > > I'm pretty sure it's running on a linux box. > > It turns out that this may be a MySQL limit: > > http://bugs.mysql.com/bug.php?id=4117 > > > > > The dimension of template is >2000, I know the error kicks in at 3000, > > but haven't iterated to find the exact point - if it would help I can > > do this. > > > > Regards > > Mark > > > > On 3/24/06, David James <[EMAIL PROTECTED]> wrote: > >> Hi, > >> > >> Mark Van De Vyver wrote: > >>> Dear R-users, > >>> First, thank you to the developers for the very useful R-library RMySQL. > >>> > >>> While using this library a recieved an error message: > >>> > >>> RS-DBI driver: (could not run statement: Too many columns) > >>> > >>> The statement that generated the error was: > >>> > >>> dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE, > >>> row.names = FALSE ) > >>> > >>> I am assuming this is a RMySQL rather than MySQL limit. > >> We need more information, e.g., what's dim(template), what version > >> of MySQL you're using, etc. > >> > >>> If that is the case I was wondering just what this limit is and if it > >>> is possible to raise it? > >>> > >>> Thanks again for all the hard work. > >>> > >>> Sincerely > >>> Mark > >>> > >>> -- > >>> Mark Van De Vyver, PhD > >>> -------------------------------------------------- > >>> My research is available from my SSRN Author page: > >>> http://ssrn.com/author=36577 > >>> -------------------------------------------------- > >>> Finance Discipline > >>> School of Business > >>> The University of Sydney > >>> Sydney NSW 2006 > >>> Australia > >>> > >>> Telephone: +61 2 9351-6452 > >>> Fax: +61 2 9351-6461 > >>> > >>> > >>> -- > >>> Mark Van De Vyver, PhD > >>> -------------------------------------------------- > >>> My research is available from my SSRN Author page: > >>> http://ssrn.com/author=36577 > >>> -------------------------------------------------- > >>> Finance Discipline > >>> School of Business > >>> The University of Sydney > >>> Sydney NSW 2006 > >>> Australia > >>> > >>> Telephone: +61 2 9351-6452 > >>> Fax: +61 2 9351-6461 > >>> > >>> ______________________________________________ > >>> [email protected] mailing list > >>> https://stat.ethz.ch/mailman/listinfo/r-help > >>> PLEASE do read the posting guide! > >>> http://www.R-project.org/posting-guide.html > >> -- > >> David > >> > > > > > > -- > > Mark Van De Vyver, PhD > > -------------------------------------------------- > > My research is available from my SSRN Author page: > > http://ssrn.com/author=36577 > > -------------------------------------------------- > > Finance Discipline > > School of Business > > The University of Sydney > > Sydney NSW 2006 > > Australia > > > > Telephone: +61 2 9351-6452 > > Fax: +61 2 9351-6461 > > > > ______________________________________________ > > [email protected] mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! > > http://www.R-project.org/posting-guide.html > > -- > Jeffrey Horner Computer Systems Analyst School of Medicine > 615-322-8606 Department of Biostatistics Vanderbilt University > -- Mark Van De Vyver, PhD -------------------------------------------------- My research is available from my SSRN Author page: http://ssrn.com/author=36577 -------------------------------------------------- Finance Discipline School of Business The University of Sydney Sydney NSW 2006 Australia Telephone: +61 2 9351-6452 Fax: +61 2 9351-6461 ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
