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

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...

   

richardbkk




Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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

   

Mark



Group Comfort
Level:
: +112
Registered:: 10/21/05

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

The forum plugin seems like it is installed correctly

Click on image to download

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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


glFusion - Enhanced Content Management

   

Mark



Group Comfort
Level:
: +112
Registered:: 10/21/05

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

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"

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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

Click on image to download

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

After running upgrade script I get this

Click on image to download

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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

Thanks!
Mark


glFusion - Enhanced Content Management

   

Mark



Group Comfort
Level:
: +112
Registered:: 10/21/05

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

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...

Click on image to download

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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

   

Mark



Group Comfort
Level:
: +112
Registered:: 10/21/05

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

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

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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:

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


glFusion - Enhanced Content Management

   

Mark



Group Comfort
Level:
: +112
Registered:: 10/21/05

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

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...

Click on image to download

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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...

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

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

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

   

richardbkk



Group Comfort
Level:
: +5
Registered:: 07/29/08

Posts: 462
15 posts :: Page 1 of 1
All times are CDT. The time is now 09:35 am.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic w/ New Post Sticky Topic w/ New Post
Locked Topic w/ New Post Locked Topic w/ New Post