SQL Syntax Error Help?!

Miyagi

Newbie

Offline

Posts: 12

SQL Syntax Error Help?!

« on: August 25, 2008, 07:03:35 am »

Hi,

Not the best SQL coder so really struggling to troubleshoot this.

Error:

Code:

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 'condition, value1, value2, ID_CONDITION
FROM smf_store_shippingconditions' at line 2
File: /home/fordxrtu/public_html/forum/Sources/Store.php
Line: 5524

Code:

Code:

5521: $result = db_query("
5522: SELECT
5523: percent, totalamount, condition, value1, value2, ID_CONDITION
5524: FROM {$db_prefix}store_shippingconditions", __FILE__, __LINE__);

SQL Version on my server: 5.0.51a-community

Thoughts on how to fix?

Thanks,
Miyagi


	Logged

Miyagi

Newbie

Offline

Posts: 12

Re: SQL Syntax Error Help?!

« Reply #1 on: August 25, 2008, 07:14:48 am »

2 seconds later... i think i've fixed it... the problem is condition is now a reserved word and needs to be 'condition'... can this be fixed properly in a new release to avoid future conflicts?


	Logged

SMFHacks

Administrator
Hero Member

Offline

Posts: 9676

Re: SQL Syntax Error Help?!

« Reply #2 on: August 25, 2008, 07:27:09 am »

Yes it can be you can escape it with `condition` the back ticks should allow it to work.


	Logged

Miyagi

Newbie

Offline

Posts: 12

Re: SQL Syntax Error Help?!

« Reply #3 on: August 31, 2008, 04:03:55 am »

Still having intermittent issues with this error popping up across various parts of the shipping conditions so i dug deeper.

I'd suggest updating Store.Template.php in the package as follows:

REPLACE ON LINE 5669:

Code:

percent, totalamount, condition, value1, value2, ID_CONDITION

THIS:

Code:

percent, totalamount, 'condition', value1, value2, ID_CONDITION

Will help other members running store fix any potential issues.