Abdel

Mikołaj Kondej
Hello,

can you please upgrade http://www.forum.mage.pl into newest versions. I have uploaded new script files yet though I would feel safer if you will perform upgrade.

Best regards
Mikołaj Kondej

21 Jun 2010
Staff: Brian Garcia
Hello,

We had a small problem during the upgrade, this ticket is being updated to Tier II support. I apologize for the inconvenience, and a technician will look at it shortly. To avoid damage to your board, please do not try to upgrade it yourself. Once again, I apologize for the inconvenience.

Kind Regards,

Brian Garcia
Invision Power Services, Inc.
http://invisionpower.com

22 Jun 2010
Mikołaj Kondej
Hi,

thank you very much for your reply. I will not take any steps to upgrade or solve that issue.

I have uploaded index.html into board directory to let my users know what is happening. The board is still accessible via http://forum.mage.pl/index.php .

I am looking forward to hear good news from you.

Best regards
Mikołaj Kondej

22 Jun 2010
Staff: Giuseppe Casagrande
Hello,

I keep getting this error when I try to import the language files:
CRASH: PHP cpu time limit exceeded at feof() in /ips_kernel/classConvertCharset.php line 558

Could you please ask your host to temporarily raise that limit in order to complete the import of the xml files?

When this is fixed I'll rebuild the language and complete also the upgrade for IP.Content.

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

22 Jun 2010
Mikołaj Kondej
Unluckily my host can't change the cpu time limit. I am hosted on big hosting company with constant and unchangable limits.

Is there possibility of omiting this step? I can install languages afterwards. Maybe deleting polish language will help?

23 Jun 2010
Staff: Matt Mecham
Hello,

Do you have SSH access on your account? We could complete the language import via SSH which may avoid the issue.

Regards,

Matt Mecham
C.S.A Invision Power Services, Inc.

23 Jun 2010
Mikołaj Kondej
Unluckily no . I have only FTP access & direct access to sql.

Maybe the whole process could be executed on yours localhost? Then all problems with limits & lack of access would be missings and conversion should be successful? Would it be possible?

I hope that we will find solution for this problem soon - questions from my community members drives me mad.

Best Regards
Mikołaj Kondej



23 Jun 2010
Staff: Giuseppe Casagrande
Hello,

To run the process locally we would need to backup your site (files+DB), move it on another server, restore everything, complete the process, backup again all and finally re-import everything on your server. This really isn't something we can do considering also that the issue is caused by the limits on your host and not by a bug in IP.Board itself.

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

23 Jun 2010
abdel@mage.pl
As far as i can see the support option isn't then anything more then
answering easy questions. The limits on this host are standard ones and in
fact that is matter of script that it uses too much resources not the matter
of anything done wrong from our side. What is more downloading files & db,
restoring it and completing process isn't really so time consuming. I would
say that (except downloading) it it should take a few clicks.

I feel disapointed that even though I pay for support option when something
goes wrong I have to personaly get things back to work. I am dinscontent
that even though I pay for commercial software there still happenes issues
that to my mind are created by bad programing logic. I had similar feelings
when I had problems which installing polish language (which in any other
freeware board is simple and happenes without any problems) and you support
told me that "polish language is not supported". Now I hear that also
upgrading board except the non-problematic upgrades is not supported.

I had expected that you will provaide me with complete support also with
issues. In fact I was very pleased with support when I bought the software
because your employees were trying to solve all the problems with me. Know I
fell that all replys are made only to create ilussion that something
happenes and "get rid of problem". I am convinced that this is not the way
it should work.

Few years ago I would recommend your software and company to anybody looking
for good board. Unluckily now I can't do it without hesitation.


On Wed, Jun 23, 2010 at 4:51 PM, <support@invisionpower.com> wrote:

>
>
> Thank you for contacting Invision Power Services.
>
> Giuseppe Casagrande has responded to your Invision Power Services request.
>
> -----------------------------------------------
>
> Hello,
>
> To run the process locally we would need to backup your site (files+DB),
> move it on another server, restore everything, complete the process, backup
> again all and finally re-import everything on your server. This really isn't
> something we can do considering also that the issue is caused by the limits
> on your host and not by a bug in IP.Board itself.
>
> --
> Giuseppe Casagrande
> Advanced Support
> Invision Power Services
> -----------------------------------------------
>
> You can respond to this message by replying via email, or logging into your
> client center at http://www.invisionpower.com/customer/
> Regards,
>
>
> *Invision Power Services*
>
>
>
>

23 Jun 2010
Staff: Giuseppe Casagrande
Hello,

The language import is taking a long time because of the charset conversion since you are using "iso-8859-2" and the xml file are in "UTF-8". Charset conversions are always resource intensive and there isn't really much that can be done about it, I have already tried to split the xml file in smaller parts (about 1/4 of the original size) and the import still fails because of the same error I provided above.

I've had some other forums (3-4) with your same issue and their host agreed to temporarily raise the time limit to allow our technicians to complete the upgrade but your host is not willing to help with that. If I provide you the SSH command to run for the language import is your host going to run it for you possibly?


