installing Xataface on IIS 5.1\PHP 4\MYSQL6 ERRORS

[cwight27]

i have gotton all three installed. php came up fine however I cant get it to recognize database_info it attempts to execute the file rather than opening. I have granted the webserver read and write to directory and sub directories. Additionally Xataface is installed in the www root directory.

Please help.

[shannah]

Try skipping the dataface_info.php step and go straight to trying to set up your first app. If you get problems, check your error logs (or hopefully the errors will display for you on the screen). Haven't tried this combination out yet, and haven't tried with MySQL 6 yet either - but no reason why it shouldn't work.

-Steve

[cwight27]

I went another direction with my development enviroment Unbuntu/php/ mysql

Everything is working until I access my new app created by Xataface. This is the error I get when I access index.php

Fatal error: Error performing mysql query to get column information from table 'PetBoarding'. The mysql error returned was : 'Table 'Montrose.PetBoarding' doesn't exist'.
On line 467 of file /var/www/xataface-1.1.5r2/Dataface/Table.php in function printStackTrace()
On line 2207 of file /var/www/xataface-1.1.5r2/Dataface/Table.php in function Dataface_Table(Pet Boarding,Resource id #11,)
On line 774 of file /var/www/xataface-1.1.5r2/Dataface/Application.php in function loadTable(Pet Boarding)
On line 1484 of file /var/www/xataface-1.1.5r2/Dataface/Application.php in function handleRequest()
On line 5 of file /var/www/Montrose/index.php in function display()
in /var/www/xataface-1.1.5r2/Dataface/Table.php on line 467

I am on the cusp if you can give me some assistance I will be on my way

[shannah]

This is likely an issue with case sensitivity in table and database names. Check your database table names and make sure that the names in the conf.ini file, and your table configuration directories match (case sensitive).

-Steve

[cwight27]

The Xataface application came up fine for one table and the other table came up with an issue

Fatal error: We had a problem with the query select count(`Patient id`) from `patient information`. in /var/www/xataface-1.1.5r2/Dataface/QueryTool.php on line 111

Any suggestions on how to proceed.

[shannah]

Strange. Are the spaces in column and tables names supposed to be there?

Also, you might want to copy and paste this query directly into PHPMyAdmin and see what the SQL error is.

[cwight27]

The front end looks wonderful lol. I am glad I got this far. A couple of issues however I cannot add new records on the data-face front end it says the field is requires I put information in it and attempt to save and it errors out. Saying the field is required. Also the search parameters do not work on form but works on the search option in the top of the page. A little strange until I hear from you I will be working on the Dash Board. Thanks for developing a useful tool.

[shannah]

ttempt to save and it errors out.

What does the error say?

[cwight27]

When I attempt to add a record in Xataface I get this message
Errors

* Some errors occurred while processing this form:
o Pet Name is a required field.

I added the name so I dont understand the error.

For the previous post I get

Failed to get field Pet_Name: 2Failed to get field Responsible_Party: 2Failed to get field Home_Number: 2Failed to get field Work_Number: 2Failed to get field Cell_Phone_Number: 2Failed to get field Email_Address: 2Failed to get field Date_of_Birth: 2Failed to get field Date_of_First_Visit: 2Failed to get field Date_of_Last_Visit: 2Failed to get field Date_of_Next_Visit: 2Failed to get field Primary_Doctors_Name: 2
Warning: Cannot modify header information - headers already sent by (output started at /var/www/xataface-1.1.5r2/Dataface/SearchForm.php:332) in /var/www/xataface-1.1.5r2/Dataface/SearchForm.php on line 354

When I attempt to access query from the Find Tab. The search bar at the top of the page works fine though.

[cwight27]

I read through the forum and I found about the spaces on the MYSQL table names which I corrected and fixed my issue. Is it possible to have the calender provide a weekly versus monthly view.

Thanks in advance!