Troubleshooting of Navicat for PostgreSQL

Troubleshooting of Navicat for PostgreSQL

How to fix The numeric column data all became null after imported

Solution:

• If the original data is Excel file, modify the format of the column from general to numeric
• import the data into Navicat for PostgreSQL again

How to fix ERROR: value too long for type character varying(255)

Solution:

• Increase the length of the column from varchar(255) to text

Troubleshooting of ...

• Troubleshooting of Excel errors

• PHP, cUrl, Python, selenium, HTTP status code errors

• Database: SQL syntax debug, MySQL errors, MySQLTuner errors or PostgreSQL errors

• Troubleshooting of regular expression

• HTML/Javascript: Troubleshooting of javascript, XPath

• Software: Mediawiki, Docker, FTP problems, online conference software

• Test connectivity for the web service, Web Ping, Network problem, Web user behavior, Web scrape troubleshooting

Template

• Bug report template