ElkArte Community

Project Support => Support => Topic started by: gevv on October 30, 2016, 06:53:19 pm

Title: Upgrade error
Post by: gevv on October 30, 2016, 06:53:19 pm
Hi,

1.0.9 upgrade Error
Error retrieving information on step: Adding new columns... (Item: 20)


I tried again has gone first error

new error
Executing: "" (0 of
Notice: Undefined index: total_items in install/TemplateUpgrade.php on line 785
)
Title: Re: Upgrae error
Post by: emanuele on October 30, 2016, 09:06:28 pm
Hi gevv, I moved your post to a topic because it's easier to work on things if each problem is a topic. ;)

So, you are trying to upgrade from 1.0.9 to 1.1 B3, correct?

Could you check in the database if the table elkarte_user_drafts has a column named "is_usersaved"?
Title: Re: Upgrade error
Post by: gevv on October 30, 2016, 09:12:02 pm
Hi gevv, I moved your post to a topic because it's easier to work on things if each problem is a topic. ;)

So, you are trying to upgrade from 1.0.9 to 1.1 B3, correct?

Could you check in the database if the table elkarte_user_drafts has a column named "is_usersaved"?

yes 1.0.9 to 1.1 B3  

is_usersaved  ok   all values are 0
Title: Re: Upgrade error
Post by: gevv on October 30, 2016, 09:30:52 pm
I empty the table elkarte_user_drafts the problem continues

Executing: "" (0 of
Notice: Undefined index: total_items in /home3/elektron/public_html/install/TemplateUpgrade.php on line 785
)
Title: Re: Upgrade error
Post by: emanuele on October 31, 2016, 08:19:01 am
I empty the table elkarte_user_drafts the problem continues
There was no reason for that. I knew already that empting the table wouldn't fix anything.
I hope you are running the upgrade on a test site, right? (Just because in ay case it's always better to run a test before doing an upgrade with a beta version. ;))

Anyway, check the table elkarte_attachments, the column "mime_type" is a varchar 20 or 255?
Title: Re: Upgrade error
Post by: gevv on October 31, 2016, 09:47:27 am
varchar 255
Title: Re: Upgrade error
Post by: gevv on November 01, 2016, 08:50:43 am
Hi,

No update is complete (TemplateUpgrade.php on line 785) , but the forum is working

No such problem

New features works



Do you have a way to go back to the old (1.0.9) version?
Title: Re: Upgrade error
Post by: emanuele on November 01, 2016, 03:17:10 pm
varchar 255
Then the update finished properly... (Actually there would be another step, but it's not so important[1].)
It could be the same problem I that was reported regarding the upgrade fail if there are no steps to perform... It's somehow random and difficult to pinpoint though. :-\
If you use the calendar, open the elkarte_settings table and insert a new entry with "variable" set to "cal_limityear" and value 10
Title: Re: Upgrade error
Post by: Keiro on November 10, 2019, 09:11:36 am
Seems like I got bit by this bug too, this time from 1.1.5 to 1.1.6.

PHP 7.2, PHP-FPM and Apache. MariaDB 10.4 on Ubuntu.

Code: [Select]
[Sun Nov 10 07:47:45.958299 2019] [php7:notice] [pid 5830] [client 172.69.63.102:44892] PHP Notice:  Undefined index: total_items in /var/www/html/forum/install/TemplateUpgrade.php on line 785, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 07:47:45.958611 2019] [php7:notice] [pid 5830] [client 172.69.63.102:44892] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 786, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 07:47:45.958633 2019] [php7:notice] [pid 5830] [client 172.69.63.102:44892] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 823, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 07:48:49.886009 2019] [php7:notice] [pid 5827] [client 172.69.63.102:58182] PHP Notice:  Undefined index: total_items in /var/www/html/forum/install/TemplateUpgrade.php on line 785, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 07:48:49.886062 2019] [php7:notice] [pid 5827] [client 172.69.63.102:58182] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 786, referer: https://forum.freedomofform.org/install/upgrade.php?step=1&
[Sun Nov 10 07:48:49.886078 2019] [php7:notice] [pid 5827] [client 172.69.63.102:58182] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 823, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 08:01:23.255994 2019] [php7:notice] [pid 5827] [client 172.69.63.102:40724] PHP Notice:  Undefined index: total_items in /var/www/html/forum/install/TemplateUpgrade.php on line 785, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 08:01:23.256042 2019] [php7:notice] [pid 5827] [client 172.69.63.102:40724] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 786, referer: https://forum.freedomofform.org/install/upgrade.php
[Sun Nov 10 08:01:23.256059 2019] [php7:notice] [pid 5827] [client 172.69.63.102:40724] PHP Notice:  Undefined index: debug_items in /var/www/html/forum/install/TemplateUpgrade.php on line 823, referer: https://forum.freedomofform.org/install/upgrade.php

Checked the table and it's set to varchar 255. The calyear database entry is also present, so... not sure what the trigger was this time.

Regards,

Keiro