Clicking on Save just shows a Select query in browser ?

[Jusmee]

I have had a Xataface application working for years, and just had to transplant it onto a new server. It is a simple application, mostly dealing with one table which holds my Record Collection. It is working as far as listing all the data etc, but when I try to enter a new record, after filling our the data form, I press the 'Save' button and it displays just the text of a select query (listed below) in the browser - and nothing is saved.

I need a pointer as to what has gone wrong. Any ideas?

Code: Select all

SELECT COUNT(*) as num FROM `latestmusic` WHERE `Shelf` = '2587' AND `Title` LIKE CONCAT('%','Greatest Hits','%') AND `Artist` LIKE CONCAT('%','test','%') AND AND AND AND `Year` = '1988' AND AND `Notes` LIKE CONCAT('%','DMM','%')

[shannah]

Does your error log give any clues? It is likely that it is hitting an error... and the error triggered a bit of debugging output that should have been removed...

[Jusmee]

Found this in the Apache log. There was heaps of the first one, and the second one seems to be exactly the one from the problem above. Strange but I am having trouble reproducing the second error today, and I know the server has been rebooted a few times. The first error is filling up the log still however.

I thought you might need to know the version of Xataface, and I checked the file that I unpacked and it is xataface-1.2.2, and I see you have 1.2.7, and also a 1.3rc version. Should I update?

Code: Select all

[Sun Jan 22 10:23:09 2012] [error] [client 192.168.1.105] PHP Warning:  Invalid argument supplied for foreach() in /var/www/xataface/Dataface/QueryBuilder.php on line 517, referer: http://192.168.1.110/xataface/music/index.php?-action=new&-table=latestmusic
[Sun Jan 22 10:23:09 2012] [error] [client 192.168.1.105] PHP Deprecated:  Function eregi() is deprecated in /var/www/xataface/Dataface/QueryBuilder.php on line 590, referer: http://192.168.1.110/xataface/music/index.php?-action=new&-table=latestmusic
[Sun Jan 22 10:23:09 2012] [error] [client 192.168.1.105] PHP Fatal error:  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND  AND  AND `Year` = '1988' AND  AND `Notes` LIKE CONCAT('%','DMM','%')' at line 1SELECT COUNT(*) as num FROM `latestmusic` WHERE `Shelf` = '2587' AND `Title` LIKE CONCAT('%','Greatest Hits','%') AND `Artist` LIKE CONCAT('%','test','%') AND  AND  AND  AND `Year` = '1988' AND  AND `Notes` LIKE CONCAT('%','DMM','%')On line 127 of file /var/www/xataface/Dataface/QueryTool.php in function printStackTrace()\n<br>On line 526 of file /var/www/xataface/Dataface/QueryTool.php in function Dataface_QueryTool(latestmusic,Resource id #11,array(,,1,350672020_1327191555,new,latestmusic,new,0,0,30,browse,__main__,-action=new&-table=latestm)\n<br>On line 1181 of file /var/www/xataface/Dataface/Application.php in function loadResult(latestmusic,Resource id #11,array(,,1,350672020_1327191555,new,latestmusic,new,0,0,30,browse,__main__,-action=new&-table=latestm)\n<br>On line 1206 of file /var/www/ in /var/www/xataface/Dataface/QueryTool.php on line 127, referer: http://192.168.1.110/xataface/music/index.php?-action=new&-table=latestmusic

[shannah]

Yes. It is a good idea to update.

[Jusmee]

Yes. It is a good idea to update.

Downloaded and installed 1.2.7. Seems to be all working, thanks.

I didn't try the 1.3 RC, just in case that introduced new problems, but, when 1.3 comes out, can I just use that, or are their changes that will mean I might have to rework my simple application?