Menu
▾
▴
phpwebsite-developers
|
From: Andy H. <ah...@ht...> - 2003-03-28 15:45:42
|
-----BEGIN PGP SIGNED MESSAGE----- Is the postgres support supposed to work? Tried getting it set up, got all my ducks in a row, but after I go through the config file creation using pgsql for the db, it prompts me to continue with the installation, I click and get: - ------ phpWebSite Core Installation: Version 0.9.0 SQL: show tables from phpws syntax error - ------ Show tables from phpws? That's not valid postgres.... Besides, there are no tables in the database at this point. postgres error log shows: ERROR: parser: parse error at or near "from" at character 13 I'm Running, FreeBSD 5.0-RELEASE, apache-1.3.27, mod_php4-4.3.1, postgresql-7.3.1 (tcpip enabled, limited to localhost) phpinfo is at http://www.nocarbos.com/output.php (sorry, just registered it recently so you'll probably have to put the ip in your hosts file, 208.3.251.162) ~~ Andy Harrison Great Works Internet System Operations ajh...@gw... RSA 1024 pgp key: http://www.nachoz.com/andy.pub -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPoRnQ1PEkLgodAWVAQE9QwQAknBeZjKEAr0QCCG7TCSZlxFRhIBQXZHg 3u53C3bGVaiSqawvJidAg1Sd486INRhIPRIf9bNW+eRQDDfbgpgGxfR52vjppm0M AR5Pdp/l9+DYSSKmTUiLDIjYqadXw+9oYiSaenEaQo8YRnS5aUlyarFsdXB8VV5A orAMzZ7Asug= =3cAQ -----END PGP SIGNATURE----- |
|
From: Don S. <do...@se...> - 2003-03-28 15:56:02
|
Yes it is _supposed_ to work. But a fair amount of the SQL syntax used is still mysql-centric. I've been focusing on the datatypes that I thought would break compliance. I guess the best way to find things is to actually use it. Don. On Fri, 28 Mar 2003, Andy Harrison wrote: > -----BEGIN PGP SIGNED MESSAGE----- > > Is the postgres support supposed to work? > > Tried getting it set up, got all my ducks in a row, but after I go through the > config file creation using pgsql for the db, it prompts me to continue with the > installation, I click and get: > > - ------ > phpWebSite Core Installation: Version 0.9.0 > > SQL: show tables from phpws > syntax error > - ------ > > Show tables from phpws? That's not valid postgres.... Besides, there are no > tables in the database at this point. > > postgres error log shows: > > ERROR: parser: parse error at or near "from" at character 13 > > > I'm Running, FreeBSD 5.0-RELEASE, apache-1.3.27, mod_php4-4.3.1, > postgresql-7.3.1 (tcpip enabled, limited to localhost) > > phpinfo is at http://www.nocarbos.com/output.php (sorry, just registered it > recently so you'll probably have to put the ip in your hosts file, > 208.3.251.162) > > ~~ > Andy Harrison > Great Works Internet > System Operations > ajh...@gw... > RSA 1024 pgp key: http://www.nachoz.com/andy.pub > > -----BEGIN PGP SIGNATURE----- > Version: PGP 6.5.8 > > iQCVAwUBPoRnQ1PEkLgodAWVAQE9QwQAknBeZjKEAr0QCCG7TCSZlxFRhIBQXZHg > 3u53C3bGVaiSqawvJidAg1Sd486INRhIPRIf9bNW+eRQDDfbgpgGxfR52vjppm0M > AR5Pdp/l9+DYSSKmTUiLDIjYqadXw+9oYiSaenEaQo8YRnS5aUlyarFsdXB8VV5A > orAMzZ7Asug= > =3cAQ > -----END PGP SIGNATURE----- > > > ------------------------------------------------------- > This SF.net email is sponsored by: > The Definitive IT and Networking Event. Be There! > NetWorld+Interop Las Vegas 2003 -- Register today! > http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > |
|
From: Andy H. <ah...@ht...> - 2003-03-28 16:11:56
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 28-Mar-2003, Don Seiler wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Yes it is _supposed_ to work. But a fair amount of the SQL syntax used is > still mysql-centric. I've been focusing on the datatypes that I thought > would break compliance. I guess the best way to find things is to > actually use it. Understandable, you can't exactly put in triggers, views, etc... If I can be of help testing w/pgsql, please let me know. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine homepage: http://www.nachoz.com -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPoR0Q1PEkLgodAWVAQHqNgQAvGdfoV7zje99sfdHmPQKJwrV0VdxaqM1 eEs/9qvU/M8Am3ta7GTeD4SsfHAVfGQUOHjJMoOvltIOgO5rBX7y92+RFcHzL1l/ AGEq3k8wfDlvajWAeDs2+hTKBKwhAGub/kxlgt8Gs6hpPTumB/RbhVsYxQen8cqQ be5Glvu3Pcs= =wAm3 -----END PGP SIGNATURE----- |
|
From: Matthew M. <ma...@tu...> - 2003-04-01 01:34:39
|
> Is the postgres support supposed to work? Absolutely. 'Supposed to' being the key phrase. Don told me about the error in setup and that has been fixed. If you would like to lend a hand, point out any incompatibilities and I will be happy to repair them. Sincerely, Matthew McNaney Internet Systems Architect Electronic Student Services Appalachian State University Phone: 828-262-6493 phpwebsite.appstate.edu ess.appstate.edu |
|
From: Andy H. <ah...@ht...> - 2003-04-09 13:28:33
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 01-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Is the postgres support supposed to work? > > Absolutely. 'Supposed to' being the key phrase. Don told me about the > error in setup and that has been fixed. If you would like to lend a hand, > point out any incompatibilities and I will be happy to repair them. Ok, finally got around to trying it again. I downloaded the cvs tarball last night and installed it. I got further this time, it created the config file, and prompted me to create the admin user. At the module install screen, I select all and click install button. The next screen gives me: phpWebSite Core Installation: Version 0.9.1 RC1 SQL: CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '', configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL default '', modsInstalled text, branchDir text NOT NULL, branchHttp varchar(255) NOT NULL default '') unknown error - From psql, I chopped that into a single line and tried it manually. phpws=# CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '', configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL default '', modsInstalled text, branchDir text NOT NULL, branchHttp varchar(255) NOT NULL default ''); ERROR: No namespace has been selected to create in I'm not pgsql expert, so I have no idea what it is. If you don't either, I don't mind doing the leg work and trying to figure it out if you need. Let me know. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpQf6lPEkLgodAWVAQE/SgP/UPGS4X8vXk8A7WzaAkasy70qrsYbi4ts P90KNq04qBjmO5uxBRLMDSbxeJi1OzV2NH7hzE2r+xas12hsp7lTUA3775cfNlPJ 0umbRN25kae+By4Xx4ndYwhz+8Z2g+U8HJCKuyz9+FJBaVOrxC3TS7iZEPv71pcQ WvD8hYEdJHE= =pocE -----END PGP SIGNATURE----- |
|
From: Don S. <do...@se...> - 2003-04-09 14:40:17
|
Did you specify which database to create it in. When you ran psql, what command did you specify? Don. On Wed, 9 Apr 2003, Andy Harrison wrote: > -----BEGIN PGP SIGNED MESSAGE----- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > On 01-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers] > postgres" > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > >> Is the postgres support supposed to work? > > > > Absolutely. 'Supposed to' being the key phrase. Don told me about the > > error in setup and that has been fixed. If you would like to lend a hand, > > point out any incompatibilities and I will be happy to repair them. > > > > > Ok, finally got around to trying it again. I downloaded the cvs tarball last > night and installed it. I got further this time, it created the config file, > and prompted me to create the admin user. At the module install screen, I > select all and click install button. The next screen gives me: > > > > phpWebSite Core Installation: Version 0.9.1 RC1 > > SQL: CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '', > configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL > default '', modsInstalled text, branchDir text NOT NULL, branchHttp > varchar(255) NOT NULL default '') > unknown error > > - From psql, I chopped that into a single line and tried it manually. > > phpws=# CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '', > configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL > default '', modsInstalled text, branchDir text NOT NULL, branchHttp > varchar(255) NOT NULL default ''); > ERROR: No namespace has been selected to create in > > > I'm not pgsql expert, so I have no idea what it is. If you don't either, I > don't mind doing the leg work and trying to figure it out if you need. Let me > know. > > > > ~~ > Andy Harrison > ah##@httpsite.com > ICQ: 123472 AIM/Y!: AHinMaine > [full headers for details] > > -----BEGIN PGP SIGNATURE----- > Version: PGP 6.5.8 > > iQCVAwUBPpQf6lPEkLgodAWVAQE/SgP/UPGS4X8vXk8A7WzaAkasy70qrsYbi4ts > P90KNq04qBjmO5uxBRLMDSbxeJi1OzV2NH7hzE2r+xas12hsp7lTUA3775cfNlPJ > 0umbRN25kae+By4Xx4ndYwhz+8Z2g+U8HJCKuyz9+FJBaVOrxC3TS7iZEPv71pcQ > WvD8hYEdJHE= > =pocE > -----END PGP SIGNATURE----- > > > ------------------------------------------------------- > This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger > for complex code. Debugging C/C++ programs can leave you feeling lost and > disoriented. TotalView can help you find your way. Available on major UNIX > and Linux platforms. Try it free. www.etnus.com > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > |
|
From: Andy H. <ah...@ht...> - 2003-04-09 15:40:48
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 09-Apr-2003, Don Seiler wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Did you specify which database to create it in. When you ran psql, what > command did you specify? > > Don. yep. conf/config.php <?php $dbversion = "pgsql"; $dbhost = "localhost"; $dbuser = "xxxxxx"; $dbpass = "xxxxxxxx"; $dbname = "phpws"; $table_prefix = ""; $source_http = "www.nocarbos.com/"; $source_dir = "/var/www/nocarbos/"; $hub_hash = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"; $install_pw = "xxxxxxxxxx"; ?> > psql -Upgsql phpws Welcome to psql 7.3.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit phpws=# \l List of databases Name | Owner | Encoding - -----------+-------+----------- phpws | web | SQL_ASCII template0 | pgsql | SQL_ASCII template1 | pgsql | SQL_ASCII (3 rows) To create the db, I just did a regular create database command. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpQ+9VPEkLgodAWVAQFzWwP+IafoHItTspNdsrGZHbTk1LJRoyx13AVc RZ3vWk0yi9h0s5kDe8GT4cGhkD/5zg+Tbedz085mSbFglna2Q6sLpKA3jjQki0gt hvwY2Rm/TYCzmOXOx3677zvv1tCN/hM+NhpKWUEsQcR16SsHP/z3yKlQHoA7NqTG ElrebweTQf0= =m8zN -----END PGP SIGNATURE----- |
|
From: Matthew M. <ma...@tu...> - 2003-04-09 14:56:55
|
> I'm not pgsql expert, so I have no idea what it is. If you don't either, > I > don't mind doing the leg work and trying to figure it out if you need. > Let me > know. Please do. I am not even a pgsql neophyte so I'm not sure. Google didn't find anything and nothing jumped out at me from the postgre docs. Try creating the table one column at a time and eliminate the extras. Let us know what you find out. Thanks, Matt |
|
From: Don S. <do...@se...> - 2003-04-09 15:01:50
|
I used to be a postgres junkie so I'll regress and try to help out as well when I can find some free time. However I think we should go ahead with 0.9.1 without this for now, unless a fix is found in the next day or two. Don. On Wed, 9 Apr 2003, Matthew McNaney wrote: > > I'm not pgsql expert, so I have no idea what it is. If you don't either, > > I > > don't mind doing the leg work and trying to figure it out if you need. > > Let me > > know. > > Please do. I am not even a pgsql neophyte so I'm not sure. Google didn't > find anything and nothing jumped out at me from the postgre docs. > Try creating the table one column at a time and eliminate the extras. > > Let us know what you find out. > > Thanks, > Matt > > > ------------------------------------------------------- > This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger > for complex code. Debugging C/C++ programs can leave you feeling lost and > disoriented. TotalView can help you find your way. Available on major UNIX > and Linux platforms. Try it free. www.etnus.com > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > |
|
From: Andy H. <ah...@ht...> - 2003-04-09 19:10:55
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 09-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Please do. I am not even a pgsql neophyte so I'm not sure. Google didn't > find anything and nothing jumped out at me from the postgre docs. > Try creating the table one column at a time and eliminate the extras. > > Let us know what you find out. Ok, it looks like it doesn't like the "unsigned" tag. Here is the response I got about it: > Postgres does not support the "unsigned" keyword. > > Should they need, for some reason, the functionality of an unsigned integer, > you can always create a DOMAIN of int that does not permit values < 0. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpRwOlPEkLgodAWVAQHK+AP/ZYwfP4Gfu+hpowAQcsoXN2jIjaedu/3G dM5XRRf6lBceeRAevQuNh1BmXQT+Rp+Si0iq39NictrC3Qz7QL+ERqIAiYSLy2LX eUAaROArFVkjvKX+iSYaxSKf2dP1fusxRrOtHw2ZWipO4TsLK/hem6B10rlV7QaT IMnK1tvRl84= =p3G2 -----END PGP SIGNATURE----- |
|
From: Matthew M. <ma...@tu...> - 2003-04-10 13:20:24
|
> Ok, it looks like it doesn't like the "unsigned" tag. >> Postgres does not support the "unsigned" keyword. >> >> Should they need, for some reason, the functionality of an unsigned >> integer, >> you can always create a DOMAIN of int that does not permit values < 0. I believe we can accommodate this, however, we would be losing half the range of an integer field. If an integer is not declared as unsigned, it assumes you will need negative numbers. So half the memory space is reserved for it. Correct me if I am wrong. Should this be something to worry about for primary indecies? Do we need to find out how every DB handles > 0 numbers only? <rant> And what the hell good is a standard if every db does something different? </rant> Matt |
|
From: Andy H. <ah...@ht...> - 2003-04-10 13:39:54
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 10-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > I believe we can accommodate this, however, we would be losing half the > range of an integer field. If an integer is not declared as unsigned, it > assumes you will need negative numbers. So half the memory space is > reserved for it. Correct me if I am wrong. > > Should this be something to worry about for primary indecies? Do we need > to find out how every DB handles > 0 numbers only? Yeah, I wondered about that myself. But when you use int, the docs say it assumes int4 which is +/-2,000,000 so you should be all set. > <rant> And what the hell good is a standard if every db does something > different? </rant> Geez, tell me about it. Now that I'm digging in a little more, these syntax differences are suprising. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpV0FVPEkLgodAWVAQHKJwP/fl8Em5t839ruGfp0moaC5bx9r3OVW7YE BTFY8LtBXIXJFJEZh3WXJCUHuuU0/KbuUKM/H98SWQEH10vfF1Mo2uGyFqQDe8av XS/JZGojhG91EvMw55RlnpNaVVE401tSgyFwOWHW5+y3MU9Uxokn2hBKIyIvv2d6 AUniQYCArRA= =Fj5L -----END PGP SIGNATURE----- |
|
From: Andy H. <ah...@ht...> - 2003-04-10 12:39:46
|
-----BEGIN PGP SIGNED MESSAGE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On 09-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers] postgres" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Ok, next problem figured out. After I select all modules and click install, the next page shows this: CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id varchar(32) NOT NULL default '', data text NOT NULL, ttl int NOT NULL default '0', KEY mod_title (mod_title, id) ) syntax error I looked up the syntax and key creation is a little different: CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id varchar(32) NOT NULL default '', data text NOT NULL, ttl int NOT NULL default '0', CONSTRAINT mod_title_id PRIMARY KEY (mod_title, id) ); The mod_title_id is a name for the constraint, the docs don't indicate that it's terribly important what you name it, so I just followed the example and named the constraint after the two key fields. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpVmClPEkLgodAWVAQE5SQQAmqsLikRngDQOb8ZlIa2h+4EORcCbcT8/ OwWQd+VfIuH0KPoysKrLzLyTmZCPi5EyOzOmTU6t0AzfFaht0qV1sB8x1tg7Fek/ XhDhip6HrLokeqVdh2nFCUjPP0/fu40F7nxwnH+5zSA1zPwIJLhmCofgShq/UdVp JW5kiGeKXxc= =5CCy -----END PGP SIGNATURE----- |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X