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

• 0x800703fa
• 0x8e5e03fa
• 2038
• ADO.net
• Column
• Corruption
• cx_Oracle
• CXT
• Cypher
• Data
• DateTime
• Delete
• Errors
• Extensions
• Fix
• Future
• Graphs
• HowTo
• Installation
• Int
• JET
• libcrypt
• Modules
• MSYS2
• MySQL
• Neo4j
• Nodes
• Oracle
• Overflow
• phpMyAdmin
• PIP
• Python
• Query
• Relationships
• SQL
• SqlDataReader
• Timestamp
• Types
• Updates
• Windows
• WordPress
• wp_options

Fix: WordPress not detecting updates, wp_options table corruption
26 Ιανουαρίου 21 05:35 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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 […]

Δημοσίευση στην κατηγορία: WordPress, Posts, Fix, Updates, Database, Corruption, MySQL, phpMyAdmin, wp_options

HowTo: Install Python, PIP and cx_Oracle on MSYS2 / Windows
23 Αυγούστου 20 03:12 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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 Size:        0.00 MiB :: Proceed with installation? [Y/n] y … $ pacman -S […]

Δημοσίευση στην κατηγορία: Windows, Posts, HowTo, Installation, Database, Python, MSYS2, CXT, PIP, cx_Oracle, Oracle, libcrypt, Modules

MySQL DATETIME vs TIMESTAMP and the year 2038
01 Νοεμβρίου 19 09:45 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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 in 'YYYY-MM-DD HH:MM:SS' […]

Δημοσίευση στην κατηγορία: Posts, Data, Database, Types, SQL, DateTime, Future, Timestamp, Overflow, 2038, MySQL

How-to: get int value via ADO.net SqlDataReader using column name
21 Ιανουαρίου 19 08:54 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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 ordinal). Would be nice if Microsoft was providing such things out of the box. namespace adonet.extensions […]

Δημοσίευση στην κατηγορία: Posts, Extensions, HowTo, Database, SQL, ADO.net, Int, Column, SqlDataReader

Fix: Windows Update 0x8e5e03fa, 0x800703fa errors
20 Νοεμβρίου 17 03:15 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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. Trying to […]

Δημοσίευση στην κατηγορία: Windows, Posts, Errors, Fix, Updates, Database, 0x8e5e03fa, 0x800703fa, JET, Corruption

HowTo: Delete all nodes and relationships from Neo4j graph database
18 Απριλίου 15 02:54 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

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 (n{some_field:"some_val"}) optional match (n)-[r]-() delete n,r So, to delete all nodes (including disconnected ones) and […]

Δημοσίευση στην κατηγορία: Posts, HowTo, Cypher, Relationships, Query, Graphs, Nodes, Neo4j, Delete, Database