Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-9132

Oracle CLOB support is broken, preventing storage of long strings

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.0.8-RC1
    • 3.0.7
    • Other
    • None
    • PHP Environment: 5.2.5
      Database: Oracle 10.2.0.4

      What version of phpBB are you using? phpBB 3.0.7
      What is your board's URL? No answer given
      Who do you host your board with? Company server
      How did you install your board? I used the download package from phpBB.com
      Is your board a fresh install or a conversion? Update from a previous version of phpBB3
      Do you have any MODs installed? Yes
      Is registration required to reproduce this issue? No
      What version of phpBB3 did you update from? phpBB 3.0.2
      What MODs do you have installed? Topic View Tracker
      What styles do you currently have installed? Prosilver
      What language(s) is your board currently using? EN
      Which database type/version are you using? Oracle
      What is your level of experience? New to PHP and phpBB
      When did your problem begin? After upgrading from 3.0.2 to 3.0.7.
      Please describe your problem. This is a test instance that's copied from our production board, separate database but identical setup. After upgrading to anything past 3.0.5 (ie 3.0.6 or 3.0.7), will get ORA-01756: quoted string not properly terminated [1756] error.

      I can bypass the error by editing phpBB3/styles/prosilver/template/overall_header.html, remove the space in front of " 'height=225,resi....." in the line that says window.open(url.replace(/&/g, '&'), '_phpbbprivmsg', 'height=225,resizable=yes,scrollbars=yes, width=400');.

      Then, the next error will occur whenever I try to post, w/ error ORA-01704: string literal too long [1704].

      This seems like a CLOB problem, anything larger than 4000 character isn't getting inserted on this particular page.

      Error detail see attached image.

        1. err.JPG
          err.JPG
          293 kB
        2. err2.JPG
          err2.JPG
          188 kB

            A_Jelly_Doughnut A_Jelly_Doughnut
            dennishou dennishou
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: