Fatal Error

[gstarke]

Hi
I have been looking for a way to rebuild my highly developed filemaker DB to run on "the cloud" on our mysql server, and discovered xataface! I have optomistically downloaded and installed the program folder on the server, followed the instructions as to how to set up a new app... sorted through some referencing issues for the right directory etc, and access rights to the mysql database and then encountered the following error:
"Fatal error: Call to undefined method PEAR_Error::getField() in /home/stistih/public_html/dataface/Dataface/Table.php on line 2629"
This looks to me like a mismatch in the programming and our server.
The server is hosted, but as far as I am aware is Apache, PHP 5+ & MySQl.
Is there an easy solution to this?
Regards
Graeme

[shannah]

This error indicates that you are trying to access a field that doesn't exist. Are you working with the minimal install (conf.ini and index.php)? If so can you post your conf.ini and index.php files (comment out passwords etc..) There is likely a problem here. If you you've defined delegate classes there could be a problem in there also.

-Steve

[gstarke]

Hi Steve
Thanks for the prompt response.
Yes, I have been using the minimal install just to get started.

My conf.ini is:
[_database]
host = "localhost"
user = "*******"
password = "*******"
name = "stistih_IrlenDBWeb"

[_tables]
Clients = "Clients"

My index.php is:
<?
require_once '../dataface/dataface-public-api.php';
df_init(__FILE__, 'http://homelearn.com.au/dataface');
$app =& Dataface_Application::getInstance();
$app->display();
?>

The dataface folder is in public_html directory and a folder called IrlenDBWeb is in the same directory and it contains the index.php and conf.ini
When I browse to http://www.homelearn.com.au/IrlenDBWeb that's when I get that error.
If I browse to http://www.homelearn.com.au/dataface the installer.php asks for mysql username and password, but I put in the ones I have registered (using cPanel) and it does not accept them. Is this because it has already installed? (the run-once)

[shannah]

You might want to double check the name of the "Clients" table. In Xataface it is case sensitive. I.e. if your table is actually named 'clients' and not 'Clients' then you could get an error like you described.

[gstarke]

Nope. Not that. I checked and it's definitely capital letter start.
The table has no records at the moment but does have 28 fields which may or may not have been fully defined properly.
(I'm a novice with mysql). Would that do it?

[shannah]

Please post the SQL definition of your Clients table.

[gstarke]

Hi Steve
It was manually entered with phpMyAdmin.

A copy of the page with table fields follows:
(Is this readable enough?)
Field Type Collation Attributes Null Default Extra Action
Initial Testing date No None Browse distinct values Change Drop Primary Unique Index Fulltext
Firstname varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Surname varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Address varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Suburb varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
State varchar(3) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Postcode varchar(4) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Parent Names varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Telephone varchar(10) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Mobile varchar(10) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
D.O.B. date No None Browse distinct values Change Drop Primary Unique Index Fulltext
Refered varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Optom varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Script varchar(10) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Date of Lens Test date No None Browse distinct values Change Drop Primary Unique Index Fulltext
Initial Tint varchar(30) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Retest Date date No None Browse distinct values Change Drop Primary Unique Index Fulltext
Change of Tint varchar(30) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Problem varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Patterns varchar(50) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Overlays varchar(30) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Paper varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext
Reading decimal(10,0) No None Browse distinct values Change Drop Primary Unique Index Fulltext
Comprehension decimal(10,0) No None Browse distinct values Change Drop Primary Unique Index Fulltext
Rate decimal(10,0) No None Browse distinct values Change Drop Primary Unique Index Fulltext
Spelling decimal(10,0) No None Browse distinct values Change Drop Primary Unique Index Fulltext
Recall Date date No None Browse distinct values Change Drop Primary Unique Index Fulltext
Status varchar(20) utf8_unicode_ci No None Browse distinct values Change Drop Primary Unique Index Fulltext

[shannah]

Can you post the create table statement? You can do this with an export without data

[gstarke]

Hi Steve

Is this the format you're suggesting - created as export from phpMyAdmin?

--
-- Table structure for table `Clients`
--

CREATE TABLE IF NOT EXISTS `Clients` (
`Initial Testing` date NOT NULL,
`Firstname` varchar(20) collate utf8_unicode_ci NOT NULL,
`Surname` varchar(20) collate utf8_unicode_ci NOT NULL,
`Address` varchar(50) collate utf8_unicode_ci NOT NULL,
`Suburb` varchar(20) collate utf8_unicode_ci NOT NULL,
`State` varchar(3) collate utf8_unicode_ci NOT NULL,
`Postcode` varchar(4) collate utf8_unicode_ci NOT NULL,
`Parent Names` varchar(20) collate utf8_unicode_ci NOT NULL,
`Telephone` varchar(10) collate utf8_unicode_ci NOT NULL,
`Mobile` varchar(10) collate utf8_unicode_ci NOT NULL,
`D.O.B.` date NOT NULL,
`Refered` varchar(20) collate utf8_unicode_ci NOT NULL,
`Optom` varchar(20) collate utf8_unicode_ci NOT NULL,
`Script` varchar(10) collate utf8_unicode_ci NOT NULL,
`Date of Lens Test` date NOT NULL,
`Initial Tint` varchar(30) collate utf8_unicode_ci NOT NULL,
`Retest Date` date NOT NULL,
`Change of Tint` varchar(30) collate utf8_unicode_ci NOT NULL,
`Problem` varchar(50) collate utf8_unicode_ci NOT NULL,
`Patterns` varchar(50) collate utf8_unicode_ci NOT NULL,
`Overlays` varchar(30) collate utf8_unicode_ci NOT NULL,
`Paper` varchar(20) collate utf8_unicode_ci NOT NULL,
`Reading` decimal(10,0) NOT NULL,
`Comprehension` decimal(10,0) NOT NULL,
`Rate` decimal(10,0) NOT NULL,
`Spelling` decimal(10,0) NOT NULL,
`Recall Date` date NOT NULL,
`Status` varchar(20) collate utf8_unicode_ci NOT NULL,
KEY `Firstname` (`Firstname`,`Surname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

[shannah]

Ok. Possible problems are with the d.o.b. Field. Xataface doesn't like periods in the column names. Generally I avoid spaces as well though they might be ok.

[gstarke]

Ah ha!! That did it.
I changed the name of the D.O.B. to DOB, tried again and got a different error this time - "table has no primary key", which I corrected, and behold it works!
I just knew it had to be something simple.
Thanks for that.
I will now begin to explore what Xataface can do.