N
N
Ninja Mate2016-07-29 18:48:27
MySQL
Ninja Mate, 2016-07-29 18:48:27

What could be the problem with DB connection on Amazon server?

Strange things are happening...

There is an application on JS + PHP + WP, after transferring to Amazon, records are no longer made to the database, but not quite, records are entered into one table 'activity' (the same database) perfectly, but not in others , there are also 3 almost identical tables with the same code, but you can make changes to 2 (not new records), but not to one.

There are no connection errors, data is not entered.
Where to dig?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
N
Ninja Mate, 2016-07-30
@victorzadorozhnyy

Go to phpmyadmin select database > SQL and run
SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
the problem is that new versions, when writing to a qveri table, in which instead of int there are empty '' in the new database 5.7.12 - MySQL does not auto-fill with zero.

P
Puma Thailand, 2016-07-29
@opium

see what error the insert gives

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question