Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

FOP2 Community Forum

  1. Home
  2. Support
  3. An error has ocurried Unknown field :picture

An error has ocurried Unknown field :picture

Scheduled Pinned Locked Moved Support
14 Posts 3 Posters 89 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N
    N
    nicolas
    wrote on last edited by
    #4

    Hello,

    In dblib.php, at the top, you have $debug set to false. Set it to true and try again, and post the relevant sql debug so I can track that down. Thanks,

    1 Reply Last reply
    0
    • J
      J
      jursikd
      wrote on last edited by
      #5

      Hello,

      the debug was already enabled.

      Here is the php output:

      An error has occurred

      Unknown field: picture

      notice
      /var/www/fop2/lib/dblib.php (line 351)

      mysql_num_fields(): supplied argument is not a valid MySQL result resource

      notice
      /var/www/fop2/lib/dblib.php (line 335)

      mysql_num_rows(): supplied argument is not a valid MySQL result resource
      Table 'fop2.Cancelar' doesn't exist No records found (added to code by myself)
      notice

      /var/www/fop2/lib/dblib.php (line 245)

      mysql_fetch_row(): supplied argument is not a valid MySQL result resource

      SQL logging:

      100222 12:26:26 2 Connect root@localhost on
      2 Init DB fop2
      2 Query SELECT keyword,parameter,value FROM setup
      2 Query SET NAMES 'latin1'
      2 Query DESC visual_phonebook
      2 Query SELECT * FROM visual_phonebook WHERE 1=1 LIMIT 0,5
      2 Query SELECT count() FROM visual_phonebook WHERE 1=1
      100222 12:26:29 2 Init DB fop2
      2 Query SELECT keyword,parameter,value FROM setup
      2 Query SET NAMES 'latin1'
      2 Query DESC visual_phonebook
      2 Query SELECT * FROM visual_phonebook WHERE id = 1
      100222 12:26:34 2 Init DB fop2
      2 Query SELECT keyword,parameter,value FROM setup
      2 Query SET NAMES 'latin1'
      2 Query DESC Cancelar
      2 Query SELECT * FROM Cancelar WHERE 1=1 LIMIT 0,5
      2 Query SELECT count(
      ) FROM Cancelar WHERE 1=1

      Thanks and Regards,

      d.

      1 Reply Last reply
      0
      • N
        N
        nicolas
        wrote on last edited by
        #6

        Have you tried with the latest beta ?

        1 Reply Last reply
        0
        • J
          J
          jursikd
          wrote on last edited by
          #7

          Hello,

          when can i get it, I download it from donwload section.

          Regards,

          d.

          1 Reply Last reply
          0
          • N
            N
            nicolas
            wrote on last edited by
            #8

            http://www.fop2.com/downloads/fop2.tgz

            1 Reply Last reply
            0
            • J
              J
              jursikd
              wrote on last edited by
              #9

              Hello,

              Thanks. I downloaded by i receive following errors, i'm using 32 bits:

              Can't load '/tmp/par-root/cache-8773ffe86861610a34085839186dc6802c46b5ff/ab48145e.so' for module Filter::Crypto::Decrypt: libcrypto.so.6: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
              at /usr/lib/perl5/site_perl/5.8.8/PAR/Heavy.pm line 109
              BEGIN failed--compilation aborted at /tmp/par-root/cache-8773ffe86861610a34085839186dc6802c46b5ff/inc/lib/Filter/Crypto/Decrypt.pm line 37.
              Compilation failed in require at script/fop2_server.pl line 1.
              BEGIN failed--compilation aborted at script/fop2_server.pl line 1.

              Regards,

              Daniel

              1 Reply Last reply
              0
              • N
                N
                nicolas
                wrote on last edited by
                #10

                What linux distro are you using?

                1 Reply Last reply
                0
                • J
                  J
                  jursikd
                  wrote on last edited by
                  #11

                  Sorry, It should be the first thing to mention, it is Ubuntu 8.04 LTS 32 bit server.

                  Thanks and Regards,

                  Daniel

                  1 Reply Last reply
                  0
                  • N
                    N
                    nicolas
                    wrote on last edited by
                    #12

                    Ok, just replace the fop2_server binary with this one:

                    http://www.fop2.com/downloads/fop2_server_etch32

                    (rename it to fop2_server after downloading and replace the one you have in /usr/local/fop2).

                    1 Reply Last reply
                    0
                    • J
                      J
                      jursikd
                      wrote on last edited by
                      #13

                      Hello,

                      I was just writing a response. The new binary attached does not work, i receive segmentation fault.
                      The problem with original problem with fop2 2.10 was missing symlink for libcrypto.so.6, i just add a symlink in /usr/lib/ to currently use libcrypto.so.x.x.x and the server started immediately.
                      Now the visual phonebook works, i cen delete, modify, add, etc.

                      From curiosity i re-enabled php debug, i only receive a following notice when i click on visual phonebook but not stopping it from working. The funny thing is that with debug enabled the name typed in dial window is not working (i get
                      could not parse repsonse XML) but no big deal as this only happens when the debug is on.

                      Thanks a lot for you support!

                      d.

                      notice
                      /var/www/fop2/lib/dblib.php (line 233)

                      mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

                      mysql:

                      Time Id Command Argument
                      100222 23:28:48 1 Connect root@localhost on
                      1 Init DB fop2
                      1 Query SELECT keyword,parameter,value FROM setup
                      1 Query SET NAMES 'UTF8'
                      1 Query DESC visual_phonebook
                      1 Query SELECT * FROM visual_phonebook WHERE context='' AND (o
                      wner='626' OR (owner<>'626' AND private='no')) LIMIT 0,5
                      1 Query SELECT count(*) FROM visual_phonebook WHERE context=''
                      AND (owner='626' OR (owner<>'626' AND private='no'))

                      1 Reply Last reply
                      0
                      • N
                        N
                        nicolas
                        wrote on last edited by
                        #14

                        Thanks for your report. The libcrypto reference will be very useful for other users. And great to know that the problem is fixed in the beta... Now that I look at the sql queries I wonder if you did the update on the visual_phonebook table as it has now some new fields. Regarding the php debug, any output that is outside the xml of the response will break the autocomplete function, so it is not a surprise that it does not work if debug is turned on and you see some xtra line in the output.

                        Best regards,

                        1 Reply Last reply
                        0

                        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                        With your input, this post could be even better 💗

                        Register Login
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        Powered by NodeBB Contributors
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • World
                        • Users
                        • Groups