View Issue Details

IDProjectCategoryView StatusLast Update
0013834mantisbttaggingpublic2012-02-13 06:03
Reporteremireal Assigned Torombert  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
PlatformIIS 7 MSSQL 2005OSWindows Server 2008OS Version6.0.6002
Product Version1.2.8 
Summary0013834: Application Error accesing tag_view_page
Description

When in manage_tags_page.php I see the warning:

SYSTEM WARNING: array_values() expects parameter 1 to be array, boolean given

When in click on a tag to edit it this error is displayed:

APPLICATION ERROR 0000401
Database query failed. Error received from database was #37000: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation for the query: SELECT * FROM mantis_bug_tag_table
WHERE tag_id != ?
AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b
LEFT JOIN mantis_project_user_list_table AS p
ON p.project_id=b.project_id AND p.user_id=4
JOIN mantis_user_table AS u
ON u.id=4
JOIN mantis_bug_tag_table AS t
ON t.bug_id=b.id
WHERE ( p.access_level>b.view_state OR u.access_level>b.view_state )
AND t.tag_id=? ) .

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Steps To Reproduce

Go to manage tags page
Click on a tag

Additional Information

Using:

  • IIS 7
  • Sql Server 2005
  • PHP 5.3.9

Files Generated with $g_show_detailed_errors = ON Attached

TagsNo tags attached.
Attached Files
Manage Tags.htm (6,983 bytes)   
<!-- saved from url=(0041)http://palwebi/palbt/manage_tags_page.php -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><br><div align="center"><table class="width50" cellspacing="1"><tbody><tr><td class="form-title">SYSTEM WARNING</td></tr><tr><td><p class="center" style="color:red">array_values() expects parameter 1 to be array, boolean given</p></td></tr><tr><td><p class="center">Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.</p></td></tr><tr><td>		<center>
			<table class="width75">
				<tbody><tr>
					<td>Full path: C:\Sitios Webs\UTENet\PalBT\core\database_api.php</td>
				</tr>
				<tr>
					<td>Line: 520</td>
				</tr>
				<tr>
					<td>
						<table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>p_index1</td><td>0</td><td>integer</td></tr>
<tr><td>p_index2</td><td>0</td><td>integer</td></tr>
<tr><td colspan="3" align="left"><br><strong>t_result</strong></td></tr><tr><td colspan="3"><table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td></td><td>boolean</td></tr>
</tbody></table></td></tr></tbody></table>					</td>
				</tr>
			</tbody></table>
		</center>
