unknown column on db_query in elysia_cron_update.php [#1983324]

Hi. I keep getting unknown column errors in elysia_cron_update.php

 in elysia_cron_check_version_update() (line 183 of
/var/www/openscholar/openscholar/modules/contrib/elysia_cron/elysia_cron_update.php).
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;ec_%%&#039; in &#039;where clause&#039;: select * from {variable} where name like "ec_%%" or name like "ecc_%%"; Array
(
)
 in elysia_cron_check_version_update() (line 183 of /var/www/openscholar/openscholar/modules/contrib/elysia_cron/elysia_cron_update.php).

and

1WD php: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'elysia_cron_%%' in 'where     [error]
clause': select * from {variable} where name like "elysia_cron_%%"; Array
(
)
 in elysia_cron_check_version_update() (line 28 of
/var/www/openscholar/openscholar/modules/contrib/elysia_cron/elysia_cron_update.php).
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column &#039;elysia_cron_%%&#039; in &#039;where clause&#039;: select * from {variable} where name like "elysia_cron_%%"; Array
(
)
 in elysia_cron_check_version_update() (line 28 of /var/www/openscholar/openscholar/modules/contrib/elysia_cron/elysia_cron_update.php).

Patch to follow.

Comment	File	Size	Author
#1	elysia_cron-unknown_column-1983324-1.patch	1.41 KB	jsagotsky

Comments

Comment #1

jsagotsky commented 30 April 2013 at 13:54

Status	File	Size
new	elysia_cron-unknown_column-1983324-1.patch	1.41 KB

Here's my patch. I updated the db_query calls to db_selects and that fixed it. I'm not sure why it makes a difference.

Comment #2

gotheric commented 3 May 2013 at 10:47

Assigned:	Unassigned	» gotheric
Status:	Active	» Fixed

I think the problem is using the double quotes " instead of the single quote ' for string comparison in SQL query.

I changed the query to use the single quote (i prefer not to apply the patch because that's only for D7, and now elysia_cron_update.php is drupal version independent).

Let me know if it keeps giving error in next version.

Thank for the report