Geeklog 1.61 to glFusion 1.20 pl5 and lost the Forum

	Forum Index > glFusion > glFusion Support
Geeklog 1.61 to glFusion 1.20 pl5 and lost the Forum

Printable Version

By: richardbkk (offline) Jul 24 2010 06:44 am (Read 1691 times)

richardbkk

We upgraded one of our last Geeklog 1.61 websites to glFusion 1.20, and we got a few problems. The first and most important problem is that the forum doesn't work...

In configuration I have no forum settings option and if I go to domain.com/forum/index.php I get a black screen. The error.log says the following....

PHP Formatted Code
Sat 24 Jul 2010 16:58:10 ICT - 1054: Unknown column 'rating_post' in 'field list'. SQL in question: SELECT forum_id AS forum,is_readonly,grp_id,rating_post FROM gl_forum_forums WHERE forum_id=18 

Sat 24 Jul 2010 16:59:19 ICT - 1054: Unknown column 'forum.rating_post' in 'field list'. SQL in question: SELECT forum.forum_name,forum.forum_id AS forum, category.cat_name,category.id,forum.is_readonly,forum.grp_id,forum.rating_post,forum.rating_view FROM gl_forum_forums forum LEFT JOIN gl_forum_categories category on category.id=forum.forum_cat WHERE forum.forum_id = 2 

Sat 24 Jul 2010 17:08:11 ICT - 1054: Unknown column 'forum.rating_post' in 'field list'. SQL in question: SELECT forum.forum_name,forum.forum_id AS forum, category.cat_name,category.id,forum.is_readonly,forum.grp_id,forum.rating_post,forum.rating_view FROM gl_forum_forums forum LEFT JOIN gl_forum_categories category on category.id=forum.forum_cat WHERE forum.forum_id = 19

The second problem is that I have two Geeklog plugins who don't want to remove... One is autotag and I would love to use the glFusion autotag which doesn't want to install because of the Geeklog autotag...

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: Mark (offline) Jul 24 2010 08:50 am

Mark

Let's check the Plugins page to make sure the plugins actually updated and don't show that they need to update. Go to Command & Control -> Plugins and see if any show they need to update. If they do, go ahead and run the update.

If you are still having problems, I'll whip up a little utility to force the DB changes.

Thanks!
Mark

glFusion - Enhanced Content Management

Admin

Group Comfort
Level:: +104

Registered: 10/21/05
Posts: 5904
Location: The Great State of
Texas

By: richardbkk (offline) Jul 24 2010 09:18 am

richardbkk

The forum plugin seems like it is installed correctly

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: Mark (offline) Jul 24 2010 09:24 am

Mark

OK, let's give this little utility a try. Grab the dvlpupdate.php that is attached to this post and place it in the public_html/admin/install/ directory. You must be logged into the site as a root user, then run the script (http://www.yoursitehere.com/admin/install/dvlpupdate.php). This should force all the necessary configuration and database changes to get the forum back up and running.

Thanks!
Mark

dvlpupdate.zip

glFusion - Enhanced Content Management

Admin

Group Comfort
Level:: +104

Registered: 10/21/05
Posts: 5904
Location: The Great State of
Texas

By: richardbkk (offline) Jul 24 2010 09:48 am

richardbkk

I try to run dvlpupdate.php and get a SQL error see error.log

here the error.log

PHP Formatted Code
Sat 24 Jul 2010 18:45:06 ICT - Log file reset

Sat 24 Jul 2010 19:09:19 ICT - 1054: Unknown column 'b.rating_post' in 'field list'. SQL in question: SELECT a.forum,a.pid,a.locked,a.subject,a.replies,b.forum_cat,b.forum_name,b.is_readonly,b.grp_id,b.rating_post,c.cat_name,c.id FROM gl_forum_topic a LEFT JOIN gl_forum_forums b ON b.forum_id=a.forum LEFT JOIN gl_forum_categories c on c.id=b.forum_cat WHERE a.id=45 

Sat 24 Jul 2010 19:15:15 ICT - 1054: Unknown column 'forum.rating_post' in 'field list'. SQL in question: SELECT forum.forum_name,forum.forum_id AS forum, category.cat_name,category.id,forum.is_readonly,forum.grp_id,forum.rating_post,forum.rating_view FROM gl_forum_forums forum LEFT JOIN gl_forum_categories category on category.id=forum.forum_cat WHERE forum.forum_id = 4 

