Support ⇒ New installations ⇒ Problems with fresh install of 10.0.50.9440 ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexNew installations

Problems with fresh install of 10.0.50.9440 Reply to topic


Hi all,

I am running DF for many many years and really like it! Now I have to move an existing 9.4.0.0 installation on php5.6 to a new server with php7.1 or php7.3.

Prior to the moving I tried to get a simple DF 10.0.50.9440 up and running to be sure that I can differentiate between problems running the core itself and those coming from migration / modules.

Unfortunately I do only succeed in installing DF 10 with the installer, adding an admin user already stops me from progress as no psasword matching the regulations is accepted. After that I only see "maintenance mode" and only can "reset" when accessing the page, after that the message is "404 - Loader file not found".

Looking at the debug logs was not really helpful but the message and the corresponding code in index.php points me somehow that the translation of the URL input into the includes/load/index.php or includes/load/admin.php somehow fails.

I took a plain installation and started with php7.3 and fpm, made apache related changes to .htaccess according to dragonflycms.org/Wiki/id=135/ (which seems to be outdated as the .htaccess code does not match the one in the package) and ran into those issues.
Switching to PHP 7.1 did not help.

Can you please point me to the central mistake I made or give me a hint where to continue looking?

Best regards
spacie

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Did you try: url-to-dragonfly10/?admin

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial


I tried several options and now vanilla DF 10 is running.

