This new version works fine for me now
the error about "no news items" is not here now

grettings

Thanks for reply,
many people had similar errors, i found some ones searching in this forum with "in use" words.
---

i get these errors runing in local mode in my own computer, i use phpdev5 beta3, that´s the more strange,

i will upload all the site content to the internet server and check what happen there.

grettings.

I noticed alot of people has problems with the news module, the headlines modules and the forum module,

after certain time the news storys, or the headlines, or the newbb post simply dissapear,
when you go with phpmyadmin you found the tables "in use"
what´s happening with XOOPS about these problems,
why these things happen?

--------------------------
in my particular experience, i get these problem with the news module,
my news dessapear after some time, (and i not talking about days or weeks)
and i have to overwrite the storys tables with my backup ones.
other thing i noticed is i can´t edit the news storys,
i tried from XOOPS admin panel, and no results,
i tried from phpadmin too and no results too.

i just finished a new XOOPS site, and i can´t put online dued to these issues

grettings

As Xantius, i fixed the first issue with meme´s code,
i have the no news story problem too using XOOPS 2.0.6 (i not have wfsection installed)

grettings


this is a MySQL debug:

SELECT item, auto, image, auto_image, imagealign FROM xoops_spotlight WHERE sid = 1 LIMIT 0, 1
Error number: 1054
Error message: Unknown column 'imagealign' in 'field list'

SELECT storyid, uid, title, hometext, topicdisplay, topicalign, comments, bodytext, nohtml, nosmiley FROM xoops_stories WHERE storyid= LIMIT 0, 1
Error number: 1064
Error message: You have an error in your SQL syntax near 'LIMIT 0, 1' at line 1

SELECT uname, uid FROM xoops_users WHERE uid= LIMIT 0, 1
Error number: 1064
Error message: You have an error in your SQL syntax near 'LIMIT 0, 1' at line 1

SELECT storyid, hometext, bodytext, title, published, expired, counter, nohtml, nosmiley FROM xoops_stories WHERE published < 1081083004 AND published > 0 AND (expired = 0 OR expired > 1081083004) AND storyid != ORDER BY published DESC LIMIT 0, 5
Error number: 1064
Error message: You have an error in your SQL syntax near 'ORDER BY published DESC LIMIT 0, 5' at line 1

phpdebug:
Warning [PHP]: Invalid argument supplied for foreach() in file c:\phpdev5\www\3dmax\include\common.php line 99

(always put that , is not spotlight module related)


other problem i noticed is the admin panel not save the news block configuration options.

thanks Predator and Dave_L

I making a site for a resolution of 800x600 with both columns actived, the submit new topic form, more specificaly the field "message" is too wide for the site and i need reduce his width,

i modified other forms in other modules with width problems too,
but in newbb i can´t find where the width of the message field are specificaly.

i suuposed in newbb/include/forumform.inc.php

but i found only the title, that´s not a problem ,is under my eyes



but in the message field i only found
xoopsCodeTarea("message");

anybody can point me in the right direction plz?
thanks in advance.
grettings

now all works fine :) :)

i was made only the latest files blocks, now i added the top files ones and update the module.
the problem dissapear.

Thanks ALOT for your help Mithrandir i will not forget about,

grettings

i get 2 errors

mysql debug block1

SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN (9,Array) ORDER BY date DESC LIMIT 0, 10
Error number: 1054
Error message: Unknown column 'Array' in 'where clause'

mysql debug block2

SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN (9,Array) ORDER BY date DESC LIMIT 0, 10
Error number: 1054
Error message: Unknown column 'Array' in 'where clause'

No matter what number i put in $sel_category= in block2,
it always take the number of the other file (9)

code:

mysql debug:

SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE cid IN () ORDER BY date DESC LIMIT 0, 10
Error number: 1064
Error message: You have an error in your SQL syntax near ') ORDER BY date DESC LIMIT 0, 10' at line 1

code:

Now work fine :):)

what happen when i wan put more than 1 block? sorry for not ask before.
My idea is have 3 or 4 blocks showing the latest files from each category,
when i tried to put a second block i get the following msg:

Fatal error: Cannot redeclare class xoopstree in c:\phpdev5\www\site\class\xoopstree.php on line 33

grettings