Sat 24 Jul 2010 19:21:27 ICT - CheckToken: Token failed - no token found or more than 1 token found in database 

Sat 24 Jul 2010 19:34:05 ICT - 1054: Unknown column 'rating_post' in 'field list'. SQL in question: SELECT forum_id AS forum,is_readonly,grp_id,rating_post FROM gl_forum_forums WHERE forum_id=5 

Sat 24 Jul 2010 20:16:03 ICT - 1054: Unknown column 'rating_post' in 'field list'. SQL in question: SELECT forum_id AS forum,is_readonly,grp_id,rating_post FROM gl_forum_forums WHERE forum_id=9 

Sat 24 Jul 2010 21:32:10 ICT - 1054: Unknown column 'b.rating_post' in 'field list'. SQL in question: SELECT a.forum,a.pid,a.locked,a.subject,a.replies,b.forum_cat,b.forum_name,b.is_readonly,b.grp_id,b.rating_post,c.cat_name,c.id FROM gl_forum_topic a LEFT JOIN gl_forum_forums b ON b.forum_id=a.forum LEFT JOIN gl_forum_categories c on c.id=b.forum_cat WHERE a.id=68 

Sat 24 Jul 2010 21:35:35 ICT - 1146: Table 'travelv1_gklg2.gl_am_autotags' doesn't exist. SQL in question: SELECT * FROM gl_am_autotags WHERE is_enabled = 1 

Sat 24 Jul 2010 21:35:47 ICT - 1146: Table 'travelv1_gklg2.gl_am_autotags' doesn't exist. SQL in question: SELECT * FROM gl_am_autotags WHERE is_enabled = 1 

Sat 24 Jul 2010 21:35:55 ICT - 1146: Table 'travelv1_gklg2.gl_am_autotags' doesn't exist. SQL in question: SELECT * FROM gl_am_autotags WHERE is_enabled = 1 

Sat 24 Jul 2010 21:35:59 ICT - 1146: Table 'travelv1_gklg2.gl_am_autotags' doesn't exist. SQL in question: SELECT * FROM gl_am_autotags WHERE is_enabled = 1 

Sat 24 Jul 2010 21:36:05 ICT - 1146: Table 'travelv1_gklg2.gl_am_autotags' doesn't exist. SQL in question: SELECT * FROM gl_am_autotags WHERE is_enabled = 1 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => 

    CREATE TABLE gl_commentedits (

      cid int(10) NOT NULL,

      uid mediumint(8) NOT NULL,

      time datetime NOT NULL,

      PRIMARY KEY (cid)

    ) TYPE=MYISAM

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_comments ADD name varchar(32) default NULL AFTER indent 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_stories ADD comment_expire datetime NOT NULL default '0000-00-00 00:00:00' AFTER comments 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => REPLACE INTO gl_vars (name, value) VALUES ('database_version', '1') 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_syndication CHANGE type type varchar(30) NOT NULL default 'article' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE gl_syndication SET type = 'article' WHERE type = 'geeklog' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE gl_syndication SET type = 'article' WHERE type = 'glfusion' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE  SET type='select',default_value='s:10:"US/Central";' WHERE name='timezone' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE  SET value='s:10:"US/Central";' WHERE name='timezone' AND value='' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => REPLACE INTO gl_vars (name, value) VALUES ('glfusion', '1.1.0svn') 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_staticpage ADD sp_search tinyint(4) NOT NULL default '1' AFTER postmode 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_blocks DROP INDEX blocks_bid 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_events DROP INDEX events_eid 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_forum_forums DROP INDEX forum_id 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_group_assignments DROP INDEX ug_main_grp_id 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_polltopics DROP INDEX pollquestions_pid 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_sessions DROP INDEX sess_id 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_stories DROP INDEX stories_sid 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_userindex DROP INDEX userindex_uid 

Sat 24 Jul 2010 21:44:55 ICT - glFusion: Running code update for glFusion v1.1.2svn 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.3 Development update: Executing SQL => ALTER TABLE gl_users ADD remote_ip varchar(15) default NULL AFTER num_reminders 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.4 Development update: Executing SQL => UPDATE gl_conf_values SET type='passwd' WHERE name='mail_smtp_password' LIMIT 1 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.5 Development update: Executing SQL => ALTER TABLE gl_users CHANGE username username varchar (48) NOT NULL default '' 

Sat 24 Jul 2010 21:44:55 ICT - glFusion 1.1.5 Development update: Executing SQL => ALTER TABLE gl_topics CHANGE sortnum sortnum mediumint(8) default NULL 

