Posted: 4/24/2006 12:07 PM
Post subject: Submission system broken?
Quote
trazz
Player (94)
Joined: 6/25/2005
Posts: 122
I submitted this ( http://tasvideos.org/1064S.html ) and I got the following error message. There's also no corresponding post in the workbench forum. ________________________________________________________ Submissions SQL select submission.*,system.abbr from submission,system where system.id=systemid and submission.id>0 order by systemid,gamename,gameversion failed: " Got error -1 from storage engine " Fatal error: Call to a member function MoveNext() on a non-object in /home/WWW/wikisites/nesvideos-site/inc/moviefun.php on line 548
Posted: 4/24/2006 12:10 PM
Post subject: Re: Submission system broken?
Quote
Bisqwit
Editor, Active player (296)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
trazz wrote:
SQL select submission.*,system.abbr from submission,system where system.id=systemid and submission.id>0 order by systemid,gamename,gameversion failed: " Got error -1 from storage engine "
Interesting. That SQL clause actually fails. I have no idea why it does that. EDIT: I "repaired" it by dropping the "systemid" foreign key from submissions and readding it. I still don't know what was wrong. In any case, the submission is there now.
Posted: 4/24/2006 12:57 PM
Quote
Truncated
Editor, Reviewer, Experienced player (969)
Joined: 4/17/2004
Posts: 3107
Location: Sweden
Arcade TAS of 2023 Sega TASer of 2021 Sega TAS of 2021
The recent changes page and the edit submission pages have similar errors. RecentChanges: SQL select submission.*,system.abbr from submission,system where system.id=systemid and submission.id>0 order by systemid,gamename,gameversion failed: " Got error -1 from storage engine " error_handler: errstr=Trying to get property of non-object errfile=/home/WWW/wikisites/nesvideos-site/inc/moviefun.php errline=548 Edit submission (after pressing save): Submissions SQL select submission.*,system.abbr from submission,system where system.id=systemid and submission.id>0 order by systemid,gamename,gameversion failed: " Got error -1 from storage engine " Fatal error: Call to a member function MoveNext() on a non-object in /home/WWW/wikisites/nesvideos-site/inc/moviefun.php on line 548