Re: PHP db will not allow modifications

From: Lew Pitcher <lew.pitcher_at_digitalfreehold.ca>
Date: Tue, 06 Nov 2018 17:40:53 -0500
Message-ID: <prt59n$uqf$1_at_dont-email.me>


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"
Received on Tue Nov 06 2018 - 23:40:53 CET

Original text of this message