Bug #67172: AdoDB error on editing a page - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #67172

closed

AdoDB error on editing a page

Added by alexis nicolas almost 9 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2015-05-27

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

5.5

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

In dev master using postgresql (with dbal and adodb), when clicking on Edit page properties in BE I get this error:

#1421053336: ADOdb could not run this query: SELECT "uid" FROM "sys_category" WHERE FIND_IN_SET('0', "parent") != 0 OR "parent" = ''

This error is thrown by a "if (!is_object($sqlResult))" test ($sqlResult is a huge amount of "object(ADORecordSet_postgres8)" whereas it should be, I presume, one single object).
I can't locate where this $sqlResult comes from.

Related issues 2 (0 open — 2 closed)

Actions

Copy link

Updated by alexis nicolas almost 9 years ago

Additional information:

Script mod.php?M=record_edit&moduleToken=8122495a9af184a42f55f1a33fe13fd6012a2294&edit[pages]¹¹²=edit&returnUrl=/TYPO3.CMS/typo3/mod.php?M=Dweb_layout/moduleToken=D0fb5f69ddc295f9dcc6263262f151a9c54613b9e&id=112 returns a 500 error whereas I'm on a localhost.

PostrgreSQL log returns:

function find_in_set(unknown, bigint) doesn't exist
No function matches given name and argument type
You must add explicit type cast

Actions

Copy link

Updated by alexis nicolas almost 9 years ago

% Done changed from 0 to 100

Solution given in #46271 works here.

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

Updated by Gerrit Code Review almost 9 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/39779

Actions

Copy link

#10

Updated by Morton Jonuschat almost 9 years ago

Status changed from Under Review to Resolved

Applied in changeset 14f04a6a526ce654c86e7e62bcf4cb09cfca6eb2.

Actions

Copy link

#11

Updated by Gerrit Code Review almost 9 years ago

Status changed from Resolved to Under Review

Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/41842

Actions

Copy link

#12