Sat 24 Jul 2010 21:44:56 ICT - glFusion 1.1.7 Development update: Executing SQL => CREATE TABLE IF NOT EXISTS gl_rating (

                `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

                `type` varchar(254) NOT NULL DEFAULT '',

                `item_id` varchar(40) NOT NULL,

                `votes` int(11) NOT NULL,

                `rating` decimal(4,2) NOT NULL,

                KEY `id` (`id`)

              ) Type=MyISAM; 

Sat 24 Jul 2010 21:44:56 ICT - glFusion 1.1.7 Development update: Executing SQL => CREATE TABLE IF NOT EXISTS gl_rating_votes (

                 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

                 `type` varchar(254) NOT NULL DEFAULT '',

                 `item_id` varchar(40) NOT NULL,

                 `uid` mediumint(8) NOT NULL,

                 `ip_address` varchar(14) NOT NULL,

                 `ratingdate` int(11) NOT NULL,

                 PRIMARY KEY (`id`),

                 KEY `uid` (`uid`),

                 KEY `ip_address` (`ip_address`),

                 KEY `type` (`type`)

               ) TYPE=MyISAM; 

Sat 24 Jul 2010 21:44:56 ICT - glFusion 1.1.7 Development update: Executing SQL => ALTER TABLE gl_stories ADD `rating` float NOT NULL DEFAULT '0' AFTER hits 

Sat 24 Jul 2010 21:44:56 ICT - glFusion 1.1.7 Development update: Executing SQL => ALTER TABLE gl_stories ADD `votes` int(11) NOT NULL DEFAULT '0' AFTER rating 

Sat 24 Jul 2010 21:44:56 ICT - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE votes > 0' at line 1. SQL in question: SELECT * FROM  WHERE votes > 0 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => 

    CREATE TABLE gl_commentedits (

      cid int(10) NOT NULL,

      uid mediumint(8) NOT NULL,

      time datetime NOT NULL,

      PRIMARY KEY (cid)

    ) TYPE=MYISAM

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_comments ADD name varchar(32) default NULL AFTER indent 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_stories ADD comment_expire datetime NOT NULL default '0000-00-00 00:00:00' AFTER comments 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => REPLACE INTO gl_vars (name, value) VALUES ('database_version', '1') 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_syndication CHANGE type type varchar(30) NOT NULL default 'article' 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE gl_syndication SET type = 'article' WHERE type = 'geeklog' 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE gl_syndication SET type = 'article' WHERE type = 'glfusion' 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE  SET type='select',default_value='s:10:"US/Central";' WHERE name='timezone' 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => UPDATE  SET value='s:10:"US/Central";' WHERE name='timezone' AND value='' 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => REPLACE INTO gl_vars (name, value) VALUES ('glfusion', '1.1.0svn') 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_staticpage ADD sp_search tinyint(4) NOT NULL default '1' AFTER postmode 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_blocks DROP INDEX blocks_bid 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_events DROP INDEX events_eid 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_forum_forums DROP INDEX forum_id 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_group_assignments DROP INDEX ug_main_grp_id 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_polltopics DROP INDEX pollquestions_pid 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_sessions DROP INDEX sess_id 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_stories DROP INDEX stories_sid 

Sat 24 Jul 2010 21:45:07 ICT - glFusion 1.1.0svn Development update: Executing SQL => ALTER TABLE gl_userindex DROP INDEX userindex_uid 

Sat 24 Jul 2010 21:45:08 ICT - glFusion: Running code update for glFusion v1.1.2svn 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.3 Development update: Executing SQL => ALTER TABLE gl_users ADD remote_ip varchar(15) default NULL AFTER num_reminders 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.4 Development update: Executing SQL => UPDATE gl_conf_values SET type='passwd' WHERE name='mail_smtp_password' LIMIT 1 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.5 Development update: Executing SQL => ALTER TABLE gl_users CHANGE username username varchar (48) NOT NULL default '' 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.5 Development update: Executing SQL => ALTER TABLE gl_topics CHANGE sortnum sortnum mediumint(8) default NULL 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.7 Development update: Executing SQL => CREATE TABLE IF NOT EXISTS gl_rating (

                `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

                `type` varchar(254) NOT NULL DEFAULT '',

                `item_id` varchar(40) NOT NULL,

                `votes` int(11) NOT NULL,

                `rating` decimal(4,2) NOT NULL,

                KEY `id` (`id`)

              ) Type=MyISAM; 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.7 Development update: Executing SQL => CREATE TABLE IF NOT EXISTS gl_rating_votes (

                 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

                 `type` varchar(254) NOT NULL DEFAULT '',

                 `item_id` varchar(40) NOT NULL,

                 `uid` mediumint(8) NOT NULL,

                 `ip_address` varchar(14) NOT NULL,

                 `ratingdate` int(11) NOT NULL,

                 PRIMARY KEY (`id`),

                 KEY `uid` (`uid`),

                 KEY `ip_address` (`ip_address`),

                 KEY `type` (`type`)

               ) TYPE=MyISAM; 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.7 Development update: Executing SQL => ALTER TABLE gl_stories ADD `rating` float NOT NULL DEFAULT '0' AFTER hits 

