Visual Phonebook Empty 'no records exist'

atlantia

I also get an error when trying to add a user with a picture:

Array ( [i] => Array ( [display] => id [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [firstname] => Array ( [display] => firstname [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [lastname] => Array ( [display] => lastname [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [company] => Array ( [display] => company [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [phone1] => Array ( [display] => phone1 [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [phone2] => Array ( [display] => phone2 [i] => text [values] => [display_filter] => Array ( ) [edit_filter] => Array ( ) [i] => [default] => ) [picture] => Array ( [display] => picture [i] => img [values] => [display_filter] => Array ( [0] => display_image ) [edit_filter] => Array ( ) [i] => [default] => ) )
Array
(
[firstname] => Test
[lastname] => User
[company] =>
[phone1] => 123456789
[phone2] =>
[picture] => Array
(
[name] => n789442807_6602.jpg
[type] => image/jpeg
[tmp_name] => /tmp/phpgU2kKm
[error] => 0
=> 8960
)

)
An error has occurred
No se pudo copiar el archivo

EDIT: I was able to fix this issue by chown apache. /var/www/htl/fop2/uploads

Could my first issue also be permissions based?

atlantia

Note: turning on debug has giving me some Mysql resource errors. Delving further now. I'll post my results when I figure it out.

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

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
notice
/var/www/html/fop2/lib/dblib.php (line 344)

mysql_num_fields(): supplied argument is not a valid MySQL result resource
notice
/var/www/html/fop2/lib/dblib.php (line 333)

mysql_num_rows(): supplied argument is not a valid MySQL result resource
Add Export Import
Search

No records found
NOTICE
/VAR/WWW/HTML/FOP2/LIB/DBLIB.PHP (LINE 244)

atlantia

Tried the solution proposed here with no success.

View Post 143&p=545&hilit=supplied+argument+is+not+a+valid+MySQL+result+resource#p545

giving up on that issue for the night, Happy New years to all. Will figure it out Monday.

KM

Thomas

Are you sure the config.php is setup properly?

atlantia

Pretty sure. I have even tried the root mysql account authentication, as well as using the localhost IP vs localhost entry. Still having the issue.

<?
// Database connection details
$DBHOST = '127.0.0.1';
$DBNAME = 'fop2';
$DBUSER = 'root';
$DBPASS = 'mypassword';

$language="en";

I have also tried the fop2 user and credentials. The two entries I listed were entered via the phonebook web interface, so it was able to access the database then. Immediately after entering them though they would not display in the list, along with the errors shown above (mysql_num_rows(): supplied argument is not a valid MySQL result resource, etc)

Not sure what else to look for. i understand those errors usually mean mysql permission issues, but if even the root account causes the error, and the table is setup properly, then I am a bit confused as to the nature of the issue.

nicolas

The visual_phonebook table structure in the beta changed. You are using the old structure. In the beta tarball there is a mysql-update.db file with the alter commands to add the missing fields. Best regards,

Thomas

The visual_phonebook table structure in the beta changed. You are using the old structure. In the beta tarball there is a mysql-update.db file with the alter commands to add the missing fields. Best regards,

That would answer that bad result Happy New Year.

atlantia

That fixed it for the most part, with the exception of one remaining error:

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

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

I am going to use the fix posted by Thomas in a previous forum post

View Post 143&p=545&hilit=supplied+argument+is+not+a+valid+MySQL+result+resource#p545

But wanted to give a head's up.

Thomas

That fixed it for the most part, with the exception of one remaining error:

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

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

I am going to use the fix posted by Thomas in a previous forum post

View Post 143&p=545&hilit=supplied+argument+is+not+a+valid+MySQL+result+resource#p545

But wanted to give a head's up.

I wouldn't do that because all I did in that post was give it a condition that it could never match, just switch debugging off and report it as a bug to Nicolas.

atlantia

I wouldn't do that because all I did in that post was give it a condition that it could never match, just switch debugging off and report it as a bug to Nicolas.

Will do. Should I start a new thread for the call parking issue?

Thomas

#PARKSLOT=/usr/sbin/asterisk -rx "dialplan show parkedcalls" | grep "=>" | cut -d= -f1 | sed s/\'//g | sed 's/ //g'
#if [ "X${PARKSLOT}" != "X" ]; then
#echo
#echo "[PARK/default]"
#echo "extension=${PARKSLOT}"
#echo "context=parkedcalls"
#echo "type=park"
#echo "Label=Park ${PARKSLOT}"
#echo
#fi

The parking lot seems to be commented out in autoconfig-buttons-freepbx.sh for some reason, maybe its not ready yet.

atlantia

Not using freepbx either so it wouldn't make much of a difference if it wasn't commented out (althought I see your point).
I'll have to look at that script and see what it does, maybe it will clue me into what buttons.cfg wants.

EDIT:

based on that script you would end up with

[PARK/default] ; I assume default is the context in which "parkedcalls" exists?
extension=700
context=parkedcalls
type=park
Label=Park 700

from:

/usr/sbin/asterisk -rx "dialplan show parkedcalls" | grep "=>" | cut -d= -f1 | sed s/\'//g | sed 's/ //g'
700

atlantia

Moving the parking enable discussion to View Post 230 (if an admin wants to move the above posts (12 and 13) I can reformat the first thread post to be easier on the eyes.)

FWIW I understand all this is beta. Nicolas did mention in an email that parking lots queue should show up in beta, but since it isn't I figured I'd troubleshoot on my end.

FOP2 Community Forum

Visual Phonebook Empty 'no records exist'