user warning: 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 'ORDER BY name ASC LIMIT 0, 20' at line 1 query: SELECT name,value FROM variable ORDER By name ORDER BY name ASC LIMIT 0, 20 in /var/www/html/sites/all/modules/drupal_variables/variables.module on line 135.

CommentFileSizeAuthor
mysql-error-in-variables-module.jpg57.2 KBskalak1111

Comments

skalak1111’s picture

skalak1111 commented
Status: Active » Fixed

Open variables.module page.
Go to #128 and #129 line
-------------------------------

"function variables_load(){	
  #127--  $limit = 20;
 #128--  $query = "SELECT name,value FROM {variable} <b>ORDER By name</b>";
  #129-- $count_query = "SELECT count(name) FROM {variable} <b>ORDER By name</b>";
"

---------------------------------

Remove
Order By name from the line #128 and #129.

Bug Resolved.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.