ik heb dat gedaan en krijg een foutmelding
ik heb het ook al gevraagd op het forum van Categories hierarchy, maar dat is Engels en stil.
Wanneer ik de installatie run, krijg ik deze foutmelding:
SQL request not achieved:
* reason: 1054 - Unknown column 'icon_auth' in 'field list'
* file: class_install.php, line: 733
* request: INSERT INTO phpbb_icons (icon_name, icon_url, icon_auth, icon_types, icon_order) VALUES ('icon_note', 'images/icons/icon1.gif', '', '0', 10), ('icon_important', 'images/icons/icon2.gif', '', '1', 20), ('icon_idea', 'images/icons/icon3.gif', '', '', 30), ('icon_warning', 'images/icons/icon4.gif', '', '2, 3', 40), ('icon_question', 'images/icons/icon5.gif', '', '', 50), ('icon_cool', 'images/icons/icon6.gif', '', '', 60), ('icon_funny', 'images/icons/icon7.gif', '', '', 70), ('icon_angry', 'images/icons/icon8.gif', '', '', 80), ('icon_sad', 'images/icons/icon9.gif', '', '', 90), ('icon_mocker', 'images/icons/icon10.gif', '', '', 100), ('icon_shocked', 'images/icons/icon11.gif', '', '', 110), ('icon_complicity', 'images/icons/icon12.gif', '', '', 120), ('icon_bad', 'images/icons/icon13.gif', '', '', 130), ('icon_great', 'images/icons/icon14.gif', '', '', 140), ('icon_disgusting', 'images/icons/icon15.gif', '', '', 150), ('icon_winner', 'images/icons/icon16.gif', '', '', 160), ('icon_impressed', 'images/icons/icon17.gif', '', '', 170), ('icon_roleplay', 'images/icons/icon18.gif', '', '', 180), ('icon_fight', 'images/icons/icon19.gif', '', '', 190), ('icon_loot', 'images/icons/icon20.gif', '', '', 200), ('icon_picture', 'images/icons/icon21.gif', 'auth_mod', '', 210), ('icon_calendar', 'images/icons/icon22.gif', 'auth_mod', '', 220)
The database structure has been modified.
The cache/ directory is not available to store caches. Caches processes are so disabled.
Config table has been populated.
The authorisations presets table has been populated.
De maker van Categories Hierarchy reageerde er zo op:
Drop the phpbb_icons table, recreate it using the schema included in mysql_fullRC6 (something like that) in the install_cat/schemas/, the re-run manually this sql request in phpMyAdmin. I'm really surprised you get an error there : you have probably attempt various versions installations.
Ik snap hier dus de ballen van.
dat mysql_RC6 kan ik vinden, maar "drop the phpbb_icons"?? waar kan ik die vinden?
en phpMyadmin, ken ik ook al niet
dus ik ga zoeken in class_install.ph regel 733
Code: Selecteer alles
function init()
{
global $db, $page;
[hier is dus line 733, een lege lijn]
$this->session_logged_in = false;
$session_max_length = 600; // 10 minutes
// do not use a previous session while validating a login
if ( $page->_button('logme') )
{
return $this->session_logged_in;
}
// read session from table
$sql = 'SELECT s.session_id, s.session_ip, s.session_time, u.user_id, u.user_level
FROM ' . SESSIONS_TABLE . ' s
LEFT JOIN ' . USERS_TABLE . ' u
ON u.user_id = s.session_user_id
WHERE session_id = \'' . $this->session_id . '\'';
$result = $db->sql_query($sql, false, __LINE__, __FILE__);
if ( $row = $db->sql_fetchrow($result) )
{
// check session ip with current ip
$ip_stored = substr($row['session_ip'], 0, 6);
$ip_current = substr($this->session_ip, 0, 6);
if ( $ip_stored == $ip_current )
{
// the ips match : does the session lenght ok ?
if ( (time() - intval($row['session_time'])) < $session_max_length )
{
// does the user exists
if ( !empty($row['user_id']) )
{
$this->user_id = intval($row['user_id']);
$this->user_level = intval($row['user_level']);
// this session is ok : update the session table
$fields = array(
'session_ip' => $this->session_ip,
'session_time' => time(),
);
$db->sql_statement($fields);
$sql = 'UPDATE ' . SESSIONS_TABLE . '
SET ' . $db->sql_update . '
WHERE session_id = \'' . $this->session_id . '\'';
$db->sql_query($sql, false, __LINE__, __FILE__);
$this->session_logged_in = true;
}
}
}
}
return $this->session_logged_in;
}
kan iemand mij helpen?
Zou wel fijn zijn, want mn forum is nu onbereikbaar
