Menu
▾
▴
phpwebsite-developers — For our development team.
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
(1) |
Mar
(265) |
Apr
(166) |
May
(25) |
Jun
(17) |
Jul
(20) |
Aug
(47) |
Sep
(6) |
Oct
(14) |
Nov
(66) |
Dec
(64) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(109) |
Feb
(64) |
Mar
(34) |
Apr
(23) |
May
(64) |
Jun
(9) |
Jul
(13) |
Aug
(6) |
Sep
(33) |
Oct
(272) |
Nov
(67) |
Dec
(75) |
| 2003 |
Jan
(264) |
Feb
(244) |
Mar
(171) |
Apr
(119) |
May
(54) |
Jun
(93) |
Jul
(51) |
Aug
(48) |
Sep
(14) |
Oct
(49) |
Nov
(47) |
Dec
(15) |
| 2004 |
Jan
(13) |
Feb
(27) |
Mar
(18) |
Apr
(44) |
May
(35) |
Jun
(24) |
Jul
(39) |
Aug
(142) |
Sep
(35) |
Oct
(34) |
Nov
(49) |
Dec
(24) |
| 2005 |
Jan
(60) |
Feb
(71) |
Mar
(19) |
Apr
(27) |
May
(68) |
Jun
(4) |
Jul
(30) |
Aug
(10) |
Sep
(23) |
Oct
(24) |
Nov
(13) |
Dec
(6) |
| 2006 |
Jan
(4) |
Feb
(46) |
Mar
(64) |
Apr
(18) |
May
(16) |
Jun
(37) |
Jul
(7) |
Aug
(19) |
Sep
(9) |
Oct
(8) |
Nov
(3) |
Dec
(23) |
| 2007 |
Jan
(25) |
Feb
(21) |
Mar
(32) |
Apr
(36) |
May
(12) |
Jun
(1) |
Jul
(7) |
Aug
(15) |
Sep
(13) |
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
(3) |
Feb
(5) |
Mar
(1) |
Apr
(2) |
May
|
Jun
(1) |
Jul
(2) |
Aug
(7) |
Sep
|
Oct
(5) |
Nov
(1) |
Dec
|
| 2009 |
Jan
(7) |
Feb
(1) |
Mar
|
Apr
|
May
(1) |
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(3) |
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
|
From: Matthew M. <ma...@tu...> - 2003-04-15 18:09:33
|
Here is an interesting list: http://www.bris.ac.uk/ISC/cms/features.htm Matt |
|
From: Matthew M. <ma...@tu...> - 2003-04-15 17:53:53
|
http://pear.php.net/weeklynews.php/en/20030302.html Mighty nice of them :) Matt |
|
From: Richard S. <ri...@ri...> - 2003-04-15 17:04:21
|
Hmmm... I think the poll module should also hide or show another poll once a user has submitted there answer so they don't continue to re-submit. On Monday, April 14, 2003, at 08:17 PM, Don Seiler wrote: > The PollManager action function checks for a permission of "view" in > the > poll module. No such permission is defined in poll's module_rights.txt > and so no such permission can be assigned in User Manager. As a result > non-deities who are given Poll administration rights are unable to do > any > Poll administrating. > > Fix would be to add a "view" entry to module_rights.txt. > > Also Poll's uninstall.php references $core but $core is not defined. > Changing both references to be $GLOBALS["core"] fixes that problem. > > I have checked both of these fixes into CVS. > > Don. > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > |
|
From: Don S. <do...@se...> - 2003-04-15 11:59:23
|
That's really an RFE not a bug. And I wouldn't put a high priority on it since the polls aren't supposed to be some sort of scientific research. Don. On Mon, 14 Apr 2003, Richard Sumilang wrote: > Hmmm... I think the poll module should also hide or show another poll > once a user has submitted there answer so they don't continue to > re-submit. > > On Monday, April 14, 2003, at 08:17 PM, Don Seiler wrote: > > > The PollManager action function checks for a permission of "view" in > > the > > poll module. No such permission is defined in poll's module_rights.txt > > and so no such permission can be assigned in User Manager. As a result > > non-deities who are given Poll administration rights are unable to do > > any > > Poll administrating. > > > > Fix would be to add a "view" entry to module_rights.txt. > > > > Also Poll's uninstall.php references $core but $core is not defined. > > Changing both references to be $GLOBALS["core"] fixes that problem. > > > > I have checked both of these fixes into CVS. > > > > Don. > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > _______________________________________________ > > Phpwebsite-developers mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > > > > > > |
|
From: Richard S. <rsu...@ex...> - 2003-04-15 06:21:39
|
Hmmm... I think the poll module should also hide or show another poll once a user has submitted there answer so they don't continue to re-submit. On Monday, April 14, 2003, at 08:17 PM, Don Seiler wrote: > The PollManager action function checks for a permission of "view" in > the > poll module. No such permission is defined in poll's module_rights.txt > and so no such permission can be assigned in User Manager. As a result > non-deities who are given Poll administration rights are unable to do > any > Poll administrating. > > Fix would be to add a "view" entry to module_rights.txt. > > Also Poll's uninstall.php references $core but $core is not defined. > Changing both references to be $GLOBALS["core"] fixes that problem. > > I have checked both of these fixes into CVS. > > Don. > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > |
|
From: Don S. <do...@se...> - 2003-04-15 03:18:02
|
The PollManager action function checks for a permission of "view" in the poll module. No such permission is defined in poll's module_rights.txt and so no such permission can be assigned in User Manager. As a result non-deities who are given Poll administration rights are unable to do any Poll administrating. Fix would be to add a "view" entry to module_rights.txt. Also Poll's uninstall.php references $core but $core is not defined. Changing both references to be $GLOBALS["core"] fixes that problem. I have checked both of these fixes into CVS. Don. |
|
From: Don S. <do...@se...> - 2003-04-14 19:48:12
|
I have made this change to formDate (not clock) and it was included in the recent 0.9.1 release. FYI. Don. On Sun, 13 Apr 2003, Don Seiler wrote: > In a mod I'm working on I have a birthday field. However there arises the > case when you don't always know someone's birthday. However as far as I > can tell the formDate function doesn't allow for NOT filling it in. > > So I propose for an additional parameter to formDate and clock, > useBlanks=FALSE. Defaulting to FALSE ensures backwards compatibility. > Using true will put blank options at the beginning of the select lists. > > One potential problem would then be what to default to. Right now > formDate defaults to the currentDate. In my birthday case I would prefer > it default to blanks. > > Let me know what you think or if I've missed an existing way to handle > this. > > Don. > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-14 18:47:41
|
Since my webhost/phpmyadmin setup doesn't give me an interface to do this, I've commented out the sqlLock and sqlUnlock lines in MenuItem.php. Don. On Mon, 14 Apr 2003, Matthew McNaney wrote: > > Got an error adding a pagemaster page to a menu. I had already saved the > > page and was going in through the menu man to add it: > > On versions of MySQL that are greater than v4 you will need to GRANT > permission to LOCK TABLES. > > Matthew McNaney > Internet Systems Architect > Electronic Student Services > Appalachian State University > Phone: 828-262-6493 > phpwebsite.appstate.edu > ess.appstate.edu > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > |
|
From: Matthew M. <ma...@tu...> - 2003-04-14 18:38:31
|
> Got an error adding a pagemaster page to a menu. I had already saved the > page and was going in through the menu man to add it: On versions of MySQL that are greater than v4 you will need to GRANT permission to LOCK TABLES. Matthew McNaney Internet Systems Architect Electronic Student Services Appalachian State University Phone: 828-262-6493 phpwebsite.appstate.edu ess.appstate.edu |
|
From: Don S. <do...@se...> - 2003-04-14 18:02:30
|
Got an error adding a pagemaster page to a menu. I had already saved the page and was going in through the menu man to add it: DB Error: unknown error LOCK TABLES mod_menuman_items WRITE [nativecode=1044 ** Access denied for user: 'phpws_user@localhost' to database 'phpws'] Using mysql and phpws 0.9.1. Don. |
|
From: Matthew M. <ma...@tu...> - 2003-04-14 16:53:18
|
> TeamSite is a PHPWebSite module that will add roster, statistic, and > schedule information onto the PHPWS base. It can be used by groups such as > semi-pro and amateur sports teams to create a website for their fans to > learn more about the team. Thanks Don. I'm sure our Urec program will get use of this. Matt |
|
From: Don S. <do...@se...> - 2003-04-14 16:34:03
|
TeamSite is a PHPWebSite module that will add roster, statistic, and schedule information onto the PHPWS base. It can be used by groups such as semi-pro and amateur sports teams to create a website for their fans to learn more about the team. Version 0.1.0 is released. It supports roster and schedule information. Statistics information is not yet supported. I will be working it in for 0.2.0 as time allows. I wanted to get something out for the spring sports ASAP. Download the tar.gz or zip file from our downloads/files page and show the world your softball skillz. |
|
From: Don S. <do...@se...> - 2003-04-13 23:00:52
|
In a mod I'm working on I have a birthday field. However there arises the case when you don't always know someone's birthday. However as far as I can tell the formDate function doesn't allow for NOT filling it in. So I propose for an additional parameter to formDate and clock, useBlanks=FALSE. Defaulting to FALSE ensures backwards compatibility. Using true will put blank options at the beginning of the select lists. One potential problem would then be what to default to. Right now formDate defaults to the currentDate. In my birthday case I would prefer it default to blanks. Let me know what you think or if I've missed an existing way to handle this. Don. |
|
From: Matthew M. <ma...@tu...> - 2003-04-11 16:02:39
|
> I thought this had been fixed but perhaps not? I got this while > uninstalling photoalbum. > > Warning: rmdir(images/photoalbum) [function.rmdir]: Directory not empty in > /home/httpd/htdocs/phpwebsite-full/phpwebsite/core/File.php on line 321 Got this fixed. Committing now. Thanks, Matt |
|
From: Don S. <do...@se...> - 2003-04-11 02:19:58
|
I thought this had been fixed but perhaps not? I got this while uninstalling photoalbum. Warning: rmdir(images/photoalbum) [function.rmdir]: Directory not empty in /home/httpd/htdocs/phpwebsite-full/phpwebsite/core/File.php on line 321 |
|
From: Don S. <do...@se...> - 2003-04-11 01:48:49
|
Also need update support for sqlImport. If someone else wants to take that feel free. Don. On Thu, 10 Apr 2003, Don Seiler wrote: > Alright I think I have the code in place and checked in. I have some more > testing that I want to do but it is in CVS for you to test out. > > Basically what started this all was I wanted to have my sql statements for > my update scripts in their own sql file, instead of embedded in php. > > Don. > > On Thu, 10 Apr 2003, Don Seiler wrote: > > > PLAN B: > > > > I get a clue and use the sql(Add|Modify|Drop)Column() functions already in > > place instead of writing sqlAlterTable(). Still need to do the other > > steps though. > > > > Don. > > > > On Thu, 10 Apr 2003, Don Seiler wrote: > > > > > Alright. After some light analysis here is the RFE for supporting ALTER > > > TABLE commands in core. > > > > > > 1. Need to support "alter" in extractTableName(). > > > 2. Need to support full alter table syntax in extractSQLData(). > > > 3. Need to create sqlAlterTable() function, similar to sqlCreateTable() > > > etc. > > > 4. Need to support "alter" in sqlImport() function. > > > > > > If you see a flaw in my plan let me know. Otherwise I'll start fumbling > > > through this tonight while my spouse is distracted by Will&Grace. Scrubs > > > is my one true god. > > > > > > Don. > > > > > > > > > ------------------------------------------------------- > > > 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 > > > > > > > > > > > > > > > ------------------------------------------------------- > > 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 > > > > > > > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-10 22:06:37
|
Alright I think I have the code in place and checked in. I have some more testing that I want to do but it is in CVS for you to test out. Basically what started this all was I wanted to have my sql statements for my update scripts in their own sql file, instead of embedded in php. Don. On Thu, 10 Apr 2003, Don Seiler wrote: > PLAN B: > > I get a clue and use the sql(Add|Modify|Drop)Column() functions already in > place instead of writing sqlAlterTable(). Still need to do the other > steps though. > > Don. > > On Thu, 10 Apr 2003, Don Seiler wrote: > > > Alright. After some light analysis here is the RFE for supporting ALTER > > TABLE commands in core. > > > > 1. Need to support "alter" in extractTableName(). > > 2. Need to support full alter table syntax in extractSQLData(). > > 3. Need to create sqlAlterTable() function, similar to sqlCreateTable() > > etc. > > 4. Need to support "alter" in sqlImport() function. > > > > If you see a flaw in my plan let me know. Otherwise I'll start fumbling > > through this tonight while my spouse is distracted by Will&Grace. Scrubs > > is my one true god. > > > > Don. > > > > > > ------------------------------------------------------- > > 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 > > > > > > > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-10 20:34:46
|
PLAN B: I get a clue and use the sql(Add|Modify|Drop)Column() functions already in place instead of writing sqlAlterTable(). Still need to do the other steps though. Don. On Thu, 10 Apr 2003, Don Seiler wrote: > Alright. After some light analysis here is the RFE for supporting ALTER > TABLE commands in core. > > 1. Need to support "alter" in extractTableName(). > 2. Need to support full alter table syntax in extractSQLData(). > 3. Need to create sqlAlterTable() function, similar to sqlCreateTable() > etc. > 4. Need to support "alter" in sqlImport() function. > > If you see a flaw in my plan let me know. Otherwise I'll start fumbling > through this tonight while my spouse is distracted by Will&Grace. Scrubs > is my one true god. > > Don. > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-10 20:26:49
|
Alright. After some light analysis here is the RFE for supporting ALTER TABLE commands in core. 1. Need to support "alter" in extractTableName(). 2. Need to support full alter table syntax in extractSQLData(). 3. Need to create sqlAlterTable() function, similar to sqlCreateTable() etc. 4. Need to support "alter" in sqlImport() function. If you see a flaw in my plan let me know. Otherwise I'll start fumbling through this tonight while my spouse is distracted by Will&Grace. Scrubs is my one true god. Don. |
|
From: Don S. <do...@se...> - 2003-04-10 20:15:14
|
Hm I suppose we wouldn't be able to do table prefixes then. I suppose the best avenue is to fix the sqlImport() function. In researching that endeavour, I also noticed that extractTableName doesn't support alter table either. I'll work on some fixin's from home if I have get some time. Don. On Thu, 10 Apr 2003, Don Seiler wrote: > Is it in bad taste to have just a function to read a file and run the sql > without trying to validate or any of that fancy jazz? > > Don. > > On Thu, 10 Apr 2003, Don Seiler wrote: > > > Did some invesimagating and came to the conclusion that sqlImport in > > core/Database.php barfs on 'alter table' commands. Mainly it doesn't seem > > to know when one alter table command ends, so I keep getting "incorrect > > formatting" errors. > > > > I've tried to add a line similar to the "preg_match" for drop table but I > > can't seem to get my head around it. > > > > Once that issue would be resolved, I would probably run into a problem at > > the end of sqlImport since there is no "alter" case in the > > switch($command) statement. > > > > So if someone with a less fried brain wants to give it a go that would be > > super. > > > > Don. > > > > > > > > ------------------------------------------------------- > > 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 > > > > > > > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-10 20:11:33
|
Is it in bad taste to have just a function to read a file and run the sql without trying to validate or any of that fancy jazz? Don. On Thu, 10 Apr 2003, Don Seiler wrote: > Did some invesimagating and came to the conclusion that sqlImport in > core/Database.php barfs on 'alter table' commands. Mainly it doesn't seem > to know when one alter table command ends, so I keep getting "incorrect > formatting" errors. > > I've tried to add a line similar to the "preg_match" for drop table but I > can't seem to get my head around it. > > Once that issue would be resolved, I would probably run into a problem at > the end of sqlImport since there is no "alter" case in the > switch($command) statement. > > So if someone with a less fried brain wants to give it a go that would be > super. > > Don. > > > > ------------------------------------------------------- > 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: Don S. <do...@se...> - 2003-04-10 19:59:19
|
Did some invesimagating and came to the conclusion that sqlImport in core/Database.php barfs on 'alter table' commands. Mainly it doesn't seem to know when one alter table command ends, so I keep getting "incorrect formatting" errors. I've tried to add a line similar to the "preg_match" for drop table but I can't seem to get my head around it. Once that issue would be resolved, I would probably run into a problem at the end of sqlImport since there is no "alter" case in the switch($command) statement. So if someone with a less fried brain wants to give it a go that would be super. Don. |
|
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: 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 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----- |
5 messages has been excluded from this view by a project administrator.
