Xataface Forums

i made the default index.php file from the tutorial, but when i try to run it i get
"Parse error: parse error, unexpected $end in c:\webs\test\book\index.php on line 6"

i fixed that, its because i used notepad to edit the file, but now i get thos error:

Fatal error: Call to undefined function mysql_connect() in c:\webs\test\Dataface\Application.php on line 147

It appears that you don't have MySQL support set up with your PHP install. You will need to install the mysql dll. This is a bit of a pain as PHP 5 no longer comes bundled with mysql support (though it's easy to add).

Installation instructions can be found here: http://ca3.php.net/manual/en/ref.mysql.php

One other note. I see that you are using windows. With version 0.6 I have become a little lax with checking compatibility with IIS. We have been running it on Apache on Windows with no problems, but there is a good chance that there are some incompatibilities with IIS. (i.e. I recommend you use Apache if possible).

Best regards

Steve

im sorry, i should have noted that i am using apache on windows.

ok, i added the support for mysql, now i get this:

Fatal error: Error retrieving title from database in Dataface_QueryTool::getTitles(): SELECT ``,`Description` as `__titleColumn__` FROM `products` LIMIT 250Unknown column '' in 'field list'
On line 113 of file c:\webs\test\Dataface\QueryTool.php in function printStackTrace()
On line 340 of file c:\webs\test\Dataface\ResultController.php in function getTitles(,1,1)
On line 397 of file c:\webs\test\Dataface\ResultController.php in function getLinkHtml(0,currentLink)
On line 310 of file c:\webs\test\Dataface\ResultController.php in function getCurrentHtml()
On line 458 of file c:\webs\test\Dataface\TableView.php in function toHtml()
On line 1149 of file c:\webs\test\Dataface\TableView.php in function _controller()
On line 452 of file c:\webs\test\Dataface\Application.php in function toHtml()
On line 5 of file c:\webs\test\book\index.php in function display()
in c:\webs\test\Dataface\QueryTool.php on line 113

i will most likely be switching to a linux server, but right now im testing on a windows machine, and i think thats why im getting so many errors

We have a 3 applications running on Apache on windows with no issues... so this likely isn't what is causing the errors.

What columns are in the products table?
Does it have a primary key?

If it doesn't have a primary key, adding one should fix this error.

Best regards
-Steve