Arrgh... errors

[mediman]

hmm, the prob is the board=1 all others work perfect

try

http://24.128.153.169/yabbse/index.php?board=3 or any other board!

you have to check the board "General Discussion" this is the problem!

[CD999]

I wouldn't mind deleting General Discussions in Admin and start again. Problem is, it wont let me.

trying to delete it from the board setup gets me this error.

Code Select Expand

2: MySQL: Unable to save result set
(c:\program files\apache group\apache\home\yabbse\Sources\ManageBoards.php ln 206)and refuses to delete.

[mediman]

try to delete it in db directly! and then go to admin center and "repair boards and posts"!

medi

[CD999]

thanks for all the help, I have it working, although I had to delete GD. Do you have any idea what may have caused this?

[CD999]

Sorry, spoke a little too soon.
The message page works, but when i click REPAIR BOARDS AND TOPICS i get this

Listing of board errors
The following errors are fouling up your board (blank if none):
An Error Has Occurred!

2: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
(c:\program files\apache group\apache\home\yabbse\Sources\RepairBoards.php ln 71)
 
and on the message page, just below the recent post header it says

An Error Has Occurred!

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
(c:\program files\apache group\apache\home\yabbse\Sources\Recent.php ln 149)
 


 

[mediman]

i have to thank you , each bug reported will help us to make yabbse better!

the table was corrupt!

if you will a answer i need more infos like

what php version
what mysql version
what mods or hacks have you installed!

thx you

[CD999]

php version: 4.2.0
Mysql Version: Was 4.0.1 but I downgraded to 3.23.51 after the error. Seemed to increase the speed.

Still has the errors listed above but at least people can post at this point.

[mediman]

Sorry, spoke a little too soon.
The message page works, but when i click REPAIR BOARDS AND TOPICS i get this

Listing of board errors
The following errors are fouling up your board (blank if none):
An Error Has Occurred!

2: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
(c:\program files\apache group\apache\home\yabbse\Sources\RepairBoards.php ln 71)

and on the message page, just below the recent post header it says

An Error Has Occurred!

2: mysql_num_rows(): supplied argument is not a valid MySQL result resource
(c:\program files\apache group\apache\home\yabbse\Sources\Recent.php ln 149)

not really a bug! you have deleted the categorie but have you also deleted all messages related with this board 1?

mediman

[CD999]

Forgot to. I am missing the most obvious things here.

[CD999]

I don't see a table to tell what board a post was on in phpmyadmin, and General Discussions had a lot of posts. Is there a quick way to tell?

[mediman]

you can make a script! you have first to check what topic numbers are involved and then you have to delete all messages with this topic_id!

let me explain! go to table "yabbse_topics", there you will find all topics related to board =1 ( delete in this table all topics with id_board = 1!

then go to table "yabbse_messages" and delete all messages with the topic id you found out before!

medi

if you feel not to paranoid, you can give me db access and i try to repair your board!

[CD999]

Problem here is i don't know anything about PHP, MySQL or scripting.

[mediman]

if you can wait, then i write you that script!
if you need a fast help, then i need db access!

mediman

[CD999]

Alright.

[mediman]

so i have tried to fix your prob! can you test it!

tell me if you need the script to delete the old messages!

mediman