I upgrade to 4.2.1 and thought I was careful to follow all the instructions.

Everything seems to be working except I can't display the page tree (when you click on Page) in the back end. What I get is:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pastorp/public_html/t3lib/class.t3lib_db.php on line 795

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pastorp/public_html/t3lib/class.t3lib_db.php on line 835

Warning: Cannot modify header information - headers already sent by (output started at /home/pastorp/public_html/t3lib/class.t3lib_db.php:1137) in /home/pastorp/public_html/typo3/template.php on line 632
The Page Tree


I turned on SQL Debug and got additional info:

debug_trackback
SC_alt_db_navframe->main#404 // webPageTree->

uid,title,doktype,php_tree_stop,t3ver_id,t3ver_state,t3ver_wsid,t3ver_swapmode,t3ver_state,t3ver_move_id,hidden,starttime,endtime,fe_group,module,extendToSubpages,is_siteroot,alias,shortcut,shortcut_mode,mount_pid,mount_pid_ol,nav_hide,nav_title,url
FROM pages
WHERE
pid='0' AND pages.deleted=0 AND 1=1
ORDER BY sorting

I've had this same error on 3 upgrades I've done and everytime it was solved by uninstalling then reinstalling extensions, the ones I found to be problems were calbase, ttnews and wecmap. Once I did this the error resolved.

Hope it helps you,
cheers,
Mark

Many thanks...
That solved the problem and I'm back in business..

Grace and Peace,
Pete

Mark and Peter,

Were these extensions upgraded to the latest versions prior to the upgrade to TYPO3 4.2? I can understand this error happening if that is the case.

In Him,
Mark

Actually, I think the problem was caused by my error in updating the database. I'm not exactly sure what I did wrong the first time.

I've just completed updating two other sites (one a mirror of the first one I had the problem with) and both upgraded without a hitch.

Pete