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.  / Forum error
Register
21
Dave_L
Re: Forum error

  • 2004/6/5 0:29

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Relevant MySQL queries:
CHECK TABLE xoops_priv_msgs
REPAIR TABLE xoops_priv_msgs


Use phpMyAdmin or an equivalent method to perform these operations.

While you're at it, check all the other tables too.
22
Guido83
Re: Forum error

  • 2004/6/5 1:25

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Alright, I figured out what the phpMyAdmin thing is and looked at the xoops_priv_msgs. When I go to operations it says:

----------------------------------------
Can't open file: 'xoops_priv_msgs.MYD'. (errno: 145)


Notice: Undefined variable: error_url in /var/www/html/phpMyAdmin-2.3.2/tbl_properties_operations.php on line 41

Error

SQL-query :

SHOW COLUMNS FROM `xoops_priv_msgs` FROM `bondsscheidsrechter_nl_-_xoops`

MySQL said:


Can't open file: 'xoops_priv_msgs.MYD'. (errno: 145)
----------------------------------------

So where do I check or change anything?
23
ajaxbr
Re: Forum error

  • 2004/6/5 5:25

  • ajaxbr

  • Quite a regular

  • Posts: 276

  • Since: 2003/10/25


Ouch! Check this page at MySQL.com, then call your tech support. It's some sort of MYsqlData file corruption
24
Dave_L
Re: Forum error

  • 2004/6/5 13:39

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Guido:

Error 145 usually means the table needs to be repaired.

With phpMyAdmin, it's easy to check and repair tables. From the page that lists all the tables, select the checkbox for the xoops_priv_msgs table on the left, and then in the menu at the bottom, select "With selected: Check table", and then "With selected: Repair table".

Does that help?

You might as well check all the tables while you're there. You may want to do the Analyze and Optimize operations too.
25
Guido83
Re: Forum error

  • 2004/6/5 14:09

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


HELP!!!!!!!!!
I have done absolutely nothing since yesterday evening and now the whole site is messed up..............
http://www.bondsscheidsrechter.nl/
Please guys, what now???
26
sikey
Re: Forum error

  • 2004/6/5 15:27

  • sikey

  • Not too shy to talk

  • Posts: 151

  • Since: 2003/4/29


do you have phpmyadmin installed? if so, have a look for database entries that are buse and repair those tables
27
Stewdio
Re: Forum error

  • 2004/6/5 15:39

  • Stewdio

  • Community Support Member

  • Posts: 1560

  • Since: 2003/5/7 1


Quote:

Guido83 wrote:
HELP!!!!!!!!!
I have done absolutely nothing since yesterday evening and now the whole site is messed up..............
http://www.bondsscheidsrechter.nl/
Please guys, what now???


Just posting some info for others to ponder over, I"m not sure how to fix it myself, except to restroe the db from backup.

The error I saw is:

Fatal error: Call to a member function on a non-object in /home/virtual/site55/fst/var/www/html/kernel/configitem.php on line 286

Heres the code it's refering to in configitem.php:
$sql = 'SELECT * FROM '.$this->db->prefix('config');
28
Guido83
Re: Forum error

  • 2004/6/6 14:13

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Spoke my host on the phone yesterday. He told me that the tables were all messed up and that he had tried to restore a backup from the day before yesterday, but it didn't work. He suggests that I re-install the whole XOOPS system and he will try to restore the backup after that. Is this a good idea?
29
phppp
Re: Forum error

  • 2004/6/6 15:18

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


install XOOPS in a subsite.
once the backup finished, change the subsite to your main site xoops
30
Guido83
Re: Forum error

  • 2004/6/8 13:05

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


My website is back online now, working fine, except for one last thing:
The WFsection data is gone. Well not realy gone because in the 'Manage articles' area I can see all of them. But the categories are gone so the site can't show the articles. Is there any way to restore the categories from my backup?
Thanks again for all your help, guys!
« 1 2 (3)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

162 user(s) are online (104 user(s) are browsing Support Forums)

Members: 0

Guests: 162

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