The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 41 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Sat Jun 23, 2012 9:19 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
It's all coming back to me! Well, some of it is. I think I used J2xml when migrating from 1.5 Anyway, I have now uninstalled it but still no missing buttons have appeared. Checked the DB and that seems ok. Here's the message;

Database schema version (in #__schemas): 2.5.6.
Update version (in #__extensions): 2.5.6.
Database [drive]: mysqli.
66 database changes were checked successfully.
24 database changes did not alter table structure and were skipped.


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 5:57 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
I gave humvee's 'Plan A' another try and overwrote the existing 2.5.6 live website installation with the full 2.5.6 core package [barring the installation directory] but the back end CP remains as before! 12 rather than 14 'buttons' [Joomla Update and Extension buttons still missing] and Joomla version not displayed. Where in the package would they be called from? Would they appear listed under Extension Manager:Manage ? If so, would a list of what is there [or access to it] help?


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 6:29 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
Here's a list anyway. If I knew how I could post as a table or insert a link to a PDF version!

    NAME LOCATION TYPE VERSION
    Administrator Menu Administrator Module 2.5.0
    Admin sub-Menu Administrator Module 2.5.0
    Admin - System Infos Administrator Component 2.5.0
    Akeeba Administrator Component 3.5.2
    Akeeba Backup Lazy Scheduling Site Plugin 3.3
    Akeeba Backup Notification Module Administrator Module 3.4.3
    Archived Articles Site Module 2.5.0
    ARI YUI Menu Site Module 2.0.1
    Articles Administrator Component 2.5.0
    Articles Categories Site Module 2.5.0
    Articles Category Site Module 2.5.0
    Articles - Newsflash Site Module 2.5.0
    Articles - Related Articles Site Module 2.5.0
    atomic Site Template 2.5.0
    atomic-9head Site Template 1.6.0
    Authentication - GMail Site Plugin 2.5.0
    Authentication - Joomla Site Plugin 2.5.0
    Authentication - LDAP Site Plugin 2.5.0
    Banners Site Module 2.5.0
    Banners Administrator Component 2.5.0
    beez_20 Site Template 2.5.0
    beez5 Site Template 2.5.0
    bluestork Administrator Template 2.5.0
    Breadcrumbs Site Module 2.5.0
    Button - Article Site Plugin 2.5.0
    Button - Image Site Plugin 2.5.0
    Button - Pagebreak Site Plugin 2.5.0
    Button - Readmore Site Plugin 2.5.0
    Cache Manager Administrator Component 2.5.0
    Categories Administrator Component 2.5.0
    Checkin Administrator Component 2.5.0
    Configuration Manager Administrator Component 2.5.0
    Contacts Administrator Component 2.5.0
    Content - Code Highlighter (GeSHi) Site Plugin 2.5.0
    Content - Email Cloaking Site Plugin 2.5.0
    Content - Joomla Site Plugin 2.5.0
    Content - Load Modules Site Plugin 2.5.0
    Content - Pagebreak Site Plugin 2.5.0
    Content - Page Navigation Site Plugin 2.5.0
    Content - Vote Site Plugin 2.5.0
    Control Panel Administrator Component 2.5.0
    Custom HTML Administrator Module 2.5.0
    Custom HTML Site Module 2.5.0
    Editor - CodeMirror Site Plugin 1
    Editor - None Site Plugin 2.5.0
    Editor - TinyMCE Site Plugin 3.5.2
    English (United Kingdom) Administrator Language 2.5.5
    English (United Kingdom) Site Language 2.5.5
    Extension - Joomla Site Plugin 2.5.0
    Feed Display Administrator Module 2.5.0
    Feed Display Site Module 2.5.0
    Footer Site Module 2.5.0
    Google Maps Site Plugin 2.131c
    hathor Administrator Template 2.5.0
    Installation Manager Administrator Component 2.5.0
    JMonitoring - Akeeba Backup Site Plugin 1
    Joomla CMS Site File 2.5.6
    Joomla! Content Management System Site Package 2.5.0
    Joomla! Platform Site Library 11.4
    Language Manager Administrator Component 2.5.0
    Language Switcher Site Module 2.5.0
    Latest News Administrator Module 2.5.0
    Latest News Site Module 2.5.0
    Latest Users Site Module 2.5.0
    Logged-in Users Administrator Module 2.5.0
    Login Administrator Component 2.5.0
    Login Site Module 2.5.0
    Login Form Administrator Module 2.5.0
    Mail to Site Component 2.5.0
    Media Manager Administrator Component 2.5.0
    Menu Site Module 2.5.0
    Menus Manager Administrator Component 2.5.0
    Messaging Administrator Component 2.5.0
    Module Manager Administrator Component 2.5.0
    Most Read Content Site Module 2.5.0
    Multilanguage Status Administrator Module 2.5.0
    Multithumb Site Plugin 3.0.RC4
    Newsfeeds Administrator Component 2.5.0
    Panoramic Image Viewer Site Plugin 1.2.1
    PHPMailer Site Library 5.2
    phputf8 Site Library 0.5
    Plugins Manager Administrator Component 2.5.0
    Popular Articles Administrator Module 2.5.0
    Quick Icons Administrator Module 2.5.0
    Random Image Site Module 2.5.0
    Redirect Administrator Component 2.5.0
    Search Administrator Component 2.5.0
    Search Site Module 2.5.0
    Search - Categories Site Plugin 2.5.0
    Search - Contacts Site Plugin 2.5.0
    Search - Content Site Plugin 2.5.0
    Search - Newsfeeds Site Plugin 2.5.0
    Search - Weblinks Site Plugin 2.5.0
    showplus Site Module 1.0.4.5
    SimplePie Site Library 1.2
    Statistics Site Module 2.5.0
    SWFobject Site Module 2.1
    Syndication Feeds Site Module 2.5.0
    System - Cache Site Plugin 2.5.0
    System - Debug Site Plugin 2.5.0
    System - EasyCalcCheck PLUS - ECC+ Site Plugin 2.5-3
    System - Language Filter Site Plugin 2.5.0
    System - Log Site Plugin 2.5.0
    System - Logout Site Plugin 2.5.0
    System - P3P Policy Site Plugin 2.5.0
    System - Redirect Site Plugin 2.5.0
    System - Remember Me Site Plugin 2.5.0
    System - SEF Site Plugin 2.5.0
    Template Manager Administrator Component 2.5.0
    Title Administrator Module 2.5.0
    Toolbar Administrator Module 2.5.0
    User - Contact Creator Site Plugin 2.5.0
    User - Joomla! Site Plugin 2.5.0
    User - Profile Site Plugin 2.5.0
    Users Manager Administrator Component 2.5.0
    User Status Administrator Module 2.5.0
    Weblinks Administrator Component 2.5.0
    Weblinks Site Module 2.5.0
    Who's Online Site Module 2.5.0
    Wrapper Site Component 2.5.0
    Wrapper Site Module 2.5.0


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 9:51 am 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 17194
Location: Akershus, Norway
The version is in "libraries\cms\version\version.php"

You do have the "Extensions" at the top menu?
Some rows must be missing in the database.
This is the #_modules table:

Code:
id    title    module    position    content    showtitle    params    menuid
10   Logged-in Users   mod_logged   cpanel      1   {"count":"5","name":"1","layout":"_:default","modu...   0
3   Popular Articles   mod_popular   cpanel      1   {"count":"5","catid":"","user_id":"0","layout":"_:...   0
4   Recently Added Articles   mod_latest   cpanel      1   {"count":"5","ordering":"c_dsc","catid":"","user_i...   0
86   Joomla Version   mod_version   footer      1   {"format":"short","product":"1","layout":"_:defaul...   0
9   Quick Icons   mod_quickicon   icon      1      0
2   Login   mod_login   login      1      0
12   Admin Menu   mod_menu   menu      1   {"layout":"","moduleclass_sfx":"","shownew":"1","s...   0
14   User Status   mod_status   status      1      0
13   Admin Submenu   mod_submenu   submenu      1      0
15   Title   mod_title   title      1      0
8   Toolbar   mod_toolbar   toolbar      1      0


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 10:22 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
I will look in the "libraries\cms\version\version.php" to see if there is anything obvious wrong. But it remains a mystery why, if something is/was missing, it was not repaired when I overwrote all the installed files with the full 2.5.6 package.

This is what appears in the http://nynehead.org CP.

Image

Quote:
You do have the "Extensions" at the top menu?
Some rows must be missing in the database.
This is the #_modules table:



I assume your question about "Extensions at the top menu" refers to the one showing in the image? In which case the answer is yes! Some rows missing from which database? And what should I do with the code you cite? I am no expert with MySQL but am willing to have a go! The site is all backed up. Here's the version.php. Can't see anything glaringly obvious; calls are there for version etc but to be honest I am out of my depth with this, so any advice MUCH appreciated!

Code:
<?php
/**
 * @package    Joomla.Site
 *
 * @copyright  Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.
 * @license    GNU General Public License version 2 or later; see LICENSE
 */

defined('_JEXEC') or die;

/**
 * Version information class for the Joomla CMS.
 *
 * @package  Joomla.Site
 * @since    1.0
 */
final class JVersion
{
   /** @var  string  Product name. */
   public $PRODUCT = 'Joomla!';

   /** @var  string  Release version. */
   public $RELEASE = '2.5';

   /** @var  string  Maintenance version. */
   public $DEV_LEVEL = '6';

   /** @var  string  Development STATUS. */
   public $DEV_STATUS = 'Stable';

   /** @var  string  Build number. */
   public $BUILD = '';

   /** @var  string  Code name. */
   public $CODENAME = 'Ember';

   /** @var  string  Release date. */
   public $RELDATE = '19-June-2012';

   /** @var  string  Release time. */
   public $RELTIME = '14:00';

   /** @var  string  Release timezone. */
   public $RELTZ = 'GMT';

   /** @var  string  Copyright Notice. */
   public $COPYRIGHT = 'Copyright (C) 2005 - 2012 Open Source Matters, Inc. All rights reserved.';

   /** @var  string  Link text. */
   public $URL = '<a href="http://www.joomla.org">Joomla!</a> is Free Software released under the GNU General Public License.';

   /**
    * Compares two a "PHP standardized" version number against the current Joomla version.
    *
    * @param   string  $minimum  The minimum version of the Joomla which is compatible.
    *
    * @return  bool    True if the version is compatible.
    *
    * @see     http://www.php.net/version_compare
    * @since   1.0
    */
   public function isCompatible($minimum)
   {
      return version_compare(JVERSION, $minimum, 'ge');
   }

   /**
    * Method to get the help file version.
    *
    * @return  string  Version suffix for help files.
    *
    * @since   1.0
    */
   public function getHelpVersion()
   {
      return '.' . str_replace('.', '', $this->RELEASE);
   }

   /**
    * Gets a "PHP standardized" version string for the current Joomla.
    *
    * @return  string  Version string.
    *
    * @since   1.5
    */
   public function getShortVersion()
   {
      return $this->RELEASE . '.' . $this->DEV_LEVEL;
   }

   /**
    * Gets a version string for the current Joomla with all release information.
    *
    * @return  string  Complete version string.
    *
    * @since   1.5
    */
   public function getLongVersion()
   {
      return $this->PRODUCT . ' ' . $this->RELEASE . '.' . $this->DEV_LEVEL . ' '
            . $this->DEV_STATUS . ' [ ' . $this->CODENAME . ' ] ' . $this->RELDATE . ' '
            . $this->RELTIME . ' ' . $this->RELTZ;
   }

   /**
    * Returns the user agent.
    *
    * @param   string  $component    Name of the component.
    * @param   bool    $mask         Mask as Mozilla/5.0 or not.
    * @param   bool    $add_version  Add version afterwards to component.
    *
    * @return  string  User Agent.
    *
    * @since   1.0
    */
   public function getUserAgent($component = null, $mask = false, $add_version = true)
   {
      if ($component === null)
      {
         $component = 'Framework';
      }

      if ($add_version)
      {
         $component .= '/' . $this->RELEASE;
      }

      // If masked pretend to look like Mozilla 5.0 but still identify ourselves.
      if ($mask)
      {
         return 'Mozilla/5.0 ' . $this->PRODUCT . '/' . $this->RELEASE . '.' . $this->DEV_LEVEL . ($component ? ' ' . $component : '');
      }
      else
      {
         return $this->PRODUCT . '/' . $this->RELEASE . '.' . $this->DEV_LEVEL . ($component ? ' ' . $component : '');
      }
   }
}


Last edited by feste on Sun Jun 24, 2012 10:46 am, edited 1 time in total.

Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 10:37 am 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 17194
Location: Akershus, Norway
The version in the footer is the row with id=86 in the #__modules table.
This is th sql to insert it. Replace # with your table prefix. Use phpmyadmin to inspect the table.

Code:
INSERT INTO `#_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES(86, 'Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*');


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 11:13 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
In #_modules there only seem to be id nos 1 to 19 and none of them seem to have titles or module names referring to version.


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 11:42 am 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 17194
Location: Akershus, Norway
These are the one I have for the back-end (client=1):

Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

INSERT INTO `lmk_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES
(2, 'Login', '', '', 1, 'login', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_login', 1, 1, '', 1, '*'),
(3, 'Popular Articles', '', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_popular', 3, 1, '{"count":"5","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'),
(4, 'Recently Added Articles', '', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_latest', 3, 1, '{"count":"5","ordering":"c_dsc","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'),
(8, 'Toolbar', '', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_toolbar', 3, 1, '', 1, '*'),
(9, 'Quick Icons', '', '', 1, 'icon', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_quickicon', 3, 1, '', 1, '*'),
(10, 'Logged-in Users', '', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_logged', 3, 1, '{"count":"5","name":"1","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'),
(12, 'Admin Menu', '', '', 1, 'menu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_menu', 3, 1, '{"layout":"","moduleclass_sfx":"","shownew":"1","showhelp":"1","cache":"0"}', 1, '*'),
(13, 'Admin Submenu', '', '', 1, 'submenu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_submenu', 3, 1, '', 1, '*'),
(14, 'User Status', '', '', 2, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_status', 3, 1, '', 1, '*'),
(15, 'Title', '', '', 1, 'title', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_title', 3, 1, '', 1, '*'),
(79, 'Multilanguage status', '', '', 1, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
(86, 'Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*');


Replace lmk with your database prefix.

Paste into the sql tab


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 4:05 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
Spooooky! Thanks for the help Per Yngve Berg. No idea what I am doing with MySQL really. But here's what happened.

When I open the sql tab there is this already there:
Code:
SELECT * FROM `jos_modules` WHERE 1


Do I leave that and paste in all the code you quote? including:
Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


With the sql tab open, if I click INSERT I get this:

Code:
INSERT INTO `jos_modules`(`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES ([value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],[value-9],[value-10],[value-11],[value-12],[value-13],[value-14],[value-15],[value-16],[value-17])


If I just replace everything AFTER 'jos_module' with everything AFTER your `lmk_modules` I get the following error message:

Code:
#1062 - Duplicate entry '2' for key 'PRIMARY'


with a rather fetching pink background.

Thanks again


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 4:15 pm 
Joomla! Master
Joomla! Master
Online

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 17194
Location: Akershus, Norway
That means that a row with id=2 already exists in the table.

Try a file with only those higer than 19.

Code:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

INSERT INTO `lmk_modules` (`id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES
(79, 'Multilanguage status', '', '', 1, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
(86, 'Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*');


Top
 Profile  
 
PostPosted: Sun Jun 24, 2012 5:22 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Mar 31, 2009 6:21 am
Posts: 251
Location: Devon/Somerset
Well that seemed to go in OK - green message etc. And the two lines are there in the db;

Code:
   Edit Edit    Edit Inline Edit    Copy Copy    Delete Delete    79    Multilanguage status          1    status    0    0000-00-00 00:00:00    0000-00-00 00:00:00    0000-00-00 00:00:00    0    mod_multilangstatus    3    1    {"layout":"_:default","moduleclass_sfx":"","cache"...   1    *
   Edit Edit    Edit Inline Edit    Copy Copy    Delete Delete    86    Joomla Version          1    footer    0    0000-00-00 00:00:00    0000-00-00 00:00:00    0000-00-00 00:00:00    1    mod_version    3    1    {"format":"short","product":"1","layout":"_:defaul...   1    *


but it has made no difference to the backend control panel! Still no version nor, more importantly, have the 2 missing buttons appeared.

The file in "libraries\cms\version\version.php" is presumably a general instruction called by other components. If that is correct, it seems to be working fine because the version is correctly cited under the system information. So is the problem not more likely to be found somewhere like administrator/components/com_cpanel/ and one of the files in there e.g. controller.php, cpanel.php or cpanel.xml failing to call the version.php?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 41 posts ]  Go to page Previous  1, 2



Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group