Now I still have some issues with upgrading (upload database, upload all old forum files, copy DF10 files, make changes to include/config.php as suggested). The database update tells me the following (I don't translate the german part as it is not relevant or pretty self explanatory):

Pre-upgrade steps:
Synchroniziere Datenbank Daten:
Synchroniziere Datenbank Schemen:
core . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
auth . . . . . . . . . . . .
Synchroniziere Datenbank Daten:
core . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
auth . . . . . . . . . . . . . . . . . . . . . . .
Synchronization erfolgreich abgeschlossen
Führe zusätzliche Queries aus:
Upgrading active modules:
Forums: Error: Column 'upload_id' cannot be null
Groups: Error: SQL Transaction already started.
News: Error: SQL Transaction already started.
Our_Sponsors: Error: SQL Transaction already started.
Private_Messages: Error: SQL Transaction already started.
Statistics: Error: SQL Transaction already started.
Surveys: Error: SQL Transaction already started.
Your_Account: Error: SQL Transaction already started.
coppermine: Error: SQL Transaction already started.
Dragonfly 10.0.50.9440 erfolgreich installiert
Wichtig! Ordner install jetzt löschen!
Jetzt Viel Spass!

Interestingly the "upload_id" column does not exist in any table of the 9.4 database. Is that already an error or does the error happen at the update to DF10?

I really need some help here as we currently pay for two servers and if I don't get the forum moved we are in a mess (all other content has already been moved...)

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Hi DJ Maze,

thanks for the reply, yes I did.
I ran through the process again but with longer timeouts at apache.

It looks better now but still not really working. I can log in as an admin now and recognize the structure of my board. But somehow the blocks are not displayed correctly and coppermine is the only module that is actually working (access to the gallery, showing pictures, access to administration). The rest (forums, news, etc.) is simply not showing up, I only see the linking blocks left and right. Using the administration buttons does not change anything except with coppermine.

I think the main access via /?index is malfunctioning as I use block_centerblok5_v10 for a portal function. It was implemented when I took over, until 9.4 that wasn't a problem before. But this should not affect the main functions and will be changed as soon as I can administer...

Some errors occur when content should be presented:

CMS Error modules/News/index.php line 68: Unknown column 'ptime' in 'where clause'

CMS Error modules/coppermine/blocks/stats.php line 26: Call to undefined function cpg_tablecount()

I can provide access to the site if needed, currently I am "cheating" with a unregistered domain name, name based virtual hosting and fixed name resolution on client to not have any sideeffects with the original site.

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


The specs of the new server are:

Debian 9.12
Apache 2.4.25, Server MPM: event
MySQL: 10.1.44-MariaDB-0+deb9u1
PHP: 7.1.33 or 7.3.16 (admin logon worked only with 7.1)
Dragonfly: 9.4.0.0 on the way to 10.0.50.9440

As my DB is ~1.8GB and the install process took ~40 secs: Is there a ways to execute the install process without using the browser/apache? I am afraid that there is another timeout I am not aware of and therefore have a broken DB.

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0

Last edited by spacie on Mon Mar 30, 2020 12:46 pm; edited 1 time in total


Next update: I deleted the content from the search_wordlist and wordmatch, then I had one successful update besides some duplicate index.

So my previous errors came from timeouts...I think there still is a way to rebuild the search index (I did some time with the 9.x versions) but I'd prefer to not crop the database. So I tested more, but now I am not able to replay the one-time-working setup anymore ;(

At the moment update fails again as in the second post when using firefox. When using chrome or Edge on /?install I only get weird symbols, I think that php is not executed correctly:

��\�r�r��Tb���8�X��IPB �hU* �Xk��]R�S�"����I�u���,@�'q٦�����߯{:��������Ho�,=Wg����s��Y�T�9綊�Ԕg'��d��te�C�,Ee{zY��ɫ���MO�в4ɿ�Ҥz�ڥ�n��zzS�Շ^�/�:6�di��v=�Ϟ�v[Ь̷������lQ�;��9��4��C����gI�ֶ\~��$Y�մX�m���(SWe�.�U�ӗ�3lC���X��9-6:ٜ�~q��7\elJl��VE��hY%E���O���Ӑ̦�?�������OI\m>�N߼�[��$� x���7�o�����w~��ݜ��������?�2������=p����(_��#ml�|����p�󑭊<� �!����S���/o���IQ>����lA�����ʺw>����9�П��]䑭�O���=W��g����M�,2��B7����[��z[!R��ɿ�w�o��0�̆M � Z�Il�����5U�mi��I����&98�*װ��2v F<�O�D�<���%�3*w�+�(��*)m�k��.�;�v]F�J��uY��������{�Lxxo���0�d�ǂ��m�̬�4-��|�S����ٶ�`�����?h��q��?�&���F�?\܌/5�Mf#% �ϯ��$ʷ}��un���?�*�/�������.����~��#} ���XUO6�FT��l}=Η��Y�M�E,�O����YMr���7}}Q�����P�7oOOO_�����Z?̆J��vHIJF�ɒ �F*]�y�تLP�����ab���JS��b�q��3ȿM">R"�%�ϋ F A�x� ��=�^���k2G�B���������2"�Z8�����)ڱ�� "����q�����B00��b�Y��,�#���Ln���^`k���f�GŽe+��!�8+��V�Ly�_�ƒ���5�Ѧ�q����RFJ*ˆm$�Ī.k>5�h�M!|ڜ��:0] Q�����s>M��C9m) F�~�D�Fr.-����R�V���f9䵗��s�es��;��}�,Jr�NFN �28�� p�|؝fX��c ŀ���� $A�[}%i�T='}zD!�����@N�}�I�-�?Nx��sfl/�iT�U�M�(�#�q������rͦ�؟n`k������V8��$�D�.�D�VD[�$��/2Ψ�Wi��Ԏ5�u��Kᒈ��O¯��{1"O�k^<5t��hZ� 9[�μ�W+�*�?�n����@��b��E+�!�E++�'��w�px�D��IۯM.���U5�w:���mJ���Pd�c��E�&U��Q��g5J�O9�gE���|Y�x`�E��~ų�l���ȋ��r;�ߪ�O�1C� �>5��:q��H@*�p(��R`��i�Ձx��g�xe��oL-0/�8��3C�����-�<:x2�E Z�u*3O�8؀|N� �$ɣ��=�H�d ���siY��R��$b��f.fH -���+,��g1�kz����I���jÅj�{�e�§w�qK�+ʳ� �V� �E"�3��Xʉ���9Pf�sF"�&s�!�Ep�Ĕ.Hd����sm`�K�6�C�� ~" � �q��&l��jf�a�gt� �����;��ߢ�P���3�WnP���$�f]��l�1ؖ��x.��'��I4�Qp�~���+�6)9l��Q� ��t>����pr�/�&W���n2��wS�z�e<���W��|:�x�G����j|=�����#�砒3G6N 8��(���@�j�*"�P���f{%�h�ΦH)��h��m ��q#Vu�D�'?/"�޽��z6\_1fi�����������Q�L��yj*3�s�$|�� � �`5y��`_LE�o�FO�ħ�'Ƕ�։͙s���>����r 45�o����Xr��S����Ɣos ��Ȉ@����� �!�wn�żEQ��Һǹ��ѽp�!��r���8�F���=��e���(�pr%`��_t�`��g���:�9��˨��l�.� ��T"��+U����]P�H��}�ؘ�(�@�����9��o�Z�V�hRqF�����G�fK�+����[�s\8�3�g8�1��&�M�,���Nsȸ0� Nb��_S�z��ȼ�!�!����`3���!�@ �C�7-�U$�m���ڦ�;b�r�.>ْ�#�����*�z��<��4J2jt����^5fK.A�Н�׬�X��<�DB�����š�P.��Ҋ�0�l��tEC������QQZ@�����PU�%�t�:�P��Yj�:�g����$o��D'�6�`�����7_�{�̖����更ħ*�71]dSٰ�漘 �/���˥b�!���� �.��gR���TE ��3v ��Ό#�SX��w$����XF�� ����$����lY�8#��39�a)��O���-1G(�S�� OV ���l�$��l /�y�+mӉ��3?eVVMZ�Ϭ�::�^t�e���bEEPQ!FDn������R{cR� 2����O�r�屇���}��aW�+�jc��pu@���.Xg��h`��PDI6����R����dz�z@�Ab�;���T�ȴ%E . �]BA�$�(�A�=�yQ#�d҄�$�Nщx�و1��˵�aZ�/}���p^ |4/� ��^,�K����ƥQ��>q���B?&�i/&2����Q?��Q����ʚt�{�^��IP����X�_�yG�}�v#�?�!B��:)�#�� ���}߄�f�T����&�����{p1��xη|ָ� ��I~E�Ћ����D����"5n�4*!���[�#;� ��{d�HuXE���h��h��Xܫn�Y �5��+�$�wDvokj:�U���3:e�T�6��1%�Hi��NRQ�I�k8]��(to�(���p��:O@�è!�QKܩ^�jK���5g i��.>�X�YGe�d���K��Ҵ4��x�\T|5T9 �Z���(0 � Tm����IuWҍP3+��{�K����[qy��7SJ��g��F�����(�R�f�r�> p�qN�E"�8E�h�&)y����s�T�#���H��;H��~��c����_���UQ��r1�=�`�6 -J��$l�MS��l����P}���S )��ß�ǔ���o�S�=phoY�T� �_5�w�<�Ռ�^Q�2s>����i�DN�\��6ڠ�Rù���2'� ����91)�-B�����M�� A�5�㰂����VdQ���k�j���t���� ";�8 9�,Et���&�ڙ�䋚��`��a�w��!�����-���� ��(���cm'��^���E�La_�A��WNG �$�u:xY�r����/Y�� �5+�S��YA�����^82a��E)x�%�9��m�=���aNH�"%ʶ�v�o#Pң��B������mj�X��)���g��g��HЅ�K��l��� /|-(�Ț�I��2�uj����7��\4�LKG�q}�]���9� �c��j���ZP٥���$��X&�!����*���R���K.���(S�V>s���1� ;���ᔟ��G:a;e��5n<���'t�⣬��qt�Ǘ�M����kGT�K��Q��\�(��q� Y�#� ���HNH��T���0~�N���J)Z��V�n�d���=?UJ�j�3na��������Pn4w��$�:@ u�X��m�등��?ES(�6��#w�ְ�yF��-Mp����#p`}n3eb������`e'J�%��z� b{�n̥əmQ4C%��vQ �5��Z�@V$� iנ��&����t��K%�5߶���ʥz��B���`�Ul+����`���/�N�������(�) T.�QIH��{�g�R�z��K�&�Jϊ����Y��!�>��X5�a�;�=�v��s�:i$���)�f�����7��h�t����M�Сץ�X�1̶���X@�鯪�L�"�����gx��rK���-��4j݌��5�u��%��m�R����K������L���s�r5 O#�x^����8y�e�l����5Q�ms��CT'q��bd��'Ky�J� � �AN��fAë�� F�I?i�%\t�P��H���&4S�#Fi����ӓ+�yX��l%Y�Vᙋ�? ���~���M��E���t}��C�0*)h���l���Ů�� �t��-9�%��ȥ���qXpD��X�dP������o�;G �^���.NI n�җ�̨����:��srJ� BBGm�&������2���b��LW$�z�"�V��������l;��O¼8�N����yL��VTNC͏� ���_I ��wf�'�7���4�y�0�� ���n����}�ɒ��7���!p'�.�����R�2p�[4�r�C�H׎�����o$B�5Mqѯ��la�v>�����Yq�������P ԹLۣ�M�Z�����U�l?�|��m�v��7�����S�����1=2��9����!����%ٮ�a)<���Pm�<7�}'CF�� ����hz;��A����߃���f�o��!��_.G�s���h�����1��͇��x�?O����#�A���㧹�tws5���� v���p:�f |�:���7�����<��{�7��ᆓ/����U_��Lh����h��+�߂��'�7W<| ��9䄓����Ư��� ������̇��1������|�-x�x(�_>� q�����lD�!�@�����z8SN��< B�.h�'���=E�q����8��-P~ j��Fף���W�+����v��=���nn�dt ~��/z6��:�$9���~8��iFz:%*w�-o�pD�ꤣ�:����M��`�}� �0;��9 N���ˬ8�f�_�� ����p������0�$qL�������{z���?�_k���(�Y�|S�����y�f.!������i�OZ�q����ߕpv����� ��A

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Ok, looks like .htaccess is the solution.

