51
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

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

53
philou
Re: WebSlave Project - a project managment tool
  • 2003/9/6 5:00

  • philou

  • Quite a regular

  • Posts: 384

  • Since: 2002/5/6 8


the xoops. is in fact the name of your database and so you have :
a database called XOOPS with all tables for Xoops
a table called xoops_ws_restrictions
in this table name you in fact to things : the prefix you have choose at the install (here it's xoops) and the rest of the name (ws_restrictions you can find in the sql file for the module instal. and table creating

54
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_



55
gronice
Re: WebSlave Project - a project managment tool
  • 2003/9/6 7:41

  • gronice

  • Just popping in

  • Posts: 30

  • Since: 2003/7/31


Yes there is a misstake un the sql-file

Like ackbarr already said

CREATE TABLE xoops_ws_restrictions

should be

CREATE TABLE ws_restrictions

Have fun
G'Ron

56
Mithrandir
Re: WebSlave Project - a project managment tool

Created the table ws_restrictions, which was missing somehow.

Now I can add restrictions etc. but when I go to edit the tasks to assign a user to it, it gives me:

Fatal error: Call to a member function on a non-object in /usr/local/psa/home/vhosts/ruffdesigns.co.uk/web_users/Mithrandir/modules/wsproject/class/core.php on line 1794

Line 1794 being:
$this->__data['user_name'] = $user->getVar('uname');

57
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

58
gronice
Re: WebSlave Project - a project managment tool
  • 2003/9/8 20:55

  • gronice

  • Just popping in

  • Posts: 30

  • Since: 2003/7/31


Your typo problem ist fixed a looong time ago.

Have a look at the CVS-Tree every thing looks.

May be if you pay for something you'll get 24h support, but I don't get anything then a thank you for this modul and this is ok, please respect this is my own sparetime.
And sometimes I get hungry and my boss don't pay me to write oss.

The CVS-Tree is a nice place for bugfixes and new features, too.
May be you I'll find some nice additions like a my-tasks block for your own frontpage.
There you could add a task to make a nice picture of the landscape where you life a mail it to may little hungry mailbox.

Have fun
G'Ron

59
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

60
gronice
Re: WebSlave Project - a project managment tool
  • 2003/9/14 14:10

  • gronice

  • Just popping in

  • Posts: 30

  • Since: 2003/7/31


Next Version!

Download v.0.7.8

Change-Log:

v.0.7.8
- fixed a typo in sql -file
- fixed problem with ticks
- added a mytasks block

It's not tested very well, but I hope it run's properly.
If not, please report bugs. Thx.

Have fun
G'Ron

Login

Who's Online

222 user(s) are online (155 user(s) are browsing Support Forums)


Members: 0


Guests: 222


more...

Donat-O-Meter

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

Latest GitHub Commits