thanks , but is there a tutorial which is am not aware of probably , in which you have covered how one can send data and be updated automatically in a shiny app , let say every time there is change in such data stream(think of TH-cam comments or product reviews by customers on eBay) and how such new data points are being updated - after probably some basic data analysis or not - have you already covered that ?
Attempting to troubleshoot a problem with the "odbc" package. It throws an error when running the library(odbc) line. Error is as follows: Error: package or namespace load failed for ‘odbc’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]): namespace ‘rlang’ 0.4.11 is already loaded, but >= 1.0.2 is required So far I've: 1) Installed the newest version of r and r studio and restarted the r studio session and still got the same error. 2) Tried remove.packages(rlang) and then install.packages("rlang") 3) install.packages("Rtools") With a few other attempts to restart and delete old R files to start from scratch and not able to get past this error. Any suggestions?
Hello Joshua, The error message suggests that the package 'odbc' requires a more recent version of the 'rlang' package (at least version 1.0.2) than the one that's currently loaded in your session (version 0.4.11). You've already tried some good troubleshooting steps, but it seems like there's still an older version of 'rlang' interfering. Here are a few suggestions to try: 1)Update rlang package. Sometimes, a simple package update could resolve the issue. Please try: update.packages("rlang") 2)Check and remove all instances of rlang: Make sure you've removed all instances of 'rlang' from all your library paths. You can check your library paths and the packages installed in them with: .libPaths() installed.packages() If 'rlang' appears in more than one place, you might need to remove it from each library path before reinstalling it. For example: remove.packages("rlang", lib = "path_to_your_library") After removal, install the newest version of rlang: install.packages("rlang") 3)Check the package dependencies: Check that the dependencies for the 'odbc' package are correctly installed. You can do this using: install.packages("odbc", dependencies = TRUE) This will also try to update 'rlang' if it is a dependency of 'odbc'. 4)Use devtools package to install rlang from source: If none of the above steps work, it might be a good idea to try installing 'rlang' from source. The 'devtools' package can be used to install packages from their GitHub repositories. Here's how you can install 'rlang' from source: # If 'devtools' isn't installed if (!requireNamespace("devtools", quietly = TRUE)) install.packages("devtools") devtools::install_github("r-lib/rlang") Remember to restart your R session after trying each of these steps. Please note that due to the complex nature of package management and various environmental factors, these suggestions might not resolve your issue. If you continue to encounter problems, it may be necessary to consult with a local expert or reach out to the R community for further assistance. Regards, Cansu
@@cansustatisticsglobe thank you for the help. Solution 1) resulted in the same issue as before Solution 2) stated unexpected messages when I did the remove and install rlang steps: (Error in remove.packages : there is no package called ‘rlang’) (Error in install.packages : Updating loaded packages) But Solution 2 appears to have worked. *will update on this if something changes Thanks a lot!
That generic con code breaks. Even with eval=FALSE it will not run. This is the error I get: Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'driver_name' : file not found The only way around it is to comment it out. Any thoughts? I first encountered this in Quarto and then again in RMarkdown Notebook.
Hey Haraldur, sorry for the delayed response, I was on vacation and couldn't reply earlier. Do you still need help with this error message? Regards, Joachim
Thank you for the comment and taking the time to give us feedback! We really appreciate that. Sad to hear that the video was too theoretically for you.
Great tutorial! Thanks
Thanks Mehmet, glad you like my videos!
You are genius, thanks a lot!
Hi Ignat, thank you very much for the positive feedback, glad you like the video!
thanks , but is there a tutorial which is am not aware of probably , in which you have covered how one can send data and be updated automatically in a shiny app , let say every time there is change in such data stream(think of TH-cam comments or product reviews by customers on eBay) and how such new data points are being updated - after probably some basic data analysis or not - have you already covered that ?
Hey, unfortunately, I don't have a tutorial about this yet. However, this might be a good topic for a future tutorial.
This is excellent!
Thank you Wayne, glad you think so! :)
Gracias, muy amable de su parte.
Thank you Rogelio, nice to hear!
Attempting to troubleshoot a problem with the "odbc" package. It throws an error when running the library(odbc) line. Error is as follows:
Error: package or namespace load failed for ‘odbc’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
namespace ‘rlang’ 0.4.11 is already loaded, but >= 1.0.2 is required
So far I've:
1) Installed the newest version of r and r studio and restarted the r studio session and still got the same error.
2) Tried remove.packages(rlang) and then install.packages("rlang")
3) install.packages("Rtools")
With a few other attempts to restart and delete old R files to start from scratch and not able to get past this error.
Any suggestions?
Hello Joshua,
The error message suggests that the package 'odbc' requires a more recent version of the 'rlang' package (at least version 1.0.2) than the one that's currently loaded in your session (version 0.4.11). You've already tried some good troubleshooting steps, but it seems like there's still an older version of 'rlang' interfering.
Here are a few suggestions to try:
1)Update rlang package. Sometimes, a simple package update could resolve the issue. Please try:
update.packages("rlang")
2)Check and remove all instances of rlang:
Make sure you've removed all instances of 'rlang' from all your library paths. You can check your library paths and the packages installed in them with:
.libPaths()
installed.packages()
If 'rlang' appears in more than one place, you might need to remove it from each library path before reinstalling it. For example:
remove.packages("rlang", lib = "path_to_your_library")
After removal, install the newest version of rlang:
install.packages("rlang")
3)Check the package dependencies:
Check that the dependencies for the 'odbc' package are correctly installed. You can do this using:
install.packages("odbc", dependencies = TRUE)
This will also try to update 'rlang' if it is a dependency of 'odbc'.
4)Use devtools package to install rlang from source:
If none of the above steps work, it might be a good idea to try installing 'rlang' from source. The 'devtools' package can be used to install packages from their GitHub repositories. Here's how you can install 'rlang' from source:
# If 'devtools' isn't installed
if (!requireNamespace("devtools", quietly = TRUE))
install.packages("devtools")
devtools::install_github("r-lib/rlang")
Remember to restart your R session after trying each of these steps.
Please note that due to the complex nature of package management and various environmental factors, these suggestions might not resolve your issue. If you continue to encounter problems, it may be necessary to consult with a local expert or reach out to the R community for further assistance.
Regards,
Cansu
@@cansustatisticsglobe thank you for the help.
Solution 1) resulted in the same issue as before
Solution 2) stated unexpected messages when I did the remove and install rlang steps:
(Error in remove.packages : there is no package called ‘rlang’)
(Error in install.packages : Updating loaded packages)
But Solution 2 appears to have worked.
*will update on this if something changes
Thanks a lot!
@@infamousprince88 Great! Thank you for the feedback!
That generic con code breaks. Even with eval=FALSE it will not run. This is the error I get:
Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'driver_name' : file not found
The only way around it is to comment it out.
Any thoughts? I first encountered this in Quarto and then again in RMarkdown Notebook.
Hey Haraldur, sorry for the delayed response, I was on vacation and couldn't reply earlier. Do you still need help with this error message? Regards, Joachim
@@StatisticsGlobe I had the same error. What would be the Drive of an oracle database?
How can your connect to an existing database in MySQL workbench? Thanks
Hey James, I've headed your question over to Kirby.
@@StatisticsGlobe I'm yet to get a response to my question. Thanks
excellent
Thank you very much Aman! :)
nice!
Thank you very much, glad you like it! :)
Great!
Thank you very much Haraldur! :)
He should have connected one for us to see😢
Hey Patrick, thanks for the feedback and your input! We will keep it in mind for future videos.
this is sooo bad, your just talking about how to do it not showing
Thank you for the comment and taking the time to give us feedback! We really appreciate that. Sad to hear that the video was too theoretically for you.