For now I have temporarily disabled IP.Content on your site and I have applied a patch to resolve the driver error so that the forum is visible/usable at least. Completing the process on a different server is not a solution because you're going to have the same issue on every upgrade.

Also there is another issue with your server and you'll need to contact your host about it too. When I try to open the "Support TAB" in your ACP I get a weird error about a malformed header from a CGI script and IP.Board doesn't use any CGI script, this is a part of the error:
Malformed header from CGI script: To mount /proc at boot you need an /etc/fstab line like: /proc /proc proc defaults In the meantime, run "mount /proc /proc -t proc" Error: /proc must be mounted To mount /proc at boot you need an /etc/fstab line like: /proc /proc proc defaults In the meantime, run "mount /proc /proc -t proc" X-Powered-By: PHP/5.2.13 Expires: Mon, 26 Jul 1997 05:00:00 GMT Cache-Control: no-cache, must-revalidate Pragma: no-cache Content-type: text/html; charset=ISO-8859-2 Content-Encoding: gzip Vary: Accept-Encoding ‹������Ãœ\[sÛ8²~N~F9‰œ-KÔ%NbGÒžÄN&Þu&žØÙìNjJ’D‹$8¼X–²ó£R©Ú§SuþÍ>Ìëüó5�R¤-;7{3>Sñ4º¾¡áÞw;/·ÿ±ÿ”MÒÀgû¯Ÿìín³ZòÞt·-kçp‡ýýùá‹=Ön¶ØA{NjYO¨±Ú$M£-ËšÍfÍY·)ã±uøÊ:!(mêfn‰êÓtS·6¸ÙSÆ’Å“þ–ÏÃq¿&Â[Þá}˜ôW�nonnjx †à îà æ^ R¬Ó¨!~ɼã~Í‘a*´‘Î#Qcæ©_KÃ…IjÑÀ˜3áq"ÒþîÁËÆÇ›NY+aíÇ|ð”P6îL�xu‡múØØ ±ô?£ßÓ“È‹ERêñ,öÖY«ÍþÂÃŒÇsFÔãy«ÕÂ?öý‹Cƒ‚ï…S¿_K&2N,eˆ®±I,Fýº™Ÿ‘Œ³ ð±hF¾5âÇÔ¦‰Ÿ:6¦^ê‹Áî~ó‰ä±»ÅîŒÓGì`ž¤"Ð÷;‡2I='éYº5º%NìE)#^÷ëŠÅGü˜ë·u°ôÆQ²#ìlÌú¬ý¯ž_>Ã…c‹½ðñö>cxLãL¨7ɫý}6â~B/z–6ÀXéÜå¡œ$©³@¸ï×¹ï«ñþÛ"°e±¿VHg•zî^h%S/:‘ŝ¨ @5v—†ÿ’îC#c_„¤2^B
éD1(ÿ®ÑxëØîÓŸ‰¥ŸÆˆ/#Ã…Ãt&ø4Y¢AS ðÀd|÷V„®7ú¹Ñ¥É×ëk9ù5–ÄN±Š«e¶ï9ÖQbucwñ8[Q,SIbÔ<配áë翚ʏ ïE6ÀþÙ—Üí_�üshÓ2’ø"ÃŒ.Æû‹A_7*ûÞ±HÉÅh»+(M®xÊíS Õ ­,‡‹>éêz±éÈÀ‚ö<‰å{©°ÚÍŽe¾6èEM"؆D¸U‚°?¦•YÍ õûõåÒTz



--
Giuseppe Casagrande
Advanced Support
Invision Power Services

24 Jun 2010
Mikołaj Kondej
Thank you for your reply,

can you please provaide me with proper SSH command? I will try to encourage my host to execute it.

As you said this problem will be repetable. Therefore I would like to ask if there is possibility of converting language files on my private computer using some commands / part of scripts and then skipping this point during update process? That would allow user just to download a few files, run a conversion process on localhost, reupload converted files and running the normal update without the need of taking your time.

As far as i understand the only problem is the conversion of files from UTF-8 to ISO. I can do that easily using "gżegżółka" software if you will provide me with files localisation. There will be still need to skip this part of upload script will it be possible?

Best regards and really thanks for your efforts
Mikołaj Kondej

24 Jun 2010
Mikołaj Kondej
I have downloaded the board to my localhost. Please advice what steps should I take to perform the update. I tried to access board/upgrade/ but I got the following SQL error:

"mySQL query error: SELECT m.*, g.* FROM ibf_members m LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup) WHERE LOWER(name)='abdel'

SQL error: Unknown column 'm.mgroup' in 'on clause'
SQL error code: 1054
Date: Thursday 24th o June 2010 09:05:45 AM"

I have't downloaded only /upload/ and /albums/ because to my mind they are not esencial.

24 Jun 2010
Staff: Giuseppe Casagrande
Hello,

1) Your host needs to go inside the folder "/forum-mage-pl" and run this command:
php rebuildFromXml.php

The command needs to be executed when inside the forum directory, running it being in another folder might return an error.

Once the command is run they need to select the option "Rebuild Lang" only and NOT "rebuildSkins" or "Both".

2) Is the upgrade_history table properly in the backup you took? It looks like it is still using the old login method used for upgrades from 1.x or 2.x. Another method would be to converter directly the XML files "admin_language_pack.xml" and "public_language_pack.xml" inside the folders "admin\applications\XXX\xml" and then replace them on the server. If they have the same charset the convert charset class won't be executed.


--
Giuseppe Casagrande
Advanced Support
Invision Power Services

24 Jun 2010
Mikołaj Kondej
Ok I have converted files at admin\appliations\xxx\xml\ from UTF-8 to ISO-8859-2. The orginal files are now listed as .bak files.

Can you please check if now the update will be possible?

24 Jun 2010
Staff: Giuseppe Casagrande
Hello,

The server is still returning that time limit error, honestly I would like to know how much seconds your host has setup for that limit..

Have you already checked if your host willing to run that SSH command for you?

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

24 Jun 2010
Mikołaj Kondej
I have sent the request for SSH command yet and I am awaiting for reply. Regarding the limits - our current provider is the biggest polish hosting company but of course that doesn't mean that it is the best. I asked them about CPU limits levels.

If they will not accept my request will we be able to get the old version of script back to work? We have another server (with SSH access and even root access possibility) and we can move board into it. Yet I am a bit sceptic about moving board in current state because transferring "non working" board which is in the middle of the update process can cause lot of problems. I mean for example that moving this board makes it nearly impossible to check it we have transferred everything correctly. Therefore I would like to ask you:
1) if we can get the board to working with old script, then transfer to dedicated server and run update process from the scratch?
2) if we can transfer the board and continue the update process on another server?

