1
samtaikido
my huge queries
  • 2006/6/7 10:21

  • samtaikido

  • Just popping in

  • Posts: 3

  • Since: 2006/6/7 1


ok ...your all gonna have to bere with me on this one ..but im a total newb on XOOPS ...here is my huge amount of problems ..as i only debugged because i couldnt publish on my homepage ....my "news" articles publish but are not seen on the main page ...i havnt really changed anything ..expect some colours in the style.css file

any help would be much appreiated ..or is it time for a new db ??

[code]SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '13e0b1e294780b6c8c1cf93bc68b5766'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_config WHERE conf_id=1
SELECT * FROM xoops_smiles
SELECT * FROM xoops_config WHERE conf_id=2
SELECT * FROM xoops_config WHERE conf_id=30
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'adminmail', conf_title = '_MD_AM_ADMINML', conf_value = 'sam.howlett@blueyonder.co.uk', conf_desc = '_MD_AM_ADMINMLDSC', conf_formtype = 'textbox', conf_valuetype = 'text', conf_order = 3 WHERE conf_id = 30
SELECT * FROM xoops_config WHERE conf_id=3
SELECT * FROM xoops_config WHERE conf_id=4
SELECT * FROM xoops_config WHERE conf_id=5
SELECT * FROM xoops_config WHERE conf_id=6
SELECT * FROM xoops_config WHERE conf_id=7
SELECT * FROM xoops_config WHERE conf_id=57
SELECT * FROM xoops_config WHERE conf_id=72
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'theme_set_allowed', conf_title = '_MD_AM_THEMEOK', conf_value = 'a:1:{i:0;s:12:"artnomad_eng";}', conf_desc = '_MD_AM_THEMEOKDSC', conf_formtype = 'theme_multi', conf_valuetype = 'array', conf_order = 13 WHERE conf_id = 72
SELECT * FROM xoops_config WHERE conf_id=63
SELECT * FROM xoops_config WHERE conf_id=8
SELECT * FROM xoops_config WHERE conf_id=9
SELECT * FROM xoops_config WHERE conf_id=10
SELECT * FROM xoops_config WHERE conf_id=53
SELECT * FROM xoops_config WHERE conf_id=16
SELECT * FROM xoops_config WHERE conf_id=11
SELECT * FROM xoops_config WHERE conf_id=13
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'debug_mode', conf_title = '_MD_AM_DEBUGMODE', conf_value = '0', conf_desc = '_MD_AM_DEBUGMODEDSC', conf_formtype = 'select', conf_valuetype = 'int', conf_order = 24 WHERE conf_id = 13
SELECT * FROM xoops_config WHERE conf_id=12
SELECT * FROM xoops_config WHERE conf_id=58
SELECT * FROM xoops_config WHERE conf_id=59
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'closesite_okgrp', conf_title = '_MD_AM_CLOSESITEOK', conf_value = 'a:1:{i:0;s:1:"1";}', conf_desc = '_MD_AM_CLOSESITEOKDSC', conf_formtype = 'group_multi', conf_valuetype = 'array', conf_order = 27 WHERE conf_id = 59
SELECT * FROM xoops_config WHERE conf_id=60
SELECT * FROM xoops_config WHERE conf_id=14
SELECT * FROM xoops_config WHERE conf_id=15
SELECT * FROM xoops_config WHERE conf_id=61
SELECT * FROM xoops_config WHERE conf_id=71
SELECT * FROM xoops_config WHERE conf_id=32
SELECT * FROM xoops_config WHERE conf_id=33
SELECT * FROM xoops_config WHERE conf_id=47
SELECT * FROM xoops_config WHERE conf_id=37
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'bad_ips', conf_title = '_MD_AM_BADIPS', conf_value = 'a:1:{i:0;s:9:"127.0.0.1";}', conf_desc = '_MD_AM_BADIPSDSC', conf_formtype = 'textarea', conf_valuetype = 'array', conf_order = 42 WHERE conf_id = 37
SELECT * FROM xoops_config WHERE conf_id=62
UPDATE xoops_config SET conf_modid = 0, conf_catid = 1, conf_name = 'module_cache', conf_title = '_MD_AM_MODCACHE', conf_value = 'a:5:{i:2;s:1:"0";i:5;s:1:"0";i:8;s:1:"0";i:9;s:1:"0";i:14;s:1:"0";}', conf_desc = '_MD_AM_MODCACHEDSC', conf_formtype = 'module_cache', conf_valuetype = 'array', conf_order = 50 WHERE conf_id = 62[code/]
does all that jargon mean my site is trashed ???

2
rabideau
Re: my huge queries
  • 2006/6/7 12:54

  • rabideau

  • Home away from home

  • Posts: 1042

  • Since: 2003/4/25


Aside from a db dump, what problems are you actually having? Can we see any of them?
Pax vobiscum,
...mark

may the road rise to meet your feet!

http://treemagic.org

3
samtaikido
Re: my huge queries
  • 2006/6/7 14:10

  • samtaikido

  • Just popping in

  • Posts: 3

  • Since: 2006/6/7 1


see thats just how skilled i am !! ...i didnt realise that was a db dump ...and i got all that from the debug in the prefrences section in the admin .....ok ok my problem is i cant seem to publish anything on the main page ....could you (or anyone) be kind enough to tell me how i can find out why it isnt publishing !! once i know how ill post it up ......

apologies for my "idiot"

Sam

4
rabideau
Re: my huge queries
  • 2006/6/7 15:28

  • rabideau

  • Home away from home

  • Posts: 1042

  • Since: 2003/4/25


Sam,

Have you read any of the XOOPS documentation?

You might start with: https://xoops.org/modules/smartfaq/

Also read: http://xoopsdocs.net/modules/docs/
Pax vobiscum,
...mark

may the road rise to meet your feet!

http://treemagic.org

5
stefan88
Re: my huge queries
  • 2006/6/7 15:40

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


To have news on your start page you can:

- use news module as your start module. To do this go to admin -> preferences -> general and at "Module for your start page" select news. (personaly I do not like this option, but some sites use it)

OR

- use blocks to make news visible on start page. Go to admin -> blocks and select the blocks you want to be visible, position and ordering. To make them visible for anonymous users (guests) you need also to go in admin -> groups -> Anonymous and give this groupe access to this blocks. With news module you have top news, news topics and so on. You can also use spotlight module to display news to be more flexible.

..

6
samtaikido
Re: my huge queries
  • 2006/6/8 0:27

  • samtaikido

  • Just popping in

  • Posts: 3

  • Since: 2006/6/7 1


Thanks everyone !! your help is much appreiated
i was (and still am) using blocks on the main page so i guess theres no reason why i cant continue using them.
im gonna continue trying my best to get my head around things along with the advice you have given me instead of bugging everyone with 20 questions

many thanks

Login

Who's Online

175 user(s) are online (114 user(s) are browsing Support Forums)


Members: 0


Guests: 175


more...

Donat-O-Meter

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

Latest GitHub Commits