Change database prefix

More
3 years 1 week ago #114296 by rem_hopster
rem_hopster created the topic: Change database prefix
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

Please Log in to join the conversation.

More
3 years 1 week ago #114318 by DenisChenu
DenisChenu replied the topic: Change database prefix
Please put the complete content of you config file. Surey some broken things.

(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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 6 days ago #114349 by rem_hopster
rem_hopster replied the 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

Please Log in to join the conversation.

More
3 years 6 days ago #114352 by DenisChenu
DenisChenu replied the 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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 6 days ago #114354 by rem_hopster
rem_hopster replied the 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

Please Log in to join the conversation.

More
3 years 6 days ago #114355 by DenisChenu
DenisChenu replied the topic: Change database prefix
You have enq_ somewhere in your config.php file without quote.

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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 5 days ago #114403 by rem_hopster
rem_hopster replied the topic: Change database prefix
Will have a look Denis.
Thanks!

Please Log in to join the conversation.

More
3 years 4 days ago #114430 by Mazi
Mazi replied the 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.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!