Installation Help

Archived from the Xataface Users forum.

gmakwa — Tue Sep 13, 2011 1:10 pm

I am looking for a quick way to administer my MYSQL database I found Xataface

My installation first wouldnt install with the installer so I manually configured the server the pages come out but I cant edit, update.
When I look at data I get 2 forms it is weird.

I figured maybe something happened with the upload I tried uploading it like 6 times (Still get the Same Errors)
I searched the forum and bug engine looking for a fix

I have been programming for years I know how to debug I checked and rechecked permissions, folders installation procedures but I still get errors

My backbone is Godaddy I hope that isnt the problem

Can somebody help me get this thing running. I have turned my information off and setup xataface to only see some development data.

Please can somebody take a look at this
www[dot]thetoptravelclub[dot]com/thetoptravelclub2/

Double forms
Cant edit anything
Cant select anything
Cant insert anything

Any help would be very much appreciated.

I looked all over the place for an app like this one but the five minute install is turning out to be allot longer than I hoped LOL

Thanks
Andrew Arthur

shannah — Tue Sep 13, 2011 6:38 pm

Here is someone else that had some problems on GoDaddy.
viewtopic.php?f=4&t=6257&p=28599&hilit=godaddy#p28585

That thread includes a fix for links not working on GoDaddy.

What exactly do you mean by double forms? Sometimes it I have stale templates in my templates_c folder after an update it will show the view tab contents twice… clearing out the templates_c directory fixes this… but I can’t tell from your description if this is what is happening.

_Steve

gmakwa — Tue Sep 13, 2011 8:57 pm

You have to go to the url you will know as soon as you look at it.

It isnt double URL’s it is double forms. I am sure if I only got 1 form everything should work.

Here is my PHP Info
www [dot] thetoptravelclub [dot] com/info.php

Here is a link to my Xataface
www [dot] thetoptravelclub [dot] com/thetoptravelclub2/

I tried adding the fix you reccomended but it didnt do anything.

Andrew

shannah — Tue Sep 13, 2011 9:46 pm

What does your index.php file look like?

gmakwa — Tue Sep 13, 2011 9:52 pm

<?php
$_SERVER[‘SERVER_PROTOCOL’] = ‘HTTP/1.0’;
require_once ‘../xataface3/dataface-public-api.php’;
df_init(__FILE__, ‘/xataface3/’)->display();

$app =& Dataface_Application::getInstance();
// get an application instance and perform initialization
$app->display();
?>

ADobkin — Wed Sep 14, 2011 4:59 am

It looks like the problem might be caused by the two display() function calls.

This line:

Code: Select all: df_init(__FILE__, '/xataface3/')->display();

Should just be:

Code: Select all: df_init(__FILE__, '/xataface3/');

Alan

gmakwa — Wed Sep 14, 2011 9:53 am

Excellent it worked thank you.

gmakwa — Wed Sep 14, 2011 10:16 am

The application still doesent work?

I got rid of the double forms but now I cant edit anything I have tried to delete the dataface change add the godaddy tag.

If you look at my app and try to Add or modify something nothing happens

<?php
$_SERVER[‘SERVER_PROTOCOL’] = ‘HTTP/1.0’;
/**
* File: index.php
* Description:
* ————-
*
* This is an entry file for this Dataface Application. To use your application
* simply point your web browser to this file.
*/
$time = microtime(true);
// use the timer to time how long it takes to generate a page
require_once ‘/var/chroot/home/content/65/8241465/html/xataface3/dataface-public-api.php’;
// include the initialization file
df_init(__FILE__, ‘/xataface3’);
// initialize the site

$app =& Dataface_Application::getInstance();
// get an application instance and perform initialization
$app->display();
// display the application

$time = microtime(true) - $time;
echo “<p>Execution Time: $time</p>”;
?>

shannah — Wed Sep 14, 2011 10:28 am

Your site is completely down right now (mysql can’t connect).

Please try to be more specific with the problems when you post. Saying “it’s not working” or “i can’t edit anything” is not very helpful for troubleshooting.

gmakwa — Wed Sep 14, 2011 10:44 am

Sorry I was trying to work on the app it is up now.

Update records – Refreshes back to the main page and doesn’t update the record.
Find – Refreshes back to the main page
New Record – Refreshes back to the main page and doesn’t add the record.
Sorting – If you click on one of the table headers to sort you get an sql error message. Some work some have the error

View Record - If you click a record in table view it goes to a blank screen.

I am reading the permissions file I suspect that is the problem.

I will setup permissions for the app.

shannah — Wed Sep 14, 2011 11:08 am

Your site has a strange redirect that seems to force all requests for index.php to just the folder.

E.g. try to type in the address
http://www.thetoptravelclub.com/thetopt … /index.php

You’ll get redirected to
http://www.thetoptravelclub.com/thetoptravelclub2/

This is where your problem is. This redirect rule, wherever it is defined, is intercepting the POST requests when submitting forms and redirecting back to the root page - and isn’t passing along the entire POST request. You need to find this rewrite/redirect rule and correct it or disable it.

-Steve

gmakwa — Wed Sep 14, 2011 11:58 am

It seems to be working now I dropped an .htaccess page in the directory and turned off the RewriteEngine

Code: Select all: Options +FollowSymlinks RewriteEngine off

Thanks for the Help
Andrew