LinkBack URL
About LinkBacks
Reply With Quoteicedawg, or the phpbb programmers, have made an typo in the "SQL", which is basically the name given to when you change something in the database. The forum runs on MySQL (a very good, free database software).
+ Reply to Thread
Results 1 to 5 of 5
Thread: Mark Topics Read
- 11-28-2004 10:43 PM #1Member
- Join Date
- Jan 2004
- Location
- The Matrix... Wishes to: Free DV ....... Bears the truth: What do you think?
- Posts
- 3,345
- Likes
- 0
Mark Topics Read
Hey, I just tried to access the mark all topics read tab in the dream guide newb welcoming forum and it gave me the following error several times:
Just in case that means anything to you guys...DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND forum_id = 22 AND topic_moved_id = 0' at line
SELECT topic_id FROM phpbb_topics WHERE topic_id IN () AND forum_id = 22 AND topic_moved_id = 0
[/b]
If I hadn't made me
I'd be more inclined to bow
Powers that be would have swallowed me up
But that's more than I can allow...
- 11-29-2004 01:52 AM #2Member
- Join Date
- Dec 2003
- Gender
- Location
- England
- Posts
- 5,449
- Likes
- 8
- 11-29-2004 09:57 AM #3Member
- Join Date
- Jun 2003
- Gender
- Location
- right here
- Posts
- 2,827
- Likes
- 15
the code associated with marking topics read isn't custom; it has been modified by the keep-topics-marked-unread mod though.
regardless, i'd say that's a fluke because i just tried it and it works. in your case the parentheses '()' should have had a list of topic ids to mark as read (from a previous SQL query) but for whatever reason they did not. anyway that message shouldn't occur again because i adjusted it so it ensures the list isn't empty first.Each new day is a chance to turn it all around.
- 11-29-2004 11:48 AM #4Member
- Join Date
- Dec 2003
- Gender
- Location
- England
- Posts
- 5,449
- Likes
- 8
he means that it was a fluke.
- 12-01-2004 04:32 AM #5Member
- Join Date
- Jan 2004
- Location
- The Matrix... Wishes to: Free DV ....... Bears the truth: What do you think?
- Posts
- 3,345
- Likes
- 0
I see....thanks
If I hadn't made me
I'd be more inclined to bow
Powers that be would have swallowed me up
But that's more than I can allow...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Bookmarks