Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » Problem updating from 5 to 6 on Windows
 
Thread actions
Print this page
  • Print all pages

    • Problem updating from 5 to 6 on Windows

    Posted by firguense posts: 3

    Hello

    First, congratulations because Tikiwiki is a really good and really useful "application" 😉

    But now I have a problem when I want to update from Tiki 5.2 to Tiki 6.0. I use the Tiki Installer and in the Step 5 I try to Update my DB.

    This update give 2 messages:

    Success Upgrade operations executed successfully: 5564 SQL queries.

    Failed Operations failed: 27 SQL queries. Display details.


    There is one of them that I understand and I solved it, but the other 26 give an error report and I dont know how can I solve it...

    The error is:

    Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement
    fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO
    MYSQL_ATTR_USE_BUFFERED_QUERY attribute.


    Had somebody this error and know how to solve it?

    Thanks you very much!!

    David

    Reads: 3660
    Posted by Philippe Cloutier posts: 1001 Canada
    Which environment is Tiki in?

    Posted by Gregor (gta74) posts: 24 Germany

    Some problem over here:

    Step 6: Review the upgrade: Operations failed: 26 SQL queries.

    The following operations failed:

    • altering table tiki_shoutbox
    • UPDATE `tiki_sefurl_regex_out
    • update `tiki_preferences' (serveral times)


    Error message:

    Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement
    fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO
    MYSQL_ATTR_USE_BUFFERED_QUERY attribute.


    Running Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 on windows 5.2 (win 2003 server)

    Posted by jstotz posts: 35

    I got the same error messages. Also, after the upgrade, when I go to admin home, I get a message that the database has not been upgraded.

    I'm also running on W2003Server.
    XAMPP for windows 1.7.3
    MySQL 5.1.41


    Posted by Philippe Cloutier posts: 1001 Canada
    Thank you. Could one of you please open a bug report and mention the identifier here?


    Posted by Gregor (gta74) posts: 24 Germany

    A clean new install of tiki6 with xampp (1.7.3) worked. So the problem cant be related with xampp...

    Must be a problem with the existing db...


    Posted by Gregor (gta74) posts: 24 Germany

    I did some more testing and I have to correct myself:

    • A clean new install of tiki 6 works with xampp 1.7.3
    • A clean new install of tiki 5 works, too
    • An update vom tiki 5.0 (clean new install, no data at all) to 6.0 does not work.
    • An update vom tiki 5.3 (clean new install, no data at all) to 6.0 works!


    Upgrading the existing (populated db) 5.0 --> 5.3 works. BUT: the upgrade to 6.0 fails again 😑


    Posted by Ed posts: 19 United States

    I am running under Windows XP Professional, 32 bit, and using XAMPP 1.7.2.

    I have tried upgrading from
    5.0 --> 6.0
    5.0 > 5.3 > 6.0

    And always get the message:

    "Success Upgrade operations executed successfully: 5209 SQL queries.

    Failed Operations failed: ## SQL queries. Display details."

    Where the "##" varies from 26 to 32.

    I have never before encountered this problem when doing Tiki upgrades. I have tried both copying over the existing file structure, and replacing it entirely, as well as restarting the MySQL RDBMS. Still, the problem persists.


    Posted by Gregor (gta74) posts: 24 Germany

    After testing I rolled back to 5.0. Now the update failes when doing the upgrade to 5.x

    Same error as already mentioned.


    Posted by Gregor (gta74) posts: 24 Germany

    I solved it for my tiki:

    The solution was provided in local.php:

    // If your php installation does not not have pdo extension

    // $api_tiki = 'adodb';


    So I added $api_tiki = 'adodb'; to tiki/db/local.php and all errors were gone 😊

    (but I had lot of encoding crap 😑)


    Posted by chrei_bibi posts: 2

    Hi,
    Same problems with the upgrade but this time from an updated version 5.0 (4.2 before).
    With the workaround ($api_tiki = 'adodb' in db/local.php file), only 2 SQL were not executed (1 update of a primary key, 1 new column already existing).
    But after any kind of upgrade, even after removing special codes in the Look & Feel > Site header & Co, tiki is just bringing nothing back (empty page).
    Eclipse PHP and debugger not installed, so I have strictly NO idea how to get out of this situation.
    Would it be not possible for one of your crack to prepare a download file with Eclipse and a running debugger. I am coming from another planet and not used to PHP: I have ages to get things working (hi hi hi).
    WAITING eagerly for the next bug fix!
    Tiki version 6.0 is still not for my installation. What a pity!
    Regards

    Posted by Philippe Cloutier posts: 1001 Canada

    Hi,
    running PHP with a debugger is just starting. This is a request for Eclipse/PHP folks, but don't expect that anytime soon.

    Sometimes however a debugger is not necessary. Presumably you're dealing with a PHP fatal error. You need to turn on PHP error reporting to see what's wrong (see error_reporting and display_error settings, or see Apache logs).


    Posted by chrei_bibi posts: 2

    Many thanks for the answer.
    I tried to set the php flag for error reporting but without any success. Still got the blank page!
    So I inserted the following code (just something generating an answer) to track the problem
    $smarty->assign('msg', tra('This feature is disabled').': feature_wiki_structure');
    $smarty->display('error.tpl');
    die;
    in the following pages
    tiki-index.php > tiki-setup.php > error_reporting.php.
    Something seems to be wrong with the following lines
    set_error_handler("tiki_error_handling", $errorReportingLevel);
    error_reporting($errorReportingLevel);
    But at this point, I do not understand really what is written.
    So I stopped: no more time to play with this toy.
    May the force be with you!
    Regards

    Posted by Leu posts: 9

    I´am not sure if my old problem is your actual problem.
    I have tried Tiki5 with Apachefriends XAMPP 1.7.3, 1.7.2 and 1.7.1.

    All version after 1.7.1 won´t run properly with Tiki. After reinstall 1.7.1 all run´s fine.


    Posted by WalterD posts: 1

    I encountered the same problem. When running the tiki-install page I get an parsing error. Then I installed 6.1 on a new path and used the same database, where after the installing process I got only a white page. So I decided to go back to the good old 5.3 pages on the original path. Now I can see my pages again with 5.3, but unfortunately can not edit them anymore. When I want to edit a page, tiki asks me to reinstall, which does not give the desired result.

    My next step would be to restore the saved database of the 5.3 version, but this is my first time to do so, and I realize my provider's phpmyadmin only lets me import around 90 Megabite.

    I guess this is what I deserve. I should have tried to restore sql files on a test database, to see what the limits are.

    I still hope, that I can somewho upgrade to 6.1. Does anyone have an idea?