search

anshuwap / glossword

Automatically exported from code.google.com/p/glossword
0 stars 0 forks source link

SQL Error #178

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
= What steps will reproduce the problem?
1. Opening main page

= What is the expected output? What do you see instead?

Database error
Invalid SQL: SELECT count(*) AS num, SUM(int_terms) AS sum FROM gw_dict` WHERE 
is_active = "1" 
(98 characters)
MySQL 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 '` WHERE 
is_active = "1"' at line 2)

= What version of the product are you using?
Glossword 1.8.12

= Please provide any additional information below.
Occurred in two different servers.
MySQL 5.6.13

Original issue reported on code.google.com by tanav...@gmail.com on 21 Aug 2013 at 7:58

GoogleCodeExporter commented 9 years ago 
I'm not familiar with SQL, but solution was:
in inc/query_storage_global-mysql410.php
find line 270 code: 
FROM '.$sys['tbl_prefix'].'dict`
and delete `
like this: FROM '.$sys['tbl_prefix'].'dict

Original comment by tanav...@gmail.com on 22 Aug 2013 at 5:25

GoogleCodeExporter commented 9 years ago 
Sorry, I was wrong, figured out that one quatation mark (`) is missing before 
the column name in line 270. It should be like this:

FROM `'.$sys['tbl_prefix'].'dict`

Original comment by tanav...@gmail.com on 30 Oct 2014 at 12:18