I get this error when clicking on "Publish" of a dashboard

We get this error when loading dashboard in the browser:

(index):1 GET https://sub.domain.com/fonts/digital-7-mono.ttf

I can see than Oracle support is already almost here.

I have been able to add an Oracle database as a source by installing the Oracle Instant Client, the node oracledb module and by uncomment the Oracle line in /public/partials/data-source/edit.html.

Unfortunately the layer functionally work only partially as only the first tables from the main schema is available. Only the first 100 available tables displayed (i assume than there is a LIMIT somewhere in the code but id do not know where).

Is it possible and/or planed to finish the Oracle support ?

The position of tables in a Layer is reset when reloading a Layer for editing.
Would be great if these could be stored and loaded with the other meta data of the Layer.

New installation on a new server. Went fine. Added data sources, tested connection succesfully. We had to add a module for MySQL support first (suggestion: add this step to documentation). Created a new layer with no issue. Went into layer. This is when I ran into problems:

• Clicked "Add new dataset"
• Selected database from drop down (MySQL db)
• The window populates a list of tables successfully
• Selected table(s)
• Clicked "Add to layer"
• Got error notification bar at top of screen

[http://nimb.ws/TdHSCf]

I get this with any database and user (full permission or read only). I get this with any dataset selected (multiple or single).

Hi, whenever I try to connect to mssql databases, there is this error:

events.js:163
throw er; // Unhandled 'error' event
^

Error: Unknown type: 0
at Parser.parseTokens (/home/pablor/Descargas/widestage/node_modules/tedious/lib/token/stream-parser.js:94:30)
at Parser._transform (/home/pablor/Descargas/widestage/node_modules/tedious/lib/token/stream-parser.js:67:14)
at Parser.Transform._read (/home/pablor/Descargas/widestage/node_modules/tedious/node_modules/readable-stream/lib/_stream_transform.js:159:10)
at Parser.Transform._write (/home/pablor/Descargas/widestage/node_modules/tedious/node_modules/readable-stream/lib/_stream_transform.js:147:83)
at doWrite (/home/pablor/Descargas/widestage/node_modules/tedious/node_modules/readable-stream/lib/_stream_writable.js:338:64)
at writeOrBuffer (/home/pablor/Descargas/widestage/node_modules/tedious/node_modules/readable-stream/lib/_stream_writable.js:327:5)
at Parser.Writable.write (/home/pablor/Descargas/widestage/node_modules/tedious/node_modules/readable-stream/lib/_stream_writable.js:264:11)
at Parser.addBuffer (/home/pablor/Descargas/widestage/node_modules/tedious/lib/token/token-stream-parser.js:59:26)
at Connection.sendDataToTokenStreamParser (/home/pablor/Descargas/widestage/node_modules/tedious/lib/connection.js:684:37)
at Connection.data (/home/pablor/Descargas/widestage/node_modules/tedious/lib/connection.js:1108:21)
at Connection.dispatchEvent (/home/pablor/Descargas/widestage/node_modules/tedious/lib/connection.js:559:45)
at MessageIO. (/home/pablor/Descargas/widestage/node_modules/tedious/lib/connection.js:476:16)
at emitOne (events.js:96:13)
at MessageIO.emit (events.js:191:7)
at ReadablePacketStream. (/home/pablor/Descargas/widestage/node_modules/tedious/lib/message-io.js:101:13)
at emitOne (events.js:96:13)
worker 20526 died.
worker 20571 born.
mongo DB connection
Server running at http://0.0.0.0:8081/ in worker 11
Mongoose connection open to mongodb://localhost:27017/widestage

And connection fails.
Also, there is no field to specify mssql db "instance".

Would it be possible to add calculation as part of a Layer.
E.g. A + B + C or A * 100 + 2 * B where A, B and C are columns in a Dataset.

For security reasons I installed MongoDB with authorization enabled as shown here

https://docs.mongodb.com/manual/tutorial/enable-authentication/

I assume, MongoDB authentication (user/pw) is a problem for Widestage. I can see the Widestage login screen but I can't login. I changed the http port as another service is already running on port 80. The CLI shows

mongo DB connection
Mongoose connection open to mongodb://localhost:27017/widestage
no records in the users model, this is the initial setup!
crypto.js:635
    throw new TypeError(
    ^

TypeError: The "digest" argument is required and must not be undefined
    at pbkdf2 (crypto.js:635:11)
    at Object.exports.pbkdf2 (crypto.js:623:10)
    at RandomBytes.ondone (/srv/widestage/server/util/hash.js:39:20)
mongo DB connection
Server running at http://0.0.0.0:28283/ in worker 5
Mongoose connection open to mongodb://localhost:27017/widestage

Just installed widestage and set up a MySQL connection to the database "prexupa". There are 7 "prexxxx" databases and 3 or 4 other non-related databases on that MySQL instance. When adding a layer, all unique tablenames and unique views across all database instances appear as choices. Almost none of the tables or view are from the database "prexupa".

Hi
I have setup the widestage server and I want to use it on top of a MongoDB.
I have created a simple layer with some relations but when I want to explore it, it looks like it does a cross join on a one to one relationship.

The layer:

Explore results:

The data in Mongo:

The filtering also doesn't work, not sure if this is related to the above problem?

MongoDb version 3.4.4 installed on a remote server with authentication required. Use same connection string can connect to this database server using Robomongo without any problem, but "test connection" here failed. tried changing mongose version and Mongodb version in package.json file, but does not work...

So does the current version support MongoDB 3.4.4? if not, when it will be fixed?

Thanks!

Hi,
How can we add individual fields from a layer to a report or dashboard?

For example in a layer "Summary" we have two fields "Average Hours" and "Total Hours"
The layer is a single record, but I can't seem to figure out how to display the two above mentioned fields in e.g. a report layout or just get it out as a value and field somewhere without listing it as a table.

Hi,
I am using widestage in combination with a local MySQL server. Although I define a certain field with the underlying MySQL-datatype "timestamp" as "Date" within the widestage layer, I cannot use it as an actual date in any query or report - it is rather handled as a any other text key.
Did I miss anything? Are there any tricks to get this working? Is the datatype correctly translated into widestage?
Your help is very appreciated. Many thanks in advance.

Hi,

Getting the above error on OSX and in container using repos dockerfile. Any suggestions?

Many thanks.

I have objects stored in mongodb. each as below:

{
"_id" : ObjectId("591bde9a272aa6178251f5d0"),
"c_obj" : ObjectId("591bde9a272aa6178251f54c"),
"name" : "Mechanical_Tag1",
"description" : "Description of Mechanical_Tag1",
"status" : "current",
"rev" : 0,
"interfaces" : [
{
"i_name" : "MT_interface1",
"exposed" : [
{
"p_name" : "P1",
"p_description" : "P1_Desc",
"p_value" : "P1Value"
},
{
"p_name" : "P2",
"p_description" : "P2_Desc",
"p_value" : "P2Value"
}
],
"deny_member" : ObjectId("591be03b272aa61782529210"),
"properties_edit_member" : ObjectId("591be03b272aa61782529211")
},
{
"i_name" : "MT_interface2",
"exposed" : [
{
"p_name" : "P1",
"p_description" : "P1_Desc",
"p_value" : "P1Value"
},
{
"p_name" : "P2",
"p_description" : "P2_Desc",
"p_value" : "P2Value"
}
],
"deny_member" : ObjectId("591be03b272aa61782529212"),
"properties_edit_member" : ObjectId("591be03b272aa61782529213")
}
],
"l_relations" : [],
"r_relations" : [],
"attached_files" : [
{
"f_name" : "t1.txt",
"f_description" : "test text file",
"f_obj" : ObjectId("591bec06272aa61782550310")
}
],
"edit_member" : ObjectId("591bde9a272aa6178251f54d"),
"deny_member" : ObjectId("591bde9a272aa6178251f54e")
}

Now, I drag & drop "name", "p_name", "p_description" as columns on Explore of widestage, no sample data displayed... Does this software support generating "flat" report from embedded mongodb data source?

Is this normal? Or is it actually an error?

node server.js local
forking 0
forking 1
forking 2
forking 3
mongo DB connection
mongo DB connection
mongo DB connection
mongo DB connection
Server running at http://127.0.0.1:8081/ in worker 4
(node:16742) DeprecationWarning: Mongoose: mpromise (mongoose's default promise library) is deprecated, plug in your own promise library instead: http://mongoosejs.com/docs/promises.html
Server running at http://127.0.0.1:8081/ in worker 3
Mongoose connection open to localhost:27017/widestage_local
(node:16736) DeprecationWarning: Mongoose: mpromise (mongoose's default promise library) is deprecated, plug in your own promise library instead: http://mongoosejs.com/docs/promises.html
Mongoose connection open to localhost:27017/widestage_local
Server running at http://127.0.0.1:8081/ in worker 2
(node:16735) DeprecationWarning: Mongoose: mpromise (mongoose's default promise library) is deprecated, plug in your own promise library instead: http://mongoosejs.com/docs/promises.html
Server running at http://127.0.0.1:8081/ in worker 1
(node:16729) DeprecationWarning: Mongoose: mpromise (mongoose's default promise library) is deprecated, plug in your own promise library instead: http://mongoosejs.com/docs/promises.html
Mongoose connection open to localhost:27017/widestage_local
Mongoose connection open to localhost:27017/widestage_local

Running widestage on our server as per instructions we get this error on refreshing the widestage page.

angular-animate.min.js:14 Uncaught TypeError: y.module(...).info is not a function
at angular-animate.min.js:14
at angular-animate.min.js:56

Any idea what it can be?

Hi Guys;

I cannot save reports. Do you know how this can be solved?
Even the administrator, and extended roles do not solve the issue.

Thanks for your help,

P.

Would it be possible to add some kind of breadcrumb or atleast a "back" button.
"Cancel" button now doubles as a back button, but it is confusing.
Any thoughts on this?

If multiple collections in the layer use the same field name the report column data appears blank for whichever field is added last to the report.

In my case, I have a Countries collection with a 'name' field and a Industries collection with a 'name' field. When I add the Countries collection field to the report it appears fine, but when I add the Industries collection field it doesn't show any data. I've also tried this with 3 fields (all called the same) and only the first one added displays the data.

Actually a layer is bind to a data source. It is not possible to get a table from a source and join it with another table from another source. When adding a new table in a layer, the modal dialog did not allow to change the data source.

Installed on Ubuntu server with node v6 without the oracledb package.
When I try yo login, web ui is silent (throwing a console error in my browser) and doesn't log me in.

Actually it is only possible to create layer and edit the layer content, i do not see a way to delete them or rename them.

Could it be possible to add a field to a Layer by simply clicking it - and if needing to customize it do it by opening clicking on the added element afterwards?

It takes a lot of mouse clicks and moving to just add the elements one would like to add.
Maybe a setting?

hi,

I want test widestage on CentOS 7 64bits.

but when I go on the portal "http://IP/login" I have this message under login/password :
{{errorLoginMessage}}

I'm not an expert in linux... I don't find solution...

any idea?

thx a lot

I'm unable to view any created reports - I just get the page filter header with nothing below (see screenshot below).

Widestage was installed via git clone a few moments ago, so using the latest commit code. I created a single MongoDB data source (connection tests ok and is running locally), a single layer that joins 2 collections and added 2 fields to the layer.

I created the report fine and can edit it without issue, it consists of the 2 fields without any sort/filters specified - but I just can't use the Reports page to display it.

The following is logged in the browser window when the view report page opens:

angular.js:13550 Error: [$injector:unpr] http://errors.angularjs.org/1.5.5/$injector/unpr?p0=uiGridConstantsProvider…20%3C-%20report_viewCtrl%20%3C-%20report_viewCtrl%20%3C-%20report_viewCtrl
    at http://localhost/angular/angular.min.js:6:412
    at http://localhost/angular/angular.min.js:43:84
    at Object.d [as get] (http://localhost/angular/angular.min.js:40:344)
    at http://localhost/angular/angular.min.js:43:146
    at d (http://localhost/angular/angular.min.js:40:344)
    at e (http://localhost/angular/angular.min.js:41:78)
    at Object.instantiate (http://localhost/angular/angular.min.js:41:441)
    at http://localhost/angular/angular.min.js:89:309
    at link (http://localhost/angular-route/angular-route.min.js:7:268)
    at ja (http://localhost/angular/angular.min.js:80:350) <div ng-view="" ng-intro-options="IntroOptions" ng-intro-method="CallMe" class="ng-scope">

I also made sure angular 1.5.5 and angular-animate 1.5.5 were both installed during bower install stage.

Using Chrome 58.0.3029.110 (64-bit) on Mac OSX Sierra.

Running server.js on node v6.2.2

Let me know if you need any other info and/or further tests carried out. Thanks!

Hi!
After starting the server on a fresh install in a VM Ubuntu box, I get this error, repeatedly:

me@Ubuntu-HV:~/widestage$ node server.js

{ Error: Cannot find module '../build/Release/bson'
at Function.Module._resolveFilename (module.js:469:15)
at Function.Module._load (module.js:417:25)
at Module.require (module.js:497:17)
at require (internal/module.js:20:19)
at Object. (/home/me/widestage/node_modules/mongoose/node_modules/bson/ext/index.js:15:10)
at Module._compile (module.js:570:32)
at Object.Module._extensions..js (module.js:579:10)
at Module.load (module.js:487:32)
at tryModuleLoad (module.js:446:12)
at Function.Module._load (module.js:438:3) code: 'MODULE_NOT_FOUND' }
js-bson: Failed to load c++ bson extension, using pure JS version
forking 0

uname -a reads:
Linux Ubuntu-HV 4.4.0-31-generic #50-Ubuntu SMP Wed Jul 13 00:07:12 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

node version is v6.9.1
bower version is 1.8.0
npm version is 3.10.8
MongoDB shell version: 2.6.10

Any idea on what must be wrong?

thanks,

Niros.

A assume than you code on a Mac...

This .DS_Store files are probably not part of your code...

Hi
I have just now installed this software on a new CentOS 7 server
I then connected it to 2 PostgreSQL servers, one have the tables names and columns with all lowercase and one with mixed cases.

The database with the lowercase tables and columns works but any time I make a report on the other database I get an errors like:
Query Error: error: relation "public.account" does not exist
Query Error: error: column wsth9nb.accountid does not exist

I tried using "Layers" created with "Add new SQL" and "Add new dataset" (the new dataset wizard shows the correct letter cases in the selection screen)

Google search shows that this error usually occurs when querying PostgreSQL with lowercase instead of the proper case

Could you please help?
Thank you
illy

Hi,

Idk if it's my mistake, but i'm getting this when i try to create a new report on the demo page:

I installed and the login page launched fine but after using the default username/password (administrator/widestage) I'm receiving:
Cannot POST /login
without any other information. Any suggestions?

Hello together,

Would it be possible to add an export function which allows to export dashboards and reports? (PDF, PNG, JPEG etc.)?

This would be a very useful... any thoughts on it?

Hi! I've tried to build groupthink today on my system:

windows 8
npm 2.15.1
bower 1.7.9
grunt-cli v1.2.0
grunt v1.0.1

and get following error

c:\temp\widestage\widestage>npm install
npm WARN deprecated [email protected]: Jade has been renamed to pug, please install the
latest version of pug instead of jade
npm WARN deprecated [email protected]: 'native-or-bluebird' is deprecated
. Please use 'any-promise' instead.
npm WARN deprecated [email protected]: Deprecated, use jstransformer
npm WARN deprecated [email protected]: cross-spawn no longer requires a bu
ild toolchain, use it instead!
npm WARN peerDependencies The peer dependency kerberos@~0.0 included from mongod
b-core will no
npm WARN peerDependencies longer be automatically installed to fulfill the peerD
ependency
npm WARN peerDependencies in npm 3+. Your application will need to depend on it
explicitly.

[email protected] install c:\temp\widestage\widestage\node_modules\oracledb
node-gyp rebuild

/
c:\temp\widestage\widestage\node_modules\oracledb>if not defined npm_config_node
_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin....\nod
e_modules\node-gyp\bin\node-gyp.js" rebuild ) else (node "" rebuild )
gyp ERR! configure error
gyp ERR! stack Error: Python executable "C:\Program Files (x86)\Python\python.EX
E" is v3.4.3, which is not supported by gyp.
gyp ERR! stack You can pass the --python switch to point to Python >= v2.5.0 & <
3.0.0.
gyp ERR! stack at failPythonVersion (C:\Program Files\nodejs\node_modules\np
m\node_modules\node-gyp\lib\configure.js:406:14)
gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node
-gyp\lib\configure.js:395:9
gyp ERR! stack at ChildProcess.exithandler (child_process.js:204:7)
gyp ERR! stack at emitTwo (events.js:87:13)
gyp ERR! stack at ChildProcess.emit (events.js:172:7)
gyp ERR! stack at maybeClose (internal/child_process.js:827:16)
gyp ERR! stack at Socket. (internal/child_process.js:319:11)
gyp ERR! stack at emitOne (events.js:77:13)
gyp ERR! stack at Socket.emit (events.js:169:7)
gyp ERR! stack at Pipe._onclose (net.js:477:12)
gyp ERR! System Windows_NT 6.3.9600
gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodej
s\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd c:\temp\widestage\widestage\node_modules\oracledb
gyp ERR! node -v v4.4.3
gyp ERR! node-gyp -v v3.3.1
gyp ERR! not ok
/

[email protected] install c:\temp\widestage\widestage\node_modules\mongodb\node_
modules\kerberos
(node-gyp rebuild) || (exit 0)

c:\temp\widestage\widestage\node_modules\mongodb\node_modules\kerberos>if not de
fined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\bin\no
de-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebuild ) else (node "
" rebuild )
gyp ERR! configure error
gyp ERR! stack Error: Python executable "C:\Program Files (x86)\Python\python.EX
E" is v3.4.3, which is not supported by gyp.
gyp ERR! stack You can pass the --python switch to point to Python >= v2.5.0 & <
3.0.0.
gyp ERR! stack at failPythonVersion (C:\Program Files\nodejs\node_modules\np
m\node_modules\node-gyp\lib\configure.js:406:14)
gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node
-gyp\lib\configure.js:395:9
gyp ERR! stack at ChildProcess.exithandler (child_process.js:204:7)
gyp ERR! stack at emitTwo (events.js:87:13)
gyp ERR! stack at ChildProcess.emit (events.js:172:7)
gyp ERR! stack at maybeClose (internal/child_process.js:827:16)
gyp ERR! stack at Socket. (internal/child_process.js:319:11)
gyp ERR! stack at emitOne (events.js:77:13)
gyp ERR! stack at Socket.emit (events.js:169:7)
gyp ERR! stack at Pipe._onclose (net.js:477:12)
gyp ERR! System Windows_NT 6.3.9600
gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodej
s\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp ERR! cwd c:\temp\widestage\widestage\node_modules\mongodb\node_modules\kerbe
ros
gyp ERR! node -v v4.4.3
gyp ERR! node-gyp -v v3.3.1
gyp ERR! not ok

[email protected] install c:\temp\widestage\widestage\node_modules\mongoose\node
_modules\mongodb\node_modules\kerberos
(node-gyp rebuild 2> builderror.log) || (exit 0)

c:\temp\widestage\widestage\node_modules\mongoose\node_modules\mongodb\node_modu
les\kerberos>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\n
ode_modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" r
ebuild ) else (node "" rebuild )

[email protected] install c:\temp\widestage\widestage\node_modules\mongoose\node_mod
ules\mongodb\node_modules\bson
(node-gyp rebuild 2> builderror.log) || (exit 0)

c:\temp\widestage\widestage\node_modules\mongoose\node_modules\mongodb\node_modu
les\bson>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_
modules\npm\bin\node-gyp-bin....\node_modules\node-gyp\bin\node-gyp.js" rebui
ld ) else (node "" rebuild )
npm ERR! Windows_NT 6.3.9600
npm ERR! argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs
node_modules\npm\bin\npm-cli.js" "install"
npm ERR! node v4.4.3
npm ERR! npm v2.15.1
npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node-gyp rebuild'.
npm ERR! This is most likely a problem with the oracledb package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs oracledb
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!
npm ERR! npm owner ls oracledb
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR! c:\temp\widestage\widestage\npm-debug.log

Seee attached log:
npm-debug.zip

It would be great to be able to add the same field more than once - inorder to be able to list e.g. the original value and one or more calculated fields like SUM and AVG to the same Layer without having create separate Layers.

npm install and bower install worked well, node server.js leads to below error
{ [Error: Cannot find module '../build/Release/bson'] code: 'MODULE_NOT_FOUND' }
js-bson: Failed to load c++ bson extension, using pure JS version
mongo DB connection
{ [Error: Cannot find module '../build/Release/bson'] code: 'MODULE_NOT_FOUND' }
js-bson: Failed to load c++ bson extension, using pure JS version
{ [Error: Cannot find module '../build/Release/bson'] code: 'MODULE_NOT_FOUND' }
js-bson: Failed to load c++ bson extension, using pure JS version
{ [Error: Cannot find module '../build/Release/bson'] code: 'MODULE_NOT_FOUND' }

and unable to login. Cannot POST /login.

How to resolve that?

As today the website http://widestage.com/ is down with just the default nginx index page.

I tried to run docker-compose up .but it throws error

npm ERR! Linux 4.9.27-moby
npm ERR! argv "/usr/local/bin/node" "/usr/local/bin/npm" "install"
npm ERR! node v6.2.2
npm ERR! npm v3.9.5
npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node-gyp rebuild'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the java package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node-gyp rebuild
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs java
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! npm owner ls java
npm ERR! There is likely additional logging output above.

how do I resolve this error.
Thank you.

When configuring a datasource I would like to connect to a DB via jump box.
(something similar to mysql workbench TCP/IP over SSH)

I've selected Oracle as a data source and trying to configure it.
I see that Widestage is throwing an error message after I test the connection.
The error I am getting is "Error: cannot find module 'jdbc'"
I see that ojdbc7.jar and orai18n.jar files exist in /widestage/server/jdbc/oracle folder
I pulled the current version of Widestage on 11 May 2017 ( a89a408 )

Any ideas? Thanks.

Server ignores MONGOHOST env var. 'localhost' hardcoded

Hi,

I'm trying to make joins between two datasets and when I create the reports and drag the field from different dataset to column list it says error inside a red bar and nothing works, Please help.

I can't seem to understand how to use the Indicator report type
I only end up with an empty output.
Could you provide some information about the usage?

Hi,
I have an ubuntu 16.04 server which has been joined windows AD domain. I'm going to install widestage on it as the MongoDB report server. when I try to run "sudo npm install", it installation process hanging...

I do install it successfully on a same server which didn't join the AD domain. so please tell me, this is the issue or not?

Thanks!

Database connection to mssql uses always 1433 port, even when configured to use another port.
The configuration is correctly saved and returned in the database configuration panel, but then widestage tries to connect to default port 1433, and obviously fails.

Clicking on delete for an added layout (frame around both input and label field) does not remove it.

The delete works for removing a report.

Stacktrace in browser:

angular.js:13550 TypeError: Cannot read property 'attr' of undefined
at b.$scope.deleteSelected (widgetProperties.js:186)
at fn (eval at compile (angular.js:14432), :4:233)
at b (angular.js:15485)
at e (angular.js:25018)
at b.$eval (angular.js:17229)
at b.$apply (angular.js:17329)
at HTMLButtonElement. (angular.js:25023)
at HTMLButtonElement.dispatch (jquery.js:4435)
at HTMLButtonElement.r.handle (jquery.js:4121)

Hello!

After a long search I finally found your Widestage!

I would love to use it on my DB, but in two different systems I stucked at the same point when tried to install Widestage.

My questions:

• In which directory I should run the 'git clone ...' command?
• Why can't I start 'node server.js', it always got me to this error message:

{ [Error: Cannot find module '../build/Release/bson'] code: 'MODULE_NOT_FOUND' }
js-bson: Failed to load c++ bson extension, using pure JS version

• Is it possible because of this, written out during npm install:

npm ERR! Linux 3.2.0-32-generic
npm ERR! argv "/usr/bin/nodejs" "/usr/bin/npm" "install"
npm ERR! node v4.4.5
npm ERR! npm v3.9.3
npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node-gyp rebuild'.
npm ERR! Make sure you have the latest version of node.js and npm installed.

Oh, and one more: is it possible to reach WideStage not in the root of the http server, but in a subdirectory?

Can you help me please, what should I do? :(

Thanks in advance,
Lajos

In file /server/core/db/sql line 885 and following (for the BETWEEN and NOT BETWEEN filters), the correct syntax should be:

result = (filterElementName + ' BETWEEN '+filterValue+' AND '+filter.filterText2);

as otherwise the resulting SQL query does NOT contain the column where the BETWEEN clause applies. Eg.

... ON (WSTmgpb.uid = WSTc1zd.uid) WHERE BETWEEN 20 AND 80 GROUP BY WSTmgpb.data_balance ...

which should really be:

... ON (WSTmgpb.uid = WSTc1zd.uid) WHERE WSTmgpb.data_balance BETWEEN 20 AND 80 GROUP BY WSTmgpb.data_balance ...

I'm not an expert in Angular/Node development, but I have managed to debug a problem enough to fix it partially. The bug causes a filter in Explore to fail validation no matter what you type in it, thus not allowing the use of filters at all, unless a value is picked using the "select distinct" search.

On line 77 of query-edit.html, a reference is made to filter.searchValue. This element is not present in the HTML, and there are also references to it in /public/js/query/controller.js that use the element for filter validation before a query is re-run. Replacing filter.searchValue with filter.filterText1 in both the HTML file and controller.js (function checkFilters), validation takes place correctly, and queries can be run.

I tried installing this on mac... with many random issue. Gave up and was successfully able to install it on both windows 8 and ubuntu. However... both of those platforms are throwing the same error in the console when attempting to login...

TypeError: $http(...).success is not a function
at b.$scope.login (login.js:156)
at fn (eval at compile (angular.js:15197), :4:135)
at e (angular.js:26808)
at b.$eval (angular.js:18017)
at b.$apply (angular.js:18117)
at HTMLButtonElement. (angular.js:26813)
at dg (angular.js:3617)
at HTMLButtonElement.d (angular.js:3605)

Thoughts?