Support Forums - All Posts - XOOPS Web Application System

Forum Index

Board index » All Posts (amok200)

« 1 2 (3) 4 5 6 7 »

wfsection - changing select box to order by weight not alphabetically ?

2004/3/14 10:06
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

How do I change the select box in wfsections (which I'm using to navigate sub-categories) to be ordered by weight instead of alphabetically ? This way I can control the order and make it more logical.

Thanks,

amok

Topic | Forum

wfsections PHP error

2004/3/12 2:39
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

I get the following PHP debug error when I go into Admin -> wfsection

Notice [PHP]: Undefined variable: string in file modules/wfsection/class/wfstree.php line 208

I'm using v1.01 (by JackJ) and also incorporating ken ohwada's fixes.

line 208 in the file referred to by the error is:

echo $string;

And sure enough as I do a search I find no instance of $string in the file. If it helps, the surrounding code is:

$result = $this->db->query($sql);

while ( list($catid, $name, $groupid, $editaccess) = $this->db->fetchRow($result) ) {

echo $string;
if (checkAccess($groupid)) {

Can someone shed some light ?

Thanks,

Amok

Topic | Forum

Re: Soapbox SQL error

2004/3/12 1:40
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi hsalazar,

Thanks for the response. Checked tables and emptied template_c, yet the problem still persists. Those query strings exist only in files within modules/soapbox, which is deactivated.

Of course, if I reactivate the module, the error disappears !

Perhaps its not deactivating properly ? I'll be interested to hear what you find out !

Incidentally, I just want to say that soapbox is just about the best looking and most well documented module I've seen. It's functionality is also very good, the only reason I chose not to use it was lack of subcategories.. but I'm watching for future developments.

Thanks,

Amok

Topic | Forum

Soapbox SQL error

2004/3/11 20:38
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

I am getting the following error if I turn on SQL debug

SELECT author FROM xoops_sbcolumns WHERE author = 4
Error number: 1146
Error message: Table 'user992_xoops.xoops_sbcolumns' doesn't exist
SELECT columnID, name FROM xoops_sbcolumns
Error number: 1146
Error message: Table 'user992_xoops.xoops_sbcolumns' doesn't exist

This error occurs when I choose 'modules' from the Admin section.

I believe 'sb' refers to Soapbox - I had installed soapbox but now have uninstalled it. How do I get rid of this error message ?

Thanks,

amok

Topic | Forum

Re: SQL error revealed by debug, please advise

2004/3/11 0:20
amok200
Just popping in
Posts: 68
Since: 2004/2/23

I discovered that the session table usually has this structure:

sess_id varchar(32) NOT NULL default '',
sess_updated int(10) unsigned NOT NULL default '0', sess_ip varchar(15) NOT NULL default '',
sess_data text NOT NULL

However mine has this structure:

sess_id varchar(32) NOT NULL default '',
sess_updated int(10) unsigned NOT NULL default '0',
sess_ip varchar(15) NOT NULL default '',
sess_data text NOT NULL,
member_name varchar(64) NOT NULL default '',
member_id mediumint(8) NOT NULL default '0',
browser varchar(64) NOT NULL default '',
login_type tinyint(1) NOT NULL default '0',
location varchar(40) NOT NULL default '',
member_group smallint(3) NOT NULL default '0',
in_forum smallint(5) NOT NULL default '0',
in_topic int(10) NOT NULL default '0',

Is this normal ? Does some process within the XOOPs core add these columns ?

Or were they added by another module ? I am running IPB v1.4a perhaps that added them.

Can anyone shed some light on this table and the associated error ? Or atleast point me towards the code that is calling this table so I can amend it given my seemingly non-standard table structure.

Thanks !

Amok

Topic | Forum

Re: SQL error revealed by debug, please advise

2004/3/10 21:19
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Thanks, I guess that would do the trick, I ran the query in phpmyadmin and it executes without error.

However I don't know where to put it ! Anyone know where this query comes from ?

Amok

Topic | Forum

Re: SQL error revealed by debug, please advise

2004/3/10 20:31
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

Thanks. Is there a less drastic course of action ?

Amok

Topic | Forum

SQL error revealed by debug, please advise

2004/3/10 20:20
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

Debug reveals the following error:

SELECT * FROM xoops_session WHERE login_type='1' AND uid>0
Error number: 1054
Error message: Unknown column 'uid' in 'where clause'

The preceding two lines are:

SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id=1
SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id=0

XOOPs doesn't seem any the worse for wear, but what is going on here, why isn't it picking up that member_id is being cast as uid.. Can I fix this, or can the query be rewritten to use member_id instead ?

I get this error on every page when I am logged in, as it is looking at the current session I guess.

Thanks,

Amok

Topic | Forum

Re: Fixing error in

2004/3/10 7:09
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Of course ! I looked everywhere but there, silly me ! Thx for the quick response

Topic | Forum

Fixing error in search.php

2004/3/10 6:40
amok200
Just popping in
Posts: 68
Since: 2004/2/23

Hi,

Search.php says "Seach Rule". Where is the source file for this so I can correct this spelling mistake ? It's not search.php or system_block_search.html, I can't seem to track it down.

Thanks,

Ali

Topic | Forum

Top

« 1 2 (3) 4 5 6 7 »

Stats
Goal:	$100.00
Due Date:	Sep 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

wfsection - changing select box to order by weight not alphabetically ?

wfsections PHP error

Re: Soapbox SQL error

Soapbox SQL error

Re: SQL error revealed by debug, please advise

Re: SQL error revealed by debug, please advise

Re: SQL error revealed by debug, please advise

SQL error revealed by debug, please advise

Re: Fixing error in

Fixing error in search.php

Login

Search

Recent Posts

Re: XoopsFaq for 2.5.10

XoopsFaq for 2.5.10

Re: activate block by default

Re: wgFilemanager released for testing and contribution

Re: wgFilemanager released for testing and contribution

Re: activate block by default

activate block by default

Re: wgFilemanager released for testing and contribution

wgFilemanager released for testing and contribution

Re: XOOPS 2.5.12 Beta-2 available for Testing

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}