I am having a phppgAdmin problem. I am running php 4.2.3 and postgreSQL 7.2
Whenever I try to create / change tables or insert / edit table rows I get error messages and my data is garbled (chopped up). I have already played with magic quotes, turning them on/off. I also re-downloaded phppgadmin thinking I may have garbled it somehow. No luck. I'm sure it is a configuration switch. I can dump the table structure and data and copy it into the sql box and it runs fine. It is only when I use the phppgadmin screens that I get the errors. Here is a sample of what I get.
I click on the edit button and get the edit form. as follows:
Database test - Table books
Field Type Function Value Comments
code bpchar 0-596-00160-6
title varchar Learning Cocoa
author varchar Apple Computer
price numeric 34.99
kind varchar macintosh
Save
When I click save this is what the error looks like:
Error - /Library/WebServer/Documents/apps/phpPgAdmin/tbl_replace.php -- Line: 77
PostgreSQL said: ERROR: parser: parse error at or near "cocoa"
Your query:
UPDATE "books" SET "code" = 6-00160-6, "title" = ning Cocoa, "author" = e Computer, "price" = 9, "kind" = ntosh WHERE "code" = '0-596-00160-6'
Notice the chopped up data.
Any suggestions?
