1
valimaggi
Re: XOOPS 2.4.4 installation stalls
  • 2010/5/5 11:20

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Hey, I got it going now.

What I got wrong was that /include/licence.php didn't got the right permissions.

But now I'm stuck at the page 10, getting this error


Fatal error: Call to undefined function xoops_getBaseDomain() in /home/neuroinf/public_html/include/common.php on line 84


Include directory and common.php are have both right access permissions.

Generally I'm asking, how is the installation supposed to be done when the XOOPS is going it be installed to the hosted site? I mean that when I move the htdocs directory to the web root of the site and then go to the sitename with my web browser to start the installation wizard, a lot of warnings appear that permissions are denied to several files.

So do I have to give that web root directory permissions to everyone (user/group/others in Linux) to read and execute? Since that's the only way to get the installation go forward with the web browser from outside of the that hosted server. I know that install-directory can be deleted after the installation but the installation requires access to other directories and files too.

There is nothing about this in the installation instructions (well, the general instructions are there with xoops_data directory etc. but nothing hosted platform specific stuff)

Installing on a hosted platform

If you are running in a hosted environment, unpack the XOOPS files locally or on the server if you have telnet or SSH access. Once you done this, make sure to move or copy all XOOPS files from the htdocs directory to your root web directory (your provider usually provides this location with directions). Once the files are copied there, you can start the install by typing "http://yoursite.com". This will start the install process.



2
valimaggi
XOOPS 2.4.4 installation stalls
  • 2010/5/4 13:07

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Hello!

I have a problem with XOOPS 2.4.4 installation. I can get to the 9th page of the installation wizard, the Initial settings page, where I'm instructed to give Admin login, Admin email and Admin password (+confirmation to that).

Then I hit the next button, and the wizards throws me back to the 6th page, the Database configuration page. Before that everything has gone smoothly, I've got these notifications in the previous pages like

"The installer has saved the specified settings to mainfile.php. Press next to go to the next step."

and

"XOOPS system tables have been created. Press next to go to the next step."

I don't understand at all what's this all about.



3
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/10/13 10:03

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Thanks for the reply again!

Quote:
I think the designer is looking for similar names and thinks there is a relation. Some existing relations may not be found eg uid and user_id.

But as in case 1 it is not. In fact the bid name is a shortcut for banner id and block id and is thus totally unrelated.
- 2 is the same case.
- 3 unrelated as explained before.
- 4 as explained before.


Ah, now I got it. So DBDesigner is pretty useless in this case.

Quote:
The cartesian product has nothing to do with table relations, but is the result of a query on two or more tables with no join condition.

The database is fully functional, but the relations are done in the PHP code. That's why I told you to examine the sources.


Yes, okay that's what I meant with my edit part of the last post. That the relations between tables are done in PHP code because they can't be done in SQL side (because of MyISAM).

Guess I have to try to check all the source files...

