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

Groups > comp.databases.mysql > #6995

Re: PHP db will not allow modifications

Cross-posted to 3 groups.

Followups directed to: comp.databases.mysql

Show all headers | View raw

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?

Check the MySQL user privileges; does it include UPDATE privileges on the 
relevant databases?

-- 
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