Organizr: Clicked autoupgrade, everything died.

[untotren]

It tells me to register, then says it's not a correct URL. I click login and use my old admin credentials, then I get a fun error:

Error: Only HTTP request are supported, please use cURL to add HTTPS support! (https://myembyurl.com)

[causefx]

What OS are you on?

Sent from my iPhone

On May 15, 2017, at 2:14 AM, untotren [e-mail] wrote:

It tells me to register, then says it's not a correct URL. I click login and use my old admin credentials, then I get a fun error:

Error: Only HTTP request are supported, please use cURL to add HTTPS support! (https://myembyurl.com)

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.

[untotren]

Windows 7 Ultimate

[untotren]

It's a hyperv image, but I am just using a stock NGINX setup

[jowy]

same happened here. Ubuntu everything stock

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 no such column: order in /var/www/Organizr/index.php:120 Stack trace: #0 /var/www/Organizr/index.php(120): PDO->query('SELECT * FROM t...') #1 {main} thrown in /var/www/Organizr/index.php on line 120

[andrewparra]

I am seeing the same error as Jowy after clicking Auto Upgrade. Running on Mac.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 no such column: order in /Applications/MAMP/htdocs/index.php:120 Stack trace: #0 /Applications/MAMP/htdocs/index.php(120): PDO->query('SELECT * FROM t...') #1 {main} thrown in /Applications/MAMP/htdocs/index.php on line 120

[causefx]

@jowy did you update today or earlier?

@andrewparra same question.

[andrewparra]

I updated today. I also clicked the manual download button before I auto-updated, and tried a clean install of that in the htmdocs directory. I was given the login page, but once logged in, I got the same error.

[causefx]

a clean install gave the same error, we will look into this, thank you.

[untotren]

@causefx Thank you for being so responsive and diligent, I know you have a life to tend to as well. Check your Hangouts/Gchat, I messaged you.

[causefx]

@untotren i didnt see anything on Hangouts. which email did you use?

[Cerothen]

Can everyone post the following so we can try and hammer it down:

OS:
OS Version:
Web Server:
Web Server Version
PHP Version:

For those of you that upgraded and had issues can you check your users.db/config.php directories and send all the .bak files (and the most recent non .bak version) in a zip package using gitter @cerothen. Only do this if your files are dated/versioned (users[2017-05-15_02-44-23][1.32].bak.db) since that will show all the steps that occured during the upgrade process.

[untotren]

In good conscious of my users, there is no way I can send you my user database... Hashed or not.

[causefx]

you could always delete the user part of the db.

[TwinMist]

I have the same problem

On 17 May 2017 at 04:20, causefx [e-mail] wrote:

you could always delete the user part of the db.

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/causefx/Organizr/issues/342#issuecomment-301974396,
or mute the thread
https://github.com/notifications/unsubscribe-auth/ADRHywfW2KI4SJQvHnTbaLRBtEAUuIcmks5r6md7gaJpZM4Na3Xu
.

[jowy]

Sent.

OS: Ubuntu
OS Version: 16.04.2 LTS (Kernel: 4.4.0-75-generic)
Web Server: nginx
Web Server Version: 1.10.0
PHP Version: 7.1.5-1+deb.sury.org~xenial+1

[jowy]

@causefx Sorry for late response... I upgraded an hour or so before my comment on May 15th

[Cerothen]

Anyone who had a failed upgrade but has backups and wants to try again please download: https://github.com/causefx/Organizr/tree/cero-dev and unpack/overwrite the directory and try again, this should resolve the issues.

[wessel145]

jowy commented 3 days ago • edited
same happened here. Ubuntu everything stock

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 no such column: order in /var/www/Organizr/index.php:120 Stack trace: #0 /var/ww

I got the same error after the auto update (before the update everything in check.php was green). can't seem to fix this...

Edit:
OS: Ubuntu server
OS Version: Xenial
Web Server: Apache
Web Server Version: 2.4.18
PHP Version: 7

Edit 2: [SOLVED]
Deleting the users.db file in /home/#user#/Organizr/ fixed the problem (since the error was in line 140 of index.php, which was a query for users), I lost all my settings etc because i didn't back-up (lesson learned). be careful with the auto update the next time aswell

[Cerothen]

Rolled new update into master, those with backups can restore and upgrade again those without @causefx apologizes for trusting me ;-).

[jowy]

Thanks, all!

[untotren]

Where are backups stored? I don't remember if I did but that sucks

[Cerothen]

Backups are stored with the original files. and have a .bak section to the filename