I have a client with 7 locations, and 175 agents. I am in the process of migrating their 2500 listings from a Windows environment to a Centos server. I've been tinkering with OR for a month or two. I am getting a little tired of reading on the OR board that a minor customization to accommodate my client's needs involves a major core change at every turn.

Anyway, Free Realty, what a concept, what a script.

Thank you!

Cheers,

SO THIS IS WHAT I DID:

I created a database user and a database.  I tried to run install.php, but there is no such file.  Instead, I tried opening via a browser install30.php but it said I needed to manually copy common.php (from common30.sample.php) and configure it.  I did this and put the
database details in lines 16 to 22 of the new copy, then ran install30.php again.  This produced a long printout that appeared to be an sql file being run, followed by a vague warning about old versions of php4.  As I have php5, I could not see its relevance.  There was also a link to "Login" at the end of the printout.  This opens a page {webroot}/admin/ which offers a choice of
    Main Administration Tool
    Agent Editor
    Site Configuration Information

I started with Main Administration Tool, assuming I need to set up admin user at least.  This links to a roughly laid out login page.  No obvious username-password pair works.  Grepping for admin, I found apparent default values on lines 93, 94 of install30.php.  These 'admin_user', 'admin_password', also do not work.  Putting in other values on the lines 89, 90 (which were null strings), also has no effect.  I suspect this file is in any case once only, and now irrelevant after it has been run.

I then tried to run /install/configurator.php (again by opening it in the browser).  To my surprise, it produces an entirely blank screen.

I can't really guess what else to try.  Pity I could find no installation instructions...

So, if someone can suggest a different strategy for installing 3.0, I shall give it a go tomorrow.  Otherwise, I shall have to go back to the uncertain delights of open-realty.  (Also seems strewn with install bugs, though at least the main interface comes up.  And then there is the non-GNU license...)

Help, anyone?

richard

Years ago back when php 3 was new I tore apart a shopping cart and turned it into a Real Estate site.

I just downloaded and am setting up a FreeRealty site for a prospective new client of mine.

It was pretty easy to get it installed and running, just a couple of stumbles and that's fine as I understand what open source is all about.

My question is I can't default the location to Nevada.  It's always Alabama.

I was going to go into the database and remove all the states except Nevada but I thought I better ask about that first.

http://66.196.34.103/~pri/index.php  is waht I'm working on.  My customer is dealing with Network Solutions trying to get her DNS servers changed to mine.

Thanks,  George

The install and upgrade scripts will now set a version number in the database. This will allow checking to see if the script is up-to-date and will show only the updates needed in the upgrade script. This will apply to versions from 2.9 up. Previous versions did not set the version in the database. It may now also become possible to check the version from the admin interface, although that has not been built yet.

I hope to have a demo release available soon at: http://freerealty.rwcinc.net/alpha

 if (config_options('debug') == 'y') 

to:

 // if (config_options('debug') == 'y') 

Or just delete that line... it's throwing off the view variable.

All fixes are in the latest release 3.0-0.rc8 (a long time coming). Download and enjoy: http://freerealty.rwcinc.net/download.php

Unknown column 'dateposted' in 'field list'

I found the other post about this and tried to run the command line suggested, but it would not work.

In PHPmyAdmin I get this error message when I try to use this command:

ALTER TABLE homes ADD COLUMN dateposted date,
dateupdated date;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dateupdated date' at line 1

Any other suggestions?

steve

Cheers,
Paul.

New features include,
new access control module,
import of Zencart customer and product records,
improved backup/restore process,

CK-ERP is an open source accounting/MRP/ERP/CRM system that runs on top of multiple middlewares.  It comprises 24 modules - Administration, Data Import, Access Control, i18n, Contact Management, Customer Relationship, Customer Self Service, Vendor Relationship, Ledger, Bank Reconciliation, MRP, Warehouse, Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager, HR, Staff Self Service and Payroll.  It provides accounting and back office functionalities to SMEs and utilizes the underlying middleware to administer accounts/groups.  Please report error and suggestion to the discussion group / mailing list, CK-ERP-en(at)googlegroups.com or CK-ERP-zh_CN(at)googlegroups.com .  General history and expected development is available at the discussion group's Archive.

Supported MiddleWares:  Centre/SIS, ClaSS; OpenBiblio; CATS; php-residence, phpScheduleIT; AssetMan; Coppermine, Gallery2; FusionTicket; phpMySport; PSCafePOS, MyHandyRestaurant; FreightFleetManagementSystem; OpenX, LandShop, Open-Realty, FreeRealty; IRM; LegalCase; ClearHealth, OpenEMR, Care2X; eGroupWare, Horde-GroupWare; Zencart, osCommerce; Drupal, Joomla, Mambo, e107, XOOPS, Xaraya; Moodle, Atutor; vTiger; WordPress, b2evolution; TikiWiki; phpBB.

Information/Demo Websites:
http://ck-erp.org
http://ck-erp.net

Download is available from,
http://sourceforge.net/projects/ck-erp
http://gro.clinux.org/projects/ck-ledger
http://gforge.oss.org.cn/projects/ck-erp

New features include,
Sample school chart of accounts,
System upgrade script,
menu choice for warehouse, retail store,
tree view for BOM, inventory category, service category,
import of eGroupWare addressbook,
full (draft) Spanish translation [improvement suggestions most welcome], and,
connector for CATS, php-residence, Open-Realty, phpScheduleIT, PSCafePOS, OpenBiblio, Centre/SIS, ClaSS, Care2X

CK-ERP is an open source accounting/MRP/ERP/CRM system that runs on top of multiple middlewares.  It comprises 23 modules - Administration, i18n, Data Import, Contact Management, Customer Relationship, Customer Self Service, Vendor Relationship, Ledger, Bank Reconciliation, MRP, Warehouse, Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager, HR, Staff Self Service and Payroll.  It provides accounting and back office functionalities to SMEs and utilizes the underlying middleware to administer accounts/groups.  Please report error and suggestion to the discussion group / mailing list, CK-ERP-en(at)googlegroups.com or CK-ERP-zh_CN(at)googlegroups.com .  General history and expected development is available at the discussion group's Archive.

Supported MiddleWares:  Centre/SIS, ClaSS; OpenBiblio; CATS; php-residence, phpScheduleIT; AssetMan; Coppermine, Gallery2; phpMyTicket; phpMySport; PSCafePOS, MyHandyRestaurant; FreightFleetManagementSystem; OpenX, LandShop, Open-Realty, FreeRealty; IRM; LegalCase; ClearHealth, OpenEMR, Care2X; eGroupWare, Horde-GroupWare; Zencart, osCommerce; Drupal, Joomla, Mambo, e107, XOOPS, Xaraya; Moodle, Atutor; vTiger; WordPress, b2evolution; TikiWiki; phpBB.

Information/Demo Websites:
http://ck-erp.org
http://ck-erp.net

Download is available from,
http://sourceforge.net/projects/ck-erp
http://gro.clinux.org/projects/ck-ledger

I've checked around both OR and FR sites but can't seem to find anything definitive.

Can anyone help?

Thanks
Susan