The Joomla! Forum ™

Hi,

I'm trying to move to a new hosting provider and export my DB through PHPMyadmin, imported on the new side. But when I tried to access my site, I get the following error:



I searched the forum, a few has the error, but there is no solution. I did try to repair the jos_session table, drop it and imported it again from the old site. Same error. I'm running out of idea ... not sure what I can do next.

Thanks for any help,
-N

It's fixed by doing the following:

Via phpmyadmin, look into the table jos_session a row with "client_id".
If it does not exist, create a new field with the following values:

* Field: client_id
* Type: tinyint
* Length; 3
* attributes: unsigned
* null: not null
* default: 0
* The remaining 2 fields must be empty

Hope it helps some of you.
-N

Got new error, I'm getting 404 when hitting the frontend. saying it's missing a component. Trying to hit the administrator page and getting this error:

* Error loading Plugins: Table 'joomla.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* Error loading Plugins: Table 'joomla.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering
* Error Loading ModulesUnknown column 'control' in 'field list' SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 1 ORDER BY position, ordering
* Error loading Plugins: Table 'joomla.jos_plugins' doesn't exist SQL=SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDER BY ordering

Can someone offer a good advice on moving a Joomla site to a new hosting company ? What I'm doing now is:

- export the DB via phpmyadmin
- rsync the directory over
- Importing the DB into the new site

The procedure has worked in the past w/ Joomla 1.x move. It's broken in 1.5 and I'm stuck ...

Thank you for any help
--

Seems this is a really old problem. I'm getting this same exact errors and have looked everywhere for a fix without success. Please can someone help me. I'm desperate now