1
fosterm
WF Links 1.03b Sort not working
  • 2007/6/1 18:02

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi all:)

I recently upgraded my wflinks install to 1.03b. I think my original install was one the wf links that came in one of the XOOPS packages a while back.

At any rate, the sort function is not working now with 1.03b. No matter what arrow I click on to sort by date, title, etc. the sort feature does not change the order of the links.

As far as I can tell all other features are working. I have searched the forum and cannot find anyone who has this same issue. Can anyone point me in the right direction.?

I am running XOOPS 2.2.5 rc2 and wflinks 1.03b from McDonald's site.

Click here for a look at the problem

Thanks for the help

2
McDonald
Re: WF Links 1.03b Sort not working
  • 2007/6/1 18:11

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Did you after uploading the files of WF-Links 1.03b to your server also update the module from the Administration panel?

3
fosterm
Re: WF Links 1.03b Sort not working
  • 2007/6/1 18:25

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi McDonald

Thanks for the reply.

I just reupdated the module to make sure. I also dumped the cache folder and temp_c. That did not solve the issue.

Anyo other ideas?

4
McDonald
Re: WF Links 1.03b Sort not working
  • 2007/6/1 19:00

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Just did a quick test on WF-Links 1.03b on a XOOPS 2.2.5 test server.
I added 2 links and rated one of them.
Sorting the 2 links by rating, popularity, title and date worked fine.
So, for the moment I don't have a solution for this.

5
fosterm
Re: WF Links 1.03b Sort not working
  • 2007/6/1 19:08

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Thanks for taking the time to test that.

I will re ftp 1.03b in the hopes that I had a glitch somewhere.

Thanks for the help.

6
fosterm
Re: WF Links 1.03b Sort not working
  • 2007/6/1 21:07

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi again

I completely unistalled and deleted wf-links 1.03b. I then downloaded it again from McDonald's site. Reinstalled it and typed in a couple of test links.

Unfortunately even with a fresh install and new data it still does not sort.

I did notice however that before and after the new install, this (Failed to execute xoops_module_update_wflinks) showed up at the bottom of the page after you hit the install button.

That give anyone a clue?

Thanks for the help.

7
skenow
Re: WF Links 1.03b Sort not working
  • 2007/6/2 2:28

  • skenow

  • Home away from home

  • Posts: 993

  • Since: 2004/11/17


What debug (php and sql) do you have?

8
fosterm
Re: WF Links 1.03b Sort not working
  • 2007/6/2 15:39

  • fosterm

  • Just popping in

  • Posts: 93

  • Since: 2005/8/7 2


Hi Skenow



I am very unfamiliar with troubleshooting at the debug level. I only receive notices (no errors) with php debug on, but with MySQL/Blocks debug turned on, when I try to use one of the sort options, I noticed this error message under the heading of "Queries Module".

Quote:
SELECT * FROM xxxx_wflinks_links WHERE published = 0 ORDER BY dateD
Error number: 1054
Error message: Unknown column 'dateD' in 'order clause'
( 0.000465 )


Is this the kind of debug info you were asking for?

Thanks for the help with this issue.

9
McDonald
Re: WF Links 1.03b Sort not working
  • 2007/6/2 16:37

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


When I switch on MySQL debug I get the same error but the sorting options still work.

What Notices do you get?

What PHP and MySQL version are you using?


You can get rid of the error by opening the file viewcat.php in a texteditor, scroll to the end and remove the following code:

/*
* get moderator items
*/
if ( checkgroups$cid'WFLinkAppPerm' ) )
{
    
$sql2 "SELECT * FROM " $xoopsDB -> prefix'wflinks_links' )
     . 
" WHERE published = 0 "
     
" ORDER BY "
     
$orderby;
    
$result2 $xoopsDB -> query$sql2 );

    
$link = array();
    
$xoopsTpl -> assign'moderate'false );
    if ( 
$result )
    {
        
$xoopsTpl -> assign'moderate'true );
        
$moderate 1;
        while ( 
$link_arr $xoopsDB -> fetchArray$result2 ) )
        {
            include 
XOOPS_ROOT_PATH '/modules/' $xoopsModule -> getVar'dirname' ) . '/include/linkloadinfo.php';
            
$xoopsTpl -> append'mod_arr'$link );
        } 
    } 
}

10
McDonald
Re: WF Links 1.03b Sort not working
  • 2007/6/2 16:41

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Quote:
I am running XOOPS 2.2.5 rc2 ...


Where are you getting XOOPS 2.2.5 rc5 from?
I can only find the rc1 version.

Login

Who's Online

190 user(s) are online (107 user(s) are browsing Support Forums)


Members: 0


Guests: 190


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