XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk




1
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/8 21:28

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


Hi Gronice,

With my previous post I was really just kicking *myself* for not realizing that betas are betas and should be approached with care (and a little bit of experience and knowledge). I did not mean to imply that you should slave for me personally.

I (and many others) appreciate the massive effort you have undertaken. I, for one, am inspired to create a new module! Perhaps it can complement the XOOPS paradigm. I should probably now learn to use CVS so I don't get behind the curve.

cheers, dooder
Topic | Forum


2
dooder
Re: Questionnaire Module

  • 2003/9/8 16:07

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


Quote:

kingink wrote:
Sorry, but I didn't understand where I have to activate the Brandycoke's liase module for the Anonymous user group. Thanx in advance for your answer.


There are three admin sections you need to visit.

1) Modules - rename liase to something other than contact us. I typed "Make Contact"

2) Blocks - make sure it is visible and assigned to one of the left, center of right columns, also choose which page you will allow it to be seen

3) Groups - click on modify anonymous user and find the (now renamed to "Make Contact") module. Put a check in the checkbox and save changes.

dooder
Topic | Forum


3
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/8 15:59

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


Right, I need to fix the reported typo in the sql file. I forgot that I was using a beta and i shouldn't expect that typo reports in sql installs would get updated within 5 days. Thanks for the help, guys. Maybe one day i can build a cool module too.

dooder
Topic | Forum


4
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/6 5:26

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


Hi philou,

thanks for the lesson in the MySQL syntax! so that is what the xoops. (xoops dot) means

I re-installed the ws module and now I have a table called:

xoops_xoops_ws_restrictions

which seems to be wrong if I follow your logic properly. I looked at the sql code that makes the tables and the first table it makes like so:

CREATE TABLE xoops_ws_restrictions

while all the other tables in the same sql script have no xoops_ prepended only ws_


Topic | Forum


5
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/6 4:32

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


The table: xoops_xoops_ws_restrictions does exist but plain old xoops_ws_restrictions doesn't.

But, it looks like it is not the same table ( Table 'xoops.xoops_ws_restrictions' ) that is being called in the code; the module is calling it by the wrong name. I grepped the WS module source for some clues but found none.

Why would the module code think the table had the 'xoops. (xoops dot)' in front of the actual name of the database? I'm a little new here, but I've noticed that the tables all have xoops_ prepended as if it is some kind of standard.

I tried re-installing, but the same error happened. It seems to me like the calling code has a little hiccup in that it adds a dot instead of an underscore?
Topic | Forum


6
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/5 17:49

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


++EDITED++ PHP Debug shows me this error at the edit project page /modules/wsproject/index.php?op=editproject&project_id=3

Quote:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /class/database/mysql/db.php on line 174

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /class/database/mysql/db.php on line 174


When I go to add a task it shows:

Quote:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /class/database/mysql/db.php on line 255821053


SQL debug is perhaps more enlightening... it looks like the database doesn't exist. or at least it doesn't exist as for as the module is concerned. Maybe the wrong name?

Quote:

SELECT conf_value FROM xoops_ws_project WHERE conf_name = 'admin_group'
UPDATE xoops_ws_projects SET name = 'Testing', startdate = '2003-7-1', enddate = '2003-9-15', description= 'no comment' WHERE project_id='3'
DELETE FROM xoops_ws_restrictions WHERE project_id='3'
Error number: 1146
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist
INSERT INTO xoops_ws_restrictions (group_id, project_id, user_rank) VALUES ('1', '3', '1')
Error number: 1146
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist
INSERT INTO xoops_ws_restrictions (group_id, project_id, user_rank) VALUES ('1', '3', '2')
Error number: 1146
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist
SELECT name, startdate, enddate, description FROM xoops_ws_projects WHERE project_id=3
SELECT * FROM xoops_groups
SELECT group_id FROM xoops_ws_restrictions WHERE project_id='3' AND user_rank='1'
Error number: 1146
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist
SELECT group_id FROM xoops_ws_restrictions WHERE project_id='3' AND user_rank='2'
Error number: 1146
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist

Does that help figure out what might be going on?

TIA!
about posting a help request without understanding that others had already outlined the problem!
Topic | Forum


7
dooder
Re: WebSlave Project - a project managment tool

  • 2003/9/5 17:07

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


I can't seem to assisgn users to my tasks. The pop up menu just says:

"Please, add a group of user (edit project)"

I have tried to select and add users to be able to modify tasks, i put existing users in existing groups and allowed them to modify tasks, I even allowed anonymous users to modify, all with no luck.

Anyone recognize what i am facing here?
Topic | Forum


8
dooder
Re: Questionnaire Module

  • 2003/9/5 15:45

  • dooder

  • Just popping in

  • Posts: 11

  • Since: 2003/9/3 1


I installed Brandycoke's liase and I like the expanded feature set. One problem I had is that I couldn't seem to get it to appear to Anonymous user group. I tried all combinations of visible and activate and modfying group access.

I renamed from Contact Us to Make Contact it in the module admin page and then it became a lot easier to find in the lists and I didn't confuse it with the system Contact Us or the Contact Plus module (which i have now replaced in favor of brandycoke's)

So, in the end, I have it working. My advice is... rename it before trying to go in and get it tow show to Anonymous users because the default is for it not to show to Anonymous.
Topic | Forum



TopTop



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

225 user(s) are online (145 user(s) are browsing Support Forums)

Members: 0

Guests: 225

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits