292051
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?



292052
ackbarr
Re: Theme Change question

In XOOPS 2.0.3 you need to activate the Theme block to change themes. This change is not permanent ATM, but lasts as long as your session does.



292053
Coplan
Theme Change question
  • 2003/9/5 21:48

  • Coplan

  • Just popping in

  • Posts: 51

  • Since: 2002/10/2


I'm using XOOPS 2.0.3.

User's can't seem to change their theme. In fact, it's not even an option in their preferences. I have two themes allowed, and custom-sessions enabled. But alas, no theme options.

Mind you, I came here (to the XOOPS site) to see if I could change my theme here. I don't know if I'm just looking in the wrong area, or what. But I can't change my theme here either. (Of course, I do realize that perhaps the admins here won't allow it).

Any help would be appreciated.



292054
ackbarr
Re: WebSlave Project - a project managment tool

Quote:
Error message: Table 'xoops.xoops_ws_restrictions' doesn't exist
Seems like this table did not get created properly by the sql script - see my post above, then uninstall the module and re-install to get a new copy of the tables



292055
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!



292056
philou
Re: WebSlave Project - a project managment tool
  • 2003/9/5 17:38

  • philou

  • Quite a regular

  • Posts: 384

  • Since: 2002/5/6 8


Thx a lot... I try this and give you the results....



292057
gronice
Re: WebSlave Project - a project managment tool
  • 2003/9/5 17:34

  • gronice

  • Just popping in

  • Posts: 30

  • Since: 2003/7/31


Sorry for the late answere.

Every one did a clean install or run the update0.6to0.7.php in the modul directory?

To modify projects and set you must set your group in the admin menue to be project admin.

If it's any thing else please turn php debugmode on or the SQL - debug mode and report me the shown errors, please.

I don't know what may be the mistake, here it runs without this errors.



The ' problem, yes I know it, will fix it as sone as posible.

I think it's a little bit more work, but you could try to did an add slashes on all items in $this->_vars you I'll find it in core.php in the wsProject Constructor.

And then you I'll have to stripslashes in the index.php on all string-items in the array from GetData.

Hope this helps, for now.





292058
Mithrandir
Re: WebSlave Project - a project managment tool

Quote:
Anyone recognize what i am facing here?

Erhm... yes... like two posts before



292059
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?



292060
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.







Login

Who's Online

802 user(s) are online (552 user(s) are browsing Support Forums)


Members: 0


Guests: 802


more...

Donat-O-Meter

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

Latest GitHub Commits