• Registered: 2007-08-29
  • Posts: 7

Topic: SQL Error

I'm getting the following error when clicking on the "My songbook" tab:



Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/chordie/include/functions.inc on line 359
mySql reports: Got error 12 from storage engine

This query was executed:
select * from songbook where songbookname='Good' and owner='tantumonium'



Please help!

Thanks.

  • Registered: 2007-08-29
  • Posts: 7

Re: SQL Error

Or maybe it decided to fix itself? wink

  • From: North East England
  • Registered: 2008-10-26
  • Posts: 207

Re: SQL Error

me too! i got that refreshed IE and its gone

cool Dont Stop Kid Keep Rockin'  !! cool
  • From: plymouth - uk
  • Registered: 2007-11-15
  • Posts: 199

Re: SQL Error

I cannot accsess my songbooks either ... keeep getting the following message . All other functions of chordie work fine .

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/chordie/include/functions.inc on line 359
mySql reports: Got error 12 from storage engine

This query was executed:
select * from songbook where songbookname='4th book' and owner='evsynator'

any resemblance to my songs sounding anything like the original is highly unlikely.

evsynator's Website

5 Reply by Syd1994 (edited by Syd1994 2009-09-07 18:31:07)

  • From: Mass. US
  • Registered: 2009-05-22
  • Posts: 94

Re: SQL Error

I tried signing in an it did that. Just opening the page gave me that message.

"Policeman shouts but I don't see him/ They're one thing I don't believe in"
-Tomorrow, 'My White Bicycle'
  • Registered: 2008-10-15
  • Posts: 20

Re: SQL Error

any idea what is wrong and when it might be fixed? Bowtalk

  • Registered: 2008-02-02
  • Posts: 1

Re: SQL Error

My songbook seems to have crashed as well. Now that the heat in Georgia is breaking I was looking forward to returning to music. Anyone have any ideas on what to do?

  • upyerkilt
  • upyerkilt
  • Unofficial king of Scotland
  • Offline
  • From: Balloch, Scotland, UK, Earth
  • Registered: 2006-03-04
  • Posts: 3,290

Re: SQL Error

i am getting an error message too.

I have emailed per about this. Hopefully he will have time to fix this soon.

I cannot get the home page or any where else really apart from in here by going through my history.



Ken

ye get some that are cut out for the job and others just get by from pretending
  • Registered: 2009-08-05
  • Posts: 1

Re: SQL Error

Logged in and got this


mySql reports: Table './guitaradmin/songbook' is marked as crashed and should be repaired

This query was executed:
select ID from songbook where owner='crazybaby' and songbookname='My songbook'

I cannot access my songbook and I cannot access any tabs.

Please look into.

  • Registered: 2006-03-04
  • Posts: 5

Re: SQL Error

Am seeing the same error . . . give me a shout if you need a hand with the fix, I'm a certified MySQL DBA

  • From: Almancil, Algarve, Portugal
  • Registered: 2006-09-02
  • Posts: 6,205

Re: SQL Error

I too am getting the same message and I also have contacted Per about the situation. In fact the only way I can log in successfully is from the Forum page and not from the home page.

I am sure that Per will remedy the situation shortly.

Roger

"Do, or do not; there is no try"

Roger Guppy's Website

  • From: Almancil, Algarve, Portugal
  • Registered: 2006-09-02
  • Posts: 6,205

Re: SQL Error

I recieved a message a short while ago that Per is looking at this problem. Hopefully it will be fixed soon.

Roger

"Do, or do not; there is no try"

Roger Guppy's Website

  • From: New jersey
  • Registered: 2007-04-25
  • Posts: 23

Re: SQL Error

crazybaby wrote:

Logged in and got this


mySql reports: Table './guitaradmin/songbook' is marked as crashed and should be repaired

This query was executed:
select ID from songbook where owner='crazybaby' and songbookname='My songbook'

I cannot access my songbook and I cannot access any tabs.

Please look into.

I'm having the same problem, crazybaby.

  • NELA
  • Honoured Member
  • Offline
  • From: West Monroe, La. 71292
  • Registered: 2007-11-28
  • Posts: 1,303

Re: SQL Error

Count me in. I'm getting the same message.

Nela

NELA's Website

  • Registered: 2009-09-07
  • Posts: 1

Re: SQL Error

Did anyone get an answer yet with the message about mySql reports: Table './guitaradmin/songbook' is marked as crashed and should be repaired.....let me know

  • Registered: 2007-08-29
  • Posts: 7

Re: SQL Error

No, Chordie!!! Don't die on me!!!

  • From: Rio Grande Valley, TX
  • Registered: 2008-06-12
  • Posts: 245

Re: SQL Error

Well I'm up and running!!!!!!!!Little scare, but nothing to call home about!!!!
Weird how chordie was down for a while, and the pillars of the earth almost came tumbling down

Forgive your enemies, but always remember their names!
  • From: Tooele Ut
  • Registered: 2006-03-04
  • Posts: 4,049

Re: SQL Error

Well, all is well now.

You can see all my video covers on [url]http://www.youtube.com/bensonp1000[/url]
I have finally found happiness in my life.  Guitars, singing, beer and camping.  And they all intertwine wonderfully.
  • Registered: 2008-10-15
  • Posts: 20

Re: SQL Error

I realised Chordie was important to me but I didn't realise how much until I lost it for a day!  By the way, if you are in the UK and lost access to the Beatles you can see the ones on my Song Book if you press Print View  Under BOWTALK. I hope it works for you because I can recover all my own lost Beatles syuff.

  • Registered: 2008-10-15
  • Posts: 20

Re: SQL Error

I checked - you can view all the Beatles songs that I have collected but of course they are in my key and are showing in guitar chords whilst I saved them for Ukulele BUT at least they are there for access.

A big thank you to all at Chordie for their service - about time I bought a T shirt!

  • Registered: 2008-10-15
  • Posts: 20

Re: SQL Error

In fact, if you punch in Beatles to the Search engine under Public Songbooks, you can gte loads of Beatles songs, turn them into VIEW and print them off to circumvent the ban that exists on UK websites.