This is on Windows Server 2019 on a machine I purchased to run a development environment and a bit of monitoring.
New setup using Xampp 7.4
MySQL MariaDB 10.4.17
Every attempt it creates a table called oc_migrations and nothing more, despite being a local mysql databas on port 3306 and root access with FULL privileges.
From what I gather searchin on that SQLSTATE code it seems to be generated by a typo or a mismatch or something I don’t know how it appeared. Since it creates that table it does communicate with the database server, but fails after that one table creation. I have downloaded your full v 20 package and copied the files to xampp’s htdocs folder to run the site from there.
Have you tried deleting entire Database and start again?
Check the permissions in the creation of database:
CREATE DATABASE nextcloudDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'nextcloud1'@'localhost' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON nextcloudDB.* TO 'nextcloud1'@'localhost';
I deleted the database and started over three times in a row…
Thanks, that did not help, despite creating the database . It still only creates the oc_migrations table…
An exception occurred while executing ‘SELECT uid, displayname FROM oc_users WHERE uid_lower = ?’ with params [“nextcloud”]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextclouddb.oc_users’ doesn’t exist
I could try creating and populating the database manually and then skip the setup… its a thing I have done many times when moving sites, albeit not with Nextcloud. What file has the DB entries…?
Not interested in doing it that way since it adds an additonal hurdle in regards to system file access in Windows. Linix is crappy, been at it, there are like 25 different ways to do things, there are hardly any standards and I am fed yup with trying 5 different distros that all have a sligthly different approach in how to achive a wanted result. yum, zypper, dnf, bash CRAP
I share the frustration as the original poster of this issue. I’m trying to get XAMPP/PHP/MySQL working on Windows 10 as well, but running into the same issue. Saying “windows isn’t supported” is garbage as I’m afraid to say the vast majority of OS market share is still Windows users. I unfortunately made the switch to OwnCloud because of this issue.
A better way to approach this issue would be to figure out why oc_users isn’t being created as part of the database creation process, but oc_migrations is. When I look at the nextcloud.log file, I see an error message that says something to the effect of
“Host localhost was not connected because it violates local access rules”, which is odd as the user I created has full privileges, but I assume this same thing happens if using the default root user as well.
My advice to the developers, download the 3 latest stable versions of NextCloud, the 3 latest versions of PHP, and the 3 latest versions of XAMPP onto a Windows 10 machine, and try to set up a server using XAMPP’s PHP and MySQL data. A tip, drag and drop the 3 NextCloud folders into the xampp/htdocs folder and call them nextcloud1, nextcloud2, nextcloud3 to make them easier to navigate to. This shouldn’t be too hard to diagnose for the developers who know where to look at the logs, etc. But if at the end of the day it just plain old doesn’t work cuz windows, switch to OwnCloud.
That may be true for the desktop market. On the server market it looks quite different. Depending on which statistics you look at, the market share of Windows on servers is well below 50%. And for web services that run on a LAMP or LEMP stack, it’s probably way less.
OwnCloud doesn’t officially support Windows either.
It’s from 2015 but I couldn’t find anything on the website that says this has changed in the meantime. The official solution to run it on Windows at that time was to use a VirtualBox VM with Linux. Today you could also use WSL2, which is basically a Linux VM too.
Worked for me, so I’m happy, basically doing the exact same setup routine, so something’s not working on the NextCloud side. Hope Windows sees some support soon as I’ve seen quite a few posts re: this issue.
Yeah but if it isn’t officialy supported it can also break at any time. I hope you are using this set-up only for personal use and not in production for a company or even worse, offer it as a solution to small businesses who don’t know they are paying you for an unsupported solution.