dragonflycms.org/Wiki/id=135/ is helping only partially as

# CHANGE
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.*)$ - [L]
# TO
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?$1 [L]

is neither matching to my existing .htaccess in 9.4.0.0 nor to the new one in 10. The last RewriteRule is

RewriteRule .* - [L]

and because I never had much to do with regexes I don't know how to create a fully working .htaccess for my apache environment.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Sorry for so many posts but I want to give as much hints as possible. This drives me mad, the /?install page is only accessible via Firefox, the forum structure from the single successful update can be seen only via Edge...and still no repeatable way to update the forum.

Is it possible to easily separate the steps from the install/update script into single steps, each returning to the installer page? And then having the possibility to simply re-run the install/update script in case it failed at one point? This would make it easier to debug my problems and would remove hopefully timing issues.

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Could you post the entire content of your htaccess.
Do you still have a db backup.

Cheers

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.7 / PHP 7.3 / head


Hi NanoCaiordo,

thanks for helping, at the moment I use the one from the DF10 package.

Attached you'll find the one that was used over years upto current 9.4.0.0 which didn't do the trick, also with the suggested changes (as much as possbible for me).

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Hi NanoCaiordo,

thanks for helping, at the moment I use the one from the DF10 package.

Attached you'll find the one that was used over years upto current 9.4.0.0 which didn't do the trick, also with the suggested changes (as much as possbible for me).

