Zuluru
after clicking Create Schema
Hi,
I have a small issue when i click create schema it tells me this error: Database Import Failed: There was a problem creating the schema table: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'phinxlog' already exists.
After deleting the phinxlog table and clicking again same issue.
Is there an issue where it tries to create the same table two times? I tried to find the file with the schema, but couldn't find it.
Thank you in advance.
Very odd, I've never seen anything like this. The phinxlog table is created automatically by the Phinx migration tool, and should be managed entirely internally by that. My code doesn't directly do anything with it. Are other tables being created, or just this one? If there are others, how many?
Okay. I have another thing to investigate in the installation process this week, and will look into this at the same time.
Ran an installation from scratch today, and it worked fine. What version of PHP and MySQL are you running this on?
Ah, this may be the problem. Testing with PHP 7.x hasn't been done yet (on the schedule for the next month or so; the underlying framework is compatible with at least 7.2).
I do know that MySQL changed an important default setting as of 5.7.5, which breaks things. If you can either use 5.7.4 or earlier, or change the "SQL mode" setting in your installation to "NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION", that will get Zuluru working with your database, and might be all that's required to fix the issue you're seeing. Again, testing and fixing Zuluru to work with 5.7.5 and beyond is on the short-term todo list, right after PHP 7.x.
I've checked in changes that get the majority of unit tests passing on PHP 7.2.16. (There are a couple issues reported in scheduling; it seems to work, but results are not as expected. Will continue to look into that.) May well work with 7.3 as well, I don't have a test bed for that right now.
Also ran the unit tests and installation with MySQL 5.7.24, and it went fine. I believe there is still an issue in there somewhere, just need to find the thing that triggers it.
Not seeing anything specific that would cause the phinxlog issue you ran into. Hoping that it's something that I resolved with the 7.2 fixes, please give it a git pull and another test and let me know how it goes.
AWS RDS MySQL instances apparently don't enable all the default modes. When I do that, the installation still runs fine, but there are problems loading pages after logging in. Unrelated to this issue, I think.