</td></tr><tr><td><center><table class="width75"><tbody><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr class="row-1"><td>C:\Sitios Webs\UTENet\PalBT\core\database_api.php</td><td>520</td><td>-</td><td>-</td><td>array_values</td><td>( &lt;boolean&gt;false )</td></tr><tr class="row-2"><td>C:\Sitios Webs\UTENet\PalBT\manage_tags_page.php</td><td>101</td><td>-</td><td>-</td><td>db_result</td><td>( &lt;Object&gt;&lt;ADORecordSet_odbc_mssql&gt; ( [databaseType] =&gt; 'odbc_mssql', [bind] =&gt; &lt;Array&gt; { [''] =&gt; 0 }, [dataProvider] =&gt; 'odbc', [useFetchArray] =&gt; NULL, [_has_stupid_odbc_fetch_api_change] =&gt; true, [fields] =&gt; false, [blobSize] =&gt; 100, [canSeek] =&gt; false, [sql] =&gt; 'SELECT count(*)
			FROM mantis_tag_table
			', [EOF] =&gt; true, [emptyTimeStamp] =&gt; '&amp;nbsp;', [emptyDate] =&gt; '&amp;nbsp;', [debug] =&gt; false, [timeCreated] =&gt; 0, [fetchMode] =&gt; 2, [connection] =&gt; &lt;Object&gt;&lt;ADODB_odbc_mssql&gt; ( [databaseType] =&gt; 'odbc_mssql', [fmtDate] =&gt; '\'Y-m-d\'', [fmtTimeStamp] =&gt; '\'Y-m-d H:i:s\'', [_bindInputArray] =&gt; true, [metaTablesSQL] =&gt; 'select name,case when type=\'U\' then \'T\' else \'V\' end from sysobjects where (type=\'U\' or type=\'V\') and (name not in (\'sysallocations\',\'syscolumns\',\'syscomments\',\'sysdepends\',\'sysfilegroups\',\'sysfiles\',\'sysfiles1\',\'sysforeignkeys\',\'sysfulltextcatalogs\',\'sysindexes\',\'sysindexkeys\',\'sysmembers\',\'sysobjects\',\'syspermissions\',\'sysprotects\',\'sysreferences\',\'systypes\',\'sysusers\',\'sysalternates\',\'sysconstraints\',\'syssegments\',\'REFERENTIAL_CONSTRAINTS\',\'CHECK_CONSTRAINTS\',\'CONSTRAINT_TABLE_USAGE\',\'CONSTRAINT_COLUMN_USAGE\',\'VIEWS\',\'VIEW_TABLE_USAGE\',\'VIEW_COLUMN_USAGE\',\'SCHEMATA\',\'TABLES\',\'TABLE_CONSTRAINTS\',\'TABLE_PRIVILEGES\',\'COLUMNS\',\'COLUMN_DOMAIN_USAGE\',\'COLUMN_PRIVILEGES\',\'DOMAINS\',\'DOMAIN_CONSTRAINTS\',\'KEY_COLUMN_USAGE\'))', [metaColumnsSQL] =&gt; 'select c.name,t.name,c.length from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name=\'%s\'', [hasTop] =&gt; 'top', [sysDate] =&gt; 'GetDate()', [sysTimeStamp] =&gt; 'GetDate()', [leftOuter] =&gt; '*=', [rightOuter] =&gt; '=*', [substr] =&gt; 'substring', [length] =&gt; 'len', [ansiOuter] =&gt; true, [identitySQL] =&gt; 'select SCOPE_IDENTITY()', [hasInsertID] =&gt; true, [connectStmt] =&gt; 'SET CONCAT_NULL_YIELDS_NULL OFF', [replaceQuote] =&gt; '\'\'', [dataProvider] =&gt; 'odbc', [hasAffectedRows] =&gt; true, [binmode] =&gt; 1, [useFetchArray] =&gt; false, [curmode] =&gt; 2, [_genSeqSQL] =&gt; 'create table %s (id integer)', [_autocommit] =&gt; true, [_haserrorfunctions] =&gt; true, [_has_stupid_odbc_fetch_api_change] =&gt; true, [_lastAffectedRows] =&gt; 0, [uCaseTables] =&gt; true, [_dropSeqSQL] =&gt; 'drop table %s', [database] =&gt; 'palbtcp', [host] =&gt; 'Driver={SQL Server};SERVER=paldbsql\\paldbsql;DATABASE=palbt;Trusted_Connection=True;', [user] =&gt; 'root', [password] =&gt; '', [debug] =&gt; false, [maxblobsize] =&gt; 262144, [concat_operator] =&gt; '+', [random] =&gt; 'rand()', [upperCase] =&gt; 'upper', [true] =&gt; '1', [false] =&gt; '0', [nameQuote] =&gt; '"', [charSet] =&gt; false, [metaDatabasesSQL] =&gt; '', [uniqueOrderBy] =&gt; false, [emptyDate] =&gt; '&amp;nbsp;', [emptyTimeStamp] =&gt; '&amp;nbsp;', [lastInsID] =&gt; false, [hasLimit] =&gt; false, [readOnly] =&gt; false, [hasMoveFirst] =&gt; false, [hasGenID] =&gt; false, [hasTransactions] =&gt; true, [genID] =&gt; 0, [raiseErrorFn] =&gt; false, [isoDates] =&gt; false, [cacheSecs] =&gt; 3600, [memCache] =&gt; false, [memCacheHost] =&gt; NULL, [memCachePort] =&gt; 11211, [memCacheCompress] =&gt; false, [sysUTimeStamp] =&gt; false, [arrayClass] =&gt; 'ADORecordSet_array', [noNullStrings] =&gt; false, [numCacheHits] =&gt; 0, [numCacheMisses] =&gt; 0, [pageExecuteCountRows] =&gt; true, [uniqueSort] =&gt; false, [autoRollback] =&gt; false, [poorAffectedRows] =&gt; false, [fnExecute] =&gt; false, [fnCacheExecute] =&gt; false, [blobEncodeType] =&gt; false, [rsPrefix] =&gt; 'ADORecordSet_', [autoCommit] =&gt; true, [transOff] =&gt; 0, [transCnt] =&gt; 0, [fetchMode] =&gt; false, [null2null] =&gt; 'null', [_oldRaiseFn] =&gt; false, [_transOK] =&gt; NULL, [_connectionID] =&gt; NULL, [_errorMsg] =&gt; '', [_errorCode] =&gt; 0, [_queryID] =&gt; NULL, [_isPersistentConnection] =&gt; false, [_evalAll] =&gt; false, [_affected] =&gt; false, [_logsql] =&gt; false, [_transmode] =&gt; '', [_error] =&gt; '' ), [_numOfRows] =&gt; 1, [_numOfFields] =&gt; 1, [_queryID] =&gt; NULL, [_currentRow] =&gt; 2, [_closed] =&gt; false, [_inited] =&gt; true, [_obj] =&gt; NULL, [_names] =&gt; NULL, [_currentPage] =&gt; -1, [_atFirstPage] =&gt; false, [_atLastPage] =&gt; false, [_lastPageNo] =&gt; -1, [_maxRecordCount] =&gt; 0, [datetime] =&gt; false ) )</td></tr></tbody></table></center></td></tr></tbody></table></div>	<br>
	<hr size="1">
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tbody><tr valign="top"><td>	<address>Copyright © 2000 - 2011 MantisBT Group</address>
	<address><a href="mailto:proyect@palermoslots.com.ar">proyect@palermoslots.com.ar</a></address>
