1
gerasimos
Posts_text table (in use) after mov or delete posts
  • 2006/10/30 7:30

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


Hello everybody, i face problem which i found a temporary solution but my problem is still there.

Any time i try to move or delete (specific posts) - i mean that is not happening to every post!! - the posts_text table crashed and i can access my forum only after repairing ot thru PHPmy admin.

The problem is that i cant get rid those posts because always the table crashed..

any ideas how i can override this?
Do you know what can cause it?
The only thing that i did , it was that i delete some users...

Xoops 2.0.13.2
Newbb 1.16


*Sorry for my bad English

2
Will_H
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 14:04

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


upgrade to cbb

3
gerasimos
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 14:33

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


ok my mistake, i have already the CBB 1.16 version (updated from newbb) i wrote newbb from the folder name.

any ideas?

4
Will_H
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 15:12

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


Well to start you are using a version of XOOPS that is over a year old. Have you considered upgrading to 2.0.15?

Latest XOOPS

Latest cbb

5
gerasimos
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 17:29

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


Quote:

Biteronboard wrote:
Well to start you are using a version of XOOPS that is over a year old. Have you considered upgrading to 2.0.15?

Latest XOOPS

Latest cbb


It is not very easy for me to change versions cause i made a lot of hardcore changes in order to suite my site needs and members. I was thinking in the past and i tried once with bad results :(.

6
Will_H
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 17:51

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


That is unfortuneate. It is going to become increasingly more and more difficult for you to get support as time goes on.

The really sad part in all this, is that because you have apparently modified your core. There is no reall way for us to guess at the problem.

Essentially you dug yourself into a whole. My suggestion would be to set up a fresh installation of 2.0.15 and move everything over piece by piece.

BOL

7
gerasimos
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 17:59

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


Quote:

Biteronboard wrote:
That is unfortuneate. It is going to become increasingly more and more difficult for you to get support as time goes on.

The really sad part in all this, is that because you have apparently modified your core. There is no reall way for us to guess at the problem.

Essentially you dug yourself into a whole. My suggestion would be to set up a fresh installation of 2.0.15 and move everything over piece by piece.

BOL


You have absolute right (and it was and my first project with XOOPS so there are many errors in there )
Can u tell me if i make a new installation XOOPS 2.0.15/cbb, and have the full backup of my XOOPS 2.0.13.xx it is possible to update all my data (Forum, articles, etc) ???

i dont need any update package (especially for forum data?)

Thank you very much for your help

8
Will_H
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 18:15

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


Iam almost certain that the sql structure has changed drastically.

Essentially you would need to disect your tables and manually add the data into your new empty tables.

Alot of work, but as far as II know you do not have many options.

9
Will_H
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 18:17

  • Will_H

  • Friend of XOOPS

  • Posts: 1786

  • Since: 2004/10/10


There have been upgrade scripts, but again I have no idea what modifications you have made to the database

10
gerasimos
Re: Posts_text table (in use) after mov or delete posts
  • 2006/10/30 18:23

  • gerasimos

  • Not too shy to talk

  • Posts: 114

  • Since: 2005/4/28


ok my friend
Thank you very much i try my best

thanks again

Login

Who's Online

212 user(s) are online (135 user(s) are browsing Support Forums)


Members: 0


Guests: 212


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