Please advice what would be best option in your opinion if my SSH command request would be declined.

24 Jun 2010
Staff: Giuseppe Casagrande
Hello,

If they reject your request about the SSH command the best option would probably be #1 at this point, that way we will be sure that everything is upgraded properly as the current upgrade has been done in several steps.

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

25 Jun 2010
Mikołaj Kondej
Strange, i have contacted support before and they have told me that they can't increase limits and now they say that they can increase it for one time script execution. They also ask what time limit would be enough? What shall I anserw them?

The current limit of script execution is: 30 sec.

25 Jun 2010
Staff: Giuseppe Casagrande
Hello,

90 seconds should be enough in most cases but tell them 180 so we are completely sure there won't be issues.

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

25 Jun 2010
Mikołaj Kondej
The limits are 130 secound now and will become normal ones tommorow at 00:00 AM GMT+1. Please try to perform as much of update as possible.

25 Jun 2010
Staff: Giuseppe Casagrande
Hello,

Okay now I don't get anymore the CPU time limit error BUT the board instead asks me to download an empty index.php file.. It may be the biggest polish hosting company but I have never seen so many issues.. I have a feeling that if we resolve this "empty index.php download" we will just get a different error again.

Let me check with the developers what else we can do apart from using the other server.

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

25 Jun 2010
Staff: Brandon
Hello,

I'm afraid we're kind of in a difficult situation here.

I'll say now - I've completed the language imports and upgraded IP.Content for you, so you should be good to go for now. We will also continue exploring ways to make the upgrader smarter and more efficient. However, at the end of the day, the particular process that was dying is simply a resource hungry process. It's only executed during the upgrade, so it doesn't impact server resources for the most part, but during the upgrade those resources do need to be available for it to finish correctly.

Like I said, you should be good to go for now. However, you may wish to consider moving your site to a server you have more control over to prevent issues in the future.

Please let me know if you have any further questions or concerns. Thanks!

Brandon Farber
Invision Power Services, Inc.

26 Jun 2010
Mikołaj Kondej
Thank you very much Brandon and Giusepee. We will take steps to move to better server as soon as we will clean up a bit our board after update.

Unluckily I have to take some more of your time. It seems that something is wrong with /ips_kernel/classXML.php. There are erros both when I am trying to import new language and while i am trying to import new skin. The PHP errors looks like this:

Warning: DOMDocument::loadXML() [domdocument.loadxml]: Premature end of data in tag content line 6 in Entity, line: 61144 in /ips_kernel/classXML.php on line 356

I was trying to upload new polish language & skins by dragon fly (stone skin) but due to that error process failed.

28 Jun 2010
Staff: Giuseppe Casagrande
Hello,

This is most likely related again to your server time limit, the import of the xml file is truncated and the script cannot receive the whole data. Try uploading via FTP the files on your server and import from there, however, if I have to guess I say you'll get again that CPU time limit error this way..

--
Giuseppe Casagrande
Advanced Support
Invision Power Services

28 Jun 2010
Mikołaj Kondej
We will try the board to new server then and if the problem will't be resolved we will contact you again.

Once again thanks for provaided help.

Best regards
Mikołaj Kondej