Activity for allocPSA
-
Anonymous posted a comment on discussion Open Discussion
Hi Con, Unfortunately I don't have the original operational vm anymore. I migrated the site over using cPanel transfer tools and assumed it was ok since I tested some other php websites and they were running fine but did not check all of them. Subsequently I destroyed the old vm. I also have backups, and tried restoring those without success. It may be possible that the current state of the app is between upgrades since at different times I did manage to get the update php page to run, but subsequently...
-
Anonymous posted a comment on discussion Open Discussion
Hi Con! So cool to get a response from you, glad you are still kicking :) I'll look into setting something like that up if I can make the time, I might have to dig around to find the right versions of dependencies and get them running. Could this be a case that docker could facilitate do you think? All the best! Keith
-
Con Zymaris posted a comment on discussion Open Discussion
Howdy Keith. We're still using the system in production with no problems, but in virtualisation or container modes, and with the then supported instances of the web-server and SQL server. If you're able to setup (or migrate) an old instance as a container or VM, then all works fine.
-
Keith Waldron posted a comment on discussion Open Discussion
I tried a few years back to migrate my installation to new server updates and was not able to iron out the bugs myself. I know active development and maintenance has not continued but is anyone running this on modern updated servers (secure)? Over the years circumstances and changing needs have found me in many different PSA solutions, but I miss the simplicity and functionality of Alloc and was curious if there was anyone who knew if there was a version that runs on current modern server platforms?...
-
Alex Lance modified a comment on discussion Open Discussion
Hi Keith, Couple of things to check: alloc_config.php should have the database credentials, if you manually try those credentials from the webserver, eg mysql -u blah -p dbname can the webserver connect to the db? this error: Fatal error: Call to a member function query() on null in /home/psaito01/public_html/shared/lib/db.inc.php on line 147 Looks like it's around this line: https://github.com/alexlance/alloc/blob/42d9be421bb31d0d967d8cc0ecbc178907105787/shared/lib/db.inc.php#L150 Which kind of...
-
Hi Keith, Couple of things to check: alloc_config.php should have the database credentials, if you manually try those credentials from the webserver, eg mysql -u blah -p dbname can the webserver connect to the db? this error: Fatal error: Call to a member function query() on null in /home/psaito01/public_html/shared/lib/db.inc.php on line 147 Looks like it's around this line: https://github.com/alexlance/alloc/blob/42d9be421bb31d0d967d8cc0ecbc178907105787/shared/lib/db.inc.php#L150 Which kind of...
-
I don't have the option of virtualizing the earlier running environment. I did a cpanel migration of accounts, I confirmed that everything was there and randomly tested several php production sites and all worked. I checked that the database and files migrated successfully. I did manage to start the update process, but this errored out. Subsequently I can neither run it under php 5.6. I do have full control of this instance (centos vm), so I can implement reasonable work arounds to get it operational...
-
Hi Keith, PHP 5.6 should be fine to use. Zero-ing in on what the cause of the issue is may be difficult however. Do you have the options of making a VM of your existing, functioning allocPSA server that you can then continue hosting as a VM?
-
Note - I have installed php 5.6 and set allocPSA to use that. I am still getting errors. I would like to stabilize and make this functional although I am not sure if the database or the files are consistent. Is there a way I can take the database I have, check the version, then pick a suitable release, run the upgrade and make it function? TIA KW
-
Con! So happy you are still at it with AllocPSA. Update - I decided to install php 5.6 to the server, I can manage this reasonably safely for a short time. Now - I applied the php 5.6 to my web app and subsequetly enabled mbstring as per one of your other posts. I also installed the php PDO package. I am now getting another error which perhaps you can help me with: Fatal error: Call to a member function query() on null in /home/psaito01/public_html/shared/lib/db.inc.php on line 147 This occurs when...
-
Howdy Keith, We're many months into the lengthy process of migrating allocPSA to PHP 7.x and updated MySQL/MariaDB. With luck, that should be finished in the coming months. In the meantime, we recommend that users host their previously running allocPSA instances as a VM, while taking sensible precautions to limit remote access etc, to reduce security risks. -- Con
-
Anonymous posted a comment on discussion Open Discussion
Hello, I am a long time allocPSA user. I recently retired an old server and migrated to a newer server that does not run php 5.6 but only 7.1, 7.2 and 7.3. I also had to update versions of alloc at the same time as trying to run the previously migrated code did not work as is. I first ran the update patch which loaded the patch page without errors, however subsequent clicking on the "apply all patches" button but received a server 500 error: Fatal error: Uncaught Error: Call to undefined function...
-
Hello, I am a long time allocPSA user. I recently retired an old server and migrated to a newer server that does not run php 5.6 but only 7.1, 7.2 and 7.3. I also had to update versions of alloc at the same time as trying to run the previously migrated code did not work as is. I first ran the update patch which loaded the patch page without errors, however subsequent clicking on the "apply all patches" button but received a server 500 error: Fatal error: Uncaught Error: Call to undefined function...
-
Hi Wally, is this still occuring? Does it always resolve when you restart MySQL? Are you using the same MySQL server version as you'd used previously? -- Con
-
Wally posted a comment on discussion Help allocPSA
Hey Alex, this seems to be re-occuring where if I restart MySQl everything is good - could you give any clues as to where I might look? Thanks.
-
Restarting MySQL seems to have got it going again.
-
Whoops forgot to login before posting...
-
There appears to be a change in the configuration of mysql (as of 5.7.12) which results in the ongoing generation of errors like: 1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by The actual problem is not one related to the SELECT statements and can be resolved by adding the following: [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION...
-
This file (db_patches.sql) is missing from the GitHub repo. It's available from here however.
-
Running the db_data.sql script within interactive mysql generates a number of errors, see below: ERROR 1366 (HY000): Incorrect string value: '\xE2\x82\xA1' for column 'currencyTypeLabel' at row 1 ERROR 1366 (HY000): Incorrect string value: '\xD9\x84.\xD8\xB3' for column 'currencyTypeLabel' at row 1 Query OK, 1 row affected (0.00 sec) ERROR 1366 (HY000): Incorrect string value: '\xE0\xB8\xBF' for column 'currencyTypeLabel' at row 1 ERROR 1366 (HY000): Incorrect string value: '\xD0\x85\xD0\x9C' for...
-
When tryng to install the current version of allocPSA (1.8.x) there will be a requirement to execute the db_patches.sql script within the intgeractive mysql program. This file appears to be missing.
-
If you are experiencing this error in allocPSA, then read on. Current versions (1.8.x) require the mbstring PHP extension. To install that, refer to your operating systen's HOWTO, for example: https://askubuntu.com/questions/772397/mbstring-is-missing-for-phpmyadmin-in-ubuntu-16-04
-
Anonymous posted a comment on discussion Help allocPSA
I think the last backslash escpes the quote in: define("ATTACHMENTS_DIR","/docs\"); Maybe try replacing it with either a single forward slash or two backslashes: define("ATTACHMENTS_DIR","/docs/"); define("ATTACHMENTS_DIR","/docs\");
-
Anonymous posted a comment on discussion Help allocPSA 1.5
I get : " Invalid username or password." in the login screen... Is there a table...
-
Anonymous posted a comment on discussion Help allocPSA 1.5
Hello, Thanks 4 your reply! I get the error: " Invalid username or password. " right...
-
Ricardo modified a comment on discussion Help allocPSA 1.5
Hello, I get the error: " Invalid username or password. " I am sure im using the...
-
Hello, I get the error: " Invalid username or password. " I am suer im using the...
-
Hello, I get the error: " Invalid username or password. " I am suer im using the...
-
Hi there. can you tell us what the error is that's thrown? -- Con
-
Anonymous posted a comment on discussion Help allocPSA 1.5
Hi Alex Sorry, was looking for this in the projects column. Found this radio button,...
-
Anonymous posted a comment on discussion Help allocPSA 1.5
Hello I have a small issue with the Inbox functionality. Emails sent to us in HTML...
-
Anonymous posted a comment on discussion Help allocPSA 1.5
Hello, I appreciate your help in advance. I just installed it for the first time,...
-
Anonymous posted a comment on discussion Help allocPSA
When I try to launch allocpsa after installing I get the following error ( ! ) Parse...
-
Hi Anonymous. it's hard to say what would be classified as many improvements from...
-
Anonymous posted a comment on discussion Help allocPSA
Yes my main issue is the installation part of the latest version and i'm getting...
-
Anonymous posted a comment on discussion Help allocPSA
Hello everyone is project still going or is it done. I have tried to install the...
-
Hi, the project is fairly mature at the moment. Not much movement from a development...
-
Ah cheers, good stuff. Thank you!
-
Yes it did. What worked was this sequence, first load structure, triggers, constraints,...
-
Hi Wally, no worries. Is there a reminder table? Does your backup/dump file have...
-
Thanks for yor quick response Alex! Got this ERROR 1146 (42S02) at line 1043: Table...
-
The procedures/functions that are a part of the alloc database didn't get backed...
-
Hi, restored db after some maintenance [ mysql alloc < allocbak.sql ] and am now...
-
Anonymous posted a comment on discussion Open Discussion
Thanks. Good to know that it's still being developed anyway. ADW
-
Greetings ADW, yes, we're still actively working on new versions of allocPSA. However,...
-
Anonymous posted a comment on discussion Open Discussion
It's been over a year now since the last release of AllocPSA. Just wondering if development...
-
Anonymous posted a comment on discussion Developer
You can avoid the error like this: $index = new Zend_Search_Lucene($index_file, ...
-
Anonymous posted a comment on discussion Help allocPSA
consulta SQL: Documentación -- task perm DROP PROCEDURE IF EXISTS check_for_parent_task_loop;...
-
Anonymous posted a comment on discussion Help allocPSA
Perfect Thanks :)
-
Anonymous, what version of allocPSA are you using? What OS and what version of MySQL?...
-
Christopher Bayliss posted a comment on discussion Help allocPSA
try changing the group owner and owner of /var/local/alloc/ to apache, e.g.: chown...
-
ok, the issue I had was due to php-mbstring not being installed. Make sure you have...
-
Yes this is still an issue. I'm looking into it now, and hopefully will report back...
-
Chris, is this still an issue? We're performing some installation tests presently...
-
sol2014, we're performing some test installs presently to see if we can replicate...
-
Hello there, allocPSA provides information about how to use the Wiki as well as what...
-
sol2014 posted a comment on discussion Help allocPSA
Can someone help me with this? I wanted to test it out on my Godaddy Shared Hosting...
-
Chris Bailey posted a comment on discussion Help allocPSA
Hi, I just downloaded version 1.8.9 and when I browse to http://<Server>/alloc all...
-
Hello there. the: "Fatal error: Uncaught exception 'Exception' with message 'Validation...
-
Dilip, are you still seeing the same issue? -- Con
-
Dilip Gupta posted a comment on discussion Developer
Hi, Yes the PHP PDO library is installed and activated on my server. Thanks, Dilip...
-
Hi Guys, I installed the allocpsa on my server successfully, When I login and try...
-
Alfredo, please review the following for more information: https://sourceforge.net/p/allocpsa/discussion/562149/thread/0ef2aebd/?limit=25#31ba...
-
Hi Anshul, Here's a thread for that issue in project-open, maybe it is a similar...
-
Anshul, it doesn't look like you're using allocPSA, but you're using Project-Open....
-
Anshul Patidar posted a comment on discussion Open Discussion
error image of above query
-
I have created a Project ABC and a Sub Project under the this Project. I have added...
-
allocPSA 1.8.9 released
-
allocPSA released /allocPSA/1.8.9/allocPSA-1.8.9.tgz
-
Thanks for the responses. Cheers. -- Con
-
Can you confirm with me that you understood every step that I outlined in my previous...
-
Hi Jürgen, There's a half sort of hidden project filtering option on the task list...
-
Jorge, all the information you need is probably contained here: http://demo.allocpsa.net/help/help.html?...
-
Jorge, the best thing to do is to go here: http://demo.allocpsa.net/login/login.php?message_help=Username:+alloc+%3Cbr%3E+Password:+alloc...
-
Well, you're asking a lot. Essentially an application deployment tutorial in an environment...
-
Maik N. posted a comment on discussion Open Discussion
Could you answer me the following questions to your community? When was your community...
-
-
The following problem "Warning: is_readable() [function.is-readable]: open_basedir...
-
The following problem: "Unable to connect to MySQL database server! (Unable to connect...
-
Hi Con, I'm using the shared linux based server. and the details are below. Apache...
-
Hi Con, I'm using the shared linux based server. and the details are below. Apache...
-
Hi Dilip can you tell us what versions of the OS & Apache, MySQL and PHP you're using?...
-
Anonymous, is this host a standalone server, or once again something under Cpanel?...
-
Greetings Anonymous, perhaps try this solution approach: http://stackoverflow.com/questions/11475365/error-connecting-to-mysql...
-
Anonymous, can you provide more information about what version you're trying to install,...
-
-
-
Anonymous, can you copy and paste the exact error you're seeing? -- Con
