XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / "In Use" tables, news,etc dessapear,etc many people had this problems.
Register
1
javier
"In Use" tables, news,etc dessapear,etc many people had this problems.

  • 2004/4/4 12:07

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


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
2
Mithrandir
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

I haven't noticed that. It's the first I hear of such a problem.

We are not just talking about expired stories?

If you cannot edit records in the database from phpMyAdmin, then something is very wrong and not just with XOOPS.
3
meme
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

  • 2004/4/4 13:01

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


i used XOOPS more than 2 years did not get any error like that only one time > ( in use ) with whois online blocks
the database get some error from the server not from XOOPS
so i just changed my host
4
meme
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

  • 2004/4/4 13:12

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


sorry i forget the way to fix the wrong with database

go to your phpmyadmin

run this query

INSERT INTO `xoops_online` VALUES (0, '', 1080302700, 0, '127.0.0.1');

if not work

drop this table

xoops_online

then run this query
CREATE TABLE xoops_online (
online_uid mediumint(8) unsigned NOT NULL default '0',
online_uname varchar(25) NOT NULL default '',
online_updated int(10) unsigned NOT NULL default '0',
online_module smallint(5) unsigned NOT NULL default '0',
online_ip varchar(15) NOT NULL default '',
KEY online_module (online_module)
) TYPE=MyISAM;
5
Mithrandir
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

meme - this relates to news stories how? You lost me
6
meme
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

  • 2004/4/4 14:16

  • meme

  • Quite a regular

  • Posts: 271

  • Since: 2002/12/10


lol
Mithrandir

sorry heheheh
7
javier
Re: "In Use" tables, news,etc dessapear,etc many people had this problems.

  • 2004/4/4 23:44

  • javier

  • Not too shy to talk

  • Posts: 184

  • Since: 2002/8/6 1


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.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

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

Members: 0

Guests: 175

more...

Donat-O-Meter

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

Latest GitHub Commits