HOME MADE MOD - Problem

This forum is now closed as part of retiring phpBB2.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

This forum is now closed due to phpBB2.0 being retired.
Post Reply
User avatar
[PT]BlueDragon
Registered User
Posts: 60
Joined: Wed Mar 02, 2005 3:25 pm

HOME MADE MOD - Problem

Post by [PT]BlueDragon » Mon Jun 30, 2008 10:26 am

Hi, at first i'm sorry if this post are not in the correct place, but i don't find where to put it.

My problem is "simple"
i made a mod to put subtitles (downloads) in my forum, but now my host change something and i get a lot of errors.

one of them is that:


SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release LIKE '%house%' AND ano LIKE '%%' AND tipo = 'Série' ORDER BY id DESC LIM' at line 1

SELECT * FROM phpbb_legendas WHERE titulo LIKE '%house%' OR release LIKE '%house%' AND ano LIKE '%%' AND tipo = 'Série' ORDER BY id DESC LIMIT 0 ,10

Line : 495
File : legendas.php

how i solve that??

thks

User avatar
Brf
Support Team Member
Support Team Member
Posts: 50714
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: HOME MADE MOD - Problem

Post by Brf » Mon Jun 30, 2008 11:21 am

I am guessing that "release" is a reserved word. You would have to change the name of that column,

User avatar
T0ny
Registered User
Posts: 1383
Joined: Sun Jan 29, 2006 8:42 pm
Location: Lancashire
Name: Tony

Re: HOME MADE MOD - Problem

Post by T0ny » Mon Jun 30, 2008 3:39 pm

or enclose it in backticks

Code: Select all

OR `release` LIKE '%house%' 

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 23702
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: HOME MADE MOD - Problem

Post by Paul » Mon Jun 30, 2008 3:57 pm

T0ny wrote:or enclose it in backticks

Code: Select all

OR `release` LIKE '%house%' 
Backticks arent a good idea, its mysql only and it never a good idea to use reserved words table name to prevent confusion ;).
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

Post Reply

Return to “[2.0.x] MOD Writers Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests

cron