Page MenuHomePhabricator

Jhuff05
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Jan 12 2017, 8:03 PM (131 w, 1 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Jhuff05 [ Global Accounts ]

Recent Activity

May 31 2017

Jhuff05 added a comment to T145635: Error installing with SQL Server 2014 Express: Index 'oi_name_archive_name' has more than 900 bytes long.

No, This is still an active problem. and demon, you must work in customer relations

May 31 2017, 10:48 AM · Schema-change, MediaWiki-Installer, MSSQL

Apr 27 2017

Jhuff05 created T164018: Error during install of 1.28.1 with MSSQL server: Implicit conversion from data type varchar to varbinary(max) is not allowed..
Apr 27 2017, 5:40 PM · MSSQL, MediaWiki-Internationalization

Mar 24 2017

Jhuff05 added a comment to T161237: MSSQL Error when using limit statement in Cargo Query.

I updated Cargo as of 0900 23 March 2017, has there been a change since then?

Mar 24 2017, 3:22 PM · MSSQL, MediaWiki-extensions-Cargo
Jhuff05 added a comment to T161237: MSSQL Error when using limit statement in Cargo Query.

Update PageForms to Page Forms 4.1 (380aafb)
Still are seeing the above problem.

Mar 24 2017, 1:35 PM · MSSQL, MediaWiki-extensions-Cargo

Mar 23 2017

Jhuff05 created T161237: MSSQL Error when using limit statement in Cargo Query.
Mar 23 2017, 7:06 PM · MSSQL, MediaWiki-extensions-Cargo

Mar 21 2017

Jhuff05 added a comment to T160912: Cargo using incorrect field name in queries.

Any page that we put that Cargo Query on, fails. Normal cargo table views and drilldowns work fine.

Mar 21 2017, 5:29 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T160912: Cargo using incorrect field name in queries.

Yaron,
Sorry, but I think you are still missing part of the problem. Take the following example, here we are declaring a Cargo table
called Observation, it has 8 fields named Observation_topic, Event_Name, WFC_Title, WFF, keyword, Observation_type, Observation_Discussion,
and Observation_recommendation, declared as such:

Mar 21 2017, 4:24 PM · MediaWiki-extensions-Cargo

Mar 20 2017

Jhuff05 added a comment to T160912: Cargo using incorrect field name in queries.

We simplified the Cargo query to:
{{#cargo_query:
tables=Observation,Event

join on=Observation.keyword=Event.keyword
fields=Observation.keyword=Keywords, Event.keyword=Keywords
where=Observation.keyword holds '{{PAGENAME}}' or Event.keyword holds '{{PAGENAME}}'
default='''''No results to display'''''
format=tag cloud

}}

Mar 20 2017, 4:37 PM · MediaWiki-extensions-Cargo
Jhuff05 created T160917: MSSQL Database error "bit is invalid for sum operator" on Special:WantedPages.
Mar 20 2017, 3:26 PM · MediaWiki-Special-pages, MSSQL
Jhuff05 created T160912: Cargo using incorrect field name in queries.
Mar 20 2017, 2:12 PM · MediaWiki-extensions-Cargo

Mar 16 2017

Jhuff05 added a comment to T158766: Error during document revision compare.

How could this be closed, Resolved , if it has not been tested against MSSQL?

Mar 16 2017, 3:13 PM · MSSQL, MW-1.28-release-notes, MW-1.27-release-notes, MW-1.29-release (WMF-deploy-2017-03-21_(1.29.0-wmf.17)), MW-1.29-release-notes, Patch-For-Review, MediaWiki-Database

Mar 13 2017

Jhuff05 added a comment to T159555: Cargo Date type field errors.

Awesome! Good Job, looks like everything is working as it should.
Thanks, it was really good meeting you at EMWCon last week.
Jerome

Mar 13 2017, 2:31 PM · MediaWiki-extensions-Cargo

Mar 7 2017

Jhuff05 added a comment to T159555: Cargo Date type field errors.

Did a new GIT Pull, moved the files to our wiki codebase.
still found one DAYOFMONTH function call line 148 of cargofilter.php I corrected that by changing it to just DAY,

Mar 7 2017, 3:01 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T159555: Cargo Date type field errors.

From the drill down page:

Mar 7 2017, 1:56 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T159555: Cargo Date type field errors.

OK, I did a New GIT Pull and placed it into my wiki codebase. I found two more uses of the "DayOfMonth" function that I changed to "Day". They were line 119 of CargoAppliedFilter.php and line 141 of CargoFilter.php I am still experiencing two errors during "View" and "Drilldown".
The "VIEW" Error is:
<br />
<b>Warning</b>: htmlspecialchars() expects parameter 1 to be string, object given in <b>C:\inetpub\wwwroot\WCR\extensions\Cargo\CargoSQLQuery.php</b> on line <b>1214</b><br />

Mar 7 2017, 1:22 PM · MediaWiki-extensions-Cargo

Mar 6 2017

Jhuff05 added a comment to T159555: Cargo Date type field errors.

I did a GIT Pull...

Mar 6 2017, 5:13 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T159555: Cargo Date type field errors.

Yaron,
I used GIT to download the files and put them in place. One of the errors, is corrected. The error for the drilldown page is fixed and the page shows with the correct dates, but the "VIEW" page still has the error:

Mar 6 2017, 4:33 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T159555: Cargo Date type field errors.

Yaron,

Mar 6 2017, 4:28 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T159555: Cargo Date type field errors.

I changed the function from dayofmonth to day and now I am getting the following error:

Mar 6 2017, 12:44 PM · MediaWiki-extensions-Cargo

Mar 3 2017

Jhuff05 created T159555: Cargo Date type field errors.
Mar 3 2017, 5:35 PM · MediaWiki-extensions-Cargo

Feb 22 2017

Jhuff05 created T158766: Error during document revision compare.
Feb 22 2017, 1:47 PM · MSSQL, MW-1.28-release-notes, MW-1.27-release-notes, MW-1.29-release (WMF-deploy-2017-03-21_(1.29.0-wmf.17)), MW-1.29-release-notes, Patch-For-Review, MediaWiki-Database

Feb 21 2017

Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

Git download solved the problems!!!!
Thank You!!!!
Jerome

Feb 21 2017, 5:53 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

No, I used the Zip file download from the cargo Main page.
I will try to get it with GIT and let you know how it goes...
Thank you!!

Feb 21 2017, 4:36 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

Yaron,
This is lines 70 - 89, showing whare I placed what you sent above.
$fieldType = $fieldDescription->mType;

			// Special handling for URLs, to avoid them
			// overwhelming the page.
			// @TODO - something similar should be done for lists
			// of URLs.
			if ( $fieldType == 'URL' && !$fieldDescription->mIsList ) {
				// Thankfully, there's a message in core
				// MediaWiki that seems to just be "URL".
				$fieldName = "CONCAT('[', $fieldName, ' " .
					$this->msg( 'version-entrypoints-header-url' )->parse() . "]')";
			}
Feb 21 2017, 4:28 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

Line 83 is in the middle of an IF statement: $fieldType = $fieldDescription->mType; I placed it in there, but nothing was displayed on the screen when I went to Special:Cargo Tables, it just listed the 9 table that we have defined

Feb 21 2017, 4:07 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

Yaron, I updated to Cargo ver. 1.3 I am still getting a Concat error: A database query error has occurred. This may indicate a bug in the software.
◾Query:
SELECT TOP 100 [_pageName] AS [Page],CONCAT('[', link, ' URL]') AS [link],[sometext] AS [sometext] FROM [wiki].[cargo__hufftest1] ORDER BY [_pageName]

Feb 21 2017, 2:12 PM · MediaWiki-extensions-Cargo
Jhuff05 added a comment to T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.

Yaron,

Feb 21 2017, 2:08 PM · MediaWiki-extensions-Cargo

Feb 17 2017

Jhuff05 created T158418: Using a table with a field type of "URL" causes a MSSQL CONCAT error.
Feb 17 2017, 12:38 PM · MediaWiki-extensions-Cargo

Jan 13 2017

Jhuff05 created T155260: Cargo not creating tables with MS SQLServer database.
Jan 13 2017, 7:01 PM · MSSQL, Patch-For-Review, MediaWiki-extensions-Cargo

Jan 12 2017

Jhuff05 created T155188: When installing MediaWiki 1.27.1 with SQL Server 2008 R2 Error Occures:.
Jan 12 2017, 8:07 PM · MediaWiki-Database