1
JamesSAEP
clone article .99 module issue
  • 2006/12/14 15:47

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Apache 2.2
MySQL/PHP 5
XOOPS 2.0.16
Article .99

I have cloned the Article module and installed it successfully. All the features seem to work ok, but when I go to view my XOOPS profile where it lists the latest posts in each section, I get the following error and the cloned section doesn't appear:
You have an error in your SQL syntaxCheck the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ac.ac_publish > 0 AND a.uid=2 ORDER BY a.art_id DESC LIM

The debug info is (magazine is the cloned module):
WarningInvalid argument supplied for foreach() in file /modules/magazine/include/functions.parse.php(100) : eval()'d code line 56

Did I miss something?

2
blindman
Re: clone article .99 module issue
  • 2006/12/15 9:54

  • blindman

  • Not too shy to talk

  • Posts: 119

  • Since: 2005/6/26


I try to use clones of phppp article module.
The original module works fine, I've clonned some modules and installed it. Install procces was OK, articles, categories, topics management is OK, but writer management does not work properly.

My issue is:
I have some article-0.99 clonned module, clone1, clone2, clone3 for say. Seems to manage right articles, categories and topics but when I try to add a writer in clone1, and click the link that open popup selection page (for writer/author), I see the writers from clone3 writer table, and some wrong text constants. I think the page pick the wrong query (because of writers) wrong folder (because of text constants).
I notticed that the last one works fine, last installed. If I uninstall the last one, the second one start to work fine, and the first one still doesn't work.

I use XOOPS 2.2.4, article 0.99, and the last frameworks files (I don't remmember it's number)

JamesSAEP, in your case the error message may come because you search in all module tables, writer table inclusive. And that writer table is empty. I have added with phpmyadmin a writer for cloned module and the error SQL message is gone.
Don't follow me. I'm lost too.

3
JamesSAEP
Re: clone article .99 module issue
  • 2006/12/15 16:09

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Quote:

blindman wrote:
JamesSAEP, in your case the error message may come because you search in all module tables, writer table inclusive. And that writer table is empty. I have added with phpmyadmin a writer for cloned module and the error SQL message is gone.


I had added an entry into the cloned writer table, but still have message.

4
JamesSAEP
Re: clone article .99 module issue
  • 2006/12/27 20:37

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Bump

Still haven't been able to solve this one.

5
phppp
Re: clone article .99 module issue
  • 2006/12/27 21:10

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


How did you make the clone?
describe the steps you have followed

6
JamesSAEP
Re: clone article .99 module issue
  • 2006/12/27 21:17

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Step 1: copied the "article" folder to "clubs"

Step 2:
In the vars.php file, I set $GLOBALS["ART_DB_PREFIX"] = "clubs";

Step 3:
edit /sql/mysql.sql, changed all table prefix to the specified value "clubs". For example, change "CREATE TABLE clubs_article"

Step 4:
change all template name prefix to clubs, including all templates in /templates/ and /templates/blocks/.

Step 5:
Installed module

7
phppp
Re: clone article .99 module issue
  • 2006/12/27 21:27

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


The reason I can imagine is that you haven't set the category permissions correctly.

Solutions:
1 Set at least one category accessible to your group, OR
2 replace /include/search.inc.php with the one in SVN
search.inc.php

8
JamesSAEP
Re: clone article .99 module issue
  • 2006/12/27 21:30

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Permissions are set correctly - I have several articles w/ the categories. I'll try the file and post back the results.

9
JamesSAEP
Re: clone article .99 module issue
  • 2006/12/27 21:35

  • JamesSAEP

  • Just can't stay away

  • Posts: 732

  • Since: 2005/2/28


Ok, the search.inc.php file was the solution. Thanks.

Login

Who's Online

154 user(s) are online (109 user(s) are browsing Support Forums)


Members: 0


Guests: 154


more...

Donat-O-Meter

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

Latest GitHub Commits