Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.mysql > #6996

Re: PHP db will not allow modifications

Followups directed to: comp.databases.mysql

Show all headers | View raw

Lew Pitcher wrote:

> super70s wrote:
> 
>> Hi, I have an article directory site that runs on php. I have added 1800
>> articles to it over the past few years as I have time. Lately I've
>> noticed in the Admin Panel of the site (not the Cpanel of the server)
>> that it will not accept modifications to existing articles. Also
>> sometimes the browser will crash when I try that. Could these problems
>> be due to the db becoming too huge? The Admin Panel is accepting new
>> articles as normal though and they are displaying on the site.
>> 
>> In my server cPanel under "MySQL Databases," it did not say anything was
>> wrong with the db and when I checked it, I got this result:
>> 
>> [articlesite_artic.article_master] OK
>> [articlesite_artic.category_master] OK
>> [articlesite_artic.document_master] OK
>> [articlesite_artic.settings] OK
>> [articlesite_artic.user_master] OK
>> 
>> But I went ahead and did a "repair" on it anyway, and the message was
>> "db repaired."
>> 
>> When I tried to modify an existing article, the problem remained.
>> 
>> Any thoughts?

This was my WAG, posted during TV commercials...
> Check the MySQL user privileges; does it include UPDATE privileges on the
> relevant databases?

Now, on to the real answer.

You asked
>> Any thoughts?

Yes, a few.

First off, you've given us exactly NO detail about the problem you are 
having. You say that you have "an article directory site that runs on php", 
and that "it will not accept modifications to existing articles".

You /don't/ say whether there are any other technologies beyond the 
(inferred) HTML, PHP and MySQL technologies that you already mention. Choice 
of web browser, use of Javascript, client/server framework, server 
technology, all these factors, and more, can influence whether or not a web-
based application "works" or not.

Additionally, you /don't/ say what sort of errors you see, either in your 
web logs or your MySQL logs. You /don't/ say even if you /have looked/ at 
the error logs.

In other words, there's no true indication that PHP or MySQL are interfering 
with your ability to update your stored data.

And, so, the WAG. A deficiency in MySQL user privileges /can/ cause 
databases to not update. You /should/ see some sort of error, logged to 
MySQL.  You /may/ see some sort of error logged by PHP to your web log (it 
depends on what the PHP code does on MySQL Query errors). You /might even/ 
see something on the displayed web page (again, depending on how the PHP 
externalizes errors).

To get a better idea of what the problem is, you should perform some 
rudementary diagnostics yourself, such as looking for patterns in the update 
failures, checking the logs and web pages for error messages, performing 
manual updates using a MySQL client, etc.

/If/, after all that, you still have a problem, post your research (*ALL* of 
your research), and ask a question. Before you repost and ask, please read
http://www.catb.org/esr/faqs/smart-questions.html for hints and clues about 
/what/ you need to post, and /what/ you need to ask.

Luck be with you
-- 
Lew Pitcher
"In Skills, We Trust"

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

PHP db will not allow modifications super70s <super70s@super70s.invalid> - 2018-11-06 15:39 -0600
  Re: PHP db will not allow modifications Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2018-11-06 17:40 -0500
    Re: PHP db will not allow modifications Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2018-11-06 18:46 -0500
  Re: PHP db will not allow modifications Luuk <luuk@invalid.lan> - 2018-11-07 14:46 +0100
    Re: PHP db will not allow modifications super70s <super70s@super70s.invalid> - 2018-11-08 05:48 -0600
      Re: PHP db will not allow modifications Jerry Stuckle <jstucklex@attglobal.net> - 2018-11-08 09:30 -0500
        Re: PHP db will not allow modifications Martin Gregorie <martin@mydomain.invalid> - 2018-11-08 15:56 +0000
          Re: PHP db will not allow modifications super70s <super70s@super70s.invalid> - 2018-11-09 00:44 -0600
            Re: PHP db will not allow modifications Jerry Stuckle <jstucklex@attglobal.net> - 2018-11-09 22:11 -0500
              Re: PHP db will not allow modifications The Natural Philosopher <tnp@invalid.invalid> - 2018-11-10 08:30 +0000
                Re: PHP db will not allow modifications Jerry Stuckle <jstucklex@attglobal.net> - 2018-11-10 08:34 -0500
                Re: PHP db will not allow modifications Martin Gregorie <martin@mydomain.invalid> - 2018-11-10 18:09 +0000
                Re: PHP db will not allow modifications The Natural Philosopher <tnp@invalid.invalid> - 2018-11-10 18:12 +0000
                Re: PHP db will not allow modifications Jerry Stuckle <jstucklex@attglobal.net> - 2018-11-10 18:02 -0500
      Re: PHP db will not allow modifications Luuk <luuk@invalid.lan> - 2018-11-08 19:01 +0100
        Re: PHP db will not allow modifications The Natural Philosopher <tnp@invalid.invalid> - 2018-11-08 18:38 +0000
          Re: PHP db will not allow modifications Jerry Stuckle <jstucklex@attglobal.net> - 2018-11-10 08:36 -0500
  Re: PHP db will not allow modifications Percival John Hackworth <pjh@nanoworks.com> - 2018-11-07 08:44 -0800

csiph-web