Joomla! Forum - community, help and support

Posted: **Sun Jan 06, 2013 7:54 pm**

Hi everybody,

I have recently changed domain hosts from 123reg to HostPapa and am trying to restore my Joomla backup created with Akeeba Backup. Having completed the restoration process using kickstart, instead of seeing my webpage, I see the following and nothing else on my site (my site is www.sobodesign.co.uk if you want to see for yourself)

Table 'sobod170_sobo.sobo_session' doesn't exist SQL=INSERT INTO `sobo_session` (`session_id`, `client_id`, `time`) VALUES ('0a9e7b14b63b4ba415bfdfc6fda2c396', 0, 1357501559)

I have a feeling it's a database admnistration problem but I have no idea about coding or where to start and I'm in all sorts. Does anyone know why my site is not displaying at all?

Any and all answers are most appreciated.

Posted: **Sun Jan 06, 2013 9:10 pm**

The table sobo_session is missing from the database. It stores the sessions of the visitors. You don't need the content of this table, but create an emty table. Export the table definition from a working site and import.

Posted: **Sun Jan 06, 2013 11:24 pm**

Sorry, but I don't understand what that means at all!! I have just created a new empty table called sobo_session but still have the problem.

Should I try and restore the site again from the start?

Posted: **Mon Jan 07, 2013 1:23 am**

Yes, you can start from the beginning also.

Posted: **Mon Jan 07, 2013 5:48 pm**

Have now tried that - still no joy. When you say export the take definition from a working site and then import, what do you mean? Can you provide me with this? And further, why would that table definition be missing when I have simply restored from a backup of a working site?

Posted: **Mon Jan 07, 2013 10:00 pm**

I actually think I understand the problem now. There is a missing table that needs some kind of SQL code in it. I just have no idea what the SQL code should be. Can anyone help?

Posted: **Mon Jan 14, 2013 1:47 am**

You are getting close but are not there yet!

Just checked your site and the table is still missing!
use the code below after you changed the prefix

Code: Select all

#
# Table structure for table `#__session`
#

CREATE TABLE `#__session` (
  `session_id` varchar(200) NOT NULL default '',
  `client_id` tinyint(3) unsigned NOT NULL default '0',
  `guest` tinyint(4) unsigned default '1',
  `time` varchar(14) default '',
  `data` mediumtext default NULL,
  `userid` int(11) default '0',
  `username` varchar(150) default '',
  `usertype` varchar(50) default '',
  PRIMARY KEY  (`session_id`),
  KEY `whosonline` (`guest`,`usertype`),
  KEY `userid` (`userid`),
  KEY `time` (`time`)
)  DEFAULT CHARSET=utf8;

The code comes from the Joomla installation. Replace "#_" with "Truejos".
Run that against your database with PHPMYADMIN.

Joomla! Forum - community, help and support

Restored site to new domain - serious problems!!!

Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!

Re: Restored site to new domain - serious problems!!!