Portal Home > Knowledgebase > Articles Database > phpPgAdmin issues
phpPgAdmin issues
| Posted by Jakiao, 12-11-2003, 07:38 PM |
| Okay, I'm using the latest pgSQL 7.4 build with the latest phpPgAdmin available. When I try adding tables, I get the following error:
----
SQL error:
ERROR: syntax error at or near "(" at character 35
In statement:
CREATE TABLE "stats" ("id" integer(11) NOT NULL, "ip_address" character varying(11) NOT NULL)
neo_proj1: Tables: Create table
You must specify at least one field.
----
All fields are filled, but it just keeps doing that. I can't figure it out. Anybody have any idea's? Thanks.
|
| Posted by joesuffceren, 07-23-2009, 12:18 PM |
| In case someone else runs across this thread having this same problem, I solved my issue by removing the numbers I had put into the "length" fields for my columns (11 in the example above). Evidentally if you choose a column type that does not require a length, phppgadmin still allows you to put a length in and bork yourself.
|
| Posted by cselzer, 07-23-2009, 01:09 PM |
| mmmm 6 year old necro!
|
| Posted by joesuffceren, 07-23-2009, 02:02 PM |
| 6 years old, yes, but still the first hit on google for my search. I figured someone else might have the same problem, and I'd save them the 15 minutes it took me to solve it.
|
Add to Favourites 
Print this Article
Also Read
