How can I disable MySQL Strict Mode?

This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root). You'll also be prompted for the password. This will print out something like this (but much prettier): sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_D ...

View More
  Dibaca 416 kali

PHP Session not Saving

Your session directory (probably /tmp/) is not writable. Check with session_save_path() if it is writable. if (!is_writable(session_save_path())) { echo 'Session path "'.session_save_path().'" is not writable for PHP!'; } ...

View More
  Dibaca 543 kali

Force Showing all errors and warnings in PHP

You can turn it on in the script: error_reporting(E_ALL); ini_set('display_errors', 1); ...

View More
  Dibaca 405 kali

MySQL alter table add column with primary key

ALTER TABLE t_dataDROP PRIMARY KEY,ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id);   if not a primary key ALTER TABLE t_dataADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id); ...

View More
  Dibaca 427 kali

Could not find com.android.tools.build:gradle:3.0.1

add the repository also in the app/build.gradle file: classpath 'com.android.tools.build:gradle:3.0.1' TOdependencies { classpath 'com.android.tools.build:gradle:3.1.2' classpath 'com.github.dcendents:android-maven-gradle-plugin:1.4.1'} ...

View More
  Dibaca 546 kali

Android Studio Could not find com.android.tools.lint:lint-gradle:26.1.2

in proj.android-studio/app/build.gradle Fixed after I added google() to repositories repositories {jcenter()google()}   ...

View More
  Dibaca 1263 kali

npm cant find package.json

forgot to setup the directory for express: express <yourdirectory> Once you do that you should be able to see a bunch of files, you should then run the command: npm install -d ...

View More
  Dibaca 410 kali

Reset the MySQL OR MariaDB Root Password

To change the MySQL/MariaDB root password, follow these steps: Ensure that the MySQL/MariaDB server is running. Open a new Linux terminal. Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax: mysqladmin --user=root password "newpassword"OR ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

View More
  Dibaca 414 kali