Steven Dowd
|
| Posted: 05/30/2002, 5:44 AM |
|
Not sure if I found a bug or not in the supplied bookstore example,
without doing a total new install, I cannot be certain that I haven't
altered anything at all, but I just published the std Bookstore example
as php4 + templates, and it all works ok, except in the admin pages, if
I select the left admin menu 'Editorials' link, I get a page of errors.
Database error: Invalid SQL: SELECT COUNT(*) FROM
bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN bs_items ON
bs_editorials.item_id = bs_items.item_id) ON
bs_editorial_categories.editorial_cat_id =
bs_editorials.editorial_cat_id
MySQL Error: 1064 (You have an error in your SQL syntax near
'(bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id =
bs_items.item_id) O' at line 1)
Session halted.
whilst on the subject of the bookstore, is their the possibility that
you could 'this time' include a checkout page , or email checkout page
examples..
I know you didn't on the CC releases, but it was and will be always
asked for. I know you cannot really promote or push any one payment
system over another, but I cannot see why a checkout and e-mail your
order page or formpage is not included .. Its bound to be asked about,
'how to' on day one that you release..
and categories on the forum example would be next 'most wanted' .. :)
Steven Dowd
______________________
Steven.Dowd@dowd.co.uk
http://www.dowd.co.uk
______________________
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/30/2002, 7:03 AM |
|
I checked BookStore example , this bug didn't appear , I can see that count
sql
in your AdminEditorials page differs from mine , that's probably caused by
your changes,
in fact it should be
$this->CountSQL = "SELECT COUNT(*) FROM (SELECT * " .
" FROM bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN bs_items
ON bs_editorials.item_id = bs_items.item_id) ON
bs_editorial_categories.editorial_cat_id = bs_editorials.editorial_cat_id)
cnt";
If you replace it in your code everything should work ok.
To be 100% sure you need to remove and install CCS.
Alternatively, I can email you clean example and you will test it.
--
Alex
CodeCharge Developer
"Steven Dowd" <newspost.steven.dowd@dowd.co.uk> wrote in message
news:ad56r0$a4t$1@news.codecharge.com...
> Not sure if I found a bug or not in the supplied bookstore example,
>
> without doing a total new install, I cannot be certain that I haven't
> altered anything at all, but I just published the std Bookstore example
> as php4 + templates, and it all works ok, except in the admin pages, if
> I select the left admin menu 'Editorials' link, I get a page of errors.
>
> Database error: Invalid SQL: SELECT COUNT(*) FROM
> bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN bs_items ON
> bs_editorials.item_id = bs_items.item_id) ON
> bs_editorial_categories.editorial_cat_id =
> bs_editorials.editorial_cat_id
> MySQL Error: 1064 (You have an error in your SQL syntax near
> '(bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id =
> bs_items.item_id) O' at line 1)
> Session halted.
>
> whilst on the subject of the bookstore, is their the possibility that
> you could 'this time' include a checkout page , or email checkout page
> examples..
>
> I know you didn't on the CC releases, but it was and will be always
> asked for. I know you cannot really promote or push any one payment
> system over another, but I cannot see why a checkout and e-mail your
> order page or formpage is not included .. Its bound to be asked about,
> 'how to' on day one that you release..
>
> and categories on the forum example would be next 'most wanted' .. :)
>
>
> Steven Dowd
>
>
> ______________________
>
>Steven.Dowd@dowd.co.uk
> http://www.dowd.co.uk
> ______________________
>
>
>
|
|
|
|
Steven Dowd
|
| Posted: 05/30/2002, 7:41 AM |
|
I just re installed , and it did the same Alex . it seems to work ok as
ASP, but as php its giving the same error
can you mail me a clean bookstore, I will test that..
Thanks
Steven
steven.dowd@dowd.info
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ad5bfq$k1j$2@news.codecharge.com...
> I checked BookStore example , this bug didn't appear , I can see that
count
> sql
> in your AdminEditorials page differs from mine , that's probably
caused by
> your changes,
> in fact it should be
>
> $this->CountSQL = "SELECT COUNT(*) FROM (SELECT * " .
> " FROM bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN
bs_items
> ON bs_editorials.item_id = bs_items.item_id) ON
> bs_editorial_categories.editorial_cat_id =
bs_editorials.editorial_cat_id)
> cnt";
>
> If you replace it in your code everything should work ok.
> To be 100% sure you need to remove and install CCS.
> Alternatively, I can email you clean example and you will test it.
>
> --
> Alex
> CodeCharge Developer
>
>
> "Steven Dowd" <newspost.steven.dowd@dowd.co.uk> wrote in message
>news:ad56r0$a4t$1@news.codecharge.com...
> > Not sure if I found a bug or not in the supplied bookstore example,
> >
> > without doing a total new install, I cannot be certain that I
haven't
> > altered anything at all, but I just published the std Bookstore
example
> > as php4 + templates, and it all works ok, except in the admin pages,
if
> > I select the left admin menu 'Editorials' link, I get a page of
errors.
> >
> > Database error: Invalid SQL: SELECT COUNT(*) FROM
> > bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN bs_items
ON
> > bs_editorials.item_id = bs_items.item_id) ON
> > bs_editorial_categories.editorial_cat_id =
> > bs_editorials.editorial_cat_id
> > MySQL Error: 1064 (You have an error in your SQL syntax near
> > '(bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id =
> > bs_items.item_id) O' at line 1)
> > Session halted.
> >
> > whilst on the subject of the bookstore, is their the possibility
that
> > you could 'this time' include a checkout page , or email checkout
page
> > examples..
> >
> > I know you didn't on the CC releases, but it was and will be always
> > asked for. I know you cannot really promote or push any one payment
> > system over another, but I cannot see why a checkout and e-mail your
> > order page or formpage is not included .. Its bound to be asked
about,
> > 'how to' on day one that you release..
> >
> > and categories on the forum example would be next 'most wanted' ..
:)
> >
> >
> > Steven Dowd
> >
> >
> > ______________________
> >
> >Steven.Dowd@dowd.co.uk
> > http://www.dowd.co.uk
> > ______________________
> >
> >
> >
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/31/2002, 3:59 AM |
|
Sure. Check your mailbox in a couple of mins
--
Alex
CodeCharge Developer
"Steven Dowd" <newspost.steven.dowd@dowd.co.uk> wrote in message
news:ad5dna$oo8$1@news.codecharge.com...
> I just re installed , and it did the same Alex . it seems to work ok as
> ASP, but as php its giving the same error
>
> can you mail me a clean bookstore, I will test that..
>
> Thanks
>
> Steven
>steven.dowd@dowd.info
>
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:ad5bfq$k1j$2@news.codecharge.com...
> > I checked BookStore example , this bug didn't appear , I can see that
> count
> > sql
> > in your AdminEditorials page differs from mine , that's probably
> caused by
> > your changes,
> > in fact it should be
> >
> > $this->CountSQL = "SELECT COUNT(*) FROM (SELECT * " .
> > " FROM bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN
> bs_items
> > ON bs_editorials.item_id = bs_items.item_id) ON
> > bs_editorial_categories.editorial_cat_id =
> bs_editorials.editorial_cat_id)
> > cnt";
> >
> > If you replace it in your code everything should work ok.
> > To be 100% sure you need to remove and install CCS.
> > Alternatively, I can email you clean example and you will test it.
> >
> > --
> > Alex
> > CodeCharge Developer
> >
> >
> > "Steven Dowd" <newspost.steven.dowd@dowd.co.uk> wrote in message
> >news:ad56r0$a4t$1@news.codecharge.com...
> > > Not sure if I found a bug or not in the supplied bookstore example,
> > >
> > > without doing a total new install, I cannot be certain that I
> haven't
> > > altered anything at all, but I just published the std Bookstore
> example
> > > as php4 + templates, and it all works ok, except in the admin pages,
> if
> > > I select the left admin menu 'Editorials' link, I get a page of
> errors.
> > >
> > > Database error: Invalid SQL: SELECT COUNT(*) FROM
> > > bs_editorial_categories INNER JOIN (bs_editorials LEFT JOIN bs_items
> ON
> > > bs_editorials.item_id = bs_items.item_id) ON
> > > bs_editorial_categories.editorial_cat_id =
> > > bs_editorials.editorial_cat_id
> > > MySQL Error: 1064 (You have an error in your SQL syntax near
> > > '(bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id =
> > > bs_items.item_id) O' at line 1)
> > > Session halted.
> > >
> > > whilst on the subject of the bookstore, is their the possibility
> that
> > > you could 'this time' include a checkout page , or email checkout
> page
> > > examples..
> > >
> > > I know you didn't on the CC releases, but it was and will be always
> > > asked for. I know you cannot really promote or push any one payment
> > > system over another, but I cannot see why a checkout and e-mail your
> > > order page or formpage is not included .. Its bound to be asked
> about,
> > > 'how to' on day one that you release..
> > >
> > > and categories on the forum example would be next 'most wanted' ..
> :)
> > >
> > >
> > > Steven Dowd
> > >
> > >
> > > ______________________
> > >
> > >Steven.Dowd@dowd.co.uk
> > > http://www.dowd.co.uk
> > > ______________________
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
