Project

General

Profile

Actions
Copy link

Bug #36395

closed

Deleting a page via drap&drop issues SQL error no pid in syslog

Added by Philipp Gampe about 12 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2012-04-20
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

0    
caller    t3lib_DB::exec_SELECTquery
ERROR    Unknown column 'pid' in 'where clause'
lastBuiltQuery    SELECT COUNT(uid) FROM sys_history WHERE pid IN (239)
debug_backtrace    t3lib_div::callUserFunction#73 // call_user_func_array#4323 // t3lib_extjs_ExtDirectRouter->route# // t3lib_extjs_ExtDirectRouter->processRpc#106 // call_user_func_array#183 // t3lib_tree_pagetree_extdirect_Commands->deleteNode# // t3lib_tree_pagetree_Commands::deleteNode#97 // t3lib_tree_pagetree_Commands::processTceCmdAndDataMap#91 // t3lib_TCEmain->process_cmdmap#210 // t3lib_TCEmain->deleteAction#2509 // tx_version_tcemain->processCmdmap_deleteAction#3901 // t3lib_TCEmain->deleteEl#243 // t3lib_TCEmain->deletePages#3924 // t3lib_TCEmain->canDeletePage#4141 // t3lib_TCEmain->noRecordsFromUnallowedTables#4209 // t3lib_DB->exec_SELECTcountRows#6527 // t3lib_DB->exec_SELECTquery#337 // t3lib_DB->debug#191
1    
caller    t3lib_DB::exec_SELECTquery
ERROR    Unknown column 'pid' in 'where clause'
lastBuiltQuery    SELECT COUNT(uid) FROM sys_log WHERE pid IN (239)
debug_backtrace    t3lib_div::callUserFunction#73 // call_user_func_array#4323 // t3lib_extjs_ExtDirectRouter->route# // t3lib_extjs_ExtDirectRouter->processRpc#106 // call_user_func_array#183 // t3lib_tree_pagetree_extdirect_Commands->deleteNode# // t3lib_tree_pagetree_Commands::deleteNode#97 // t3lib_tree_pagetree_Commands::processTceCmdAndDataMap#91 // t3lib_TCEmain->process_cmdmap#210 // t3lib_TCEmain->deleteAction#2509 // tx_version_tcemain->processCmdmap_deleteAction#3901 // t3lib_TCEmain->deleteEl#243 // t3lib_TCEmain->deletePages#3924 // t3lib_TCEmain->canDeletePage#4141 // t3lib_TCEmain->noRecordsFromUnallowedTables#4209 // t3lib_DB->exec_SELECTcountRows#6527 // t3lib_DB->exec_SELECTquery#337 // t3lib_DB->debug#191
2    
caller    t3lib_DB::exec_SELECTquery
ERROR    Unknown column 'pid' in 'where clause'
lastBuiltQuery    SELECT uid FROM sys_history WHERE pid=239
debug_backtrace    t3lib_div::callUserFunction#73 // call_user_func_array#4323 // t3lib_extjs_ExtDirectRouter->route# // t3lib_extjs_ExtDirectRouter->processRpc#106 // call_user_func_array#183 // t3lib_tree_pagetree_extdirect_Commands->deleteNode# // t3lib_tree_pagetree_Commands::deleteNode#97 // t3lib_tree_pagetree_Commands::processTceCmdAndDataMap#91 // t3lib_TCEmain->process_cmdmap#210 // t3lib_TCEmain->deleteAction#2509 // tx_version_tcemain->processCmdmap_deleteAction#3901 // t3lib_TCEmain->deleteEl#243 // t3lib_TCEmain->deletePages#3924 // t3lib_TCEmain->deleteSpecificPage#4147 // t3lib_DB->exec_SELECTquery#4168 // t3lib_DB->debug#191
3    
caller    t3lib_DB::exec_SELECTquery
ERROR    Unknown column 'pid' in 'where clause'
lastBuiltQuery    SELECT uid FROM sys_log WHERE pid=239
debug_backtrace    t3lib_div::callUserFunction#73 // call_user_func_array#4323 // t3lib_extjs_ExtDirectRouter->route# // t3lib_extjs_ExtDirectRouter->processRpc#106 // call_user_func_array#183 // t3lib_tree_pagetree_extdirect_Commands->deleteNode# // t3lib_tree_pagetree_Commands::deleteNode#97 // t3lib_tree_pagetree_Commands::processTceCmdAndDataMap#91 // t3lib_TCEmain->process_cmdmap#210 // t3lib_TCEmain->deleteAction#2509 // tx_version_tcemain->processCmdmap_deleteAction#3901 // t3lib_TCEmain->deleteEl#243 // t3lib_TCEmain->deletePages#3924 // t3lib_TCEmain->deleteSpecificPage#4147 // t3lib_DB->exec_SELECTquery#4168 // t3lib_DB->debug#191
Actions
Copy link
 #1

Updated by Philipp Gampe about 12 years ago

The problem is that all pages in TCA seems to need a pid column. So we either add it, or we refactor all places where tcemain loops over all tables.

Actions
Copy link
 #2

Updated by Mathias Schreiber over 9 years ago

  • Status changed from New to Needs Feedback
  • Is Regression set to No

don't get one on master.
Is this fixed, maybe?

Actions
Copy link
 #3

Updated by Alexander Opitz almost 9 years ago

  • Status changed from Needs Feedback to Closed

No feedback within the last 90 days => closing this issue.

If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.

Actions
Copy link

Also available in: Atom PDF