MoosesooM: 1054

domenica 26 febbraio 2012

Zen Cart: errore 1054 mysql in inserimento EZ-Pages

Dopo aver installato la versione 1.3.0.5v2.02 del supporto multilingua delle EZ-Pages avevo un errore ogni volta che cercavo di inserire una nuova pagina:

1054 Unknown column 'pages_title' in 'field list'
in:
[insert into ezpages (pages_title, page_open_new_window, page_is_ssl, alt_url, alt_url_external, status_header, status_sidebox, status_footer, status_toc, header_sort_order, sidebox_sort_order, footer_sort_order, toc_sort_order, toc_chapter, pages_html_text) values ('', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Array')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

The solution is simple, modify .../CUSTOM_ADMIN/ezpages.php file changing:

$sql_data_array = array('pages_title' => $pages_title,
'page_open_new_window' => $page_open_new_window,
'page_is_ssl' => $page_is_ssl,
'alt_url' => $alt_url,
'alt_url_external' => $alt_url_external,
'status_header' => $status_header,
'status_sidebox' => $status_sidebox,
'status_footer' => $status_footer,
'status_toc' => $status_toc,
'header_sort_order' => $pages_header_sort_order,
'sidebox_sort_order' => $pages_sidebox_sort_order,
'footer_sort_order' => $pages_footer_sort_order,
'toc_sort_order' => $pages_toc_sort_order,
'toc_chapter' => $toc_chapter,
'pages_html_text' => $pages_html_text);

$sql_data_array = array('page_open_new_window' => $page_open_new_window,
'page_is_ssl' => $page_is_ssl,
'alt_url' => $alt_url,
'alt_url_external' => $alt_url_external,
'status_header' => $status_header,
'status_sidebox' => $status_sidebox,
'status_footer' => $status_footer,
'status_toc' => $status_toc,
'header_sort_order' => $pages_header_sort_order,
'sidebox_sort_order' => $pages_sidebox_sort_order,
'footer_sort_order' => $pages_footer_sort_order,
'toc_sort_order' => $pages_toc_sort_order,
'toc_chapter' => $toc_chapter);

venerdì 12 marzo 2010

Zen Cart: errore creazione utente su forum phpBB

Se si e' scelto di integrare Zen Cart con il forum phpBB, in fase di creazione utente nel negozio, viene richiesto anche un nickname per il forum (la password e' la stessa impostata per il negozio).

Se al momento di confermare la creazione dell'utente si ottiene l'errore:

1054 Unknown column 'group_description' in 'field list'
in:
[INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES (0, 'Personal User', 1, 0)]

per risolvere bisogna editare il file:

.../includes/classes /class.phpbb.php

del negozio. Cercare la funzione:

phpbb_create_account

e sostituirla con il codice seguente:

function phpbb_create_account($nick, $password, $email_address) {
if ($this->phpBB['installed'] != true || !zen_not_null($password) || !zen_not_null($email_address) || !zen_not_null($nick)) return false;
if ($this->phpbb_check_for_duplicate_email($email_address) == 'already_exists') {
// $this->phpbb_change_email($old_email, $email_address);
} else {
$sql = "select max(user_id) as total from " . $this->phpBB['users_table'];
$phpbb_users = $this->db_phpbb->Execute($sql);
$user_id = ($phpbb_users->fields['total'] + 1);
$sql = "insert into " . $this->phpBB['users_table'] . "
(user_id, group_id, username, username_clean, user_password, user_email, user_regdate)
values
('" . (int)$user_id . "',2, '" . $nick . "', '" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() ."')";
$this->db_phpbb->Execute($sql);
$sql = "update phpbb_config SET config_value = '{$user_id}' WHERE config_name = 'newest_user_id'";
$this->db_phpbb->Execute($sql);
$sql = "update phpbb_config SET config_value = '{$nick}' WHERE config_name = 'newest_username'";
$this->db_phpbb->Execute($sql);
$sql = "update phpbb_config SET config_value = config_value + 1 WHERE config_name = 'num_users'";
$this->db_phpbb->Execute($sql);

$sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending)
VALUES ($user_id, 2, 0)";
$this->db_phpbb->Execute($sql);
}
}