</td><td>
	<div align="right"><a href="http://www.mantisbt.org/" title="Free Web Based Bug Tracker"><img src="./Manage Tags - Seguimiento de incidentes-HAPSA-CCSA-UTE_files/mantis_logo_button.gif" width="88" height="35" alt="Powered by Mantis Bugtracker" border="0"></a></div>
</td></tr></tbody></table>


</body></html>
Manage Tags.htm (6,983 bytes)   
tag_view_page.php.htm (6,044 bytes)   
<!-- saved from url=(0047)http://palwebi/palbt/tag_view_page.php?tag_id=3 -->
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><br><div align="center"><table class="width50" cellspacing="1"><tbody><tr><td class="form-title">APPLICATION ERROR #401</td></tr><tr><td><p class="center" style="color:red">Database query failed. Error received from database was #37000: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation for the query: SELECT * FROM mantis_bug_tag_table<br>
					WHERE tag_id != ?<br>
						AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b<br>
					LEFT JOIN mantis_project_user_list_table AS p<br>
						ON p.project_id=b.project_id AND p.user_id=4<br>
					JOIN mantis_user_table AS u<br>
						ON u.id=4<br>
					JOIN mantis_bug_tag_table AS t<br>
						ON t.bug_id=b.id<br>
					WHERE ( p.access_level&gt;b.view_state OR u.access_level&gt;b.view_state )<br>
						AND t.tag_id=? ) .</p></td></tr><tr><td><p class="center">Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.</p></td></tr><tr><td>		<center>
			<table class="width75">
				<tbody><tr>
					<td>Full path: C:\Sitios Webs\UTENet\PalBT\core\database_api.php</td>
				</tr>
				<tr>
					<td>Line: 393</td>
				</tr>
				<tr>
					<td>
						<table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>p_query</td><td>SELECT * FROM mantis_bug_tag_table
					WHERE tag_id != ?
						AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b
					LEFT JOIN mantis_project_user_list_table AS p
						ON p.project_id=b.project_id AND p.user_id=4
					JOIN mantis_user_table AS u
						ON u.id=4
					JOIN mantis_bug_tag_table AS t
						ON t.bug_id=b.id
					WHERE ( p.access_level&gt;b.view_state OR u.access_level&gt;b.view_state )
						AND t.tag_id=? ) </td><td>string</td></tr>