Sat 24 Jul 2010 21:45:08 ICT - glFusion 1.1.7 Development update: Executing SQL => ALTER TABLE gl_stories ADD `votes` int(11) NOT NULL DEFAULT '0' AFTER rating 

Sat 24 Jul 2010 21:45:08 ICT - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE votes > 0' at line 1. SQL in question: SELECT * FROM  WHERE votes > 0

plus now the whole website not work, get a black screen - if I do ctrl+a I get "Fatal error: Cannot use string offset as an array in /home8/travelv1/public_html/nun/system/lib-syndication.php on line 484"

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: richardbkk (offline) Jul 24 2010 10:01 am

richardbkk

I was able to disable the feeds, so get a normal screen. I now get ...

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: richardbkk (offline) Jul 24 2010 10:04 am

richardbkk

After running upgrade script I get this

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: Mark (offline) Jul 24 2010 10:06 am

Mark

We're close, replace the old dvlpupdate.php with this new one and run it. I think that should get you going.

Thanks!
Mark

dvlpupdate.zip

glFusion - Enhanced Content Management

Admin

Group Comfort
Level:: +104

Registered: 10/21/05
Posts: 5904
Location: The Great State of
Texas

By: richardbkk (offline) Jul 24 2010 10:15 am

richardbkk

Okay this time dvlpupdate.php did run smooth no errors, if I now look at the configuration options, I have forum but it only shows...

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: Mark (offline) Jul 24 2010 10:17 am

Mark

Hmmm, well is the Forum at least working now without error? What I'm going to have to do is write a quick / dirty app to rebuild the configuration settings (not sure why the others disappeared...). This will take me a bit more time, so I want to make sure the site is at least working for now.

Thanks!
Mark

glFusion - Enhanced Content Management

Admin

Group Comfort
Level:: +104

Registered: 10/21/05
Posts: 5904
Location: The Great State of
Texas

By: richardbkk (offline) Jul 24 2010 10:21 am

richardbkk

Yes forum works, no centerblock but at least a link to the forum works http://nun.pai-nai.com

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: Mark (offline) Jul 24 2010 10:26 am

Mark

I was able to use the existing configuration initialization code with just a minor modification to make it work standalone.

Download rebuild_cfg.php and place it in the public_html/forum/ directory and then run it:

http://www.yoursitehere.com/forum/rebuild_cfg.php

After it runs, you'll want to check to see if all the configuration options are there and then delete rebuild_cfg.php.

Thanks!
Mark

rebuild_cfg.zip

glFusion - Enhanced Content Management

Admin

Group Comfort
Level:: +104

Registered: 10/21/05
Posts: 5904
Location: The Great State of
Texas

By: richardbkk (offline) Jul 24 2010 10:32 am

richardbkk

Okay I just found another weird thing normally "Show Digg.com Links" -False/True is on the Configuration page "Stories and Trackback", but on my latest upgraded website "Show Digg.com Links" is on Configuration page "Miscellaneous" tab Miscellaneous...

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: richardbkk (offline) Jul 24 2010 10:45 am

richardbkk

Is it maybe possible that some files are still from the old Geeklog 1.6.1 installation? I basically copied all glFusion files over Geeklog... I copied the files by extracting a glfusion.tar.gz file on the server so its unlikely that I missed any files...

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand

By: richardbkk (offline) Jul 24 2010 22:03 pm

richardbkk

Okay forum is back and fully functional, I fixed it the hard way removed the plugin and reinstalled the forum plugin. Now it's back to normal -also in configuration -> forum

Active Member

Group Comfort
Level:: +4

Registered: 07/29/08
Posts: 415
Location: Bangkok, Thailand