Unable to edit, delete or add record

[lg2]

Hi,

I'm having a problem with one of MySQL database. I'm unable to edit, delete or add a record but I'm able to browse datas and to retrieve them. I tried to edit using MySQL Front, PHP MyAdmin and a PHP page but it doesn't change anything.

Thanks for your help,

Luc

 

[sleipnir214]

What error are you getting?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lg2]

That's the problem. I never get an error message!

Using MySQL Front, the software tries to edit the info and after a few seconds it displays "Not responding"

With PHP MyAdmin and the PHP page, the browser request the page but it never get to a confirmation.

 

[sleipnir214]

In your PHP code, are you trapping MySQL errors?

On what OS is MySQL running?
What version of MySQL?
Is PHP running on the same machine as the MySQL server?
What version of PHP?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lg2]

Hi,

I thought the problem was solved but it reappeared. The strange thing about this is that sometimes it works and sometimes it doesn't work. Could it be a PHP command that "lock" the database?

Locally, I never get this problem. It's only on the server.

Here are some info about OS and so on :
System : Linux web180 2.4.22 #2 Tue Nov 4 13:36:13 EST 2003 i686
Server : Apache/1.3.27
PHP : 4.3.2

Other info I have about MySQL database :
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.54
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include/mysql
MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent Off Off
mysql.connect_timeout -1 -1
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

Thanks for your help.

 

[sleipnir214]

That doesn't help at all. Your configuration is likely not the culprit -- rather your code.

It also doesn't answer my question. Are you trapping MySQL errors in our PHP code?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lg2]

I am not trapping MySQL errors. Is there a simple way to do this in my page?

Also, if you suspect the problem is in my code, how come a software like MySQL Front (or PHP MyAdmin) is not able to edit a record?

 

[sleipnir214]

Here's the way I see it: Something somewhere is going to have to cough up an error. Without it, we're just running in circles.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!