- Posts: 9
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Change database prefix
- rem_hopster
- Topic Author
- Offline
- New Member
Less
More
9 years 5 months ago #114296
by rem_hopster
Change database prefix was created by rem_hopster
Hello everyone,
I've a database prefix in my DB and config file
'Enq_'
My server keeps reporting
mod_fcgid: stderr: PHP Notice: Use of undefined constant 'Enq_' on row 40 configfile
How to fix this?
Can I update the database so thats there is no prefix and keep this empty?
I can't keep it empty now because then it won't recognize the database and ask to roll out the tables in the DB
Thanks
Rem
I've a database prefix in my DB and config file
'Enq_'
My server keeps reporting
mod_fcgid: stderr: PHP Notice: Use of undefined constant 'Enq_' on row 40 configfile
How to fix this?
Can I update the database so thats there is no prefix and keep this empty?
I can't keep it empty now because then it won't recognize the database and ask to roll out the tables in the DB
Thanks
Rem
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
9 years 5 months ago #114318
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Change database prefix
Please put the complete content of you config file. Surey some broken things.
(remove the password).
Denis
(remove the password).
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- rem_hopster
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
9 years 5 months ago #114349
by rem_hopster
Replied by rem_hopster on topic Change database prefix
hi denis,
This is my config file (db part)
$databaselocation = 'localhost'; // Network location of your Database - for odbc_mssql or mssqlnative use the mssql servername, not localhost or IP
$databasename = 'name of db'; // The name of the database that we will create
$databaseuser = 'name of user'; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = 'password db’; // Password of db user
$dbprefix = 'enq_'; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is 'lime_'
Thanks for looking at it
Rem
This is my config file (db part)
$databaselocation = 'localhost'; // Network location of your Database - for odbc_mssql or mssqlnative use the mssql servername, not localhost or IP
$databasename = 'name of db'; // The name of the database that we will create
$databaseuser = 'name of user'; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = 'password db’; // Password of db user
$dbprefix = 'enq_'; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is 'lime_'
Thanks for looking at it
Rem
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
9 years 5 months ago #114352
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Change database prefix
It's an old version of LimeSurvey ? Rigth ?
But here, i think we can't help : Use of undefined constant 'Enq_' on row 40 configfile
I think it's not the config file of LimeSUrvey, but a config file somewhere in your host/server.
Denis
But here, i think we can't help : Use of undefined constant 'Enq_' on row 40 configfile
I think it's not the config file of LimeSUrvey, but a config file somewhere in your host/server.
Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- rem_hopster
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
9 years 5 months ago #114354
by rem_hopster
Replied by rem_hopster on topic Change database prefix
Denis
It's a old version
But in the error log I see this?
Use of undefined constant enq_ - assumed 'enq_' in /var/www/vhosts/domainname/httpdocs/enquete/config.php on line 40, referer: www.domainname.nl/enquete/index.php
So in my folder "enquete" where the installation of LS is done, gives the error
It's a old version
But in the error log I see this?
Use of undefined constant enq_ - assumed 'enq_' in /var/www/vhosts/domainname/httpdocs/enquete/config.php on line 40, referer: www.domainname.nl/enquete/index.php
So in my folder "enquete" where the installation of LS is done, gives the error
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13648
- Thank you received: 2491
9 years 5 months ago #114355
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Change database prefix
You have enq_ somewhere in your config.php file without quote.
Look at ir, it's not a LS issue.
Look at ir, it's not a LS issue.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- rem_hopster
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
9 years 5 months ago #114403
by rem_hopster
Replied by rem_hopster on topic Change database prefix
Will have a look Denis.
Thanks!
Thanks!
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
9 years 5 months ago #114430
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic Change database prefix
If you can't find the problem take the original config.php file and try adjusting it again.
Also note that changing the prefix at the config.php file of a running system will not lead to your DB being updated but will probably cause a DB connection problem.
Also note that changing the prefix at the config.php file of a running system will not lead to your DB being updated but will probably cause a DB connection problem.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.