unexpected end

A place for users and developers of the Xataface to discuss and receive support.

Postby compudude86 » Fri Aug 25, 2006 10:07 am

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"
compudude86
 
Posts: 59
Joined: Wed Dec 31, 1969 5:00 pm

Postby compudude86 » Fri Aug 25, 2006 10:29 am

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
compudude86
 
Posts: 59
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Fri Aug 25, 2006 11:13 am

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby compudude86 » Mon Aug 28, 2006 9:35 am

im sorry, i should have noted that i am using apache on windows.
compudude86
 
Posts: 59
Joined: Wed Dec 31, 1969 5:00 pm

Postby compudude86 » Mon Aug 28, 2006 9:57 am

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
compudude86
 
Posts: 59
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Mon Aug 28, 2006 10:43 am

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 17 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved