Page 1 of 3

There was a problem with the response text

PostPosted: Mon May 25, 2009 5:56 pm
by JackC
Ok. I purchased the software and installed it per the instructions. Created database and tables with provided sql and inserted
var $mysqlUser = 'user1';
var $mysqlDb = 'test';
var $mysqlHost = 'localhost';
var $mysqlDbPass = '';
in Common.php

the index.php runs ok, but when I try to execute Example1.php I get an error window "There was a problem with the response text". The only thing visible on the screen is the ajax icon.

The httpd error log shows
[Mon May 25 13:49:54 2009] [error] [client 192.168.1.3] PHP Notice: Undefined variable: mysqlHost in /var/www/html/online/test/Common.php on line 24, referer: http://192.168.1.3/online/test/Example1.php
[Mon May 25 13:49:54 2009] [error] [client 192.168.1.3] PHP Fatal error: Cannot access empty property in /var/www/html/online/test/Common.php on line 24, referer: http://192.168.1.3/online/test/Example1.php

Is there a package missing on my server? Thanks

Re: There was a problem with the response text

PostPosted: Tue May 26, 2009 3:28 pm
by admin
What version of php are you using? The error message is strange because on line 24 in Common.php the mysqlHost variable is not referenced. Did you modify Common.php other than adding the mysql info?

What text editor are you using to edit your files. I know that with dreamweaver you need to change the line break types otherwise the php errors can be off like this (other editors may have the same problem).

Re: There was a problem with the response text

PostPosted: Wed May 27, 2009 12:08 am
by JackC
Thanks for responding...
After many hours of tinkering with this error (Including placing error traps in the source), I finally figured out that the root of the problem was with missing php and mysql packages on my server.
I did not fully realize this at first because after I installed the packages, I neglected to remove my edits to the source. I did manage to mangle a line of code that referenced the mysql connection variables...once I replace the Common.php with your original and inserting the proper values for the variables...everything works..
Thanks again

Re: There was a problem with the response text

PostPosted: Mon Jun 08, 2009 8:45 pm
by MrMatt
I am experiencing this exact same problem. It will work just fine when I use the example. However, when I try to modify one of the example pages to work with my table and data I can not edit. I can view, search, copy and add without problems. I should add that this table has over 2 million records. Is there anything special I should be doing to accomodate a large table such as this?

Thanks!

Re: There was a problem with the response text

PostPosted: Mon Jun 08, 2009 9:03 pm
by admin
Try looking at your apache error log file. It might give more information about what is happening. The path is usually /var/log/httpd/error_log

Re: There was a problem with the response text

PostPosted: Mon Jun 08, 2009 9:15 pm
by MrMatt
That's what is really odd. My Apache error log only has the following:"[Mon Jun 08 05:22:55 2009] [error] [client 144.148.0.1] File does not exist: /var/www/favicon.ico, referer: http://144.148.88.137/s-a/
[Mon Jun 08 05:23:14 2009] [error] [client 144.148.0.1] File does not exist: /var/www/favicon.ico, referer: http://144.148.88.137/s-a/Example1.php
[Mon Jun 08 05:23:14 2009] [error] [client 144.148.0.1] File does not exist: /var/www/favicon.ico, referer: http://144.148.88.137/s-a/Example1.php
[Mon Jun 08 05:25:09 2009] [error] [client 144.148.0.1] File does not exist: /var/www/favicon.ico, referer: http://144.148.88.137/s-a/Example1.php"

admin wrote:Try looking at your apache error log file. It might give more information about what is happening. The path is usually /var/log/httpd/error_log

Re: There was a problem with the response text

PostPosted: Mon Jun 08, 2009 9:55 pm
by admin
Do you have display_errors turned on in the php.ini file?

Re: There was a problem with the response text

PostPosted: Tue Jun 09, 2009 2:25 pm
by MrMatt
Yes, I have display errors enabled and error logging enabled in my php.ini file. The message I receive: "There was a problem with the response text" only is displayed when I click on the update button when trying to save a field change. Everything else works fine.

Re: There was a problem with the response text

PostPosted: Tue Jun 09, 2009 3:33 pm
by admin
Can you post your config file and the sql to create your table and I will test it?

You can also email them to me at info@mysqlajaxtableeditor.com

Re: There was a problem with the response text

PostPosted: Wed Jun 10, 2009 12:53 am
by MrMatt
I seem to have discovered the problem. I had my table columns all in Uppercase including the id column. Once I changed the id column to lowercase I was able to edit. It is not fast when editing but the rest seems to load fine. Any suggestions for improving speed?