myaac_movie

[QuebradaZN]

Can I get the complete database?

https://prnt.sc/staj7r

[slawkens]

Which version of MyAAC are you trying to install?

[QuebradaZN]

I think the most recent, I pulled this one from Git

[slawkens]

You can see version in Admin Panel

[slawkens]

BTW. There is something wrong with your database, because migrations/2.php shouldn't be executed on newest versions. Is that an old database?

[QuebradaZN]

Newer version installed, no installation errors, only when running the site
https://prnt.sc/stb7kf
https://prnt.sc/stb7g7
https://prnt.sc/stb6zz

[slawkens]

did you import the myaac database schema.sql manually to your database?

[QuebradaZN]

I did it 2 ways, imported it manually and did the installation / install

[QuebradaZN]

SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'body' can't have a default value

Backtrace:

#0 /var/www/html/system/libs/pot/OTS_Base_DB.php(85): PDO->query('ALTER TABLE my...') #1 /var/www/html/system/migrations/2.php(5): OTS_Base_DB->query('ALTER TABLE my...')
#2 /var/www/html/system/migrate.php(10): require('/var/www/html/s...')
#3 /var/www/html/index.php(189): require('/var/www/html/s...')
#4 {main}

[slawkens]

If you imported manually, then you need to execute this in your phpmyadmin:

UPDATE `myaac_config` SET value = 30 WHERE name = "database_version";

After that, the migrations won'e be executed at all, because they shouldn't.

[QuebradaZN]

Solved... Perfect! <3

[slawkens]

Sorry, my query was wrong.

That's the correct one:

UPDATE `myaac_config` SET value = 30 WHERE name = "database_version";