@@ -153,8 +153,8 @@ |
||
153 | 153 | { |
154 | 154 | $map = []; |
155 | 155 | |
156 | - $conn = $this->context()->db( 'db-locale' ); |
|
157 | - $tconn = $this->context()->db( 'db-locale', true ); |
|
156 | + $conn = $this->context()->db( 'db-locale' ); |
|
157 | + $tconn = $this->context()->db( 'db-locale', true ); |
|
158 | 158 | |
159 | 159 | $type = \Aimeos\Base\DB\Statement\Base::PARAM_INT; |
160 | 160 | $roots = $conn->create( 'SELECT id, nleft, nright FROM mshop_locale_site WHERE level = 0' )->execute(); |
@@ -39,9 +39,12 @@ |
||
39 | 39 | { |
40 | 40 | $db->for( 'mysql', 'CREATE FULLTEXT INDEX `idx_msindte_content` ON `mshop_index_text` (`content`)' ); |
41 | 41 | |
42 | - try { |
|
42 | + try |
|
43 | + { |
|
43 | 44 | $db->for( 'postgresql', 'CREATE INDEX "idx_msindte_content" ON "mshop_index_text" USING GIN (to_tsvector(\'english\', "content"))' ); |
44 | - } catch( \Exception $e ) { |
|
45 | + } |
|
46 | + catch( \Exception $e ) |
|
47 | + { |
|
45 | 48 | // Doctrine DBAL bug: https://github.com/doctrine/dbal/issues/5351 |
46 | 49 | } |
47 | 50 | } |
@@ -269,9 +269,12 @@ discard block |
||
269 | 269 | */ |
270 | 270 | public function create( array $values = [] ) : \Aimeos\MShop\Common\Item\Iface |
271 | 271 | { |
272 | - try { |
|
272 | + try |
|
273 | + { |
|
273 | 274 | $values['log.siteid'] = $this->context()->locale()->getSiteId(); |
274 | - } catch( \Exception $e ) { |
|
275 | + } |
|
276 | + catch( \Exception $e ) |
|
277 | + { |
|
275 | 278 | $values['log.siteid'] = null; |
276 | 279 | } |
277 | 280 | |
@@ -295,9 +298,12 @@ discard block |
||
295 | 298 | $context = $this->context(); |
296 | 299 | $conn = $context->db( $this->getResourceName() ); |
297 | 300 | |
298 | - try { |
|
301 | + try |
|
302 | + { |
|
299 | 303 | $siteid = $context->locale()->getSiteId(); |
300 | - } catch( \Exception $e ) { |
|
304 | + } |
|
305 | + catch( \Exception $e ) |
|
306 | + { |
|
301 | 307 | $siteid = ''; |
302 | 308 | } |
303 | 309 | |
@@ -343,8 +349,7 @@ discard block |
||
343 | 349 | */ |
344 | 350 | $path = 'madmin/log/manager/insert'; |
345 | 351 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
346 | - } |
|
347 | - else |
|
352 | + } else |
|
348 | 353 | { |
349 | 354 | /** madmin/log/manager/update/mysql |
350 | 355 | * Updates an existing log record in the database |
@@ -307,8 +307,7 @@ |
||
307 | 307 | */ |
308 | 308 | $path = 'madmin/job/manager/insert'; |
309 | 309 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
310 | - } |
|
311 | - else |
|
310 | + } else |
|
312 | 311 | { |
313 | 312 | /** madmin/job/manager/update/mysql |
314 | 313 | * Updates an existing job record in the database |
@@ -434,8 +434,7 @@ |
||
434 | 434 | */ |
435 | 435 | $path = 'mshop/subscription/manager/insert'; |
436 | 436 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
437 | - } |
|
438 | - else |
|
437 | + } else |
|
439 | 438 | { |
440 | 439 | /** mshop/subscription/manager/update/mysql |
441 | 440 | * Updates an existing subscription record in the database |
@@ -451,8 +451,7 @@ |
||
451 | 451 | */ |
452 | 452 | $path = 'mshop/plugin/manager/insert'; |
453 | 453 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
454 | - } |
|
455 | - else |
|
454 | + } else |
|
456 | 455 | { |
457 | 456 | /** mshop/plugin/manager/update/mysql |
458 | 457 | * Updates an existing plugin record in the database |
@@ -484,8 +484,7 @@ |
||
484 | 484 | */ |
485 | 485 | $path = 'mshop/rule/manager/insert'; |
486 | 486 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
487 | - } |
|
488 | - else |
|
487 | + } else |
|
489 | 488 | { |
490 | 489 | /** mshop/rule/manager/update/mysql |
491 | 490 | * Updates an existing rule record in the database |
@@ -548,8 +548,7 @@ |
||
548 | 548 | */ |
549 | 549 | $path = 'mshop/price/manager/insert'; |
550 | 550 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
551 | - } |
|
552 | - else |
|
551 | + } else |
|
553 | 552 | { |
554 | 553 | /** mshop/price/manager/update/mysql |
555 | 554 | * Updates an existing price record in the database |
@@ -314,8 +314,7 @@ |
||
314 | 314 | */ |
315 | 315 | $path = 'mshop/stock/manager/insert'; |
316 | 316 | $sql = $this->addSqlColumns( array_keys( $columns ), $this->getSqlConfig( $path ) ); |
317 | - } |
|
318 | - else |
|
317 | + } else |
|
319 | 318 | { |
320 | 319 | /** mshop/stock/manager/update/mysql |
321 | 320 | * Updates an existing product stock record in the database |