Welcome to Geeklog Saturday, September 21 2019 @ 09:33 pm EDT

Geeklog Forums

Upgrade from 1.7.2 to 2.1.0


Status: offline

gtgillis

Forum User
Full Member
Registered: 05/11/03
Posts: 121
Location:Spring, TX
I am trying to update a site from 1.7.2 to 2.1.0

I copied all of the 2.1.0 files to the server and used the URL http://www.mysite.net/admin/install/index.php and when prompted with "Step 1 - Choose an Installation Method" I selected upgrade.

I get a blank page on the URL http://www.mysite.net/admin/install/index.php?mode=upgrade&step=3&dbconfig_path=/home2/mysite/db-config.php&language=english&version=1.7.2

When I checked the error log I found the following which looks like the tables are not getting upgraded.

Sat Dec 13 08:48:53 2014 - 173.0.54.xxx - 1054: Unknown column 'whos_online' in 'field list' in /home2/mysite/system/lib-sessions.php:364. SQL in question: INSERT INTO gl_sessions (sess_id, uid, start_time, remote_ip, whos_online) VALUES (1270527288, 1, 1418485733, '173.0.54.232', 1)
Sat Dec 13 08:48:53 2014 - 173.0.54.xxx - E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ /home2/mysite/system/databases/mysqli.class.php line 279

When I try the main site page I get the error "Unfortunately, an error has occurred rendering this page. Please try again later." with the same error log message as above.

The server is running PHP Version 5.2.17 and mySQL version 5.1.66.

Anyone have any idea's?

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1378
Hmmm... It has been a while since I looked at upgrades but yours has failed for some reason. It is probably missing more than just the whos_online column (which was introduced in Geeklog 2.0.0). You could try adding that column and see.

A few others have also had this problem. There might be a few clues in this topic:

https://www.geeklog.net/forum/viewtopic.php?showtopic=95585


One of the Geeklog Core Developers.

All times are EDT. The time is now 09:33 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content