• From: Herts - UK
  • Registered: 2005-09-11
  • Posts: 842

Topic: Query Failing

Ok... I have been at work all night (not working on this problem though tongue) and this is starting to annoy me now.

I have this bit of code...

$result = $db->query('SELECT subject FROM '.$db->prefix.'topics WHERE id='.$id) or error('Unable to fetch topic subject', __FILE__, __LINE__, $db->error());

When a topic has been deleted it gives me the "unable to fetch topic subject" error instead of the normal "message(Bad request)" error.

Come on, someone point out the obvious for me... please....

Me: Blog | Twitter | TwitPic Exporter

StevenBullen's Website

2 Reply by Utchin (edited by Utchin 2008-04-11 10:02)

  • Utchin
  • PunBB senior member
  • Offline
  • Registered: 2007-02-09
  • Posts: 760

Re: Query Failing

('SELECT subject FROM '.$db->prefix.'topics WHERE id='.$id ) its that bit (so i think)

could be '.$id.' ')
or just with the '.$id ')

Sorry. Unactive due to personal life.
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Query Failing

matt: No, that code is perfectly fine.
StevenBullen: You need to give us context, what file/around what line?

  • From: Germany
  • Registered: 2007-02-14
  • Posts: 644

Re: Query Failing

Enable PUN_SHOW_QUERIES and paste the query. I guess the id is missing...

FluxBB - v1.4.8

lie2815's Website

5 Reply by StevenBullen (edited by StevenBullen 2008-04-11 17:26)

  • From: Herts - UK
  • Registered: 2005-09-11
  • Posts: 842

Re: Query Failing

lie2815 wrote:

I guess the id is missing...

Correct! big_smile

User error on my part... sad

Me: Blog | Twitter | TwitPic Exporter

StevenBullen's Website

6 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: Query Failing

StevenBullen wrote:
lie2815 wrote:

I guess the id is missing...

Correct! big_smile

User error on my part... sad

Nice to know I'm not the only one who does that trick on occasion. big_smile

MattF's Website