Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:
  • Page:
  • 1
  • 2

TOPIC: Update from 1.9 to 2.0

Update from 1.9 to 2.0 3 years 4 months ago #93314

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1797
  • Thank you received: 439
  • Karma: 110
Hello,
...may you have your solution here
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => bit.ly/20NW9V8 (already included in /docs/demosurveys)
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93317

  • DezB
  • DezB's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Hi Ben V

You Genius, thank you so much

All sorted, loaded, running and even updated.

Many thanks again as I can breathe again now.

DezB :woohoo:
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93319

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1797
  • Thank you received: 439
  • Karma: 110
You're welcome!
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => bit.ly/20NW9V8 (already included in /docs/demosurveys)
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93694

  • DezB
  • DezB's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Hi folks

I've now sorted this and will post the method shortly for anyone else that uses 1and1 servers.

Many thanks to all those who helped by the way...

Cheers

DezB
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93702

  • DezB
  • DezB's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Hi Folks

With many thanks to Ben_V, the answer was:

Install Error

I was having the same issue and after an hour of hacking around in the code I have found what you need to do.

Open application/controllers/InstallerController.php and around line 1106 in the _getDsn function you will find this:

$dsn = "mysql:host={$sDatabaseLocation};port={$sDatabasePort};dbname={$sDatabaseName};"


Change to this

$dsn = "mysql:unix_socket={$sDatabaseLocation};port={$sDatabasePort};dbname={$sDatabaseName};";


And the install will run as normal but in the host box instead of localhost put /tmp/mysql5.sock

Works a treat..

DezB
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93707

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9281
  • Thank you received: 1324
  • Karma: 384
Hello,

Can you tell us what did you have in application/config/config.php after the installation.

Somethink like that :
'connectionString' => 'mysql:unix_socket=/var/run/mysqld/mysqld.sock;port=3306;dbname=limesurvey;',

Maybe a checkbox or a select with connection method can be a goos idea.

Denis
PS: don't need port for unix_socket:
'connectionString' => 'mysql:unix_socket=/var/run/mysqld/mysqld.sock;dbname=limesurvey;',
seem good enough.
Maybe fill a bug report / development patch
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
Last Edit: 3 years 4 months ago by DenisChenu.
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93774

  • DezB
  • DezB's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Hi Denis

That sounds like a good idea, 1and1 are one of the largest hosts in the UK, Germany and across Europe so I guess there are many others such as me who are not programmers but want to have a go.

Many thanks

DezB
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93775

  • DezB
  • DezB's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Sorry, in answer to your question:

'connectionString' => 'mysql:unix_socket=/tmp/mysql5.sock;port=3306;dbname=dbxxxxxxxxx;',
'emulatePrepare' => true,

Hope this helps

DezB
The administrator has disabled public write access.

Update from 1.9 to 2.0 3 years 4 months ago #93782

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9281
  • Thank you received: 1324
  • Karma: 384
DezB wrote:
Sorry, in answer to your question:

'connectionString' => 'mysql:unix_socket=/tmp/mysql5.sock;port=3306;dbname=dbxxxxxxxxx;',
'emulatePrepare' => true,

Hope this helps

DezB
Can you quicly test:
'connectionString' => 'mysql:unix_socket=/tmp/mysql5.sock;dbname=dbxxxxxxxxx;', ?

ANd please : fill a feature request here : bugs.limesurvey.org
(Same account information than forum).

Denis
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.248 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form