First time I've had any problems to report with a vB upgrade but when I switched to 4.2 from 4.1.12 some issues did arise. I don't know if they're all bugs or something I've done but they've not occured before.
1. Incorrect time on External Data Feed (JS).
When I call the output from EXTERNAL.PHP (defaults to RSS) the time on my latest threat via our test forum is accurate.
24 August 2012 15:46
But when I load the JS type (external.php?type=js), which is what I normally use, it outputs the time for that same thread as "01:46 PM". The forum time settings are correct, as is the setting on my admin profile.
How to fix this as otherwise my feed output is all out by 2 hours?
2. My main forum page always forces back to forum.php instead of index.php as before.
It looks like Activity Stream, which is a hedious thing, has changed the way navigation is handled. Anyway I unchecked all the "Active" bits Admin CP > Settings > Navigation Manager to disable it and then set my 'Forum' to default. But now everytime I press the home link in Navbar (this links back to my /forum/index.php file) it annoying converts that to load as /forum/forum.php.
I need to get this back to how it was before so that when /forum/index.php is called it stays as index.php and isn't magically changed to forum.php. How can I do that (note: my index.php source file already calls require('forum.php'); as I don't use the CMS)?
3. Can't remove the CMS Product (MySQL Error)
After the upgrade I went to remove the BLOG and CMS products as per usual (I never wanted the CMS/Blog and always have to remove it after the install). The Blog product disabled and removed fine. The CMS disabled fine but when trying to remove the CMS is throws out this (never happened before, it's always removed fine in the past):
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT MAX(permissions & 1) AS perm
FROM vb4_cms_permissions
WHERE nodeid = 1 AND usergroupid IN (6);
MySQL Error : Table 'db************.vb4_cms_permissions' doesn't exist
Error Number : 1146
Request Date : Friday, August 24th 2012 @ 05:07:29 PM
Error Date : Friday, August 24th 2012 @ 05:07:29 PM
Script : ************/index.php
Referrer : ************/forum.php
IP Address : 2.************
Username : ************
Classname : vB_Database
MySQL Version : 5.0.92-1~ui60+1
I then tried again and now always get this:
Database error in vBulletin 4.2.0:
Invalid SQL:
DELETE cms_widgettype, cms_widget, cms_widgetconfig
FROM vb4_package AS package
LEFT JOIN vb4_cms_widgettype AS cms_widgettype
ON cms_widgettype.packageid = package.packageid
LEFT JOIN vb4_cms_widget AS cms_widget
ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
LEFT JOIN vb4_cms_widgetconfig AS cms_widgetconfig
ON cms_widgetconfig.widgetid = cms_widget.widgetid
WHERE package.productid = 'vbcms';
MySQL Error : Table 'db******.vb4_cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Friday, August 24th 2012 @ 05:32:08 PM
Error Date : Friday, August 24th 2012 @ 05:32:09 PM
Script : **************/admincp/plugin.php?do=productkill
Referrer : **************/admincp/plugin.php?do=productdelete&productid=vbcms&s=
IP Address : 2.220******
Username : ******
Classname : vB_Database
MySQL Version : 5.0.92-1~ui60+1
Not a huge issue as I can just disable the CMS but still, I want it gone.
1. Incorrect time on External Data Feed (JS).
When I call the output from EXTERNAL.PHP (defaults to RSS) the time on my latest threat via our test forum is accurate.
24 August 2012 15:46
But when I load the JS type (external.php?type=js), which is what I normally use, it outputs the time for that same thread as "01:46 PM". The forum time settings are correct, as is the setting on my admin profile.
How to fix this as otherwise my feed output is all out by 2 hours?
2. My main forum page always forces back to forum.php instead of index.php as before.
It looks like Activity Stream, which is a hedious thing, has changed the way navigation is handled. Anyway I unchecked all the "Active" bits Admin CP > Settings > Navigation Manager to disable it and then set my 'Forum' to default. But now everytime I press the home link in Navbar (this links back to my /forum/index.php file) it annoying converts that to load as /forum/forum.php.
I need to get this back to how it was before so that when /forum/index.php is called it stays as index.php and isn't magically changed to forum.php. How can I do that (note: my index.php source file already calls require('forum.php'); as I don't use the CMS)?
3. Can't remove the CMS Product (MySQL Error)
After the upgrade I went to remove the BLOG and CMS products as per usual (I never wanted the CMS/Blog and always have to remove it after the install). The Blog product disabled and removed fine. The CMS disabled fine but when trying to remove the CMS is throws out this (never happened before, it's always removed fine in the past):
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT MAX(permissions & 1) AS perm
FROM vb4_cms_permissions
WHERE nodeid = 1 AND usergroupid IN (6);
MySQL Error : Table 'db************.vb4_cms_permissions' doesn't exist
Error Number : 1146
Request Date : Friday, August 24th 2012 @ 05:07:29 PM
Error Date : Friday, August 24th 2012 @ 05:07:29 PM
Script : ************/index.php
Referrer : ************/forum.php
IP Address : 2.************
Username : ************
Classname : vB_Database
MySQL Version : 5.0.92-1~ui60+1
I then tried again and now always get this:
Database error in vBulletin 4.2.0:
Invalid SQL:
DELETE cms_widgettype, cms_widget, cms_widgetconfig
FROM vb4_package AS package
LEFT JOIN vb4_cms_widgettype AS cms_widgettype
ON cms_widgettype.packageid = package.packageid
LEFT JOIN vb4_cms_widget AS cms_widget
ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
LEFT JOIN vb4_cms_widgetconfig AS cms_widgetconfig
ON cms_widgetconfig.widgetid = cms_widget.widgetid
WHERE package.productid = 'vbcms';
MySQL Error : Table 'db******.vb4_cms_widgettype' doesn't exist
Error Number : 1146
Request Date : Friday, August 24th 2012 @ 05:32:08 PM
Error Date : Friday, August 24th 2012 @ 05:32:09 PM
Script : **************/admincp/plugin.php?do=productkill
Referrer : **************/admincp/plugin.php?do=productdelete&productid=vbcms&s=
IP Address : 2.220******
Username : ******
Classname : vB_Database
MySQL Version : 5.0.92-1~ui60+1
Not a huge issue as I can just disable the CMS but still, I want it gone.
Comment