* using log directory 'd:/Rcompile/CRANpkg/local/4.4/xgb2sql.Rcheck' * using R version 4.4.3 (2025-02-28 ucrt) * using platform: x86_64-w64-mingw32 * R was compiled by gcc.exe (GCC) 13.3.0 GNU Fortran (GCC) 13.3.0 * running under: Windows Server 2022 x64 (build 20348) * using session charset: UTF-8 * checking for file 'xgb2sql/DESCRIPTION' ... OK * checking extension type ... Package * this is package 'xgb2sql' version '0.1.2' * package encoding: UTF-8 * checking package namespace information ... OK * checking package dependencies ... OK * checking if this is a source package ... OK * checking if there is a namespace ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'xgb2sql' can be installed ... OK * checking installed package size ... OK * checking package directory ... OK * checking 'build' directory ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... OK * checking for left-over files ... OK * checking index information ... OK * checking package subdirectories ... OK * checking code files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... [1s] OK * checking whether the package can be loaded with stated dependencies ... [0s] OK * checking whether the package can be unloaded cleanly ... [1s] OK * checking whether the namespace can be loaded with stated dependencies ... [0s] OK * checking whether the namespace can be unloaded cleanly ... [1s] OK * checking loading without being on the library search path ... [0s] OK * checking use of S3 registration ... OK * checking dependencies in R code ... OK * checking S3 generic/method consistency ... OK * checking replacement functions ... OK * checking foreign function calls ... OK * checking R code for possible problems ... [3s] OK * checking Rd files ... [0s] OK * checking Rd metadata ... OK * checking Rd cross-references ... OK * checking for missing documentation entries ... OK * checking for code/documentation mismatches ... OK * checking Rd \usage sections ... OK * checking Rd contents ... OK * checking for unstated dependencies in examples ... OK * checking LazyData ... NOTE 'LazyData' is specified without a 'data' directory * checking installed files from 'inst/doc' ... OK * checking files in 'vignettes' ... OK * checking examples ... [4s] ERROR Running examples in 'xgb2sql-Ex.R' failed The error most likely occurred in: > ### Name: booster2sql > ### Title: Transform XGBoost model object to SQL query. > ### Aliases: booster2sql > > ### ** Examples > > library(xgboost) > # load data > df = data.frame(ggplot2::diamonds) > head(df) carat cut color clarity depth table price x y z 1 0.23 Ideal E SI2 61.5 55 326 3.95 3.98 2.43 2 0.21 Premium E SI1 59.8 61 326 3.89 3.84 2.31 3 0.23 Good E VS1 56.9 65 327 4.05 4.07 2.31 4 0.29 Premium I VS2 62.4 58 334 4.20 4.23 2.63 5 0.31 Good J SI2 63.3 58 335 4.34 4.35 2.75 6 0.24 Very Good J VVS2 62.8 57 336 3.94 3.96 2.48 > > # data processing > out <- onehot2sql(df) > x <- out$model.matrix[,colnames(out$model.matrix)!='price'] > y <- out$model.matrix[,colnames(out$model.matrix)=='price'] > > # model training > bst <- xgboost(data = x, + label = y, + max.depth = 3, + eta = .3, + nround = 5, + nthread = 1, + objective = 'reg:linear') Warning in throw_err_or_depr_msg("Passed unrecognized parameters: ", paste(head(names_unrecognized), : Passed unrecognized parameters: max.depth. This warning will become an error in a future version. Warning in throw_err_or_depr_msg("Parameter '", match_old, "' has been renamed to '", : Parameter 'data' has been renamed to 'x'. This warning will become an error in a future version. Warning in throw_err_or_depr_msg("Parameter '", match_old, "' has been renamed to '", : Parameter 'label' has been renamed to 'y'. This warning will become an error in a future version. Warning in throw_err_or_depr_msg("Parameter '", match_old, "' has been renamed to '", : Parameter 'eta' has been renamed to 'learning_rate'. This warning will become an error in a future version. Error in process.y.margin.and.objective(y, base_margin, objective, params) : Got numeric 'y' - supported objectives for this data are: reg:squarederror, reg:squaredlogerror, reg:logistic, reg:pseudohubererror, reg:absoluteerror, reg:quantileerror, count:poisson, reg:gamma, reg:tweedie. Was passed: reg:linear Calls: xgboost -> process.y.margin.and.objective Execution halted * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... [6s] ERROR Error(s) in re-building vignettes: --- re-building 'xgb2sql.Rmd' using rmarkdown Quitting from xgb2sql.Rmd:221-231 [unnamed-chunk-6] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error in `process.y.margin.and.objective()`: ! Got numeric 'y' - supported objectives for this data are: reg:squarederror, reg:squaredlogerror, reg:logistic, reg:pseudohubererror, reg:absoluteerror, reg:quantileerror, count:poisson, reg:gamma, reg:tweedie. Was passed: reg:linear --- Backtrace: ▆ 1. └─xgboost::xgboost(...) 2. └─xgboost:::process.y.margin.and.objective(...) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: processing vignette 'xgb2sql.Rmd' failed with diagnostics: Got numeric 'y' - supported objectives for this data are: reg:squarederror, reg:squaredlogerror, reg:logistic, reg:pseudohubererror, reg:absoluteerror, reg:quantileerror, count:poisson, reg:gamma, reg:tweedie. Was passed: reg:linear --- failed re-building 'xgb2sql.Rmd' SUMMARY: processing the following file failed: 'xgb2sql.Rmd' Error: Vignette re-building failed. Execution halted * checking PDF version of manual ... [18s] OK * checking HTML version of manual ... [1s] OK * DONE Status: 2 ERRORs, 1 NOTE