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?

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

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.

Hello,

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

Regards,

d.

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

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

Thanks and Regards,

Daniel

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