phpwebsite-developers

[Phpwebsite-developers] NOTICE

[Matthew M. <ma...@tu...>]

I have updated the core installation files to the new auto increment
format. However, I have hit a snag in the sqlImport function as it blindly
queries the commands it is sent.

So while I work on sqlImport creating a sequence on the CREATE query,
installation will NOT work.

More to come...


Matthew McNaney
Internet Systems Architect
Electronic Student Services
Email: ma...@tu...
URL: http://phpwebsite.appstate.edu
Phone: 828-262-6493
ICQ: 141057403

Re: [Phpwebsite-developers] NOTICE

[Matthew M. <ma...@tu...>]

Ok the install will work now. sqlImport creates a sequence table for every
table created with a primary id field.

As each of you are converting your modules please be aware of some things.

Remove the auto_increments from your CREATE statements. Make sure the id
column is set as a primary key that is unsigned.

Make sure you are not locking your tables before inserting if you want to
auto_increment. The PEAR sequencer does this automatically and your lock
will conflict. Use the returnId parameter if you need the last column id.

When you install, boost will not translate some statements. I am looking
in to that.

Matthew McNaney
Internet Systems Architect
Electronic Student Services
Email: ma...@tu...
URL: http://phpwebsite.appstate.edu
Phone: 828-262-6493
ICQ: 141057403

Re: [Phpwebsite-developers] NOTICE

[Don S. <do...@se...>]

Rock.

Don.

On Mon, 21 Oct 2002, Matthew McNaney wrote:

> Ok the install will work now. sqlImport creates a sequence table for every
> table created with a primary id field.
> 
> As each of you are converting your modules please be aware of some things.
> 
> Remove the auto_increments from your CREATE statements. Make sure the id
> column is set as a primary key that is unsigned.
> 
> Make sure you are not locking your tables before inserting if you want to
> auto_increment. The PEAR sequencer does this automatically and your lock
> will conflict. Use the returnId parameter if you need the last column id.
> 
> When you install, boost will not translate some statements. I am looking
> in to that.
> 
> Matthew McNaney
> Internet Systems Architect
> Electronic Student Services
> Email: ma...@tu...
> URL: http://phpwebsite.appstate.edu
> Phone: 828-262-6493
> ICQ: 141057403
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future of 
> Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) 
> program now. http://ad.doubleclick.net/clk;4699841;7576298;k?
> http://www.sun.com/javavote
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 

Re: [Phpwebsite-developers] NOTICE

[Steven L. <st...@tu...>]

Doh... lol  This is going to blow menuman out of the water.  Hopefully it
will not be too much of a problem to fix :)

+1 though, it is good this stuff is being taken care of now.

> Ok the install will work now. sqlImport creates a sequence table for
> every table created with a primary id field.
>
> As each of you are converting your modules please be aware of some
> things.
>
> Remove the auto_increments from your CREATE statements. Make sure the id
> column is set as a primary key that is unsigned.
>
> Make sure you are not locking your tables before inserting if you want
> to auto_increment. The PEAR sequencer does this automatically and your
> lock will conflict. Use the returnId parameter if you need the last
> column id.
>
> When you install, boost will not translate some statements. I am looking
> in to that.
>
> Matthew McNaney
> Internet Systems Architect
> Electronic Student Services
> Email: ma...@tu...
> URL: http://phpwebsite.appstate.edu
> Phone: 828-262-6493
> ICQ: 141057403
>
>
>
>
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future of
> Java(TM) technology. Join the Java Community Process(SM) (JCP(SM))
> program now. http://ad.doubleclick.net/clk;4699841;7576298;k?
> http://www.sun.com/javavote
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


-- 
Steven Levin
Electronic Student Services
Appalachian State University
Phone: 828.262.2431
PhpWebsite Development Team
URL: http://phpwebsite.appstate.edu
Email: st...@NO...