The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi
Mot de passe perdu ? Nom d'utilisateur perdu ?
  • Page :
  • 1

SUJET : Upgrading to 2.0 Error: Table 'speci53_soosurvey.lime_survey_url_parameters' not

Upgrading to 2.0 Error: Table 'speci53_soosurvey.lime_survey​_url_parameters' not il y a 4 mois 6 jours #91380

  • albertang
  • Portrait de albertang
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
When upgrading to 2.0 from 1.9, the following error was encountered:
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'speci53_soosurvey.lime_survey_url_parameters' doesn't exist

Please fix this error in your database and try again

Going through the database, the table indeed does not exist. I created a blank table with the same name, then error occurs when the upgrade is looking for fields in the table. Can I get a copy of the table somewhere or the detail of the table fields so that I can create it?

Any help is much appreciated!
L'administrateur à désactivé l'accès en écriture pour le public.

Re: Upgrading to 2.0 Error: Table 'speci53_soosurvey.lime_survey​_url_parameters' not il y a 4 mois 4 jours #91421

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 4431
  • Remerciements reçus 460
  • Karma: 167
Strange, The db creation are set in update process.

Maybe some "db version" error.
if ($oldversion < 149)
        {
            $fields = array(
            'id' => 'integer',
            'sid' => 'integer',
            'parameter' => $sVarchar.'(50)',
            'targetqid' => 'integer',
            'targetsqid' => 'integer'
            );
            createTable('{{survey_url_parameters}}',$fields);
            Yii::app()->db->createCommand()->update('{{settings_global}}',array('stg_value'=>149),"stg_name='DBVersion'");
        }
source: application/helper/update/updatedb_helper.php

Denis
L'administrateur à désactivé l'accès en écriture pour le public.

Re: Upgrading to 2.0 Error: Table 'speci53_soosurvey.lime_survey​_url_parameters' not il y a 4 mois 3 jours #91579

  • albertang
  • Portrait de albertang
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
Thanks for the reply.

Where can I find the dbversion in my old installation to verify what the old db version value is?
L'administrateur à désactivé l'accès en écriture pour le public.
  • Page :
  • 1
Modérateurs: DenisChenu, ITEd
Temps de génération de la page : 1.066 secondes
Donation Image