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


« 1 ... 29199 29200 29201 (29202) 29203 29204 29205 ... 29422 »


292011
Shine
Re: How to "clone" Tiny Content

  • 2003/9/6 9:24

  • Shine

  • Just can't stay away

  • Posts: 822

  • Since: 2002/7/22


Quote:
I think that's all. If you have any problems, please post them here to make the necessary corrections.


Not quit
You forgot to mention the sql file. This file needs also to be corrected into name of his rewritten module.
Ie.:
Previous 'tinycontent'
New modname: 'mymodule' (sportsdraw)

Otherwise it doesn't connect to the correct DB tables of the rewritten TContent module.

grtz., Shine

[edit]

Wait a minute,.........within this tinycontent module I found a writing from its developer.
Open: modinfo.php
It says:
Quote:
//***********************************************************************//
// No language config below! Only if you want to change the Prefix //
// or the directory of the module! So you can sipmly duplicate this //
// module by copying it in another folder and change the settings below! //
// Also before install a clone change the prefix in the sql file! //
//***********************************************************************//

define("_MI_TINYCONTENT_PREFIX", "tinycontent");
define("_MI_DIR_NAME", "tinycontent");


Try to do exactly what he's saying here. Change both lines tinycontent into sportsdraw and open your sqlfile and change also tinycontent prefix into sportsdraw.
Upload, install and see what happens.

[/edit]
Topic | Forum


292012
philroy
Re: How to "clone" Tiny Content

  • 2003/9/6 9:00

  • philroy

  • Friend of XOOPS

  • Posts: 107

  • Since: 2003/8/23


Help?? Sorry...there's been no response to the errors when cloning that I've posted and I'm desperate.

Phil
Topic | Forum


292013
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
Topic | Forum


292014
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


292015
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
Topic | Forum


292016
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


292017
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.
Topic | Forum


292018
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.
Topic | Forum


292019
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
Topic | Forum


292020
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






[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

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

Members: 0

Guests: 215

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