Welcome, Guest. Please Login or Register.
October 03, 2024, 05:21:00 PM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  English Help  |  What's happened ? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: What's happened ?  (Read 237 times)
zaquic
Noobie
*
Posts: 32


I'm a llama!

What's happened ?
« on: March 16, 2003, 10:15:10 AM »
Reply with quote

I got the error message:

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
(C:\yabbse\Sources\MessageIndex.php ln 123)

What's happened ?

How to kick it out ?
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:What's happened ?
« Reply #1 on: March 16, 2003, 10:43:32 AM »
Reply with quote

Try REPAIRing all your tables in phpMyAdmin.

REPAIR TABLE yabbse_log_topics;
REPAIR TABLE yabbse_topics;
REPAIR TABLE yabbse_log_boards;
REPAIR TABLE yabbse_boards;
REPAIR TABLE yabbse_messages;

And so forth... (those alone might fix it...)

You might also try upgrading to 1.5.1.

-[Unknown]
Logged
zaquic
Noobie
*
Posts: 32


I'm a llama!

Re:What's happened ?
« Reply #2 on: March 16, 2003, 11:08:39 AM »
Reply with quote

I have tried like you said, but it still appear the same message.

Few days ago, I tried to upgrade to 1.5.1, but it become out of my control. So I try to restore the state 1.4.1, it now appear the message I mentioned above.

The prcedure I restore the system is:
delete /mysql/data/yabbse
delete all YaBBSE files
reinstall 1.4.1
update the template.php and Setting.php
copy the forum data into /mysql/data

It look good in phpMyAdmin, but when I get in the Forum page, try to login or click the topic, the message appear.

I need help.
Logged
zaquic
Noobie
*
Posts: 32


I'm a llama!

Re:What's happened ?
« Reply #3 on: March 16, 2003, 11:45:55 AM »
Reply with quote

It's my fault about restoring 1.4.1

The mysql data I restored is the newly structure(table) modified by UPGRADE.php, it can't use in 1.4.1.

I have restored the right structure version, and now it work nice like before. I will try to upgrade to 1.5.1 some day.

For my fault(bother you), I beg your pardon.
Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  What's happened ? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.066 seconds with 21 queries.