TYPO3 Core

Do you have tried to enable the dbal-debug code?
Does this print any errors during the queries?

Thanks for the advice - I've turned on dbal debugging now.
Yes, there has been an error.
I made screenshots of all important log-informations.

Put it all together in a Word File (t3_dbal_debug.zip) and as a txt file with images (t3_dbal_debug_txt_file.zip).

Hi, could those of you seeing this problem tell me what PHP version is used? Thanks.

I doubt the fix from Felix is correct, ADOdb does support ADODB_FETCH_BOTH.

Hi Kasten,

same problem here with PHP version 4.4.6.
With Felix patch the problem is solved!

Greets,
MB

The patch of Felix works fine and is needed for me to show more than 2 levels (+ patch of daniel)

I can also report success with Felix patch. Though I got problems again when installing templavoila, then the tree for the sub pages created by TV wizard doesn't appear and the listview doesn't list records anymore either. which it did before installing TV. However existing and new pages created outside root page connected to TV are shown and handled great. We're running PHP 5.2.4 and MSSQL 2005.

Hi,

Is this issue still a problem for you with latest TYPO3 version?

If so, I'll have a look at this and fix it (would be great to get some euros back for work on DBAL :D), otherwise I'll close this issue as I could not reproduce it.

If it still happens for you, please give more information in order for me to be able to reproduce the issue.

Committed 4640_v2.diff:

- trunk (rev. 30854)
- DBAL_1-0 (rev. 30855)

I still want to test whether problem with number of levels in pagetree is now solved before setting this bug to resolved.

Using standard page module (not TemplaVoilà), I cannot show more than a single level (root + first level). Patch of Felix does not help in 4.4-dev (trunk at the moment).

The (+) icon is properly shown but when I click on it to open 2nd level, the whole tree closes. Opening it again only shows 1st level again.

I now have a huge number of copies of the first node shown when I try to open it

Problem understood! Autoincrement did not work with PDO. I created first page manually in MSSQL (with uid=1) and then created a subpage from within TYPO3 and it got uid=0 with pid=1. Somehow this created a circular reference when showing the page tree.

@Tolleiv Nietsch, I'll move it to the DBAL bugtracker

Hello,

since we have a productive (!) website using dbal and MSSQL with obdc I can confirm that this is solved.

Greets