An error has ocurried Unknown field :picture

cerokee

I followed the following instructions but still the same problem :

View Post 143&p=548&hilit=An+error+has+ocurried+Unknown+field+%3Apicture#p548

any idea?

nicolas

I do not think you need to tweak the code, but be sure to have the correct table created. Did you create the database? Did you modify config.php to have the correct mysql credentials?

jursikd

Hello,

I have the same problem, on the same line as in the thread in previous post. The problem only happens when there are changes (addition or edit) to the phone book. It is not a problem of mysql as as i can see entries created directly in mysql (with the credential configured in config.php). I add the print of mysql error code and it looks like follows:

/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

For me it looks like the script tries to access the table which does not exist as there is only visual_phonebook in fop2 database.

Thanks in advance for your help.

Regards,

Daniel

nicolas

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,

jursikd

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.

nicolas

Have you tried with the latest beta ?

jursikd

Hello,

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

Regards,

d.

nicolas

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

jursikd

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

nicolas

What linux distro are you using?

jursikd

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

Thanks and Regards,

Daniel

nicolas

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).

jursikd

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'))

nicolas

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,