reactos-kernel

[ros-kernel] rosproj on reactos.dhs.org

[Steven E. <ste...@ya...>]

Ok well its up....sorta. I dont know whats wrong but
when I run 
http://reactos.dhs.org/rosproj/initial_data.php
I get
Initial rights created
Initial roles created
Initial rights in roles created
Initial Projects created
Failed to insert into table: 1064: You have an error
in your SQL syntax near ' NULL, 'ReactOS', 'ReactOS
operating system.')' at line 1
SQL: INSERT INTO modules VALUES (0, NULL, , NULL,
'ReactOS', 'ReactOS operating system.')

http://reactos.dhs.org/rosproj/index.php runs but f
course there is no data.

Its 4 am. I need sleep
Peace

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

Re: [ros-kernel] rosproj on reactos.dhs.org

[David W. <we...@cw...>]

On Sun, May 12, 2002 at 01:00:30AM -0700, Steven Edwards wrote:                                           
> SQL: INSERT INTO modules VALUES (0, NULL, , NULL, 'ReactOS', 'ReactOS 
                                           ^
> operating system.')
> 
Doesn't something need to go there?

Re: [ros-kernel] rosproj on reactos.dhs.org

[Rex J. <re...@lv...>]

At 03:50 PM 5/12/02 +0000, you wrote:
>On Sun, May 12, 2002 at 01:00:30AM -0700, Steven Edwards 
>wrote:
> > SQL: INSERT INTO modules VALUES (0, NULL, , NULL, 'ReactOS', 'ReactOS
>                                            ^
> > operating system.')
> >
>Doesn't something need to go there?

Technically no, this form of INSERT implicitly selects all columns in the 
table
for the insert.  But, it is usually a bad idea from a maintainability point 
to use the
abbreviated form of insert.  Similarly, its bad form to use '*' as a column 
selector in
a select statement.


Rex Jolliff
re...@lv...

Re: [ros-kernel] rosproj on reactos.dhs.org

[Casper H. <ch...@us...>]

s=F8n, 2002-05-12 kl. 17:47 skrev Rex Jolliff:
> At 03:50 PM 5/12/02 +0000, you wrote:
> >On Sun, May 12, 2002 at 01:00:30AM -0700, Steven Edwards=20
> >wrote:
> > > SQL: INSERT INTO modules VALUES (0, NULL, , NULL, 'ReactOS', 'ReactOS
> >                                            ^
> > > operating system.')
> > >
> >Doesn't something need to go there?
>=20
> Technically no, this form of INSERT implicitly selects all columns in the=
=20
> table
> for the insert.  But, it is usually a bad idea from a maintainability poi=
nt=20
> to use the
> abbreviated form of insert.  Similarly, its bad form to use '*' as a colu=
mn=20
> selector in
> a select statement.

Well, mysql (3.23.41) does not accept this (I just checked). Try putting
NULL there (it is the project_id field).

I executed the same script without errors btw.

RE: [ros-kernel] rosproj on reactos.dhs.org

[Steven E. <Ste...@ya...>]

> Well, mysql (3.23.41) does not accept this (I just checked). 
> Try putting NULL there (it is the project_id field).

Put a NULL where? I looked in the initial_data.php and classes.inc but
couldn't find where I would need the NULL statement for project_id

Thanks
Steven

RE: [ros-kernel] rosproj on reactos.dhs.org

[Rex J. <re...@lv...>]

At 09:39 PM 5/12/02 -0400, you wrote:

> > Well, mysql (3.23.41) does not accept this (I just checked).
> > Try putting NULL there (it is the project_id field).
>
>Put a NULL where? I looked in the initial_data.php and classes.inc but
>couldn't find where I would need the NULL statement for project_id

You either need to specify data for all columns in the order they appear in 
the table,
or you need to specify the columns explicitly, for example (I don't know 
column names,
so ill make some up):

INSERT INTO modules
   (module_id, insert_date, insert_user, module_name, module_description)
   VALUES
   (0, NULL, NULL, 'ReactOS', 'ReactOS');

Using this form, if you have nullable or defaultable columns, you dont need to
specify them.  Also, you can add columns to a table without breaking all the
code if explicit columns are used in inserts.


>Thanks
>Steven
>
>
>_______________________________________________________________
>
>Have big pipes? SourceForge.net is looking for download mirrors. We supply
>the hardware. You get the recognition. Email Us: ban...@so...
>_______________________________________________
>reactos-kernel mailing list
>rea...@li...
>https://lists.sourceforge.net/lists/listinfo/reactos-kernel

Rex Jolliff
re...@lv...

RE: [ros-kernel] rosproj on reactos.dhs.org

[Steven E. <Ste...@ya...>]

OK I figured it out.
http://reactos.dhs.org/rosproj/tables/tables.mysql.php doesn't give a
error but it never builds the tables. Whats up with that? So of course
the next step wont work. 
Grrrr. Any ideas? When I run it from the command line php
rosproj/tabels/tables.mysql.php I get this

root@www:/var/www/htdocs/rosproj/tables# php tables.mysql.php
X-Powered-By: PHP/4.2.0
Content-type: text/html

root@www:/var/www/htdocs/rosproj/tables#

Any help would be great.

Thanks
Steven

"Every revolution was once a thought in one man's mind"
- Ralph Waldo Emerson 

RE: [ros-kernel] rosproj on reactos.dhs.org

[Jason F. <jas...@ya...>]

Yeah I should modify it to give error messages. Did you create the
rosproj db in mysql? Run mysql and try "use rosproj" (without the
quotes). If it fails then the db hasn't been created properly - refer
to reactos.org/install.txt, I think it is.

- Jason

--- Steven Edwards <Ste...@ya...> wrote:
> OK I figured it out.
> http://reactos.dhs.org/rosproj/tables/tables.mysql.php doesn't give
> a
> error but it never builds the tables. Whats up with that? So of
> course
> the next step wont work. 
> Grrrr. Any ideas? When I run it from the command line php
> rosproj/tabels/tables.mysql.php I get this
> 
> root@www:/var/www/htdocs/rosproj/tables# php tables.mysql.php
> X-Powered-By: PHP/4.2.0
> Content-type: text/html
> 
> root@www:/var/www/htdocs/rosproj/tables#
> 
> Any help would be great.
> 
> Thanks
> Steven
> 
> "Every revolution was once a thought in one man's mind"
> - Ralph Waldo Emerson 
> 
> 
> _______________________________________________________________
> 
> Have big pipes? SourceForge.net is looking for download mirrors. We
> supply
> the hardware. You get the recognition. Email Us:
> ban...@so...
> _______________________________________________
> reactos-kernel mailing list
> rea...@li...
> https://lists.sourceforge.net/lists/listinfo/reactos-kernel


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

RE: [ros-kernel] rosproj on reactos.dhs.org

[Jason F. <jas...@ya...>]

Yes, inserts aren't using a very good style. I'll change it...
sometime. :)

- Jason

--- Rex Jolliff <re...@lv...> wrote:
> At 09:39 PM 5/12/02 -0400, you wrote:
> 
> > > Well, mysql (3.23.41) does not accept this (I just checked).
> > > Try putting NULL there (it is the project_id field).
> >
> >Put a NULL where? I looked in the initial_data.php and classes.inc
> but
> >couldn't find where I would need the NULL statement for project_id
> 
> You either need to specify data for all columns in the order they
> appear in 
> the table,
> or you need to specify the columns explicitly, for example (I don't
> know 
> column names,
> so ill make some up):
> 
> INSERT INTO modules
>    (module_id, insert_date, insert_user, module_name,
> module_description)
>    VALUES
>    (0, NULL, NULL, 'ReactOS', 'ReactOS');
> 
> Using this form, if you have nullable or defaultable columns, you
> dont need to
> specify them.  Also, you can add columns to a table without
> breaking all the
> code if explicit columns are used in inserts.
> 
> 
> >Thanks
> >Steven
> >
> >
> >_______________________________________________________________
> >
> >Have big pipes? SourceForge.net is looking for download mirrors.
> We supply
> >the hardware. You get the recognition. Email Us:
> ban...@so...
> >_______________________________________________
> >reactos-kernel mailing list
> >rea...@li...
> >https://lists.sourceforge.net/lists/listinfo/reactos-kernel
> 
> Rex Jolliff
> re...@lv...
> 
> 
> _______________________________________________________________
> 
> Have big pipes? SourceForge.net is looking for download mirrors. We
> supply
> the hardware. You get the recognition. Email Us:
> ban...@so...
> _______________________________________________
> reactos-kernel mailing list
> rea...@li...
> https://lists.sourceforge.net/lists/listinfo/reactos-kernel


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com