DeutschEnglish

Submenu

 - - - By CrazyStat - - -

29. August 2018

phpBB: Upgrade fails (timeout) – solution and how to update on the CLI

Filed under: PHP,Server Administration — Tags: , , , , , , , — Christopher Kramer @ 10:46

So if you are getting a Timeout when updating phpBB to 3.2.2, it tells you to either increase the maximum time limit or do the update on the CLI.

How to update on the CLI

Of course, this requires that you have access to the CLI.

  • On the CLI, go into the install folder of phpBB
  • Create a file named config.yml that contains this:
    updater:
        type: db_only
  • Make sure the above file does not end with newlines
  • Run:
    php ./phpbbcli.php update config.yml

Fixing the update timeout problem

In my case, the CLI update gave this error:

PHP Fatal error:  Call to a member function fetch_array() on resource in [...]/install/update/new/phpbb/db/migration/data/v32x/fix_user_styles.php on line 42

This is a bug in the migration script. The most easy way to fix it, is to go into your config.php and change the $dbms from mysql to mysqli. This is recommended anyway.

If this is not possible for you, open the mentioned file and search for:

$enabled_styles = $result->fetch_array();

And replace this with:

$enabled_styles = $this->db->sql_fetchrowset($result);

Thanks to RMcGirr83 and Marc on this thread.

Recommendation

Try my Open Source PHP visitor analytics script CrazyStat.

4. March 2012

Forum (board) opened for discussion and support

Filed under: CrazyStat,Uncategorized — Tags: , , , , — Christopher Kramer @ 12:42

Today I would like to introduce Christosoft Forum.

It is meant both for support, especially about CrazyStat, but also any general discussion about things of common interest.

I hope it will be used especially for CrazyStat support.

You do not even have to register at the moment, you can post as guest if you solve a captcha. Let’s hope I can keep this setting and it won’t be abused.

So from now on, please use the forum if you have any problems with CrazyStat. Other users might help you before I find the time or you might find the solution for your problem in an old thread.

Let me know what you think of it, either here or in the forum.

Also let me know if you have suggestions, e.g. for subforums or forum settings.

Edit: This is part of my plans to make development of CrazyStat more open. Expect other steps like Bugtracker or public SVN soon…

26. December 2011

CrazyStat development to get more open (Bugtracker, Wiki, FAQ, SVN)

Filed under: CrazyStat — Tags: , , , , , , — Christopher Kramer @ 15:17

Bug Tracker

I plan to start a public bug tracker for CrazyStat. I think this makes it easier for you to report bugs and feature requests and easier for me to manage those. I also plan a way so you can vote for new features.

Please let me know what your favourite bug tracker is. At the moment I favor redmine, but I’m not sure yet. Redmine also includes a nice wiki and project planning capabilities.

FAQ Script

Another idea of mine is to use a FAQ-script for CrazyStat. This makes asking and answering questions a lot easier. Some scripts can also handle translations which would be a great help to create FAQ in multiple languages. At the moment I think phpMyFAQ is the best solution for CrazyStat as it

  • supports multiple languages
  • supports community asking, answering and translation but also moderation and anti-spam
  • can export the FAQ into PDF/XHTML so it can be shipped in static format with CrazyStat as it is at the moment

If you have any good/bad experience with any FAQ script please let me know.

Of course it would be perfect if bug tracker, wiki and FAQ would be nicely integrated.

Public SVN

At the moment I develop CrazyStat in a SVN which is private only, but I think to make the development of CrazyStat more open, it will be necessary to open the SVN. Somebody proposed to use git, but I think at the moment git does not offer much that CrazyStat development needs compared to what SVN offers. Let me know if you disagree.

Bulletin Board / Forum

Some discussion around open-source software like user support might be more suitable to be done on a forum instead of a bugtracker or wiki. Of course phpBB is classic here, I would also consider something that is tightly integrated with the other software (bugtracker etc.).

Sourceforge project?

Somebody also proposed that I should open a sourceforge project for CrazyStat. I really like sourceforge and I think that might be a good idea, although I also love having full control over all the systems I use. But I think by opening a sourcforge project, I might get all those tools I discuss here quite easily and well integrated.

Update: I opened a sourforge project for CrazyStat now. Not much on there up to now, though. I think I will use Sourceforge for SVN, but I am not sure about the other tools. Although they are integrated nicely, they are also very limited in functionality.

Your feedback

Please let me know what tools you think an open source project like CrazyStat needs, which ones you favour and so on.