Hi Jpadie,
Thank you very very much. It works fine when I changed from int8[] and float8[] to numeric and text[]to varchar. All this while it has been a postgres proiblem and not the script you gave me.
This is the message:
Database Record inserted correctly
thanks very much again
Gokop
Hi,
I changed the criteria_parameters to Criteria_Parameters and see the error:
Warning: pg_query(): Query failed: ERROR: relation "criteria_parameters" does not exist in /var/www/html/newconnection.php on line 61
Problem inserting database record. Error was ERROR: relation...
Hi Jpadie,
My first postgres table was Criteria_Parameters and columns were 'CriteriaID', 'DomainID', 'Criteria_Name', 'Upper_Lim', 'Lower_Lim', 'Range', 'Unit'. But after running the php script it complains. I went through the postgres documentation and I saw that the script converts all names...
In postgres, I declared the table fields data types as:
criteriaid as int8[]
domainid as int8[]
criteria_name as text[]
upper_lim as float8[]
lower_lim as float8[]
range as float8[]
unit as text[]
Has this got anything to do with the error. Anyway they were declaed as int8, float8 and text...
Hi, It gave this error:
Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 62
Problem inserting database record. Error was ERROR: array value must start with "{" or dimension information
in line 62 i.e...
By commenting the $fields = implode (" , ", $fields); below foreach and above $query, I got:
Warning: pg_query(): Query failed: ERROR: syntax error at or near "Array" at character 34 in /var/www/html/newconnection.php on line 62
Problem inserting database record. Error was ERROR: syntax error...
Hi Thanks,
Without changing anything, I got:
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51...
Hi Jpadie,
See the codes:
<?php
//set the debug parameters
ini_set('display_errors','on');
error_reporting (E_ALL);
//start the motor
switchboard();
function switchboard(){
if (isset($_POST['submit'])){
processForm();
}
displayForm();
}
function displayForm(){
echo...
You have done so well Jpadie. I did that and got this error:
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50
Warning: implode(): Bad arguments. in /var/www/html/newconnection.php...
Yes that solves the problem also. I got some errors such as criteria_parameters relations, but I solved them. The error is :
Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60
Problem inserting...
Itried to comment the is_binary and leave the is_string. I got this error:
Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60
Problem inserting database record. Error was ERROR: array value must start...
Hi Jpadie,
Thanks. At least I saw errors now with this change in the input button type. See errors displayed on the browser:
Warning: Invalid argument supplied for foreach() in /var/www/html/newconnect.php on line 49
Notice: Undefined variable: dbValues in /var/www/html/newconnect.php on line...
Hi Jpadie,
It looks ok, however it does not insert data into the table. I have even granted insert, select, udate priviledges to the globus user.
I will try working on configurations in httpd.conf and php.ini and see what happens.
Thanks for your great help.
Gokop
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.