Best regards
Lutz
Attachment: htaccess-df_9.4.0.0.txt
Description
Filename htaccess-df_9.4.0.0.txt
Filesize 2.93 KiB
Downloaded 1 Time(s)

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


Did you find anything helpful? Interestingly the /?install page is only working with Firefox...neither IE nore Edge nor Chrome works.

Still having problems with the timeout, the server hoster support is also not really helping.
I found traces of others having similar problems with Apache hardcoded timeouts. These should have been fixed in an early version of 2.4 (I think it was 2.4.8) but it looks like it could have been reimplemented in a later version.

Is there a way to execute the install/update script via php-cli so that apache is not able to interfer?

Best regards
Lutz

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


I did have a look at your htaccess and it seems there isn't any code you would need to port, so I'd say you only need to use htaccess shipped with v10.

Replace with original v10, wait for a minute or hit the site in random pages while asking your browser to "force relaod" (ctrl + f5; ctrl + r). This is needed to push the new htaccess into cachings.

After you browse the site with the updated version and everything is ok, try to reproduce each above issues.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.7 / PHP 7.3 / head

Last edited by NanoCaiordo on Fri Apr 03, 2020 12:30 pm; edited 2 times in total


Thanks for the advise!

I understand that I should upload the files and database of DF9.4.0.0 to the new server, change the .htaccess to the df10 provided one and then try to use the forum as usual resp. forcing reloads to get the new .htaccess acting?

I tried that but I am afraid that the PHP version 7.1 is preventing me from doing that:

"Fatal error: Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /var/www/vhosts/<site-domain>/df9/includes/cmsinit.inc:70 Stack trace: #0 /var/www/vhosts/<site-domain>/df9/index.php(36): require_once() #1 {main} thrown in /var/www/vhosts/<site-domain>/df9/includes/cmsinit.inc on line 70"


Or was that ok to do so and now copy the df10 install files into the folder? I had the impression that .htaccess changes had immediate effect.

I hoped there is a way to break the updating process into multiple pages...but I can't do so, I am no PHP coder.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Debian/2.2./5.5.60/5.6.40/9.4.0.0


I've missed to make clear about using:

v9, including it's htaccess, with PHP5
v10, including it's htaccess, with PHP7

so in case you want to upgrade and you are already running PHP7, upload v10, hit /?install and try again.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.7 / PHP 7.3 / head

All times are UTC


Jump to: