There was a problem with the response text

Discuss MySQL Ajax Table Editor

There was a problem with the response text

Postby JackC » Mon May 25, 2009 5:56 pm

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
JackC
 
Posts: 17
Joined: Fri May 22, 2009 5:38 pm

Re: There was a problem with the response text

Postby admin » Tue May 26, 2009 3:28 pm

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).
admin
Site Admin
 
Posts: 1495
Joined: Fri Jul 11, 2008 1:34 am

Re: There was a problem with the response text

Postby JackC » Wed May 27, 2009 12:08 am

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
JackC
 
Posts: 17
Joined: Fri May 22, 2009 5:38 pm

Re: There was a problem with the response text

Postby MrMatt » Mon Jun 08, 2009 8:45 pm

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!
MrMatt
 
Posts: 22
Joined: Mon Jun 08, 2009 8:33 pm

Re: There was a problem with the response text

Postby admin » Mon Jun 08, 2009 9:03 pm

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
admin
Site Admin
 
Posts: 1495
Joined: Fri Jul 11, 2008 1:34 am

Re: There was a problem with the response text

Postby MrMatt » Mon Jun 08, 2009 9:15 pm

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
MrMatt
 
Posts: 22
Joined: Mon Jun 08, 2009 8:33 pm

Re: There was a problem with the response text

Postby admin » Mon Jun 08, 2009 9:55 pm

Do you have display_errors turned on in the php.ini file?
admin
Site Admin
 
Posts: 1495
Joined: Fri Jul 11, 2008 1:34 am

Re: There was a problem with the response text

Postby MrMatt » Tue Jun 09, 2009 2:25 pm

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.
MrMatt
 
Posts: 22
Joined: Mon Jun 08, 2009 8:33 pm

Re: There was a problem with the response text

Postby admin » Tue Jun 09, 2009 3:33 pm

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
admin
Site Admin
 
Posts: 1495
Joined: Fri Jul 11, 2008 1:34 am

Re: There was a problem with the response text

Postby MrMatt » Wed Jun 10, 2009 12:53 am

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?
MrMatt
 
Posts: 22
Joined: Mon Jun 08, 2009 8:33 pm

Next

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 5 guests

cron