Critter

I'm having a strange problem where Accounts created by one user is not visible (searchable) by another user (even those with Admin rights)

Unfortunately this is version 1.1.2, and I know a probable fix is to upgrade, but that's difficult at the moment.

Anyone got any suggestions?

Best regards Espen Lyngaas

The demo system is available and has been populated with basic data. We intend to keep the system up to date adding sales/purchase invoices, moving stock, processing works orders, etc. including month end processing. The system will be refreshed on a regular basis with this additional data.

This thread sure came in handy.

Must say, README.txt is pretty much rubbish. As gerrya already points out, the PostgresQL actually needs built something like as follows:

$ psql

postgres=# CREATE USER "user" WITH PASSWORD '';

postgres=# ALTER USER "user" CREATEDB;

postgres=# \q

$ createdb egs2db -U "user" -h localhost

$ psql -h localhost -U "user" -d egs2db

postgres=# \i /"path-to"/egs2beta1initial.sql

All that, PLUS having to remove two illegal UTF8 characters from egs2beta1initial.sql (see the thread on that) around line 10765 and the undocumented requirement to install the software in the root web service directory (see the other thread on that - WTF!?!) are pretty much the three main hurdles to getting this going.

After the undocumented struggles, however, the software DOES run and provides exactly what I was looking for - a lean, minimalist CRM & Project web service

Hey there

How about multilingual support? is there a plan for it?

Thanks

EGS is changing.

From June 1st 2009 Severn Delta are taking over the responsibility for the development of EGS.

For the last few years Severn Delta Limited have been collaborating with Senokian Solutions to develop EGS for use in manufacturing. Lots of work has been going on in the background to develop the EGS framework and additional modules.

We'll be letting you have an insight into where we are up to and our future plans over the next few days and weeks.

Team EGS

can this be installed on a shared hosting account? Does anyone have a demo to look at?

Damn! I have been looking high and low for something like this - a decent looking and easy to use CRM / Project Management System with Time tracking.

Then I find out its a dead project. Damn!!

I have the same problem. When I try to add some project I receive similar exception

Try moving the app out of the folder eg2 into your wwwroot folder.

That sorted some probs for me.

//Skalitz

Hello everyone

I've tried to log in but when I try to access to the index page, I got a blank page without any code or error number.

Apache is running so I can access other applications.

I have already created the databases and run the SQL script, I have modified my config.php according to my server configuration.

What could be wrong?, I'm user the latest stable release.

Kind regards!

Hi,

Sorry for a potentially noobish question.

I'm trying to install EGS on my Web Hotel account witch supports both PostgreSQL and PHP.

I copied the files to the server root and set up the conf file correctly so that the app connects to the DB.

My problem is that I cant import the supplied schema into the DB.

The interface for SQL management is phpPGAdmin and when i created the DB it automatically created a schema called public. I entered this schema and tried running an SQL question by uploading the egs2beta1initial.sql file. This created the whole structure in the schema public but it didnt include any info in the tables.

When i browse the DB, ie. users there is no info there (i suppose it should be user: root and pass: password, but its empty).

When i try to login to the application it says: "Incorrect username/password combination, please try again"

I think the problem lies in my method of importing the DB (by upload an SQL script in phpPgAdmin)

When troubleshooting this ive come across a way of doing this: psql -U yourdbname yourdbname < yourdumpfile. (psql is the same command as in the readme-file) But i dont know where to put the sql-file in order for phpPgAdmin to find it?

Please help, i'm pulling my hair here. Thanks, Skalitz

ok, I've tried installing using phpPGAdmin and via separately via shell. So far, I get an error on shell saying "Incorrect username/password combination, please try again" and a very cryptic error on phpPGAdmin. Can anyone please tell me where I should start looking for the cause of the issue?

Also, I performed a reverse md5 hash on the password stored in the users table and it verifies as "password" so root / password should work, alas, I am baffled as it is broke.

Regards.

P.s. many thanks for the help!

I need an erp that can do the following...Can EGS?

Invoice customers and charge their credit card. Allow salesman to only see his own customers and sales. Allow Sales Manager to see all customers and sales. Support recurring sales.

Did I come to the right place?

Hi

Something that I would like to see is support for incoming and out going packages. It would be nice if in my business, my sales men could create a sales order, assign it to my shipping department. Then my shipping department could take that sales order, create an invoice and shipping label, package my item up and ship it. It would then be able to email the customer with the tracking number and be marked as shipped.

The only other CRM I know of that has something like this is info@hand.

I have been looking at this project and am really excited! I feel like I would like to get involved in some way however I still feel a good CRM should be developed in Java IMO.

(Edit.. I think this functionality exists in EGS ? I did read enough I guess, I would be nice if the demo got fixed :)

The Net Duck

Hi!

I'm new in EGS, I wanted to try it in my localhost ( Ubuntu 8.04, Apache2, PHP5, MySQL, PostgreSQL, phpMyAdmin, phppgAdmin ).

I've created the database, and I've configured the config.php file.

When I try to log in with any user ( if I invent a user it happens the same ), I don't go to any index or homepage, I go to the Apache's index.html page ( IT WORKS! )

Do you know what have I to do?

Thanks!

Sorry about my english if I have made any mistake...

I am trying to set up 1.2.8 and did the following:

1. Uploaded all files
2. Set up the config file
3. Created database in postgresql
4. Imported schema.sql and got the following error: language "plpgsql" does not exist

Stopped there.

How do I sort this out? Any help deeply appreciated.

I have gotten EGS installed and working but I cannot login at all. I am not getting any error messages at all, I am just at the login page and no matter what I type it just brings me back to the login screen.

Resolved the problem myself. Dropped database and created it with a different user other than the postgres user.

Re-installed everything and same thing happened. Tried both password and root as the root user password: Error in log is as follows:

2008-08-06 11:43:52 AST LOG: database system is ready

2008-08-06 12:00:18 AST ERROR: permission denied for relation users

2008-08-06 12:00:18 AST STATEMENT: SELECT u.username FROM users u LEFT JOIN usercompanyaccess uca ON (u.username=uca.username) LEFT JOIN systemcompanies sc ON (uca.companyid=sc.company_id) WHERE sc.enabled AND uca.enabled AND u.username='root' AND password=md5('password')

2008-08-06 12:00:31 AST ERROR: permission denied for relation users

2008-08-06 12:00:31 AST STATEMENT: SELECT u.username FROM users u LEFT JOIN usercompanyaccess uca ON (u.username=uca.username) LEFT JOIN systemcompanies sc ON (uca.companyid=sc.company_id) WHERE sc.enabled AND uca.enabled AND u.username='root' AND password=md5('root')

I ran into some issues with the hard drive in this test PC and am currently re-installing system, will try again with this application as soon as the system is up and running and hopefully have better success. Will let you know one way or the other.