Jump to content


validate datyabase - table predefine ivalid field count


1 reply to this topic

#1 stelio

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 09 November 2011 - 02:15 AM

Hi
Installing version 4.0.1.0 from scratch and when testing database I got the following message:
Invalid field count for predefined. Delete predefined manually and try to recreate the tables.

Done that using livezilla wizard and coping the resulted sql from "show sql dump" into phpmyadming with no sucsses.

bellow part of the sql dump relative to predefined table.

CREATE TABLE IF NOT EXISTS `predefined` (

`id` int(11) unsigned NOT NULL,

`internal_id` varchar(32) COLLATE utf8_bin NOT NULL,

`group_id` varchar(32) COLLATE utf8_bin NOT NULL,

`lang_iso` varchar(5) COLLATE utf8_bin NOT NULL,

`invitation_manual` mediumtext COLLATE utf8_bin NOT NULL,

`invitation_auto` mediumtext COLLATE utf8_bin NOT NULL,

`welcome` mediumtext COLLATE utf8_bin NOT NULL,

`website_push_manual` mediumtext COLLATE utf8_bin NOT NULL,

`website_push_auto` mediumtext COLLATE utf8_bin NOT NULL,

`chat_info` mediumtext COLLATE utf8_bin NOT NULL,

`ticket_info` mediumtext COLLATE utf8_bin NOT NULL,

`browser_ident` tinyint(1) unsigned NOT NULL DEFAULT '0',

`is_default` tinyint(1) unsigned NOT NULL DEFAULT '0',

`auto_welcome` tinyint(1) unsigned NOT NULL DEFAULT '0',

`editable` tinyint(1) unsigned NOT NULL DEFAULT '0',

`email_chat_transcript` mediumtext COLLATE utf8_bin NOT NULL,

`email_ticket` mediumtext COLLATE utf8_bin NOT NULL,

`queue_message` mediumtext COLLATE utf8_bin NOT NULL,

`queue_message_time` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

KEY `internal_id` (`internal_id`),

KEY `group_id` (`group_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

and the exported sql generated by phpmyadmin

- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: 09/11/2011 às 00h12min
-- Versão do Servidor: 5.0.92
-- Versão do PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Banco de Dados: `wisecart_livezilla`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `predefined`
--

CREATE TABLE IF NOT EXISTS `predefined` (
`id` int(11) unsigned NOT NULL,
`internal_id` varchar(32) collate utf8_bin NOT NULL,
`group_id` varchar(32) collate utf8_bin NOT NULL,
`lang_iso` varchar(5) collate utf8_bin NOT NULL,
`invitation_manual` mediumtext collate utf8_bin NOT NULL,
`invitation_auto` mediumtext collate utf8_bin NOT NULL,
`welcome` mediumtext collate utf8_bin NOT NULL,
`website_push_manual` mediumtext collate utf8_bin NOT NULL,
`website_push_auto` mediumtext collate utf8_bin NOT NULL,
`chat_info` mediumtext collate utf8_bin NOT NULL,
`ticket_info` mediumtext collate utf8_bin NOT NULL,
`browser_ident` tinyint(1) unsigned NOT NULL default '0',
`is_default` tinyint(1) unsigned NOT NULL default '0',
`auto_welcome` tinyint(1) unsigned NOT NULL default '0',
`editable` tinyint(1) unsigned NOT NULL default '0',
`email_chat_transcript` mediumtext collate utf8_bin NOT NULL,
`email_ticket` mediumtext collate utf8_bin NOT NULL,
`queue_message` mediumtext collate utf8_bin NOT NULL,
`queue_message_time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `internal_id` (`internal_id`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Extraindo dados da tabela `predefined`
--

INSERT INTO `predefined` (`id`, `internal_id`, `group_id`, `lang_iso`, `invitation_manual`, `invitation_auto`, `welcome`, `website_push_manual`, `website_push_auto`, `chat_info`, `ticket_info`, `browser_ident`, `is_default`, `auto_welcome`, `editable`, `email_chat_transcript`, `email_ticket`, `queue_message`, `queue_message_time`) VALUES
(0, '', 'Suporte', 'EN', 0x48656c6c6f2c206d79206e616d6520697320256e616d65252e20446f20796f75206e6565642068656c703f205374617274204c6976652d43686174206e6f7720746f2067657420617373697374616e63652e, 0x48656c6c6f2c206d79206e616d6520697320256e616d65252e20446f20796f75206e6565642068656c703f205374617274204c6976652d43686174206e6f7720746f2067657420617373697374616e63652e, 0x48656c6c6f202565787465726e616c5f6e616d65252c206d79206e616d6520697320256e616d65252c20686f77206d617920492068656c7020796f753f, 0x57656273697465204f70657261746f7220256e616d652520776f756c64206c696b6520746f20726564697265637420796f7520746f20746869732055524c3a0d0a0d0a2575726c25, 0x57656273697465204f70657261746f7220256e616d652520776f756c64206c696b6520746f20726564697265637420796f7520746f20746869732055524c3a0d0a0d0a2575726c25, '', '', 1, 1, 1, 0, '', '', '', 0),
(1, '', 'Suporte', 'DE', 0x477574656e205461672c206d65696e65204e616d652069737420256e616d65252e2042656ec3b6746967656e205369652048696c66653f204765726e6520626572617465206963682053696520696e2065696e656d204c69766520436861742e, 0x477574656e205461672c206d65696e65204e616d652069737420256e616d65252e2042656ec3b6746967656e205369652048696c66653f204765726e6520626572617465206963682053696520696e2065696e656d204c69766520436861742e, 0x477574656e20546167202565787465726e616c5f6e616d65252c206d65696e204e616d652069737420256e616d652520776965206b616e6e206963682049686e656e2068656c66656e3f, 0x45696e204265747265756572206469657365722057656273656974652028256e616d652529206dc3b66368746520536965206175662065696e656e20616e646572656e2042657265696368207765697465726c656974656e3a0d0a0d0a2575726c25, 0x45696e204265747265756572206469657365722057656273656974652028256e616d652529206dc3b66368746520536965206175662065696e656e20616e646572656e2042657265696368207765697465726c656974656e3a0d0a0d0a2575726c25, '', '', 1, 0, 1, 0, '', '', '', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

can see any field missing

thanks for any help

#2 Derek Punzova

    Support Team Member

  • Moderators
  • 6082 posts

Posted 09 November 2011 - 07:18 AM

Thanks for all the information, that really helped.

You are right, the database is fine.

Is it possible that you still have an older version installed and that you are trying (by accident) to use the files of the old version with the database of the new one?

Please copy the URL of the server installation and open it in your browser to get the version number of the installation you are connecting to.

Hope this helps.
- If you like to suggest a new feature, please click here.
Kind Regards,
Derek





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users