great software by the way !!
Tried it on MacOS, on a bitnami LAMP stack, no problems ... so far.
But when installed on Ubuntu Xenial i had two errors :
1/ page not found
because of insufficent parameters in apache config
2/ Fatal error: Uncaught TypeError: Argument 1 passed to flight\Engine::handleException() must be an instance of Exception, instance of Error given in /var/www/html/VisualQuery/core/flight/Engine.php:149 Stack trace: #0 [internal function]: flight\Engine->handleException(Object(Error)) #1 {main} thrown in /var/www/html/VisualQuery/core/flight/Engine.php on line 149
-> because we must rename the file app/classes/SqlFormatter.php to app/classes/sqlformatter.php
After some research, i'v found the solution :
0/enable rewrite engine on apache (as root : a2enmod rewrite)
1/for my visualquery directory named as "visualquery" in /var/www/html
2/rename the file app/classes/SqlFormatter.php to app/classes/sqlformatter.php
3/then create a file in /etc/apache2/conf-available/visualquery.conf with the content below
4/ Activate de conf in apache via the command "a2enconf visualquery" as root
5/ reload your apache conf via the command "service apache2 reload" as root
Hi,
great software by the way !! Tried it on MacOS, on a bitnami LAMP stack, no problems ... so far.
But when installed on Ubuntu Xenial i had two errors : 1/ page not found because of insufficent parameters in apache config
2/ Fatal error: Uncaught TypeError: Argument 1 passed to flight\Engine::handleException() must be an instance of Exception, instance of Error given in /var/www/html/VisualQuery/core/flight/Engine.php:149 Stack trace: #0 [internal function]: flight\Engine->handleException(Object(Error)) #1 {main} thrown in /var/www/html/VisualQuery/core/flight/Engine.php on line 149 -> because we must rename the file app/classes/SqlFormatter.php to app/classes/sqlformatter.php
After some research, i'v found the solution :
0/enable rewrite engine on apache (as root : a2enmod rewrite) 1/for my visualquery directory named as "visualquery" in /var/www/html 2/rename the file app/classes/SqlFormatter.php to app/classes/sqlformatter.php 3/then create a file in /etc/apache2/conf-available/visualquery.conf with the content below 4/ Activate de conf in apache via the command "a2enconf visualquery" as root 5/ reload your apache conf via the command "service apache2 reload" as root
... then, it should work in http://yourserver/visualquery
vi /etc/apache2/conf-available/visualquery.conf then copy this content
Apache config file for Dolibarr
Directory for web pages
<Directory /var/www/html/visualquery>
<IfVersion < 2.3> Order deny,allow Allow from all
DirectoryIndex index.php Options +FollowSymLinks +Indexes