Project

General

Profile

Actions

Bug #67059

closed

AdoDB error with PostgreSQL

Added by alexis nicolas over 9 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-05-20
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.5
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

In v7.2 with postgre driver (v9.2):
Core: Error handler (BE): PHP Warning: pg_query(): Query failed: ERREUR: erreur de syntaxe sur ou près de « ) »
LINE 4: ) VALUES (
^ in xxx/typo3/sysext/adodb/adodb/drivers/adodb-postgres7.inc.php line 219


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Epic #64459: Make TYPO3 run on PostgreSQLClosed2015-05-21

Actions
Related to TYPO3 Core - Bug #67668: PostgreSQL needs escaping for BLOB fieldsClosed2015-06-21

Actions
Actions #1

Updated by alexis nicolas over 9 years ago

Sorry, I gave too few (and wrong) information:
When I click on modules 'View', 'Filelist', 'Language', 'Extensions', 'Access', 'Backend users', 'Reports' or 'Log' I got a PHP error in BE:

#1: PHP Warning: pg_query(): in C:\wamp\www\typo3_7.2\typo3\sysext\adodb\adodb\drivers\adodb-postgres7.inc.php line 219

And in php_error.log:

[20-May-2015 16:01:23 Europe/Paris] PHP Fatal error: Call to a member function includeLLFile() on a non-object in C:\wamp\www\typo3_7.2\typo3\sysext\dbal\mod1\index.php on line 22

[20-May-2015 16:01:23 Europe/Paris] PHP Stack trace:

[20-May-2015 16:01:23 Europe/Paris] PHP 1. {main}() C:\wamp\www\typo3_7.2\typo3\mod.php:0

[20-May-2015 16:01:23 Europe/Paris] PHP 2. TYPO3\CMS\Core\Core\Bootstrap->run() C:\wamp\www\typo3_7.2\typo3\mod.php:24

[20-May-2015 16:01:23 Europe/Paris] PHP 3. TYPO3\CMS\Backend\BackendModuleRequestHandler->handleRequest() C:\wamp\www\typo3_7.2\typo3\sysext\core\Classes\Core\Bootstrap.php:191

[20-May-2015 16:01:23 Europe/Paris] PHP 4. TYPO3\CMS\Backend\BackendModuleRequestHandler->callTraditionalModule() C:\wamp\www\typo3_7.2\typo3\sysext\backend\Classes\BackendModuleRequestHandler.php:74

[20-May-2015 16:01:23 Europe/Paris] PHP 5. require() C:\wamp\www\typo3_7.2\typo3\sysext\backend\Classes\BackendModuleRequestHandler.php:164

Actions #2

Updated by alexis nicolas over 9 years ago

  • % Done changed from 0 to 100

Problem solved after (I presume) cleaning some records from pages table... Weird!

Actions #3

Updated by alexis nicolas over 9 years ago

  • Assignee set to Markus Klein
Actions #4

Updated by Markus Klein over 9 years ago

  • Assignee deleted (Markus Klein)

I can't help here, sorry.

Actions #5

Updated by Morton Jonuschat about 8 years ago

  • Status changed from New to Closed

Solved in master by switching to Doctrine DBAL and removing AdoDB.

Actions

Also available in: Atom PDF