Welcome to Geeklog, Anonymous Saturday, June 15 2024 @ 01:17 pm EDT

Geeklog Forums

Upgrade from 1.7.2 to 2.1.0

Status: Banned


Forum User
Full Member
Registered: 11/05/03
Posts: 121
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, '', 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


Site Admin
Registered: 09/27/05
Posts: 1468
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:


One of the Geeklog Core Developers.

All times are EDT. The time is now 01:17 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