« previous next »
Pages: 1 [2] 3  All   Go Down

Author Topic: Line 2052 MySQL error  (Read 3296 times)

0 Members and 1 Guest are viewing this topic.

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Curse that error!
« Reply #15 on: April 19, 2008, 08:17:30 PM »
If you have more problems post back.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Curse that error!
« Reply #16 on: April 19, 2008, 08:22:11 PM »
Maybe just change the thread title to "Line 2052 MySQL error" or something like that, just in case someone else is wondering about the same thing. Up to you. I probably should have done it myself but I was feeling flippant.

Anyway it seems fine now. Cheers.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #17 on: April 19, 2008, 09:10:34 PM »
Changed...and glad it's fixed. :)
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #18 on: April 20, 2008, 06:07:59 PM »
Bother. Something I hadn't tested was the quick edit feature, and it looks like that is throwing up an error now. The old error is gone but attempting to use the quick edit now generates this:

Hacking attempt...

      SELECT IFNULL(mem.realName, m.posterName) AS posterName, m.posterTime, m.body, m.ID_TOPIC, m.subject, t.locked
      FROM (smf_messages AS m, smf_boards AS b, smf_topics AS t)
         LEFT JOIN smf_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
      WHERE m.ID_MSG = 59527
         AND b.ID_BOARD = m.ID_BOARD
         AND t.ID_TOPIC = m.ID_TOPIC
         AND 1 ';
      LIMIT 1
File: /home/cofexm/public_html/Sources/Post.php
Line: 2052
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #19 on: April 20, 2008, 09:14:32 PM »
Do you have any mods installed that edit the post.php file. ??? If not try just replacing the whole thing.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #20 on: April 21, 2008, 04:00:02 AM »
They edit some parts of it but not that part. Rather than replacing it I can just undo the edit I did yesterday, but of course then I'll have the old error back. :grin
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #21 on: April 21, 2008, 11:08:38 AM »
Ok. can you re-upload your post.php again...the one you are using now.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #22 on: April 21, 2008, 04:21:40 PM »
Yep. Tis attached.  :)
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #23 on: April 21, 2008, 08:10:40 PM »
K; I will look at it now.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #24 on: April 21, 2008, 08:27:09 PM »
I think the ignore user mod is putting out the problems to tell you the truth.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #25 on: April 22, 2008, 03:43:32 AM »
I doubt it, because the MySQL syntax error has been around for months and Ignore User was only installed a couple of weeks back.
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #26 on: April 22, 2008, 07:28:01 AM »
Ok, well I will take another look when I get home today then. :)
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #27 on: April 25, 2008, 05:17:48 PM »
Any ideas? If not I'll have to return it to the original state since the current setup means the "Insert Quote" and "Quick edit" features don't work and both generate "Hacking attempt" errors.

Do those features use some other method to the rest of the forum code?
Logged

Offline bigguy

  • Site Owner
  • Administrator
  • *
  • Posts: 13217
  • Karma: 269
  • Gender: Male
  • Get'r Done
    • P.C. Tweakr
  • SMF Version: 2.0 Gold
Re: Line 2052 MySQL error
« Reply #28 on: April 25, 2008, 10:35:39 PM »
Sorry I have not been able to look at this further; but might have time tomorrow night. I was at the home and garden show all day promoting my new business. I will try to take another look tomorrow though. If you would like until then I guess returning it to it's original state would be the best. I am sorry for the late response.
Logged

Offline antechinus

  • Hero Member
  • *
  • Posts: 445
  • Karma: 65
Re: Line 2052 MySQL error
« Reply #29 on: April 25, 2008, 11:07:28 PM »
No worries. Ya gotta live and it isn't a humungous deal anyway. Was quite funny actually coz the other admin saw "Hacking attempt" in the error log and started squawking.  :dnc

It's a quick and easy edit so if nobody can figure a solution I'll just live with the old error. It'd be nice to clear it if possible though because as the forum grows it will start to accumulate quite a lot of errors.
Logged
Pages: 1 [2] 3  All   Go Up
« previous next »