Zikula Community

• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 19, 2009 - 10:41 PM

  Hi,
  After following the upgrade process to a queue I still get the above error after clicking on the "Click here to start the upgrade process"...
  
  I have deleted and added a new user to the DB incase I was wrong with the passwd but still got the following error.(Remove the .htaccess files)
  
  Please tell me where am I wrong:
  
  $PNConfig['DBInfo']['default']['dbtype'] = 'mysql';
  $PNConfig['DBInfo']['default']['dbhost'] = 'localhost';
  $PNConfig['DBInfo']['default']['dbuname'] = 'me_pnke1';
  $PNConfig['DBInfo']['default']['dbpass'] = 'mynewusernamepasswd'; Should this be the DB passwd but not sure if there is one
  $PNConfig['DBInfo']['default']['dbname'] = 'me_pnke1';
  $PNConfig['DBInfo']['default']['encoded'] = 1;
  $PNConfig['DBInfo']['default']['pconnect'] = 0;
  $PNConfig['DBInfo']['default']['dbtabletype'] = 'innodb'; Should this be myisam
  $PNConfig['DBInfo']['default']['dbcharset'] = 'latin1';
  
  
  
  Am lost after this....
  
  Regards,
  Khlur.
  
  
  
  edited by: khlurkari, Jul 20, 2009 - 04:12 PM
  
  --
  Tur Shipai Tur

  • 
  •  
• Arthens
  
  

  • Rank: Developer
  • Registered: Mar 29, 2005
  • Last visit: Mar 13, 2010
  • Posts: 228

  Posted: Jul 19, 2009 - 10:44 PM

  If the DB password is not encode you have to change
  $PNConfig['DBInfo']['default']['encoded'] = 1;
  in
  $PNConfig['DBInfo']['default']['encoded'] = 0;
  
  --
  Zikula Italia
  SimpleGallery

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 19, 2009 - 10:46 PM

  Let me try this... hehehehe Thanx for the quick reply...
  
  --
  Tur Shipai Tur

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 19, 2009 - 10:48 PM

  Hehehehe Tried the following and got this error
  
  Table 'me_pnke1.zk_module_vars' doesn't exist
  SELECT pn_value , pn_name FROM zk_module_vars WHERE pn_modname='/PNConfig'
  
  --
  Tur Shipai Tur

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Jul 19, 2009 - 11:16 PM

  Your table prefix ('zk') is probably wrong. Change it to what is appropriate for you (this might be 'nuke').
  
  See also Wiki: UpgradingZikula764 (especially if you are using the migration distribution)
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 19, 2009 - 11:22 PM

  Yeah! dat was it... Thank you soooo much .... changed the following:
  
  global $PNConfig;
  $PNConfig['System']['installed'] = 0; // installer will change this during installation
  $PNConfig['System']['tabletype'] = 'myisam'; // installer will change this during installation
  $PNConfig['System']['temp'] = 'pnTemp'; // installer will change this during installation
  $PNConfig['System']['prefix'] = 'nuke'; This was zk initially // installer will change this during installation
  $PNConfig['System']['development'] = 0; // should be set to 0/false when cutting a release for production use
  
  
  Thank you so much....
  
  Regards,
  Khlur
  
  --
  Tur Shipai Tur

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 19, 2009 - 11:31 PM

  LOL,
  After all the upgrading process was done I got to this page......
  
  Zikula is Not Installed!
  
  You are seeing this message because Zikula is not yet installed. You can install Zikula by visiting the install script, but before doing so please read the installation instructions. Further information can be found in the online documentation.
  
  Should I install a fresh one or did I still do somethign wrong???
  
  --
  Tur Shipai Tur

  • 
  •  
• craigh
  
  

  • Rank: Developer
  • Registered: Jun 16, 2003
  • Last visit: May 29, 2010
  • Posts: 1966

  Posted: Jul 20, 2009 - 12:48 AM

  did you run upgrade.php once?
  
  because you may have tried to run things multiple times, you may have some corruption. I would suggest replacing your DB with your backup and then make sure your config settings are correct and then run the upgrade.php once.

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Jul 20, 2009 - 12:59 AM

  Teb

  See also Wiki: UpgradingZikula764

  Just read that page.
  
  It says you have to set
  

  Code

  php]$PNConfig['System']['installed'] = 1;

  
  
  Just change that value in /config/config.php and you should be good to go.
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 20, 2009 - 01:28 AM

  I did the installation only once..... Am in the process of replacing the DB.... then will try the above. suggestion too.... Am really grateful for all this help ... Really lost rite now thought I got it good when the upgrade process was done..
  
  --
  Tur Shipai Tur

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 20, 2009 - 01:42 AM

  Below is the error I now get after using the backup DB and setting the "PHP]$PNConfig['System']['installed'] = 1;"
  
  Unknown column 'pn_name' in 'field list'
  SELECT pn_uid AS "uid",pn_name AS "name",pn_femail AS "femail",pn_url AS "URL",pn_user_avatar AS "user_avatar",pn_user_icq AS "user_icq",pn_user_occ AS "user_occ",pn_user_from AS "user_from",pn_user_intrest AS "user_intrest",pn_user_sig AS "user_sig",pn_user_aim AS "user_aim",pn_user_yim AS "user_yim",pn_user_msnm AS "user_msnm",pn_bio AS "bio",pn_timezone_offset AS "timezone_offset" FROM nuke_users76x AS tbl
  
  --
  Tur Shipai Tur

  • 
  •  
• Teb
  
  

  • Rank: Team Member
  • Registered: Feb 27, 2005
  • Last visit: Apr 12, 2010
  • Posts: 665

  Posted: Jul 20, 2009 - 02:03 AM

  Hmmm... So, when you initially ran the upgrade.php and forgot to set $PNConfig['System']['installed'] = 1, you at least got the upgrade right, but you couldn't access your site.
  Now, you restored a backup of your database and you get this message? Strange, because the upgrade process itself does not use that config setting. Only the index.php does, and that one is not called untill the migration has conpleted.
  
  Are you sure your database was empty before you restored your backup? Are you sure you are using the same backup as you did with your first install? At what stage of the migration-process was this message shown?
  
  Please restore the backup again and verify that your old PostNuke is running correctly on that database. Then, follow the documentation from the Wiki to start the migration process from scratch and please tell us at what stage the migration fails (there are about 5 or 6 steps in the migration)
  
  
  
  edited by: Teb, Jul 20, 2009 - 03:04 PM
  
  --
  -- Teb
  -- Dutch Zikula Community
  
  Support questions in a Personal Message will be ignored. Use the forums at all times!

  • 
  •  
• khlurkari
  
  

  • Rank: Softmore
  • Registered: Oct 28, 2005
  • Last visit: Oct 21, 2009
  • Posts: 128

  Posted: Jul 20, 2009 - 09:59 PM

  Hello again,
  
  Follow your instructions to the queue... hehehehe ... No problem at all this time.. I completely deleted the DB then created a new one imported the backup DB then restarted the upgrade process... All well now...
  
  Thank you so much Teb, Craigh, Arthens, couldn't have done this without your help.
  
  --
  Tur Shipai Tur

  • 
  •  
•  
•  

Users on-line

• rgasch

This list is based on users active over the last 60 minutes.