View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
12540Bug reportsInstallationpublic2017-10-23 11:39
Reportertammo Assigned ToLouisGac 
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Product Version3.0.0-beta.x 
Summary12540: Crask when install on XAMPP
Description

Please fix the following input errors:

There were errors when trying to populate the database:
Executing: CREATE TABLE lime_surveys ( sid int(11) NOT NULL, owner_id int(11) NOT NULL, admin varchar(50) default NULL, active varchar(1) NOT NULL default 'N', expires datetime default NULL, startdate datetime default NULL, adminemail varchar(254) default NULL, anonymized varchar(1) NOT NULL default 'N', faxto varchar(20) default NULL, format varchar(1) default NULL, savetimings varchar(1) NOT NULL default 'N', template varchar(100) default 'default', language varchar(50) default NULL, additional_languages varchar(255) default NULL, datestamp varchar(1) NOT NULL default 'N', usecookie varchar(1) NOT NULL default 'N', allowregister varchar(1) NOT NULL default 'N', allowsave varchar(1) NOT NULL default 'Y', autonumber_start int(11) NOT NULL default '0', autoredirect varchar(1) NOT NULL default 'N', allowprev varchar(1) NOT NULL default 'N', printanswers varchar(1) NOT NULL default 'N', ipaddr varchar(1) NOT NULL default 'N', refurl varchar(1) NOT NULL default 'N', datecreated date default NULL, publicstatistics varchar(1) NOT NULL default 'N', publicgraphs varchar(1) NOT NULL default 'N', listpublic varchar(1) NOT NULL default 'N', htmlemail varchar(1) NOT NULL default 'N', sendconfirmation varchar(1) NOT NULL default 'Y', tokenanswerspersistence varchar(1) NOT NULL default 'N', assessments varchar(1) NOT NULL default 'N', usecaptcha varchar(1) NOT NULL default 'N', usetokens varchar(1) NOT NULL default 'N', bounce_email varchar(254) default NULL, attributedescriptions text, emailresponseto text default NULL, emailnotificationto text default NULL, tokenlength int(11) NOT NULL default '15', showxquestions varchar(1) default 'Y', showgroupinfo varchar(1) default 'B', shownoanswer varchar(1) default 'Y', showqnumcode varchar(1) default 'X', bouncetime int(11), bounceprocessing varchar(1) default 'N', bounceaccounttype varchar(4), bounceaccounthost varchar(200), bounceaccountpass varchar(100), bounceaccountencryption varchar(3), bounceaccountuser varchar(200), showwelcome varchar(1) default 'Y', showprogress varchar(1) default 'Y', questionindex int(11) default '0' NOT NULL, navigationdelay int(11) NOT NULL default '0', nokeyboard varchar(1) default 'N', alloweditaftercompletion varchar(1) default 'N', googleanalyticsstyle varchar(1) DEFAULT NULL, googleanalyticsapikey VARCHAR(25) DEFAULT NULL, gsid int(11) DEFAULT '1' PRIMARY KEY (sid)) ENGINE=MYISAM CHARACTER SET utf8mb4 ; failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(sid)) ENGINE=MYISAM CHARACTER SET utf8mb4' at line 1' in D:\dev\lsgit\framework\db\CDbCommand.php:358 Stack trace: #0 D:\dev\lsgit\application\controllers\InstallerController.php(999): CDbCommand->execute() #1 D:\dev\lsgit\application\controllers\InstallerController.php(969): InstallerController->executeSQLFile('D:\dev\lsgit/in...', 'lime') #2 D:\dev\lsgit\application\controllers\InstallerController.php(577): InstallerController->_setup_tables('D:\dev\lsgit/in...') #3 D:\dev\lsgit\application\controllers\InstallerController.php(79): InstallerController->stepPopulateDb() #4 D:\dev\lsgit\framework\web\CWebApplication.php(282): InstallerController->run('populatedb') #5 D:\dev\lsgit\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 D:\dev\lsgit\framework\base\CApplication.php(185): CWebApplication->processRequest() #7 D:\dev\lsgit\index.php(205): CApplication->run() #8 {main}

Steps To Reproduce

Try to install develop branche

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)3.0.beta GIT
I will donate to the project if issue is resolvedNo
Browserchrome
Database type & versionff
Server OS (if known)Windows10
Webserver software & version (if known)XAMPP Apache
PHP Version5.5.30

Users monitoring this issue

There are no users monitoring this issue.

Activities

tammo

tammo

2017-07-25 09:50

developer   ~44220

Cannot proceed, because when I use a older database:

Internal Server Error

Property "Survey.gsid" is not defined.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

2017-07-25 09:49:29

LouisGac

LouisGac

2017-07-25 10:14

developer   ~44222

what database are you using? MySQL or MSSQL?

tammo

tammo

2017-07-25 10:18

developer   ~44223

MySql

LouisGac

LouisGac

2017-07-25 10:19

developer   ~44224

and the db update script didn't get launched?

tammo

tammo

2017-07-25 10:20

developer   ~44225

Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.5.30

mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $

tammo

tammo

2017-07-25 10:21

developer   ~44226

This was during a new install, because the previous db gave the error:

Internal Server Error

Property "Survey.gsid" is not defined.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

2017-07-25 09:49:29

tammo

tammo

2017-07-25 10:23

developer   ~44228

Last edited: 2017-07-25 10:24

And online (limegit.toolsforresearch.com/admin) I see:

Internal Server Error

The asset "/home/limegit/domains/limegit.toolsforresearch.com/public_html/assets//styles-admin/Noto_All_Languages/images/logo_icon.png" to be published does not exist.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

2017-07-25 10:00:26

So I feel a little lost and kindly ask your guidance...

tammo

tammo

2017-07-25 10:24

developer   ~44229

See the double slash in .... assets//styles-admin....

LouisGac

LouisGac

2017-07-25 10:27

developer   ~44230

Ok I could reproduce the mysql error

tammo

tammo

2017-07-25 13:58

developer   ~44234

Great. It worked.

Issue History

Date Modified Username Field Change
2017-07-25 09:14 tammo New Issue
2017-07-25 09:14 tammo Status new => assigned
2017-07-25 09:14 tammo Assigned To => LouisGac
2017-07-25 09:50 tammo Note Added: 44220
2017-07-25 10:14 LouisGac Note Added: 44222
2017-07-25 10:18 tammo Note Added: 44223
2017-07-25 10:19 LouisGac Note Added: 44224
2017-07-25 10:20 tammo Note Added: 44225
2017-07-25 10:21 tammo Note Added: 44226
2017-07-25 10:23 tammo Note Added: 44228
2017-07-25 10:24 tammo Note Edited: 44228
2017-07-25 10:24 tammo Note Added: 44229
2017-07-25 10:27 LouisGac Note Added: 44230
2017-07-25 13:58 tammo Note Added: 44234
2017-10-23 11:39 LouisGac Status assigned => closed
2017-10-23 11:39 LouisGac Resolution open => fixed