application not working after changing environment

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

application not working after changing environment

Postby julian_fr » Thu May 07, 2009 1:53 am

hello steve!

first of all, thanks a lot for your application
it works great and it's a wonderful tool !

ok now my lil problem :

i 've made a xataface application on my xp workstation using WAMP with easyphp. it worked great.

now i want to move it to a Suse server.

i've moved the mysql database on the server, i've modified the conf.ini and
i've just copy all my application folder to the htdocs folder on the suse server. and it worked i can access to the application.

but some bugs appear :


when i click on some tables tabs, some display ok, some display blank pages.
After some research, it seems like the unfunctionnal tables are those with a fields.ini modified with sql statement in the top of the file.
for example, the fields.ini file of my table 'liendem' is like that :

_________________________________________________

__sql__="SELECT l.*, CONCAT(t.cqc, ' ', t.nom, ' ', t.prenom) AS demandeur, d.datenrgt AS datedem, d.csitdem AS sitdem FROM tiers t, liendem l , demande d
WHERE l.TIERS_ctiers=t.ctiers
AND l.DEMANDE_nodem=d.nodem"

[demandeur]
widget:label = "Nom Tiers"
order=-3
filter=1

etc.. whith all the fields ..

________________________________________________

on my xp workstation,it works fine but on the suse => blanck page

If i remove the sql statement on the top of the file, it displays fine but of course without the functionnalitites brought by the sql statement.

i've tried to modify the sql statement but nothing worked. if there ' s a sql statement in the top of fields.ini =>blank page.

can you help me ?

sorry for my bad english.i'm french and moreover i'm a noob :-)


thanks again
julian_fr
 
Posts: 1
Joined: Thu May 07, 2009 1:25 am

Postby shannah » Thu May 07, 2009 9:36 am

Check for case sensitivity on table and column names. Windows MySQL is case insensitive, but SUSE is case sensitive. This is most likely your problem.
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 16 guests

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