mimecorg / webissues Goto Github PK

I've installed WebIssues 2.0.2 with MySQL and noticed that the issue id isn't sequential but skipping by two, i.e. 1, 4, 7, 10 etc.

I looked at the table schema and see that the primary key on issues isn't using AUTO_INCREMENT - is that expected?

I see that there is a getInsertId function for each db engine and that MySQL is using mysqli_insert_id function.

The db engine for MS SQL is using @@IDENTITY so I assume that it's using an identity column definition?

The system still works OK, but it's strange to see the id not being sequential. Is this a bug or expected behavior?

Is it possible to set the base URL anywhere, I am struggling to find it.

The register of a new issue response email look like this to me so the link back fails -

'To view this issue, you can open the following URL:

/client/index.php#/issues/17'

From experience it is nesseccary to have a fulltext search option that does not only search for a term in the ticket title, but also in the ticket body.

If this is possible I found no way to do it?

Hello Michal,

just installed webissue and trying to add a new button at the top right of the menu but without any success.
trying to add it in client/index.html.php or in common/navbar.html.php

any ideas why?

Best regards.

Hi there,

how I can debug this ?

the message says me absolutely nothing at all,
also, I see nothing in the server log files...

Hello,

I'm searching for a (really) opensource ticketing system for a customer...

The need is to have a versatile enough ticketing system to manage technical operations in a datacenter.

So we need to link the ticket to an equipment with its location (floor, room, rack number, server number).

The custom fields are a (very) good start be we would have to contribute improvements... plus integration with equiment database systeml, with enterprise directory (LDAP) plus maybe SSO, plus workflow and delegation to manage fine grained approval, and reporting...

Would webissues community be open to such cooperation (discussions about how to do things the right way, review and merging of the pull requests that would be submitted, etc.)

Kind regards,
PV

It would be nice if all dialogs could be closed when pressing the ESC key.

Make all selecboxes searchables like "select2" plugin.(https://es.vuejs.org/v2/examples/select2.html)

I've a lot of projetcs and only can do scroll, search función would be great.

And so an auto-width with long options mames.

Regards!

Search function work properly when search with [ID, Name, Created Date, etc]
but when search with custom field it always show Unexpected error - An internal server error occurred.

Hi there and thanks to the team for the beta. Nice to see progress in this project.

I haven't fully checked out beta 1 yet so i'm not sure if there is a configuration option for what i'll ask, but for CSV exporting it would be better to be able to define the separator somewhere. Excel by default understands semicolon as separator, so personally, i would prefer to have that as a default separator in my setup.

Also, from what i've seen in the demo page after exporting the "Tasks" item, the "Location" column of each task row is "WebIssues — Tasks". "—" is not a standard character, so perhaps you should consider changing it to a simple "-".

NA

In list view ID, Name, Location column use half screen area while the rest need to scroll
It would be great if user can adjust column width by themselves

I miss the complete overview over all tickets in the system. So I need a new selection value for the type selection at the top left at the web client. I do need a value "All types" (should be the default) that leads to an overview of all tickets without filtering a type.

Well, what the title says...

Changed to php 7.2.7 (Windows 7 pro - IIS express) not for a specific reason, just testing.

v. 7.0.9 and 7.0.33 work fine.

When using date filters i keep getting an error caused by the format of the data.

We use to work with version 1.1.5 and at the begining of the year we jumped to 2.0 and to in august 2.0.1.

The funny thing is that we had a big amount of views created on version 1.1.5 with date filters, and worked fine, but when we try to create a new one or when we try to modify the date of an existing one we get this "non-valid format" error.

Any ideas?
Thanks!

I've noticed that a custom Class was written for generating the Hash for Passwords, which salts the Password with MD5.
Ref:

Salted MD5 is not fitted for hashing Password and is widely not regarded safe for this purpose. (Ref)

Is there a reason not to use the Build-In functions from PHP that comes with way better Hashing Alogorymths, namely: password_hash for creating and password_verify, both available since PHP5.

As it stands now, I see this as a massive Security Vulnerability. Although this could be very easily migrated to the native PHP functions by replacing the body of the relative method in the PasswordHash class since the signature is very similar, if not identical.

While upgrading from a working 1.1.5 to 2.0.5 (after i logged in and pressed "update database"), i received the following error. The user has permission in the DB (owner) and the folder structure (1.1.5 was working fine). Where should i start checking?

Unhandled com_exception: Source: Microsoft OLE DB Provider for SQL Server
Description: Cannot drop the trigger 'alerts_type_id_delete', because it does not exist or you do not have permission. in C:\inetpub\apps\WebIssues\v2.0\system\db\mssql\engine.inc.php on line 85
Stack trace:
#0 C:\inetpub\apps\WebIssues\v2.0\system\db\mssql\engine.inc.php(85): com->Execute()
#1 C:\inetpub\apps\WebIssues\v2.0\system\db\connection.inc.php(215): System_Db_Mssql_Engine->execute()
#2 C:\inetpub\apps\WebIssues\v2.0\system\db\connection.inc.php(186): System_Db_Connection->executeArgs()
#3 C:\inetpub\apps\WebIssues\v2.0\system\db\mssql\schemagenerator.inc.php(127): System_Db_Connection->execute()
#4 C:\inetpub\apps\WebIssues\v2.0\system\db\schemagenerator.inc.php(158): System_Db_Mssql_SchemaGenerator->executeAlterTable()
#5 C:\inetpub\apps\WebIssues\v2.0\setup\updater.inc.php(461): System_Db_SchemaGenerator->removeReferences()
#6 C:\inetpub\apps\WebIssues\v2.0\setup\update.php(149): Setup_Updater->updateDatabase()
#7 C:\inetpub\apps\WebIssues\v2.0\setup\update.php(132): Setup_Update->updateDatabase()
#8 C:\inetpub\apps\WebIssues\v2.0\setup\update.php(42): Setup_Update->processForm()
#9 C:\inetpub\apps\WebIssues\v2.0\system\web\component.inc.php(100): Setup_Update->execute()
#10 C:\inetpub\apps\WebIssues\v2.0\system\web\application.inc.php(77): System_Web_Component->run()
#11 C:\inetpub\apps\WebIssues\v2.0\system\core\application.inc.php(210): System_Web_Application->execute()
#12 C:\inetpub\apps\WebIssues\v2.0\system\bootstrap.inc.php(130): System_Core_Application->run()
#13 C:\inetpub\apps\WebIssues\v2.0\setup\update.php(180): System_Bootstrap::run()
#14 {main}

Assume a webissues site in which 2 projects exist, Project1 and Project2. Each project contains a "MyBugs" folder and a "MyTasks" folder. On the leftmost combobox, you select the folder type "Bugs". You then go and select Project1 from the combobox.

Now, at the right of the "Project" combobox, the Folder combobox exists. It has as a default value "All folders". Since it contains only one "Bugs" folder (the "MyBugs" one), why not pre-select it? That way, every time you add a new Issue, you will not have to select the "Folder".

Currently, anon users can see issues, comments and attachments (and can download them). I believe, there should be a setting about what anon user can do, so we can prevent downloading attachments.

I've been using Email Notification when Issue has edited in Previous version
https://doc.mimec.org/webissues/1.1/en/webissues.prep.notifications.html

But in current version I've not seen it in Email Setting
Is it gone?