Player clips into the ground when I press the restart button

The title says it all. I have a subway surfers like game prototype, where I just added a restart button that can reload the scene. However whenever I press restart the charaters gets into a slightly lower position. After a few deaths the player is clipped into the ground and cannot jump at all. I looked up so many similar questions, all about checking colliders and rigidbodies but I personally couldn’t find anything. It also has to do something with my gravity and stuff. Because I have a gravity modifier that if I set to 1, this issue never happens. The problem is, that then the player jumps around like he is on the moon. I also tried an experiment where I started my player from the air, not from the ground. And with every single restart the player fell faster and faster eventually falling trough the ground once again. So something can be with gravity. This is what I have in the character controller. I wasn’t satisfied with my physics and I wanted it to make a bit more interesting.

I tried readding colliders, putting the same scripts on brand new objects, checking on and off rigidbody options.

void Start()     {         playerRb = GetComponent<Rigidbody>();         Physics.gravity *= gravityModifier;     }      // Update is called once per frame     void Update()     {         Vector3 xPos = new Vector3(xRange, 0, 0);         if (Input.GetKeyDown(KeyCode.Space) && isOnGround)         {             playerRb.AddForce(Vector3.up * jumpForce, ForceMode.Impulse);             isOnGround = false;         } 

SQL Database stuck In Recovery state after restart

SQL Server was restarted by mistake, when it came online, database came back in "In Recovery" mode.

Check from error it says "Recovery of database ‘DB1’ (5) is 8% complete (approximately 27146 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

It says it will 8 hours to bring this 2tb database online.

Any quick way to fix this, as we didnt had anything open in LOG files, so even if they r ignored, its no impact.

We want to bring this database ONLINE quickly

Windows wants to install an old version even though i have the latest one, already downloaded it just needs restart, how do i know if it’s safe?

Here is the screenshot of my updates history/status.

Here in this dropbox picture there are 2 comments with all the info.

I can not enter Digital ocean droplet and restart it

I installed ubuntu 18 on Digital ocean droplet several days ago with ssh access, but tring to
get to it I got error in my console :
ssh: connect to host NNN.NNN.NNN.NNN port 22: Connection timed out
I opened droplet in DO settings and saw:

That is very strange and That is out of my expierence, I have no option to restart the droplet.
How to fix it?


MySQL 5.7 on W2K12 essentials – starts fine and then fails after restart

I have a W2K12 Essentials server that I’m trying to get MySQL 5.7 running on for in house development. It installs just fine – I change install and data directories to two separate directories on the D:\ drive.

Service starts as normal. I stop it, go in and change the Logon to Local System Account with Allow Service to Interact with Desktop (installer sets it to Network Service). Restart service just fine.

Open up my.cnf to change the innodb_buffer_pool_size to 1G. Save changes. Won’t start (Services hangs on Starting). Revert change back to 8M. Service still won’t start and eventually fails.

Event viewer shows “The MySQL57 service terminated unexpectedly. It has done this 2 time(s).”

Task manager shows mysqld running but using only about 1.2mb of memory.

UPDATE – just uninstalled and reinstalled again. Left the Log on as Network Service, but gave Network Service full permissions on my MySQL folder and my MySQLData folder.

Stopped and restarted numerous times.

Copy my.cnf to a safe place. Change innodb_buffer_pool_size from 8M to 48M. Won’t start (again Task Manager shows 1.3mb memory usage). Kill task. Switch it back to 8M. Still won’t start. Overwrite my.cnf with my backup copy and now it works again. I am changing nothing else in that file and using notepad.exe to edit it.

AutoNumber Column Task ID restart every year

I am trying to create a column with increment number when adding a new task, but restart every year, for instance in year of 2017, i would like to Task ID looks like this: 2017-001, 2017-002, 2017-003 and so on.

Also it will restart back to 001 when the date is 2018, for instance in year of 2018, Task ID will look like this: 2018-001, 2018-002, 2018-003

How would i do this? Please help!

Ubuntu 16.04 freezes at Shutdown and restart

Im shashikanth from India. i have reinstalled Ubuntu 16.04 via USB pendrive in DELL Inspiron 15 7577 system. Ubuntu OS doesn’t shut down normally after re-installation. I have to forcefully press the shutdown button for it. I have seen this below links and tried to rectify the error and resolve it but it didn’t work out.

My Ubuntu won't shutdown

Ubuntu 16.04 hangs on shutdown/restart

i tried to install nvidia drivers manually but the screen freezes for this step also.

Can Any Help me resolve this issue asap

Thank you

Ubuntu Server 18.04 Having to restart MySQL service every few hours

I have an Ubuntu server I have set up on my local network. I recently installed MySQL Server on it, and followed a guide for letting it through UFW firewalls and setting the services to autostart. After reboots OR after a few hours of being idle, I am having to restart the MySQL services in order to connect via MySQL Workbench from my desktop. When I attempt to connect I just get a “Can not connect to Database Server” error message. I go into Cockpit (Web server manager) and I can see the services is running “MySQL Community Server : active (running)”

When I restart the services via cockpit or command line, the problem is resolved and I can connect again from MySQL Workbench. I have done some googling around but every search is bringing back posts about how to reset the admin password, which I don’t need to do and I think is unrelated.

Any suggestions? Thanks,

Edit: Output from systemctl status mysql during issue.

mysql.service - MySQL Community Server    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)    Active: active (running) since Thu 2019-10-03 02:24:04 UTC; 56s ago   Process: 1950 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/ (code=exited, statu   Process: 1525 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)  Main PID: 1952 (mysqld)     Tasks: 27 (limit: 4915)    CGroup: /system.slice/mysql.service            └─1952 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/  Oct 03 02:23:36 server systemd[1]: Starting MySQL Community Server... Oct 03 02:24:04 server systemd[1]: Started MySQL Community Server. 

Webpage isn’t updating changes unless I restart apache2

I’ve been searching for a solution to this problem for a very long time now and I just can’t seem to figure it out.

I’ve installed apache2 and mysql and php7.0 on a fresh install of ubuntu yet the problem stil persists.

Just trying to create an ideal web development environment. The process goes as follows: 1) start apache2 && mysql 2) make changes to my index.php file in /var/www/html 3) check my ip using ifconfig and then go to that adress 4) notice my changes haven’t taken place!! 5) restart apache2 6) refresh my page and realize that the changes have been made

Why wont apache2 recognize changes made without having to completely restart the service everytime???