First things first.
PHP: 4.2.2
MySQL: 3.23.45
Apache: 1.3.26 (Unix)
Using 0.2a I get the same problem as shown by the chap in the bug tracker ... The left hand column takes up the entire screen, the centre pane never gets shown and the site is unusable.
I back-tracked to vers 0.2 and now can't get any bookstore panel to appear anywhere. If put onthe left it simply doesn't appear, if put on teh right it knocks out all the other panels there (apart from poll) yet still doesn't appear.
Having said that 0.2 is usable, however some niggles.
Catagories aren't working just yet. Editing the MySQL table directly is OK and books will apear in the correct catagories (for display puposes) however catagory admin from the bookstore admin interface results in either a MySQL syntax error or it claims not to be able to find the table.
Change and delete catagories don't have selection boxs associated with them and using "add" produces the synatx error.
Manage books, again no selection box for the catagory so books can only be entered to teh default catagory ... however as I mention above direct input to the MySQL table (thank heavens for MySQL Admin!) works just fine.
Display ... bookstore link works just fine, apparently just how it's intended to ... great work.
OK then, on top of all that a feature request :-)
When you get the block working OK as I understand it it will display a random book from the list? If so is there anyway by which it can be tweaked by displaying a random book from a particular catagory based on the topic catagory.
That is have a look-up table that maps topic numbers to (book) catagory numbers ...
(unmapped topics remaining random from the whole list.)
That's enough for now, just wish my skills with php/MySQL were up to giving you a bit more "real" help.
Don't hesitate to shout though if you'd like me to test anything or you need more details.
Chris
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Same here...when I tried 0.2a everything was pushed to the right....and would not allow be to uninstalled from admin...
Then I downloaded 0.2 and it allowed me to enter my amazon id# and dev id# etc...but it would not allow me to create categories - got the error that "ppp.mod_bookstore_categories" does not exsist...when I went into phpmyadmin there was a phpws_mod_bookstore_categories...
It also did not allow me to add books...
When I clicked to view the store it had a default category there with a PHP book listed but when I went to admin to try to delete the book/category neither were listed...
Also...the 0.2 version allowed me to uninstall from admin area.
Can't wait to use this mod:) Wish I could help more technically but I am a php baby..
If you need someone to help testing installs email me...
Gina:)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just a reminder I see that you've got phpmyadmin. Using this you can actually create catagories, add, delete and assign books to catagories to your hearts content.
Doing it this way you end up with a very usable link on your menu to your bookshop, which does actually display and work very well.
I've a feeling that even with the "finished product" it may be quicker to admin the store via myadmin rather than the web interface.
All the best,
Chris
(and apologies for spelling/grammar in my previous ... and no doubt future ... posts)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have just uploaded version 0.2b. This is the result of work done by spiggy (phpgirl.com) and I think she is running Linux.
I think some of the problems may be related to permissions on the tables and directories. This is less of a problem with win2k, and the only significant difference I can think of, and one I can't recreate.
She has also been very helpful catching errors that I have made as a result of looking at the same code for too long. It's amazing what a fresh set of eyes, and a significant knowledge of php will do.
Please give it a try and let me know how it works out.
Thanks all.
Victor
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The admin area ... all selection boxes associated with catagory selection now appear ... and are functional.
The "recommends" box also now appears in the correct place ... but as yet I haven't had a book appear in it ...
This may be because although I have many catagories set-up I have only put books into one of them. As soon as I have populated all the catagories with books/products I'll report back.
As for Spiggy, she has a great site, I wonder if she'll marry me :-)
Chris
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
First things first.
PHP: 4.2.2
MySQL: 3.23.45
Apache: 1.3.26 (Unix)
Using 0.2a I get the same problem as shown by the chap in the bug tracker ... The left hand column takes up the entire screen, the centre pane never gets shown and the site is unusable.
I back-tracked to vers 0.2 and now can't get any bookstore panel to appear anywhere. If put onthe left it simply doesn't appear, if put on teh right it knocks out all the other panels there (apart from poll) yet still doesn't appear.
Having said that 0.2 is usable, however some niggles.
Catagories aren't working just yet. Editing the MySQL table directly is OK and books will apear in the correct catagories (for display puposes) however catagory admin from the bookstore admin interface results in either a MySQL syntax error or it claims not to be able to find the table.
Change and delete catagories don't have selection boxs associated with them and using "add" produces the synatx error.
Manage books, again no selection box for the catagory so books can only be entered to teh default catagory ... however as I mention above direct input to the MySQL table (thank heavens for MySQL Admin!) works just fine.
Display ... bookstore link works just fine, apparently just how it's intended to ... great work.
OK then, on top of all that a feature request :-)
When you get the block working OK as I understand it it will display a random book from the list? If so is there anyway by which it can be tweaked by displaying a random book from a particular catagory based on the topic catagory.
That is have a look-up table that maps topic numbers to (book) catagory numbers ...
(unmapped topics remaining random from the whole list.)
That's enough for now, just wish my skills with php/MySQL were up to giving you a bit more "real" help.
Don't hesitate to shout though if you'd like me to test anything or you need more details.
Chris
mysql: 3.23.41
php: 4.0.6
RedHat Linux 7.3
Hello,
Same here...when I tried 0.2a everything was pushed to the right....and would not allow be to uninstalled from admin...
Then I downloaded 0.2 and it allowed me to enter my amazon id# and dev id# etc...but it would not allow me to create categories - got the error that "ppp.mod_bookstore_categories" does not exsist...when I went into phpmyadmin there was a phpws_mod_bookstore_categories...
It also did not allow me to add books...
When I clicked to view the store it had a default category there with a PHP book listed but when I went to admin to try to delete the book/category neither were listed...
Also...the 0.2 version allowed me to uninstall from admin area.
Can't wait to use this mod:) Wish I could help more technically but I am a php baby..
If you need someone to help testing installs email me...
Gina:)
Hi Gina,
Just a reminder I see that you've got phpmyadmin. Using this you can actually create catagories, add, delete and assign books to catagories to your hearts content.
Doing it this way you end up with a very usable link on your menu to your bookshop, which does actually display and work very well.
I've a feeling that even with the "finished product" it may be quicker to admin the store via myadmin rather than the web interface.
All the best,
Chris
(and apologies for spelling/grammar in my previous ... and no doubt future ... posts)
I have just uploaded version 0.2b. This is the result of work done by spiggy (phpgirl.com) and I think she is running Linux.
I think some of the problems may be related to permissions on the tables and directories. This is less of a problem with win2k, and the only significant difference I can think of, and one I can't recreate.
She has also been very helpful catching errors that I have made as a result of looking at the same code for too long. It's amazing what a fresh set of eyes, and a significant knowledge of php will do.
Please give it a try and let me know how it works out.
Thanks all.
Victor
Hi,
Looking much better already.
The admin area ... all selection boxes associated with catagory selection now appear ... and are functional.
The "recommends" box also now appears in the correct place ... but as yet I haven't had a book appear in it ...
This may be because although I have many catagories set-up I have only put books into one of them. As soon as I have populated all the catagories with books/products I'll report back.
As for Spiggy, she has a great site, I wonder if she'll marry me :-)
Chris