search

aimeos / aimeos-core

Aimeos PHP e-commerce framework for ultra fast online shops, scalable marketplaces, complex B2B applications and #gigacommerce
https://aimeos.org
Other
3.26k stars 112 forks source link

Qoute reserved keyword in migration #308

Closed tobbe-j closed 1 year ago

tobbe-j commented 1 year ago

Bug

Some migrations were failing, caomplaining about syntax errors in the sql queries.

Problem

The queries were broken in postgresql since they used a column named end without qouting it, causing problems since end is a reserved keyword in postgresql.

Fix

Use the $db-qi(...) for those columns.

coveralls commented 1 year ago

Coverage Status

Coverage: 90.539%. Remained the same when pulling 314417f9844b203dff1c1d5717f9c1867c10ef0c on tobbe-j:patch-1 into b0b8abd113abfcb2c610669764195869d2623f0b on aimeos:master.

aimeos commented 1 year ago

Thanks a lot! :-)