Solved errors
Direct solutions to common programming errors and system issues.
Page 9 of 17
pymssql: sqlfront.h Not Found Error
When you install pymssql and you get the error: src/_mssql.c:568:22: fatal error: sqlfront.h: No such file or directory. try to install freetds-dev with apt (sudo apt install freetds-dev)
Python: pip is broken. _internal module cannot be imported
The error is common after you execute "pip install pip -U" and you will see the error "ImportError: No module named _internal" everytime you execute "pip". One solution is to change the import on the pip file: **from pip import main**, change that line with **from pip._internal import main**. Check here for alternative solutions to this error.
pip: module has no attribute main Error
If you are using pip and get the following import error: AttributeError: 'module' object has no attribute 'main' you can import main from pip._internal. Check here for the complete solution
vxworks: Get memory map of a downloadable project
To get the memory map in vxWorks use lkup "" > memory_map_vxworks.txt. lkup will list vxWorks symbols from the system symbol table.
Fix Wine Install on Ubuntu 64bit: Broken Packages
If you get "E: Unable to correct problems, you have held broken packages." error while you install wine via apt, you need to enable i386 architecture. See here how to install wine in a few steps...
gpg: signing failed: Inappropriate ioctl for device
If you got the error "Inappropriate ioctl for device", try to execute export GPG_TTY=$(tty). See here for more details on the solution
Angular ng serve: Use of const in strict mode Error
If when running ng serve --open you got the error SyntaxError: Use of const in strict mode. Make sure you are using node 6.9.0 at least.
How to show seconds/minutes or years ago using javascript
Sometimes you want to show the user dates in a better way like " a few seconds ago", " two minutes ago", etc. In this brief solution we explain how to use momemnt.js to convert a date or string to this format.
SQL Server: Add Column with ALTER TABLE
In this solution we are going to review how to add a column to an existing table on SQL Server with default values. In this small solution you will learn how to add a columns in table. You can use the ALTER TABLE statement in SQL Server. We will show an example using the NOT NULL constraint.
Solved! Fiona 1.7.1 missing GeoPackage & FileGDB
If you are missing GeoPackages or ESRI FileGDB as suuported drivers, execute: pip install -I fiona --no-binary fiona. This will compile the source of Fiona and link to your installed libraries. Check here for full description of the problem.