Page 1 of 1
VOTE ON THE BOARD FIX!!! HURRY BEFORE THEY ARE ALL GONE!!
Posted: Thu Mar 24, 2005 9:04 am
by BD
Make yer pick
Posted: Thu Mar 24, 2005 10:21 am
by KrAzYdAvE
I'm cool with starting over, is there any way to get the content of a thread though?
I kinda need the content for that LAN party thread, whoever posted isn't important, just need content. If it's too big of a deal, don't worry about it.
Posted: Thu Mar 24, 2005 11:05 am
by Akira
I can get the cLAN topic to display content, as soon as I know what SQL query/command to run to update poster_id to be mine or your's for that matter. I don't know alot about MySQL.
What I need to do, is update poster_id that equals -1, in topic_id that equals 1161 to update poster_id to be 3
As for all other posts, I can go through and just delete them all instead of attempting recovery. Just one big mess to try to regain them all. If cLAN one is needed, at least that should be straight forward.
Posted: Thu Mar 24, 2005 12:24 pm
by Serpent
Akira wrote:I can get the cLAN topic to display content, as soon as I know what SQL query/command to run to update poster_id to be mine or your's for that matter. I don't know alot about MySQL.
What I need to do, is update poster_id that equals -1, in topic_id that equals 1161 to update poster_id to be 3
As for all other posts, I can go through and just delete them all instead of attempting recovery. Just one big mess to try to regain them all. If cLAN one is needed, at least that should be straight forward.
update <tablename> set <this> = <that> where <this> = <that>
http://dev.mysql.com/doc/mysql/en/update.html
Posted: Thu Mar 24, 2005 12:31 pm
by Akira
Makes sense, but I still can't figure out how to be explicit for the particular topic_id
Ugh. Sorry, I'm just not very good with this sort of stuff. Setting up MySQL is one thing, modifying tables/data is just not me.
Posted: Thu Mar 24, 2005 4:12 pm
by Baron[CotC]
Ive never seen the table so this is just a guess but its similar to this:
update <tablename> set poster_id = KD where topic_id = cLanParty
Posted: Thu Mar 24, 2005 4:21 pm
by Akira
I tried my grand idea, and no go. Gonna probably have to delete things. But can't do so via phpBB, only in MySQL, and as that is, hard to really tell what's what.
Posted: Thu Mar 24, 2005 4:21 pm
by Serpent
Red has got it... and if you are still having problems maybe I can help... (I (UNFORTUNATELY) have setup mysql and had to restore massive tables inside of databases, etc... restoral, backup, table maintenance, replication, etc... the works. heh... I personally hate MySQL, but have a lot of experience.
)
Posted: Thu Mar 24, 2005 4:34 pm
by Akira
See, my lack of knowledge with MySQL doesn't help, but I think what is worse is that I don't know where/what to repair in the database!
I don't know what causes the board to not display message content, but continues to display the original poster and subject. If you were to figure out that, I can give you access to do so.
Posted: Thu Mar 24, 2005 7:50 pm
by Greg Boyington
i have only posted like 4 times so nothing important to me
Posted: Thu Mar 24, 2005 8:23 pm
by Serpent
Akira wrote:See, my lack of knowledge with MySQL doesn't help, but I think what is worse is that I don't know where/what to repair in the database!
I don't know what causes the board to not display message content, but continues to display the original poster and subject. If you were to figure out that, I can give you access to do so.
I'll download it and uncompress it on my computer here and then go through the code... I'll look over the source.. shouldnt be too hard to find the tables related to the boards.... and then just see how they all interact together... I'll get back to you on this...
(unless you are going to just drop the tables or delete the rows from them anyway...)