New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
I reissued already, using migration tool of cpanel, source codes and directories are same.
I think this is database problem.
I seem to remember a gotcha that might be related to this. I believe it was making sure that strick mode was disabled. Also did you make sure you created the database with the same character set and collation as before?
Check this one
https://forums.cpanel.net/threads/disable-mysql-strict-mode.424152/
also try ticketing the Cpanel team
Thank you, but looks like it was failed because i tried a suggestion of @support123.
I move manually by backup -> download -> upload. It is failed too.
your db screwed? perhaps you can try checking db for error plus admin/db details consistent with your install
Your DB isn't screwed.
Strict SQL mode is in effect if either STRICT_ALL_TABLES or STRICT_TRANS_TABLES is enabled: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict
edit the /usr/my.cnf file
You need to set your sql-mode to something that doesn't have those strict options like so:
sql-mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
restart mysql
and then on your server type mysql
and then type;
@sql_mode;
if it says something like; STRICT_TRANS_TABLES
it's still in strict mode, if not, then your good to go.
I recently enquired to WHMCS support about this and this is pretty much what they came back with.
Contact cPanel team
@sql_mode;
+--------------------------------------------+
@sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)
There is no problem with changing to strict mode. On old server, i dont change anything in my.cnf. But when i move to new server ( 3 servers on test), this problem was appeared.
You've not updated it right as 'STRICT_TRANS_TABLES' is still considered strict, please follow what I said in my last reply, it'll work for you.
THANK YOU THANK YOU!!! This should be in the support SOMEWHERE. Amazing. It's literally been years since I've been able to use my billing website. Thank you!!