English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message

  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 12
TOPIC: Error 500 on slave site
#7008
Error 500 on slave site 13 Years, 8 Months ago Karma: 0
Hi,
getting this error on slave site:
Code:
500 - DB function failed with error number 1054
Unknown column 'a.friends' in 'field list' SQL=SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.` view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s. `userid` as _isonline, u.* FROM `slave2_community_users` as a LEFT JOIN `slave2_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `slave2_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='0'


on any menu but the home page
israelim.derberliton.de/index.php?option...ontpage&Itemid=2

need help urgent!
avush96
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Gender: Male avush96 derBerliton News
The administrator has disabled public write access.
derBerliton News derberliton.de/
  
#7012
Re:Error 500 on slave site 13 Years, 8 Months ago Karma: 0
Hi, need support and help urgent please!!
avush96
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Gender: Male avush96 derBerliton News
Last Edit: 2011/04/20 13:12 By avush96.
The administrator has disabled public write access.
derBerliton News derberliton.de/
  
#7021
Re:Error 500 on slave site 13 Years, 8 Months ago Karma: 54
I suspect that you have created a slave site that is sharing the CB users with another website.
I suspect that the other website that physically contain the CB users has added custom fields (perhaps 'friends').

If I am correct, when you create the "slave2_" website, the "friend" field was not present in CB.
MySQL save the table layout when sharing a table.
As you have shared the CB content, you can just "uninstall" the CB extension in Slave2 and "re-Share" the extension in Slave2.
Use the JMS Tool menu for that.
This will rebuild the MySQL colomn snapshot that is saved when creating the link between the websites.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#7026
Re:Error 500 on slave site 13 Years, 8 Months ago Karma: 0
Hi,
I gave up on this one and deinstalled the slave.

made a new slave to public_html/multisites/slave2, marked "Create deploy directory:" and saved. all looks good from back-end but when I click the domain in order to go with installation I get this error:

Code:
Fatal error: Class 'JDispatcher' not found in /xxx/xxx/public_html/libraries/joomla/application/application.php on line 499


I did it a few times with sub Domanin from Cpanel and without and same error!

it is simply not working!! can you help?
avush96
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Gender: Male avush96 derBerliton News
Last Edit: 2011/04/21 20:31 By avush96.
The administrator has disabled public write access.
derBerliton News derberliton.de/
  
#7038
Re:Error 500 on slave site 13 Years, 8 Months ago Karma: 0
avush96 wrote:

Code:
Fatal error: Class 'JDispatcher' not found in /xxx/xxx/public_html/libraries/joomla/application/application.php on line 499



Hi,
problem with this error is solved by reinstalling core joomla files.
but now I have again 500 error on israelim.derberliton.de/index.php/community
not in the rest of the menu!!!
attached pic of the error
What can I do to fix this error????
thanks
Avi
avush96
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Gender: Male avush96 derBerliton News
The administrator has disabled public write access.
derBerliton News derberliton.de/
  
#7046
Re:Error 500 on slave site 13 Years, 8 Months ago Karma: 54
The error message reports that 'avush96_Slave2.tmp' does not exists.
It seems this is a temporary table that is probably created by MySQL.
Perhaps you should have a look in the MySQL configuration or error somewhere to see if your MySQL had an error. (Perhaps not enough memory, or too many temporary file open, ...)
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
JMS, multisite for joomla
Joomla Multi Sites Version 1.2.x
Bugs, errors reporting
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla