Xataface Forums

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

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.