Locked



Editor, Emulator Coder, Expert player (2156)
Joined: 5/22/2007
Posts: 1134
Location: Glitchvania
On the submission queue page: * The Edit button/link is always displayed as [|.]. * "Access blocked because of missing/unacceptable referrer information." when you click on any sorting arrow (in IE 7) or "underline" (in Firefox 3.0.11). On other pages: * The Edit button/link is displayed as . if you are not logged in. EDIT: One more (forum bug): Right after I started this thread, the post-post redirection guided me to http://tasvideos.org/forum/viewtopic.php?p=205633#205633, which doesn't exist.
<klmz> it reminds me of that people used to keep quoting adelikat's IRC statements in the old good days <adelikat> no doubt <adelikat> klmz, they still do
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
The movie statistics page is down - I get this error when I try to reach it:
Movie Statistics

Fatal error: Uncaught SoapFault exception: [HTTP] Not Found in /home/tasvideos/public_html/inc/tracker_api.php:14 Stack trace: #0 [internal function]: SoapClient->__doRequest('<?xml version="...', 'http://tracker....', 'urn:NesvTracker...', 1, 0) #1 [internal function]: SoapClient->__call('Scrape', Array) #2 /home/tasvideos/public_html/inc/tracker_api.php(14): SoapClient->Scrape(false) #3 /home/tasvideos/public_html/modules/moviestatistics.php(194): LoadBittorrentTrackerData() #4 /home/tasvideos/public_html/modules/moviestatistics.php(26): MovieData->LoadData() #5 /home/tasvideos/public_html/modules/moviestatistics.php(17): MovieStatisticsRender(Array) #6 /home/tasvideos/public_html/inc/wikifun.php(387): MovieStatistics(Array) #7 /home/tasvideos/public_html/inc/wikifun.php(432): WikiBuiltInModuleDoExec('moviestatistics', '') #8 /home/tasvideos/public_html/inc/wikifun.php(185): WikiBuiltInModule('MovieStatistics', '') #9 /home/tasvideos/public_html/inc/wikirender.php(42): WikiLinkFunc('module:MovieSta...') #10 /home/tasvid in /home/tasvideos/public_html/inc/tracker_api.php on line 14
Joined: 8/27/2006
Posts: 883
When opening Metal Slug X thread --------------------------------------- phpBB : Critical Error Error updating sessions table DEBUG MODE SQL Error : 1205 Lock wait timeout exceeded; try restarting transaction UPDATE sessions SET session_time = 1247507808, session_page = 30 WHERE session_id = '13a05ee91b799cf5f0059ebe3a2fb228' Line : 370 File : sessions.php Backtrace: includes/functions.php[741]: ErrorPrintBacktrace() includes/sessions.php[370]: message_die(204, string(29) "Error updating sessions table" , string(0) "" , 370, {string(55)}, {string(131)}) viewtopic.php[191]: session_pagestart(string(8) "d8ef5fda" , 30)
Experienced player (961)
Joined: 12/3/2008
Posts: 939
Location: Castle Keep
Yeah i randomly get that last critical error as well, its not tied to a particular topic apparrently
Joined: 8/27/2006
Posts: 883
And the website is kind of slow. It might be related to this update. Because there's a lot of update on the sessions table, it might slow down the website. You should see if you can put a no lock on the update. This might solve the problem.
Former player
Joined: 12/5/2007
Posts: 716
Randil wrote:
The movie statistics page is down
fixed. Helping was also affected by this at least shows something again. I'll have to dig into the code to comment on the urgent seed requests.
Editor, Reviewer, Experienced player (979)
Joined: 4/17/2004
Posts: 3109
Location: Sweden
The search page is out of order: http://tasvideos.org/Search.html It only appears to work if you are logged in. Otherwise, it always returns 0 results.
Player (121)
Joined: 2/11/2007
Posts: 1522
For whatever reason on one of my computers most topics in the forum don't get marked as read now. Not all, but most. Running Chrome on three computers, only happens on one. Not terrible, but thought I'd mention it.
I make a comic with no image files and you should read it. While there is a lower class, I am in it, and while there is a criminal element I am of it, and while there is a soul in prison, I am not free. -Eugene Debs
Joined: 7/2/2007
Posts: 3960
I've had that problem for ages. I'd love to know what causes it. :\
Pyrel - an open-source rewrite of the Angband roguelike game in Python.
Joined: 8/27/2006
Posts: 883
hum it works for me, but I know there's been a couple of problem with the SQL Statement that update the session table.
Former player
Joined: 12/5/2007
Posts: 716
alden, Derakon: Log out from the forums, delete your cookies and log in again. I've never had that issue, but I'm guessing it's session related. ZeXr0: It will happen again and there's nothing we really can without getting a server with even more memory.
Experienced player (623)
Joined: 11/30/2008
Posts: 650
Location: a little city in the middle of nowhere
On the "Pending submissions" page, whenever I try to sort the list, it links me to the front page. ie clicking on "⇕Submitted" will link to the front page.
Measure once. Cut twice.
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
This might have already reached your attention, but it might be worth pointing out: In the Workbench section, there is a link to page 2, but if you go to page 2, it says "There are no posts in this forum." Is this something that can be fixed, or is it a bug that is buried deep in the PhPBB code?
Player (121)
Joined: 2/11/2007
Posts: 1522
ShinyDoofy wrote:
alden, Derakon: Log out from the forums, delete your cookies and log in again. I've never had that issue, but I'm guessing it's session related.
So far so good... thanks again Mr. Shiny!
I make a comic with no image files and you should read it. While there is a lower class, I am in it, and while there is a criminal element I am of it, and while there is a soul in prison, I am not free. -Eugene Debs
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
Hello again, I have a forum bug to report: Whenever you quote a forum post by TASVideoAgent or TASvideoGrue, the name used in the quote is NesVideoAgent.
Former player
Joined: 12/5/2007
Posts: 716
The latter is fixed, but I'll have to talk back with Nach about the former. Thanks for the report :)
Editor, Skilled player (1202)
Joined: 9/27/2008
Posts: 1085
Having difficulties accessing the board at times...
phpBB : Critical Error Error creating new session DEBUG MODE SQL Error : 1205 Lock wait timeout exceeded; try restarting transaction INSERT INTO sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('b3e5efd353d010b0371f125d19e7b12d', -1, 1249531803, 1249531803, '476f021c', -1, 0, 0) Line : 200 File : sessions.php Backtrace: includes/functions.php[743]: ErrorPrintBacktrace() includes/sessions.php[200]: message_die(204, string(26) "Error creating new session" , string(0) "" , 200, {string(55)}, {string(239)}) includes/sessions.php[407]: session_begin(-1, string(8) "476f021c" , -1, true) login.php[37]: session_pagestart(string(8) "476f021c" , -1)
After an extended length of time waiting, half a minute at least, I'm hit with this message. It happens often enough that it gets quite difficult to see much of what's going on at the forums. I often enough lurk without being logged on, so I'm not quite sure if the problem works the same way with our without this status. In any case, things are extra slow for a while when trying to view the forums. The main site appears to be fine, however. You know, any page without /forum in the address box.
Former player
Joined: 8/1/2004
Posts: 2687
Location: Seattle, WA
That page shows up regardless of whether or not you're logged in.
hi nitrodon streamline: cyn-chine
Player (121)
Joined: 2/11/2007
Posts: 1522
ShinyDoofy wrote:
ZeXr0: It will happen again and there's nothing we really can without getting a server with even more memory.
How much would more memory cost? Heh, I got that timeout screen when I tried to post this, how appropriate :P
I make a comic with no image files and you should read it. While there is a lower class, I am in it, and while there is a criminal element I am of it, and while there is a soul in prison, I am not free. -Eugene Debs
Joined: 8/27/2006
Posts: 883
SQL Error : 1205 Lock wait timeout exceeded; try restarting transaction Don't know if this could help.
The error means what it says. Are any other transactions accessing that table at the same time you are inserting rows? What is your TransactionDeadlockDetectionTimeout? The default of 1200ms is very short. Are you using 5.0 or 5.1? On 5.1 you can try to increase it... we use 10000 (10 seconds) on our production systems.
And maybe see if there are any select that could be performed with the expression WITH NO LOCK (don't know if it exist in mysql)
Joined: 11/11/2006
Posts: 1235
Location: United Kingdom
As of posting, I'm getting the error below frequently:
SQL Error : 1205 Lock wait timeout exceeded; try restarting transaction
Edit: Also, posting this post logged me out. what the hell?
<adelikat> I am annoyed at my irc statements ending up in forums & sigs
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
I found a weird bug today: The site automatically logs me out when I visit http://tasvideos.org/GameList/NES.html I have made sure I'm logged in on the main page, not just the forum, but as soon as I load the NES page, I get logged out. If I go to any other page from that page, I get logged in again. So there's probably something wrong with the page http://tasvideos.org/GameList/NES.html Is anyone else having problems with this?
Editor, Emulator Coder, Expert player (2156)
Joined: 5/22/2007
Posts: 1134
Location: Glitchvania
I only experienced something like the front page didn't display that I had logged in until I manual reloaded the page. It has never automatically logged me out, though.
<klmz> it reminds me of that people used to keep quoting adelikat's IRC statements in the old good days <adelikat> no doubt <adelikat> klmz, they still do
Skilled player (1827)
Joined: 4/20/2005
Posts: 2161
Location: Norrköping, Sweden
I should also note that this happens when I try to log in on that page: after entering my login name, pressing enter, enter my password, press enter, the page starts to load, but when it has finished loading, I'm at the same page, still logged out. So it seems no matter what, I can't log in on that page...
adelikat
He/Him
Emulator Coder, Site Developer, Site Owner, Expert player (3573)
Joined: 11/3/2004
Posts: 4754
Location: Tennessee
It is a known bug. It isn't specific to any one page. The only cure is to delete your (tasvideos) cookies. That will fix it (until it happens again). For me it is the user editor that is prone to this bug. I currently have no idea what is the cause of it.
It's hard to look this good. My TAS projects

Locked