Mysql error after installing

[suzdal]

Like it

Up

0

Down

Drop it

::

database is wrong, the table where is stored the user sessions is missing, for a best chance, try to reinstall the console… in this process is when the db is created.

if it continues going wrong, create it manually:

CREATE TABLE IF NOT EXISTS `tsesion` (
  `ID_sesion` bigint(20) unsigned NOT NULL auto_increment,
  `ID_usuario` varchar(60) NOT NULL default ‘0’,
  `IP_origen` varchar(100) NOT NULL default ”,
  `accion` varchar(100) NOT NULL default ”,
  `descripcion` varchar(200) NOT NULL default ”,
  `fecha` datetime NOT NULL default ‘0000-00-00 00:00:00’,
  `utimestamp` bigint(20) unsigned NOT NULL default ‘0’,
  PRIMARY KEY  (`ID_sesion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[Edgar]

Like it

Up

0

Down

Drop it

::

Same error but now tserver

[Edgar]

Like it

Up

0

Down

Drop it

::

Hi,

Thanks a lot for you answer.

Can you send me the sql for tserver?

Best regards

[raul]

Like it

Up

1

Down

Drop it

::

try to run (from the pandora console directory):

cat pandoradb.sql | mysql -D pandora -u root -p

This will insert all the tables that were not inserted in the installation process (by the way, it’s very strange…)

Regards,

Raul

[Edgar]

Like it

Up

0

Down

Drop it

::

Hi, I ran pandoradb.sql file… fine

Also, installation did not create apache site