- Moderated by:
- Support Team
-
- rank:
-
Freshman
- registered:
- September 2005
- Status:
- offline
- last visit:
- 15.10.08
- Posts:
- 40
I want upgrade my site from 726 to 760, but I've a problem... install.php doesn't modify any table in database, and when I go to the index page of the site I've this error:
Code
Fatal error: mysql error: [1054: Unknown column 'postnuke_blocks.pn_collapsable' in 'field list'] in EXECUTE("SELECT postnuke_blocks.pn_bid as bid, postnuke_blocks.pn_bkey as bkey, postnuke_blocks.pn_mid as mid, postnuke_blocks.pn_title as title, postnuke_blocks.pn_content as content, postnuke_blocks.pn_url as url, postnuke_blocks.pn_position as position, postnuke_blocks.pn_weight as weight, postnuke_blocks.pn_active as active, postnuke_blocks.pn_collapsable as collapsable, postnuke_blocks.pn_defaultstate as defaultstate, postnuke_blocks.pn_refresh as refresh, postnuke_blocks.pn_last_update AS unix_update, postnuke_blocks.pn_language as blanguage, postnuke_blocks.pn_position as postion FROM postnuke_blocks WHERE postnuke_blocks.pn_active = 1 AND (postnuke_blocks.pn_language='ita' OR postnuke_blocks.pn_language='') ORDER BY postnuke_blocks.pn_weight") in /web/htdocs/www.acmilan.net/home/UPGRADE/includes/classes/adodb/adodb-errorhandler.inc.php on line 77
So...
I've no error during the upgrade.
Why the script cannot modify the database?
I follow all the points of upgrading guide.
Thank you all ;)
Edit: I'm upgrading from PN .726 Phoenix -
- rank:
-
Steering Committee
- registered:
- December 2002
- Status:
- offline
- last visit:
- 23.11.08
- Posts:
- 13415
Follow the manual. There should be no need to run the install script with .726
--
Regards,
Simon
itbegins.co.uk - Zikula Consulting
Please read the Support Guide -
- rank:
-
Moderator
- registered:
- March 2002
- Status:
- offline
- last visit:
- 26.08.08
- Posts:
- 7720
The manual outlines the process - that you login into your site and then the upgrade each of the modules from the modules admin panel - this process performs the upgrade. However i'm not sure why a couple of people are getting this fatal error - what should happen (and does in the vast majority of cases) is that you don't see your blocks but can get directly the modules admin panel (as outlined in the manaul) to upgrade each component.
Firstly lets get your site upgrded. I've been writing and testing a quick upgrade script that will take some of the pain away from the upgrade process - in this release there are siginifcant changes to some key modules.
Grab the following PHP file (http://www.markwest.me.uk/downloads/upgrade.phps). Put this file in your PN root and rename it upgrade.php. Run this from a browser and enter your admin username and password and follow the rest of the on screen instructions. This process will upgrade all modules for you.
Next can you provide me with full details of your environment. The PHP version, mysql version and a full phpinfo report.
-Mark -
- rank:
-
Freshman
- registered:
- September 2005
- Status:
- offline
- last visit:
- 15.10.08
- Posts:
- 40
-
- rank:
-
Freshman
- registered:
- September 2005
- Status:
- offline
- last visit:
- 15.10.08
- Posts:
- 40
I've got another problem.
All the _ contained in the name of modules (i.e. "admin_messages") are seen as a space.
So the link in the admin panel is index.php?module=Admin%20Messages&type=admin and not index.php?module=Admin_Messages&type=admin the result is that the module isn't available.
How can I fix this bug? -
- rank:
-
Moderator
- registered:
- March 2002
- Status:
- offline
- last visit:
- 26.08.08
- Posts:
- 7720
This problem has been covered extensively on the forum already (hint: forum search....) for example in this thread. Highlighted words are the search terms.
Also please post seperate queries in seperate threads.
-Mark
