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

Groups > comp.databases.mysql > #7004

Re: PHP db will not allow modifications

Cross-posted to 3 groups.

Show all headers | View raw

In article <ps1mag$n8m$1@news.albasani.net>,
 Martin Gregorie <martin@mydomain.invalid> wrote:

> On Thu, 08 Nov 2018 09:30:42 -0500, Jerry Stuckle wrote:
> 
> > On 11/8/2018 6:48 AM, super70s wrote:
> >> In article <5be2ecc4$0$32263$e4fe514c@news.xs4all.nl>,
> >>   Luuk <luuk@invalid.lan> wrote:
> >> 
> >>> Are you using the correct statement to update this table?
> >>>
> >>> What is the exact error message that is given when you try to update
> >>> an article?
> >> 
> >> The message in the "New Article" window says "Article Information
> >> Saved"
> >> as normal, however it refuses to accept the modification.
> >> 
> >> I'm afraid I don't have a lot of experience with this, in fact I had to
> >> hire someone to install the db so I apologize if I "offended anyone's
> >> senses."
> >> 
> >> It isn't that big a deal really, I'm pretty good at proofreading the
> >> articles before I post them but sometimes I'll spot a small typo or
> >> something and want to go back and correct it (until now, lol).
> >> 
> >> 
> > It sounds like you aren't checking the result codes from your SQL
> > statements, so your script does not tell you when a request failed.
> > 
> > You should check the result of *every* database request - or you'll run
> > into problems like this.  Fix your code and see what the failure is.
> 
> ...and don't forget that some SQL statements generate a linked chain of 
> exception messages if they fail. Trapping the first exception may tell 
> your code that there is a problem and what sort it is, but if its fatal 
> you probably need to see all the exceptions in the chain to understand 
> what went wrong.

I guess a workaround could be to simply delete the article that needs 
the modification, make the correction, then repost it as a new article. 
But I'd lose any "link juice" that URL had.

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