RSS LJ

June 8, 2003

All is now good in the world ()

by fluffy at 3:30 AM
That was a fucking pain in the ass. But the forum is recovered to its former glory.

phpBB needs a better upgrade mechanism. One which doesn't require the admin to take a crash-course in SQL to learn how to fix the horribly-broken tables.

(If you already had an account, it should still work just fine, though you may need to clear your cookies to get in. Also, all avatar images got deleted.)

Update: Except for that little problem of not being able to post anything. God damnit. The upshot: I know enough SQL to be dangerous now.

Comments

#MT514 June 8, 2003 5:34 AM

>The upshot: I know SQL now.

I hope so. ;)
I just received the following error:

-----

Error in posting

DEBUG MODE

SQL Error : -1 ERROR: pg_aclcheck: class "phpbb_topics_id_seq" not found

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Re; Fixed forums', 30, 1055069564, 7, 0, 0, 0)

Line : 257
File : /home1/magenta/trikuare.cx/html/forum/includes/functions_post.php

#MT515 Obsidious June 8, 2003 5:35 AM

Oops, I forgot to fill in my name. That last post was from me. =)

#MT516 Neo June 8, 2003 9:56 AM

Whoa.... I know SQL...

#MT517 Morpheus June 8, 2003 10:25 AM

Show me.

#MT518 Neo June 8, 2003 10:41 AM

"SELECT * FROM maintable;"
"UPDATE maintable SET count=0 WHERE name='Morpheus';"

*poses impressively in white gi*

#MT519 fluffy June 8, 2003 10:52 AM

Shit shit shit shit shit.

This'll be a while longer yet, I think.