Enter the correct username - Problem

[Curt]

"Enter the correct username" Problem
OK, I am very new to PHP and MySQL and I need some coaching. I have a realtor program that I down loaded and I have followed the instructions (tried on two of my sites with the same problem) and I get a PHP/SQL "Enter the correct username" line when I try to run the configurator program. I activated a database and I am using the control panel id and pwd in my scrips.

http://www.point-tech.com/openrealty/configurator.php
http://www.point-tech.com/openrealty/admin.php

When I first try to access the script I get phromted for a password and user ID, once I enter those I get blank screen only with the words "Enter the correct username"

The install process is at:
http://www.point-tech.com/openrealty/installation.php

Any ideas?

Thanks,
Curt

[Annette]

Which username/password combo are you entering? When I enter the username and password as written in the installation file (openadmin/openpassword) I get the first configurator screen.

[Annette]

Followup to the above: that actually loaded the tables and gave me a link to the OpenRealty sample page. So...try to get in again using that user/password - and change that user/password if you can/ If you can't, let me know and I'll move this thread out of public view.

[Curt]

Thanks, Not sure what I was thinking but I was trying to use the contorl panel password. Now that I look closer I should have known better. I should be able to change the password, thanks.

[Curt]

OK, Now I have a new problem, when I run the script from wood-crafting.com my script works just fine but when I run it from point-tech.com I get the following:

Connecting to DB....
Connected!
Created table in point_tech_com
You have an error in your SQL syntax near '(air VARCHAR (1), alrm VARCHAR (1), bcny VARCHAR (1), cbl VARCHAR (1), crp VARCH' at line 1Added home features to point_tech_com
You have an error in your SQL syntax near '(fee VARCHAR (1), bp VARCHAR (1), boat VARCHAR (1), clb VARCHAR (1), gtd VARCHAR' at line 1Added community features to point_tech_com
Unknown column 'air' in 'field list'Sample record added to point_tech_com

I have deleted all of my tables starting with a clean database but I still get the same errors.

Thanks,
Curt

[Annette]

I'll take a look at it. The ALTER is a bit funny to work with - interesting that they just didn't include all the ALTER items in the original table build.

[Annette]

OK, I combined the two additional ALTER statements into the table creation portion of that script, and then successfully inserted the sample listing. Looks good to go.