Fóruns do Joomla.com.br e JoomlaBrasil.org

SQL=BLOB/TEXT column \'text\' can\'t have a default value SQL=# Table structure for table `jos_poll_data`\n\nCREATE TABLE `jos_poll_data` (\n  `id` int(11) NOT NULL auto_increment,\n  `pollid` int(4) NOT NULL default \'0\',\n  `text` text NOT NULL default \'\',\n  `hits` int(11) NOT NULL default \'0\',\n  PRIMARY KEY  (`id`),\n  KEY `pollid` (`pollid`,`text`(1))\n) TYPE=MyISAM:
- - - - - - - - - -
# Table structure for table `#__poll_data`

CREATE TABLE `#__poll_data` (
  `id` int(11) NOT NULL auto_increment,
  `pollid` int(4) NOT NULL default '0',
  `text` text NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=# Dumping data for table `jos_poll_data`\n\nINSERT INTO `jos_poll_data` VALUES (1, 14, \'Absolutely simple\', 1):
- - - - - - - - - -
# Dumping data for table `#__poll_data`

INSERT INTO `#__poll_data` VALUES (1, 14, 'Absolutely simple', 1)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (2, 14, \'Reasonably easy\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (2, 14, 'Reasonably easy', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (3, 14, \'Not straight-forward but I worked it out\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (3, 14, 'Not straight-forward but I worked it out', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (4, 14, \'I had to install extra server stuff\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (4, 14, 'I had to install extra server stuff', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (5, 14, \'I had no idea and got my friend to do it\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (5, 14, 'I had no idea and got my friend to do it', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (6, 14, \'My dog ran away with the README ...\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (6, 14, 'My dog ran away with the README ...', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (7, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (7, 14, '', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (8, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (8, 14, '', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (9, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (9, 14, '', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (10, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (10, 14, '', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (11, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (11, 14, '', 0)
= = = = = = = = = =

SQL=Table \'joomla.jos_poll_data\' doesn\'t exist SQL=INSERT INTO `jos_poll_data` VALUES (12, 14, \'\', 0):
- - - - - - - - - -
INSERT INTO `#__poll_data` VALUES (12, 14, '', 0)
= = = = = = = = = =

Willian Souza escreveu: Vc não precisa criar o BD pelo phpMyadmin. O phpMyadmin geralmente vc usa para editar/criar tabelas.

Para criar o BD vc faz isto pelo MySql do Cpanel.

pchardnet escreveu: theflokin,

Hum... então tente com:
`text` text NOT NULL,

Ou seja, retire o default '0'


Ps.: Tá meio cabuloso isso. Estive verificando a Query dentro do Installation e ela possui o default ''

pchardnet escreveu: joomla.sql