VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Apr 3, 2018, 09:05 AM
trypetide trypetide is offline
Member
 
Join Date: Jun 2010
Posts: 34
Default Database error while browsing

Hi there~

Just to let you know that, as of now, I can acces the website and forums (duh), but whenever I'm clicking on a Soundtrack's page, boom.

Database error.

On the other hand, artists/groups' pages are working great.

So I guess something messed up a bit a part of the database at some point.
=O
Reply With Quote
  #2  
Old Apr 3, 2018, 09:52 AM
Myrkul's Avatar
Myrkul Myrkul is online now
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: France
Posts: 3,124
Default

Admins probably saw it, here's the error just in case.
Quote:
Invalid SQL:
SELECT
a.*, b.titles
FROM vgmdb_product_album a
LEFT JOIN vgmdb_product b
ON (a.productid = b.productid)
WHERE a.albumid = XXXXX
ORDER BY a.productalbumid ASC;

MySQL Error : Table './vgmdb/vgmdb_product' is marked as crashed and should be repaired
Reply With Quote
  #3  
Old Apr 3, 2018, 11:28 AM
TerraEpon's Avatar
TerraEpon TerraEpon is offline
Senior Member
 
Join Date: Jun 2009
Posts: 584
Default

Just to confirm it's happening to me too
Reply With Quote
  #4  
Old Apr 3, 2018, 01:04 PM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Posts: 4,329
Default

search engine is broken, it's annoying
Reply With Quote
  #5  
Old Apr 3, 2018, 01:07 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

Confirming same.
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #6  
Old Apr 3, 2018, 05:26 PM
Zhane Masaki's Avatar
Zhane Masaki Zhane Masaki is offline
Senior Member
 
Join Date: Sep 2007
Location: San Rafael, California
Posts: 466
Default

Quote:
Originally Posted by Phonograph View Post
search engine is broken, it's annoying
It works, click advanced search. I tested it on JoJo just now
__________________
Lifelong gamer, avid VGM collector, and huge supporter of VGMdb

I am extremely knowledgable on ALL THINGS Ys and LUNAR. If you have a question about either series, ASK AWAY! I will answer it to the best of my ability!

Reply With Quote
  #7  
Old Apr 3, 2018, 05:45 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is online now
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

I get this status for that table from a check:

Quote:
[vgmdb.vgmdb_product] warning: Table is marked as crashed
[vgmdb.vgmdb_product] warning: 5 clients are using or haven't closed the table properly
[vgmdb.vgmdb_product] error: Record at pos: 1004244 is not remove-marked
[vgmdb.vgmdb_product] error: record delete-link-chain corrupted
[vgmdb.vgmdb_product] error: Corrupt
There is a button to repair the database, though I am not sure if I need to take the site offline first...
Reply With Quote
  #8  
Old Apr 3, 2018, 05:52 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is online now
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 8,242
Default

Ok, I think that fixed it. Let me know if anything weird happens.
Reply With Quote
  #9  
Old Apr 4, 2018, 02:41 AM
trypetide trypetide is offline
Member
 
Join Date: Jun 2010
Posts: 34
Default

Seems to work again, thanks~
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Error ExiledLife Questions and Comments 5 Jan 5, 2015 02:20 AM
ERROR kami68k Album Discussions 0 Oct 30, 2011 06:20 AM
Appearance of browsing scans Nisto Questions and Comments 11 Jun 9, 2010 10:33 AM
N/A: We Are Error MrMAGFest Album Discussions 0 Aug 19, 2008 07:08 PM
Error on Captain Commando~ G.S.M. Capcom 5 file [error of the original GSM5 booklet?] depa Questions and Comments 2 Apr 30, 2008 06:50 AM