DZComposer Posted March 25, 2006 Share Posted March 25, 2006 Please report all bugs or problems with the forums here.Please follow these guidelins for submitting bug reports:1. Please check this thread to see if your bug has already been reported.2. Please describe the problem exactly, including the complete text of any error message.3. Please give the page(s) involved. If it is a 404 (file not found), please tell where the link you clicked was.4. Please tell what you're trying to do and exactly what you were doing. What browser are your using? What OS? I need to be able to reproduce the problem in order to fix it. Link to comment Share on other sites More sharing options...
Ludvig11 Posted March 25, 2006 Share Posted March 25, 2006 General StarFox: StarFox Vending Machine 2 something seems to be missing there to. Link to comment Share on other sites More sharing options...
ArwingMaster Posted March 26, 2006 Share Posted March 26, 2006 Off-Topic: Funny Pictures (56K WARNING) Not really a popular topic, but I still thought you would like to know Link to comment Share on other sites More sharing options...
Ludvig11 Posted March 26, 2006 Share Posted March 26, 2006 Off Topic Sticky: Avatar/Singnature change Seems to be Error(s) in this aswell.. Link to comment Share on other sites More sharing options...
brotheroffalco Posted April 6, 2006 Share Posted April 6, 2006 missing the last page of Starfox RP in the role playing section Link to comment Share on other sites More sharing options...
Mr. Krystal Posted April 6, 2006 Share Posted April 6, 2006 Suddenly, the Mega Krystal Fanart page is fixed. Did you do something DZComposer? Link to comment Share on other sites More sharing options...
Orbital Fox Posted April 6, 2006 Share Posted April 6, 2006 I saw that... odd. Link to comment Share on other sites More sharing options...
Mr. Krystal Posted April 6, 2006 Share Posted April 6, 2006 It's not fixed after all. It just means that the difference in posts and perceived posts is about 10. Link to comment Share on other sites More sharing options...
Mr. Krystal Posted April 13, 2006 Share Posted April 13, 2006 Quotes apparently don't work sometimes, look at one of my recent posts: http://forum.starfox-online.net/viewtopic.php?p=46273#46273 Link to comment Share on other sites More sharing options...
Dark Fox Posted April 13, 2006 Share Posted April 13, 2006 "the post you post/page you requested does not contain data".... *dies* Link to comment Share on other sites More sharing options...
DZComposer Posted April 13, 2006 Author Share Posted April 13, 2006 EDIT: *fixed* You'll have to go back and hit "edit" on all of your affected posts as this fix doesn't scan the database. 2.0.20 turned out to be a buggy release. There may be a problem with the PMs as well, but I don't feel like plodding around in any more php files and I haven't gotten a complaint yet. Link to comment Share on other sites More sharing options...
Dark Fox Posted April 17, 2006 Share Posted April 17, 2006 EDIT: *fixed* You'll have to go back and hit "edit" on all of your affected posts as this fix doesn't scan the database. 2.0.20 turned out to be a buggy release. There may be a problem with the PMs as well, but I don't feel like plodding around in any more php files and I haven't gotten a complaint yet. haven't had a prb with PM's yet, I will donload that version and see what else may be wrong with it, but I think the worst is over...... Link to comment Share on other sites More sharing options...
DZComposer Posted April 20, 2006 Author Share Posted April 20, 2006 I found out the exact number of missing posts. We are missing a total of 208 posts. There are 27641 entries (at the time of this post, of course, and not counting this post) in the phpbb_posts table. There are 27433 (at the time of this post, of course, and not counting this post) in the phpbb_posts_text table. Here's the basics of how these tables work: When you post, 2 entries are made into the database. One goes into phpbb_posts, the other goes into phpbb_posts_text. phpbb_posts contains all the information about the posts, such as when it was posted, who posted it, the IP address of the user, whether or not the sig was included, etc. phpbb_posts_text contains the actual post itself. For instance, the text you're reading right now is stored here. Also, the subject is stored here. These tables are linked. If there is an entry in phpbb_posts but not in phpbb_posts_text, you get this "missing posts" phenomenon. I'm not sure why it is done this way, but it is. I am searching for a way to go though these tables and delete all records in phpbb_posts that do not have a record in phpbb_posts_text that does not involve me reading each of these tables which are more that 20 000 lines a piece. :nervous: Link to comment Share on other sites More sharing options...
Dark Fox Posted April 20, 2006 Share Posted April 20, 2006 , the subject is stored here. These tables are linked. If there is an entry in phpbb_posts but not in phpbb_posts_text, you get this "missing posts" phenomenon. I'm not sure why it is done this way, but it is. I am searching for a way to go though these tables and delete all records in phpbb_posts that do not have a record in phpbb_posts_text that does not involve me reading each of these tables which are more that 20 000 lines a piece. I think to thwart hackers, 'cus you have to crack both tables in order to crack the data base......rarley dose it help, the just hack the passwords by download ing PhpBB, extracting the dencryption system, then using dos to download the database files...... try looking for a comparison program, that would tell you right off thebat wich ones where broken..... as far as the mega krystal fanart, you're gonna have to do that manually......by checking the mysql tables...... :shock: Link to comment Share on other sites More sharing options...
DZComposer Posted April 20, 2006 Author Share Posted April 20, 2006 Good news! I talked with my networking teacher (who also teaches the MySQL class) and he gave me an SQL query to try. I'll try it later. Link to comment Share on other sites More sharing options...
Ludvig11 Posted September 19, 2006 Share Posted September 19, 2006 I dunno if this is the rigth topic but... Recently it has many times been really slow to browse trougth this forum.. (Like now)and I get some "Error-log" quite often... why is it like this for me? and is there others who has the same problem(s)? Link to comment Share on other sites More sharing options...
Lilacs Posted September 19, 2006 Share Posted September 19, 2006 I dunno if this is the rigth topic but... Recently it has many times been really slow to browse trougth this forum.. (Like now)and I get some "Error-log" quite often... why is it like this for me? and is there others who has the same problem(s)? Your not alone I have been getting the same problem, My 4 gig computer would slow to a trickle when coming to the forum and would be lighting fast on other web sites. After I defragged it it started to move a bit faster but not by a whole lot. Edit: When trying to enter the Rec room I reseved this: Failed obtaining forum access control lists DEBUG MODE SQL Error : 2013 Lost connection to MySQL server during query SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_mod FROM phpbb_auth_access a, phpbb_user_group ug WHERE ug.user_id = 457 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 16 Line : 156 File : auth.php DZ, what are you and Dwight doing back there? Link to comment Share on other sites More sharing options...
Owner/Technical Admin Sideways Posted September 19, 2006 Owner/Technical Admin Share Posted September 19, 2006 I get that from time to time too. Link to comment Share on other sites More sharing options...
DZComposer Posted September 20, 2006 Author Share Posted September 20, 2006 I think GoDaddy was doing some maintenance on their database servers today. CHS also had MySQL problems earlier today. Anything involving MySQL is a database issue. Also, some of the speed issuers are related to SFO being on a shared server. Other sites use the web and database servers that SFO does. Dedicated servers are expensive. On a side note, I am not too pleased that phpbb spits out the SQL statements in it's database errors.... No bueno for security... Oh well, phpbb is open source and it isn't like someone can't download it and look at the php.... Link to comment Share on other sites More sharing options...
Lilacs Posted October 3, 2006 Share Posted October 3, 2006 Glad to say ever since we switched of php to SMF I have be getting no error reports and my com blasts through the pages. Link to comment Share on other sites More sharing options...
Ludvig11 Posted December 28, 2006 Share Posted December 28, 2006 Well, emoticons seems to "render" wrong sometimes, like when I scroll in pages.. Link to comment Share on other sites More sharing options...
Inuyasha Posted December 28, 2006 Share Posted December 28, 2006 I had a weird error recently, where it insisted that I'd posted, but I hadn't. I checked, and there was no post in the topic. I had to get out of the reply form for about a minute and then try again, and it worked. 0.o -Inuyasha Link to comment Share on other sites More sharing options...
DZComposer Posted December 28, 2006 Author Share Posted December 28, 2006 What kind of post were you making? A lot of BBCode? Images? What it kind of sounds like is that the database statement errored out, but the php worked. I would think the SMF devs would put a check for that though. Link to comment Share on other sites More sharing options...
Inuyasha Posted December 29, 2006 Share Posted December 29, 2006 No, just my usual posts, with this font. No URLs even. Only happened once though; no system's perfect. -Inuyasha Link to comment Share on other sites More sharing options...
Mr. Krystal Posted September 20, 2008 Share Posted September 20, 2008 All our avatars are missing! Edit: When trying to update my avatar, I got this error: "The attachments upload directory is not writable. Your attachment or avatar cannot be saved." Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now