bolt: DBAL 2.6 Problems

Apart from the rest of the dramas a default install on 3.2 & 3.3 (probably all versions) give the following per platform:

Sqlite

Table bolt_pages is not the correct schema: invalid column template
Table bolt_showcases is not the correct schema: invalid column file

PostgreSQL:

Table bolt_blocks is not the correct schema: invalid column templatefields, invalid column image
Table bolt_entries is not the correct schema: invalid column templatefields, invalid column image, invalid column video
Table bolt_field_value is not the correct schema: invalid column value_json_array
Table bolt_log_change is not the correct schema: invalid column diff
Table bolt_log_system is not the correct schema: invalid column source
Table bolt_pages is not the correct schema: invalid column templatefields, invalid column image
Table bolt_showcases is not the correct schema: invalid column templatefields, invalid column geolocation, invalid column video, invalid column image, invalid column imagelist, invalid column  filelist, invalid column multiselect
Table bolt_users is not the correct schema: invalid column stack, invalid column roles

About this issue

  • Original URL
  • State: closed
  • Created 7 years ago
  • Comments: 21 (13 by maintainers)

Most upvoted comments

Well, probably best way to fix it is to check that json type exists or not and if missed (DBAL<2.6) - add own JsonType . And replace all json_array to json.

Second way is to extend JsonArrayType and turn on comment hinting.

I’m really suprized why Taluu was not added commentHint fix to JsonArrayType. (but added it to JsonType https://github.com/doctrine/dbal/blob/master/lib/Doctrine/DBAL/Types/JsonType.php#L94)

Yes, sorry. I meant Bolt 3.2 and 3.3 😃