Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Change database prefix

  • rem_hopster
  • rem_hopster's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #114318 by DenisChenu
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

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
  • rem_hopster's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #114352 by DenisChenu
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

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
  • rem_hopster's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 4 months ago #114355 by DenisChenu
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.

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
  • rem_hopster's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 4 months ago #114403 by rem_hopster
Replied by rem_hopster on topic Change database prefix
Will have a look Denis.
Thanks!
The topic has been locked.
  • Mazi
  • Mazi's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
9 years 4 months ago #114430 by Mazi
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.

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.

Lime-years ahead

Online-surveys for every purse and purpose