wishcraft, I'm sorry that I have to decline since I really don't have time to any extra stuff at the moment. :(



4
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/10/9 13:00

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Is anyone able to answer my questions in my last post ?

Thank you

BR

Mikko V



5
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/10/2 11:26

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Thanks for replying to these questions.

Quote:
Every module contains a /sql/mysql.sql file (appointed in xoops_version.php), which contains the table structure for the module's specific tables. These tables are created at module install and removed with uninstall.


Okay. Is there somewhere .sql file for XOOPS table structure?

Quote:
No, all tables are MyISAM tables and referential integrity is only possible with the InnoDB storage engine, which is not always available.


Yes, but how the references then work between the tables in the XOOPS database? I'm not too familiar with MyISAM even if I tried to study it a bit with Google.

Quote:
Such things are not possible between two tables.
If the (unique) primary keys (are used to) point to each other you have a one to one relation.


That's what I thought too.

Quote:
I think you are misinterpreting the functions between these two tables. AFAIK When a banner has had its required display times it is copied to the other table and deleted in the first table and the 2 bid are both PRIMARY KEY, but are unrelated.
They do have both a 1 to many relation with bannerclient trough their cid field. One client can have many running and finished banners.


Here's a screenshot from DBDesigner 4. I used Reverse-engineer to get the table structure from the XOOPS database. I selected only few tables to be fetched to describe my issue.

Screenshot

I have numbers for every "connection" between tables.

1. Relations between "xoops_newsblock" and "xoops_bannerfinish" tables. Key used is "bid" for both ways.

2. Relations between "xoops_newsblock" and "xoops_banner" tables. Key used is "bid" for both ways.

3. Relations between "xoops_banner" and "xoops_bannerfinish" tables. Key used is "bid" for both ways. Below of these tables (marked with "3." also), there are Relation Editors for these two relations. We can see they are 1:N relations and both have "bid" as the "foreign key". (same goes to number 1 and number 2 relations in the picture")

4. Relations between "xoops_bannerclient" to "xoops_banner" and to "xoops_bannerfinish" tables. Key used is "cid" for both like you explained.


Here's documentation for DBDesigner, and a precise link to Relation Editor part

Online documentation of DBDesigner 4, Relation Editor

Online documentation of DBDesigner 4

In the first link, we can see these


1:n one - to - many relation
Explanation: One row in the source table matches many rows in the destination table.

Example: A relation between an [order] table and a [orderproduct] table. One order can have many products and a product in the [orderproduct] table is only part of one order.


1:n (Non Identifying) one - to - many relation, FK not in PK
Explanation: One row in the source table matches many rows in the destination table but the Foreign Key in the destination table is not in the Primary Key Index.

Example: A relation between a [payment] table and an [order] table. Each row in the [order] table as a [payment] assigned to. Only [idorder] is the Primary Key field in the [order] table.


So is this just a flaw in DBDesigner that it misinterpretes these relations? Because according to the software, they are 1:N relations. And to me, it's strange. Isn't it that if that is the case, they are actually "same" tables (and why aren't 1:1 relations used then?) Confusing.

BR

Mikko V

edit. Hmm, now I thought that is it with MyISAM that you have to always do the Cartesian product with the two tables which should have relations between each other? And with WHERE clause pick up the correct rows.

If this is correct, then DBDesigner possibly can't guess which tables really references to each other and it just puts every table referencing to each other which have the same keys??? And the functionality of the database is just in code where the database is really used.

Is it so?



6
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/10/1 12:20

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Is it that when module is implemented to XOOPS, the database for the module is generated automatically by XOOPS?

I thought this because there's some strange solutions in the database of one module I'm looking for. I used that DBDesigner and "reverse-engineered" the table structure from the XOOPS database.

In the tables of this module and also in XOOPS tables, there's this strange kind of thing (example):

Two tables A and B. Both are referencing to each other's primary keys with 1:N relation like explained in DBDesigner's online documentation (one - to - many relation One row in the source table matches many rows in the destination table.)

For example xoops_banner and xoops_bannerfinish tables have such referential "connection" between each other. Both have their primary keys also as foreign keys and they refer to each other by them. Confusing.

Why is it done like this? Are there no referential integrity set in the XOOPS database generally?

Thanks in advance if anyone can lighten me a bit about this issue.

BR

Mikko V



7
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/8/24 10:52

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Thanks for the advice, I did that. But I really can't get much out of it, there isn't mentioned the word "query" even once in kernel "doxygenated" documentation.

I mean I can get the hierarchy diagram by doxygen but it doesn't help me much with the table structure problem.



8
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/8/13 13:22

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Quote:

It is looking in the PHP sources (search for the word query) and find the relations by the used variables from one query to the other. This way you find that eg uid and user_id are both user identifiers.

The sources are on your system, if you have XOOPS running, starting at the webroot (or some subdirectory of it). A maybe more convenient way to access this is the source cross reference (DoxyGen) at XooFoo.


Thanks for the reply.

I used that DoxyGen and searched for "query". It found over 300 hits with that. I don't know how to start exactly. Do you mean I search every place which has sql-query written? And with them I try to figure out the relations between the tables?



9
valimaggi
Re: Structure and relational model of the XOOPS database
  • 2009/8/12 12:48

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


Thank you for your replies ghian and bumciach!

I feared that my be the case with the documentation ghian. I'm puzzled with that "following the queries" though. I couldn't find any queries in my web server folder where I have my XOOPS files (if you meant sql query files or something?) Where these sources are available which you mentioned?

I was able to get DBDesigner4 working and get the table model from my XOOPS database. It's just a bit difficult-to-use-software because the GUI is somehow not right (perhaps got to do with the Linux version perhaps), all the texts in every dialog and pane and everywhere are partly hidden. It's like the it's not been correctly done to Linux or something.

http://img14.imageshack.us/img14/7648/dbddesignerscrnsht.png

BTW, I couldn't get Workbench installed (I don't have for example package called "libzip", probably some other packages too are missing). bumciach, do you know what all I need to get it working on my Linux (CentOS). I have to install everything as tar.gz sources because it's forbidden to use yum and that kind of stuff with my computer (maintenance has put this kind of order if people want to install own software, which they won't maintain)



10
valimaggi
Structure and relational model of the XOOPS database
  • 2009/8/7 9:47

  • valimaggi

  • Just popping in

  • Posts: 10

  • Since: 2009/8/4 6


(I couldn't find any better subforum for this question)

Hello, I'm Mikko from TUT (Tampere University of Technology), Finland.

I'm doing my thesis work and part of it got to do with XOOPS-based webdatabase for research data. One part of that is to analyze the database used. I'm talking about reverse-engineering the database tables back to relational and eventually conceptual models. I can't find anywhere any kind of documentation about database XOOPS uses. I can use MySQL to see what tables are in the database but can't figure out anything much further from that.

So my question is, do developers have any documentation about the database structure and its development (conceptual and relational models). Or is there anyone who I can contact to and ask further about this things? (if the documentation is completely missing)

I'd be very grateful if someone can help me on this.

Best regards

Mikko V




TopTop



Login

Who's Online

215 user(s) are online (124 user(s) are browsing Support Forums)


Members: 0


Guests: 215


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