View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04729 | Bug reports | Survey participants (Tokens) | public | 2010-11-09 17:08 | 2010-11-17 01:03 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.90+ | ||||
Fixed in Version | 1.90+ | ||||
Summary | 04729: SQL Syntax error when initialising token for survey | ||||
Description | When I attempt to initialise tokens for any survey, I receive the following error: Token table could not be created. This is on a default installation of MySQL. No modifications/customizations have been done. | ||||
Steps To Reproduce |
| ||||
Additional Information | PHP 5.2.14 with Suhosin-Patch 0.9.7 (cli) mysql Ver 14.14 Distrib 5.5.6-rc, for portbld-freebsd8.0 (i386) using 5.2 | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 9406 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | IE8 | ||||
Database type & version | MySQL v.5.2 | ||||
Server OS (if known) | FreeBSD 8.0-RC1 | ||||
Webserver software & version (if known) | Apache 2.2 | ||||
PHP Version | PHP v.5.2 | ||||
I can run the SQL statement CREATE TABLE tokens_84713 ( perfectly fine on mySQL server here. |
|
I am quite certain that this is a bug with your MySQL server, missing DB engine or your mySQL is just too old. |
|
I am running v.5.5.6 MySQL. I apologize for the mixup. But 'Type' has been obsolete for a while now, and this query works with using 'engine' instead of 'type'. Is there anywhere that I can change the script for this query? |
|
Attached fixed file. |
|
Fix released in latest 1.90+ version. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2010-11-09 17:08 |
|
New Issue | |
2010-11-10 16:48 | c_schmitz | Assigned To | => c_schmitz |
2010-11-10 16:48 | c_schmitz | Status | new => assigned |
2010-11-10 16:49 | c_schmitz | Note Added: 13482 | |
2010-11-10 17:09 | c_schmitz | Note Added: 13484 | |
2010-11-10 17:09 | c_schmitz | Status | assigned => closed |
2010-11-10 17:09 | c_schmitz | Resolution | open => no change required |
2010-11-11 22:19 |
|
Note Added: 13504 | |
2010-11-11 22:19 |
|
Status | closed => feedback |
2010-11-11 22:19 |
|
Resolution | no change required => reopened |
2010-11-11 23:03 | c_schmitz | Note Added: 13505 | |
2010-11-11 23:03 | c_schmitz | File Added: tokens.php | |
2010-11-11 23:04 | c_schmitz | Status | feedback => resolved |
2010-11-11 23:04 | c_schmitz | Fixed in Version | => 1.90+ |
2010-11-11 23:04 | c_schmitz | Resolution | reopened => fixed |
2010-11-17 01:03 | c_schmitz | Note Added: 13544 | |
2010-11-17 01:03 | c_schmitz | Status | resolved => closed |
2016-12-08 10:39 | c_schmitz | Category | Tokens => Survey participants (Tokens) |