<tr><td>p_limit</td><td>-1</td><td>integer</td></tr>
<tr><td>p_offset</td><td>-1</td><td>integer</td></tr>
<tr><td>g_db_log_queries</td><td>0</td><td>integer</td></tr>
<tr><td>g_db_param_count</td><td>39</td><td>integer</td></tr>
<tr><td>s_check_params</td><td>1</td><td>boolean</td></tr>
<tr><td>params</td><td>2</td><td>integer</td></tr>
<tr><td>i</td><td>2</td><td>integer</td></tr>
<tr><td>t_result</td><td></td><td>boolean</td></tr>
<tr><td colspan="3" align="left"><br><strong>arr_parms</strong></td></tr><tr><td colspan="3"><table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>3</td><td>integer</td></tr>
<tr><td>1</td><td>3</td><td>integer</td></tr>
</tbody></table></td></tr><tr><td colspan="3" align="left"><br><strong>g_queries_array</strong></td></tr><tr><td colspan="3"><table class="width100"><tbody><tr><th>Variable</th><th>Value</th><th>Type</th></tr><tr><td>0</td><td>1</td><td>integer</td></tr>
<tr><td>1</td><td>1</td><td>integer</td></tr>
<tr><td>2</td><td>1</td><td>integer</td></tr>
<tr><td>3</td><td>1</td><td>integer</td></tr>
<tr><td>4</td><td>1</td><td>integer</td></tr>
<tr><td>5</td><td>1</td><td>integer</td></tr>
<tr><td>6</td><td>1</td><td>integer</td></tr>
<tr><td>7</td><td>1</td><td>integer</td></tr>
<tr><td>8</td><td>1</td><td>integer</td></tr>
<tr><td>9</td><td>1</td><td>integer</td></tr>
<tr><td>10</td><td>1</td><td>integer</td></tr>
<tr><td>11</td><td>1</td><td>integer</td></tr>
<tr><td>12</td><td>1</td><td>integer</td></tr>
<tr><td>13</td><td>1</td><td>integer</td></tr>
<tr><td>14</td><td>1</td><td>integer</td></tr>
<tr><td>15</td><td>1</td><td>integer</td></tr>
<tr><td>16</td><td>1</td><td>integer</td></tr>
<tr><td>17</td><td>1</td><td>integer</td></tr>
<tr><td>18</td><td>1</td><td>integer</td></tr>
<tr><td>19</td><td>1</td><td>integer</td></tr>
<tr><td>20</td><td>1</td><td>integer</td></tr>
<tr><td>21</td><td>1</td><td>integer</td></tr>
<tr><td>22</td><td>1</td><td>integer</td></tr>
<tr><td>23</td><td>1</td><td>integer</td></tr>
<tr><td>24</td><td>1</td><td>integer</td></tr>
<tr><td>25</td><td>1</td><td>integer</td></tr>
<tr><td>26</td><td>1</td><td>integer</td></tr>
<tr><td>27</td><td>1</td><td>integer</td></tr>
<tr><td>28</td><td>1</td><td>integer</td></tr>
<tr><td>29</td><td>1</td><td>integer</td></tr>
<tr><td>30</td><td>1</td><td>integer</td></tr>
<tr><td>31</td><td>1</td><td>integer</td></tr>
<tr><td>32</td><td>1</td><td>integer</td></tr>
<tr><td>33</td><td>1</td><td>integer</td></tr>
<tr><td>34</td><td>1</td><td>integer</td></tr>
<tr><td>35</td><td>1</td><td>integer</td></tr>
<tr><td>36</td><td>1</td><td>integer</td></tr>
<tr><td>37</td><td>1</td><td>integer</td></tr>
</tbody></table></td></tr></tbody></table>					</td>
				</tr>
			</tbody></table>
		</center>
</td></tr><tr><td><center><table class="width75"><tbody><tr><th>Filename</th><th>Line</th><th></th><th></th><th>Function</th><th>Args</th></tr><tr class="row-1"><td>C:\Sitios Webs\UTENet\PalBT\core\database_api.php</td><td>393</td><td>-</td><td>-</td><td>trigger_error</td><td>( &lt;string&gt;'401', &lt;integer&gt;256 )</td></tr><tr class="row-2"><td>C:\Sitios Webs\UTENet\PalBT\core\tag_api.php</td><td>754</td><td>-</td><td>-</td><td>db_query_bound</td><td>( &lt;string&gt;'SELECT * FROM mantis_bug_tag_table
					WHERE tag_id != ?
						AND bug_id IN ( SELECT b.id FROM mantis_bug_table AS b
					LEFT JOIN mantis_project_user_list_table AS p
						ON p.project_id=b.project_id AND p.user_id=4
					JOIN mantis_user_table AS u
						ON u.id=4
					JOIN mantis_bug_tag_table AS t
						ON t.bug_id=b.id
					WHERE ( p.access_level&gt;b.view_state OR u.access_level&gt;b.view_state )
						AND t.tag_id=? ) ', &lt;Array&gt; { [0] =&gt; 3, [1] =&gt; 3 } )</td></tr><tr class="row-1"><td>C:\Sitios Webs\UTENet\PalBT\tag_view_page.php</td><td>88</td><td>-</td><td>-</td><td>tag_stats_related</td><td>( &lt;integer&gt;3 )</td></tr></tbody></table></center></td></tr></tbody></table></div>

</body></html>
tag_view_page.php.htm (6,044 bytes)   

Relationships

duplicate of 0013731 closeddregad When i click on one tag mantis crash on sql 

Activities