jobberbase installieren - wie?
lima-city → Forum → Die eigene Homepage → Homepage Allgemein
apache
array
base
break
code
dank
datei
fehler
file
http
idee
kind
live array
live http
modul
part
schauen
setting
teil
url
-
Hallo,
ich habe hier bei Lima versucht jobberbase zu installieren und folgende Anleitung befolgt: http://wiki.jobberbase.com/install/guide-for-apache, ich gebe auch zu nicht sicher zu sein ob ich das so richtig gemacht habe. Auf jeden Fall kommt nur eine weiße Seite mit dem FavIcon von jobberbase.
Hat Jemand Erfahrung damit bereits gemacht und kann mir helfen an was es liegen könnte? Vielleicht reicht auch schon eine schnelle Anleitung auf deutsch.
Vielen Dank! -
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!
lima-city: Gratis werbefreier Webspace für deine eigene Homepage
-
Hallo rotuganda,
da ich davon ausgehe das dies nur ein Cache-Problem deines Browsers ist solltest du einfach die URL der Jobberbase-Installation einstellen. Dann kann man schauen ob dies zutrifft. Ich wollte gerade eine Testinstallation machen aber nach lesen vonDatabase setup
habe ich es dann doch sein lassen. Welche der beiden Varianten hast du gewählt?
Before setting up the database, there are some things that you should be aware of: some hosting companies don't allow you to have more than one database (usually in case of low-end (very cheap or free) hosting plans). If that's your situation, follow the next step (Single database hosting), otherwise jump to step "Multiple database hosting". -
Hi,
dank dir für deine schnelle Antwort, also anschauen kannst du meine Installation hier: http://rotuganda.lima-city.de/ (ich dachte das wäre klar als ich schrieb hier bei Lima).
Und gewählt habe ich ich sozusagen beides, erst die Multi und danach die Single-Methode. -
Ich weiß nicht sicher, ob das was bringt, aber leg doch mal eine
.htaccess
Datei auf deinen Webspace mit folgendem Inhalt
php_value display_errors on -
Hi karpfen,
dank dir für deine Antwort, ich habe es gemacht und folgendes kommt dabei raus (immerhin):
Fatal error: Call to a member function fetch_assoc() on a non-object in /home/webpages/lima-city/rotuganda/html/_includes/class.JobberSettings.php on line 23
Googlesuche hilft mir aber auch nicht wirklich weiter - ich kann den Fehler (obwohl ich ihn nun sehe) nicht beheben. Hat Jemand eine Idee? -
Hast du überprüft ob auch wirklich alle Dateien ordnungsgemäß hochgeladen wurden?
Kommt ja nicht selten vor, dass in CMS von Lima als verbotene gekennzeichnete Dateien vorhanden sind.
-
Ja soweit ich das eben überprüft habe, ja alle Daten sind komplett hochgeladen. Sollte ich einfach alles nochmal hochladen (ich mach es einfach mal)?!
edit: so sieht meine config_envs.php-Datei aus (womöglich falsch):
<?php /** * Define environments * */ $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'localhost', // mysql credentials 'db_host' => 'localhost', 'db_port' => 3306, 'db_user' => 'USER4xxx', 'db_password' => 'xxxx', 'db_name' => 'db_44648_1', 'db_prefix' => 'jb_', // your site's full url 'app_url' => 'http://rotuganda.lima-city.de/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'local', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'dev', //use 'apache_mod_rewrite' for Apache hosting or 'iis_url_rewrite', 'iis_isapi_rewrite' for IIS hosting 'rewrite_mode' => 'apache_mod_rewrite' ); ?>
Sollte man beim Tabellen-Präfix vielleicht nur jb und nicht jb_ angeben?
Beitrag zuletzt geändert: 31.5.2011 10:40:21 von rotuganda -
Auf lima-city NICHT localhost, sondern mysql.lima-city.de !
-
karpfen schrieb:
Auf lima-city NICHT localhost, sondern mysql.lima-city.de !
Gut geändert, Fehler bleibt der gleiche, die Confi-Datei sieht jetzt so aus:
<?php /** * Define environments * */ $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'localhost', // mysql credentials 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USER4xxx', 'db_password' => 'xxxx', 'db_name' => 'db_44648_1', 'db_prefix' => 'jb_', // your site's full url 'app_url' => 'http://rotuganda.lima-city.de/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'local', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'dev', //use 'apache_mod_rewrite' for Apache hosting or 'iis_url_rewrite', 'iis_isapi_rewrite' for IIS hosting 'rewrite_mode' => 'apache_mod_rewrite' ); ?>
Edit: also ich habe jetzt nochmal alles von neu installiert, jeden einzelnen Schritt, Fehler bleibt der selber. Hat denn Niemand eine Idee wie ich das installieren könnte?
Beitrag zuletzt geändert: 31.5.2011 23:30:23 von rotuganda -
In der Konfiguration (config.envs.php) fehlt der
$__instances['live']
Teil. Dort rührt der Fehler nämlich her, da die meisten das Gane falsch konfigurieren.
Der
$__instances['local']
Teil ist nicht für den Einsatz im Netz gedacht. Sollte am Ende dann in etwa so aussehen:
// local (http://localhost) $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'localhost', // mysql credentials 'db_host' => 'localhost', 'db_port' => 3306, 'db_user' => 'root', 'db_password' => 'root', 'db_name' => 'test', 'db_prefix' => '', // your site's full url 'app_url' => 'http://localhost/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'local', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'dev', //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite' 'rewrite_mode' => 'apache_mod_rewrite' ); // live (http://rotuganda.lima-city.de) $__instances['live'] = array( 'prefix' => 'rotuganda', 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USER4xxx', 'db_password' => 'xxxx', 'db_name' => 'db_44648_1', 'db_prefix' => '', 'app_url' => 'http://rotuganda.lima-city.de/', 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'Off', 'location' => 'online', 'environment' => 'prod', 'rewrite_mode' => 'apache_mod_rewrite' );
Im Übrigen stimmt dein prefix nicht ;)
// should be a unique part of the url (or the entire url if you wish)
Beitrag zuletzt geändert: 1.6.2011 1:02:13 von fabo -
Danke, danke, danke Fabo
... aber es bleibt wie es ist, die Datei sieht jetzt so aus:
<?php /** * Define environments * */ // local (http://rotuganda.lima-city.de/) $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'localhost', // mysql credentials 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USERXXXX', 'db_password' => 'XXXX', 'db_name' => 'db_44648_1', 'db_prefix' => '', // your site's full url 'app_url' => 'http://rotuganda.lima-city.de/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'online', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'prod', //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite' 'rewrite_mode' => 'apache_mod_rewrite' ); // live (http://rotuganda.lima-city.de/) $__instances['live'] = array( 'prefix' => 'http://rotuganda.lima-city.de/', 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USERXXXX', 'db_password' => 'XXX', 'db_name' => 'db_44648_1', 'db_prefix' => 'jb_', 'app_url' => 'http://rotuganda.lima-city.de/', 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'Off', 'location' => 'online', 'environment' => 'prod', 'rewrite_mode' => 'apache_mod_rewrite' ); // setup current instance foreach ($__instances as $__instance) { // http requests if (isset($_SERVER['HTTP_HOST'])) { $_compare_to = $_SERVER['HTTP_HOST']; } if (strstr($_compare_to, $__instance['prefix'])) { define('DB_HOST', $__instance['db_host']); define('DB_PORT', $__instance['db_port']); define('DB_USER', $__instance['db_user']); define('DB_PASS', $__instance['db_password']); define('DB_NAME', $__instance['db_name']); define('DB_PREFIX', $__instance['db_prefix']); // values kind of redundant, they indicate wether this is a live/production or dev/testing environment define('LOCATION', $__instance['location']); define('ENVIRONMENT', $__instance['environment']); // base url of the app define('APP_URL', $__instance['app_url']); define('REWRITE_MODE', $__instance['rewrite_mode']); // error reporting ini_set('error_reporting', $__instance['ini_error_reporting']); ini_set('display_errors', $__instance['ini_display_errors']); break; } } ?>
Was mache ich den falsch?
Beitrag zuletzt geändert: 1.6.2011 1:02:18 von rotuganda -
'prefix' => 'http://rotuganda.lima-city.de/',
Ersetzen durch:
'prefix' => 'rotuganda',
oder
'prefix' => 'lima-city.de',
Hab die o.g. Config geändert. Probiers damit ;)
Beitrag zuletzt geändert: 1.6.2011 1:05:51 von fabo -
Danke
, aber es klappt nicht....
jetzt siehts so aus:
<?php /** * Define environments * */ // local (http://rotuganda.lima-city.de/) $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'lima-city.de', // mysql credentials 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USERX', 'db_password' => 'X', 'db_name' => 'db_44648_1', 'db_prefix' => '', // your site's full url 'app_url' => 'http://rotuganda.lima-city.de/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'online', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'prod', //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite' 'rewrite_mode' => 'apache_mod_rewrite' ); // live (http://rotuganda.lima-city.de/) $__instances['live'] = array( 'prefix' => 'lima-city.de', 'db_host' => 'mysql.lima-city.de', 'db_port' => 3306, 'db_user' => 'USERX', 'db_password' => 'X', 'db_name' => 'db_44648_1', 'db_prefix' => 'jb_', 'app_url' => 'http://rotuganda.lima-city.de/', 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'Off', 'location' => 'online', 'environment' => 'prod', 'rewrite_mode' => 'apache_mod_rewrite' ); // setup current instance foreach ($__instances as $__instance) { // http requests if (isset($_SERVER['HTTP_HOST'])) { $_compare_to = $_SERVER['HTTP_HOST']; } if (strstr($_compare_to, $__instance['prefix'])) { define('DB_HOST', $__instance['db_host']); define('DB_PORT', $__instance['db_port']); define('DB_USER', $__instance['db_user']); define('DB_PASS', $__instance['db_password']); define('DB_NAME', $__instance['db_name']); define('DB_PREFIX', $__instance['db_prefix']); // values kind of redundant, they indicate wether this is a live/production or dev/testing environment define('LOCATION', $__instance['location']); define('ENVIRONMENT', $__instance['environment']); // base url of the app define('APP_URL', $__instance['app_url']); define('REWRITE_MODE', $__instance['rewrite_mode']); // error reporting ini_set('error_reporting', $__instance['ini_error_reporting']); ini_set('display_errors', $__instance['ini_display_errors']); break; } } ?>
Ich hatte beides versucht:
fabo schrieb:
'prefix' => 'http://rotuganda.lima-city.de/',
Ersetzen durch:
'prefix' => 'rotuganda',
oder
'prefix' => 'lima-city.de',
Hab die o.g. Config geändert. Probiers damit ;) -
'db_prefix' => 'jb_',
Stimmt der? Oder hast du Jobberbase ohne bzw. mit einem anderen Prefix installiert? -
Ich denke doch das es stimmt...guckst du: http://i46.photobucket.com/albums/f133/rotuganda/mysqllima-cityde-mysqllima-cityde-db_44648_1-phpMyAdmin336.jpg
-
Poste mal bitte den Inhalt der Datei class.JobberSettings.php. Sonst muss ich mir das Teil gleich mal herunterladen und selber gucken :D
-
<?php /** * jobberbase site configuration class * * @author Erik Goverde <http://chronoscripts.com> <chronos@chronoscripts.com> * @license You are free to edit and use this work, but please keep the credits. * */ class JobberSettings { var $mSettings = false; function __construct() { global $db; $sql = 'SELECT * FROM '.DB_PREFIX.'settings ORDER BY id ASC'; $result = $db->query($sql); $settings = array(); while ($row = $result->fetch_assoc()) { // Setting temporary variable names for the 'value' and 'fieldtype' fields $value = $row['value']; $data_type = $row['data_type']; $input_type = $row['input_type']; $input_options = $row['input_options']; $validation = explode('|', $row['validation']); // Apply certain actions on special fields if ($input_type == 'checkbox' || $input_type == 'select' || $input_type == 'radiobutton') $input_options = explode('|', $input_options); elseif ($input_type == 'available_themes') { $input_type = 'select'; $themes = array(); $dir = APP_PATH.'_templates/'; if ($dh = opendir($dir)) { while (($file = readdir($dh)) !== false) { if (filetype($dir . $file) != 'file' && $file != '.' && $file != '..' && $file != '.svn' && $file != '_cache') $themes[] = $file; } closedir($dh); } $input_options = $themes; } if ($data_type == 'boolean' && $value != 1) $value = false; // Add the row to the setting array $settings[$row['name']] = array( 'name' => $row['name'], 'title' => $row['title'], 'description' => $row['description'], 'data_type' => $data_type, 'input_type' => $input_type, 'input_options' => $input_options, 'validation' => $validation, 'value' => stripslashes($value), 'category_id' => $row['category_id'] ); } $this->mSettings = $settings; } public function GetSettingsCategories() { global $db; $sql = 'SELECT id, name, var_name, description FROM '.DB_PREFIX.'settings_categories ORDER BY id ASC'; $result = $db->query($sql); $settings_category = array(); while ($row = $result->fetch_assoc()) { $settings_category[] = array('name' => $row['name'], 'var_name' => $row['var_name'], 'description' => $row['description']); } return $settings_category; } public function GetSettingsCategoryNameById($id) { global $db; $sql = 'SELECT name FROM '.DB_PREFIX.'settings_categories WHERE id = ' . $id; $result = $db->query($sql); $row = $result->fetch_assoc(); return $row['name']; } public function GetSettingsCategoryIdByVarname($var_name) { global $db; $sql = 'SELECT id FROM '.DB_PREFIX.'settings_categories WHERE var_name = "' . $var_name . '"'; $result = $db->query($sql); $row = $result->fetch_assoc(); return $row['id']; } public function GetSetting($name, $advanced = false) { $settings = $this->mSettings; if (!empty($settings[$name])) { if ($advanced == true) return $settings[$name]; else return $settings[$name]['value']; } else return false; } public function GetSettings($setting_names = false, $advanced = false) { $settings = $this->mSettings; $settings_array = array(); if (!empty($setting_names)) { $i = 0; while($i < count($setting_names)) { if (!empty($settings[$setting_names[$i]]) && $advanced == true) $settings_array[$setting_names[$i]] = $settings[$setting_names[$i]]; elseif (!empty($settings[$setting_names[$i]])) $settings_array[$setting_names[$i]] = $settings[$setting_names[$i]]['value']; $i++; } return $settings_array; } elseif ($advanced == false) { foreach ($settings as $setting) { $settings_array[$setting['name']] = $setting['value']; } return $settings_array; } else return $settings; } public function GetSettingsByCategory($category_id, $advanced = false) { global $db; $sql = 'SELECT name FROM '.DB_PREFIX.'settings WHERE category_id = ' . $category_id . ' ORDER BY ordering ASC'; $result = $db->query($sql); $settings_list = array(); while ($row = $result->fetch_assoc()) { $settings_list[] = $row['name']; } $settings = $this->GetSettings($settings_list, $advanced); return $settings; } public function UpdateSettings($settings_array) { global $db; $settings = $this->mSettings; $i = 0; while($i < count($settings_array)) { $value = $settings_array[$i]['value']; $name = $settings_array[$i]['name']; if ($value != $settings[$name]['value']) { $sql = 'UPDATE '.DB_PREFIX.'settings SET value = "' . $value . '" WHERE name = "' . $name . '"'; $db->query($sql); } $i++; } } } ?> -
Unter $__instances['live']
'environment' => 'prod',
auf
'environment' => 'dev',
stellen und schauen, ob du eine andere, genauere Fehlermeldung erhälst.
Beitrag zuletzt geändert: 1.6.2011 1:45:31 von fabo -
Gemacht....
Weiß nicht: http://rotuganda.lima-city.de/
Edit: also es sieht anders aus ja:
aber es hilft mir nicht... menno das ist aber auch kombliziert....Fatal error: Uncaught exception 'QueryException' with message 'Table 'db_44648_1.settings' doesn't exist' in /home/webpages/lima-city/rotuganda/html/_includes/class.Db.php:34 Stack trace: #0 /home/webpages/lima-city/rotuganda/html/_includes/class.JobberSettings.php(19): Db->query('SELECT * FROM s...') #1 /home/webpages/lima-city/rotuganda/html/_config/config.php(75): JobberSettings->__construct() #2 /home/webpages/lima-city/rotuganda/html/index.php(16): require_once('/home/webpages/...') #3 {main} thrown in /home/webpages/lima-city/rotuganda/html/_includes/class.Db.php on line 34
Beitrag zuletzt geändert: 1.6.2011 1:49:04 von rotuganda -
Na siehste ;)
In der Config fehlt der Datenbankprefix jb_
Nimm bitte genau diese Config:
<?php /** * Define environments * */ // local (http://localhost/jobberbase/public) $__instances['local'] = array( // should be a unique part of the url (or the entire url if you wish) 'prefix' => 'localhost', // mysql credentials 'db_host' => 'localhost', 'db_port' => 3306, 'db_user' => 'root', 'db_password' => '', 'db_name' => 'jobberbase', 'db_prefix' => '', // your site's full url 'app_url' => 'http://localhost/jobberbase/trunk/public/', // error reporting 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', // environment setting 1 (use 'local' for localhost/testing OR 'online' for live, production environment) 'location' => 'local', // environment setting 2 (use 'dev' together with 'local' in the previous setting OR 'prod' with 'online') 'environment' => 'dev', //'apache_mod_rewrite', 'iis_url_rewrite' -microsoft URL Rewrite module, 'iis_isapi_rewrite' 'rewrite_mode' => 'apache_mod_rewrite' ); // live (http://rotuganda.lima-city.de) $__instances['live'] = array( 'prefix' => 'lima-city.de', 'db_host' => 'localhost', 'db_port' => 3306, 'db_user' => 'USERXXXX', 'db_password' => 'XXXX', 'db_name' => 'db_44648_1', 'db_prefix' => 'jb_', 'app_url' => 'http://rotuganda.lima-city.de/', 'ini_error_reporting' => E_ALL, 'ini_display_errors' => 'On', 'location' => 'online', 'environment' => 'prod', 'rewrite_mode' => 'apache_mod_rewrite' ); // setup current instance foreach ($__instances as $__instance) { // http requests if (isset($_SERVER['HTTP_HOST'])) { $_compare_to = $_SERVER['HTTP_HOST']; } if (strstr($_compare_to, $__instance['prefix'])) { define('DB_HOST', $__instance['db_host']); define('DB_PORT', $__instance['db_port']); define('DB_USER', $__instance['db_user']); define('DB_PASS', $__instance['db_password']); define('DB_NAME', $__instance['db_name']); define('DB_PREFIX', $__instance['db_prefix']); // values kind of redundant, they indicate wether this is a live/production or dev/testing environment define('LOCATION', $__instance['location']); define('ENVIRONMENT', $__instance['environment']); // base url of the app define('APP_URL', $__instance['app_url']); define('REWRITE_MODE', $__instance['rewrite_mode']); // error reporting ini_set('error_reporting', $__instance['ini_error_reporting']); ini_set('display_errors', $__instance['ini_display_errors']); break; } } ?> -
Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!
lima-city: Gratis werbefreier Webspace für deine eigene Homepage
