search

google-code-export / glossword

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

database error #65

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
= What steps will reproduce the problem?
add a term to a dictionary
or: add a dictionary

= What is the expected output? What do you see instead?
expected: no error
instead I see the following error message (i removed my email and password)

Database error: Invalid SQL: UPDATE `gw_users` SET id_user = '2', ua = '', 
login = 'admin', password = 'XXX', is_active = '1', is_multiple = '1', 
is_show_contact = '1', date_reg = '1213806621', date_login = '1213803036', 
int_items = '1', user_fname = 'wh', user_sname = ' ', user_email = XXX', 
user_perm = 'a:17:{s:8:\"IS-EMAIL\";i:1;s:8:\"IS-LOGIN\";i:1;s:11:\"IS-
PASSWORD\";i:1;s:10:\"IS-PROFILE\";i:1;s:8:\"IS-USERS\";i:1;s:13:\"IS-
TOPICS-OWN\";i:1;s:9:\"IS-TOPICS\";i:1;s:12:\"IS-DICTS-OWN\";i:1;s:8:\"IS-
DICTS\";i:1;s:12:\"IS-TERMS-OWN\";i:1;s:8:\"IS-TERMS\";i:1;s:15:\"IS-TERMS-
IMPORT\";i:1;s:15:\"IS-TERMS-EXPORT\";i:1;s:13:\"IS-CPAGES-
OWN\";i:1;s:9:\"IS-CPAGES\";i:1;s:15:\"IS-SYS-SETTINGS\";i:1;s:10:\"IS-SYS-
MNT\";i:1;}', user_settings = 'a:10:
{s:10:\"avatar\_img\";s:0:\"\";s:12:\"avatar\_img\_y\";s:0:\"\";s:12:\"avat
ar\_img\_x\";s:0:\"\";s:10:\"gmt\_offset\";s:1:\"3
\";s:9:\"is\_htmled\";s:1:\"1
\";s:13:\"is\_use\_avatar\";i:0;s:11:\"locale\_name\";s:7:\"en-utf8
\";s:8:\"location\";s:0:\"\";s:11:\"visualtheme\";s:9:\"gw\_silver\";s:12:\
"dictionaries\";a:1:{i:2;i:1;}}' WHERE `id_user` = "2"
MySQL Error: 1054 (Unknown column 'ua' in 'field list')
Headers already sent in C:\xampp\htdocs\glossword\lib\class.db.mysql.php 
on line 242
Location:
/glossword/gw_admin.php?a=edit&t=dicts&id=2

= What version of the product are you using? On what operating system?
1.8.9, under a winXP xamp installation (not the one provided by glossword, 
but glossword's requirements check on install did not report an error)

= Please provide any additional information below.

please note that the terms/dictionaries actually DO get saved. so apart 
from that error message, which seems to have no big effects, glossword is 
usable in my installation.

Original issue reported on code.google.com by borpan...@gmail.com on 18 Jun 2008 at 5:46

GoogleCodeExporter commented 9 years ago 
http://code.google.com/p/glossword/issues/detail?id=60

Original comment by dmitry.s...@gmail.com on 18 Jun 2008 at 6:52

GoogleCodeExporter commented 9 years ago 
yes, that helped, thanks!

Original comment by borpan...@gmail.com on 20 Jun 2008 at 12:35