Re: PHP db will not allow modifications

On 06-Nov-2018, super70s wrote
(in article<super70s-64F973.15393306112018_at_reader.albasani.net>):

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

Can you connect to the database with mysql? Can you update or remove records from tables? Can you export the database to a SQL file?

These are primitives that point to issues with the database. The web interface may be the underlaying problem. Until you isolate where the problem is, it's anyone's guess. It's like going to the dealership and saying "the car makes this weird sound when I go over 50".

Spend some more time isolating the issue and report back your findings.

-- 
DeeDee, don't press that button! DeeDee! NO! Dee...