Καλώς ορίσατε στο dotNETZone.gr - Σύνδεση | Εγγραφή | Βοήθεια
σε

 

Αρχική σελίδα Ιστολόγια Συζητήσεις Εκθέσεις Φωτογραφιών Αρχειοθήκες

Παρουσίαση με Ετικέτες

Όλες οι Ετικέτε... » Posts » Database   (RSS)
  • Fix: WordPress not detecting updates, wp_options table corruption

    I have been trying recently to troubleshoot a WordPress website that was not detecting available core and plugin updates. So I installed WordPress Debug Bar plugin and after enabling WP_DEBUG in wp-config.php I could open the Debug menu from the WordPress admin bar and see some errors being logged. At the wp-content/wp-debug.log file that I ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Ιανουαρίου 26, 2021
  • HowTo: Install Python, PIP and cx_Oracle on MSYS2 / Windows

    Here’s how to install Python, PIP package installer and cx_Oracle extension module on MSYS2: $ pacman -S python warning: python-3.8.3-1 is up to date — reinstalling resolving dependencies… looking for conflicting packages… Packages (1) python-3.8.3-1 Total Installed Size:  108.66 MiB Net Upgrade ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Αυγούστου 23, 2020
  • MySQL DATETIME vs TIMESTAMP and the year 2038

    Judging from MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/datetime.html, it sounds best to use DATETIME rather than TIMESTAMP if you want your database to be future proof. After all 2038 is only 18+ years away. The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Νοεμβρίου 1, 2019
  • How-to: get int value via ADO.net SqlDataReader using column name

    Based on Sam Holder’s answer at https://stackoverflow.com/questions/7388475/reading-int-values-from-sqldatareader/54296026, just contributed an extension method for fetching Int32 values via ADO.net’s SqlDataReader, without jumping through hoops (aka first fetch column ordinal [number] by name, then fetching the int value passing the column ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Ιανουαρίου 21, 2019
  • Fix: Windows Update 0x8e5e03fa, 0x800703fa errors

    Sometime ago, I was receiving errors 0x8e5e03fa and 0x800703fa on several pending updates at Windows 10’s Update pane (found at Settings / Updates & Security / Windows Update from the Start menu). The updates history wasn’t showing many more details, but could see Knowldege Base article numbers (KBxx) for some pending cummulative updates. ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Νοεμβρίου 20, 2017
  • HowTo: Delete all nodes and relationships from Neo4j graph database

    At a Neo4j question in http://stackoverflow.com/questions/19624414/delete-node-and-relationships-using-cypher-query-over-rest-api, a recent reply (older ones use obsolete Cypher syntax) says: Both START and the [r?] syntax are being phased out. It’s also usually not advised to directly use internal ids. Try something like: match ...
    Δημοσιεύτηκε στο George Birbilis' blog (Weblog) από το μέλος birbilis στις Απριλίου 18, 2015
Με χρήση του Community Server (Commercial Edition), από την Telligent Systems